The training can also be schedule for a single course, such as “Introduction Oracle 9i SQL”. This training program can contain the “Oracle 9i Programming Module” and many other modules. The Module “Oracle 9i Programming” can be a part of “Developers Training Level 1” program. Hence a Module can contain one or more courses. There should be atleast one Program or one module or one course scheduled for every calendar.Įxample of a course is “Introduction to Oracle 9i SQL” or “Oracle 9i PL/SQL” Which in turn forms a part of the Module “Oracle 9i Programming”. That form a part of the training calendar.Ī training calendar can have one or more Programs, Modules and Courses The user is required to enter the details about the Insert the calendar code, desc, from date and to date in that table.Īs soon as the following Screen is launched, the details saved in the temporary table should be used to populate the screen controls.
The name of the table would start with the keyword TAB and followed by the calendar code. Note : Apart from inserting the details about the Calendar code,description, From Date and TO Date of the calendar in the calendar master table, create another temporary table (this table should be dropped after the calendar is created) where the name of the table would contain the calendar code, entered by the user. And the calendar From period has to be greater than the system dateĪfter the User saves the calendar details and clicks on the hyperlink, “Edit Programs / Modules in the calendar” link the following screen (see Figure 1.1) is launched, where the user enter the details about the Programs, Modules and courses in the calendar. Calendar from period has to be earlier than the Calendar To period.
#FINAL DRAFT 10 USER DICTIONARY CODE#
Calendar Code should not already exists in the tableĬ. Write an SP that takes these parameters from the screen, Validates the inputs and inserts the same into the calendar table. When the Save button is clicked, the calendar code along with the period for which it is created has to be saved in the table “Calendar” with has the fields (Calendar_Code, Description, Training_Unit, Period_From, Period_To). The Combo “Status” has to be loaded with the value “Open” and “closed”. Write an SP that will output this valueĢ. The Combo “Training Calendar Unit” has to be loaded with the Value “Ramco Unit” as soon the screen is launched. The Logic to be executed on each event (button click, Screen Load etc) is to be implemented by writing an SP. The first Screen is used to create the calendar Code and also the period for which the calendar is to be created. Step 2: Specify the programs, modules and courses in the calendar. Step 1: Create the calendar code, description and the period Consider the following Application that helps to create the Training Calendar for a month.
0 kommentar(er)
