1 PACKAGE igs_ps_unit_lgcy_pkg AS
2 /* $Header: IGSPS85S.pls 120.1 2005/06/29 04:17:55 appldev ship $ */
3
4 /***********************************************************************************************
5 Created By : Sanjeeb Rakshit, Shirish Tatiko, Saravana Kumar
6 Date Created By: 11-NOV-2002
7 Purpose : This package has the 8 sub processes, which will be called from
8 PSP Unit API.
9 process 1 : create_unit_version
10 Imports Unit Version and its associated Subtitle and Curriculum
11 process 2 : create_teach_resp
12 Imports Teaching Reponsibility.
13 process 3 : create_unit_discip
14 Imports Unit Discipline.
15 process 4 : create_unit_grd_sch
16 Imports Unit Grading Schema.
17 : validate_unit_dtls
18 Validations performed across different sub process at unil level.
19 process 5 : create_unit_section
20 Imports Unit Section and its associated Credits Point and Referrence
21 process 6 : create_usec_grd_sch
22 Imports Unit Section Grading Schema
23 process 7 : create_usec_occur
24 Imports Unit Section Occurrence
25 process 8 : create_unit_ref_code
26 Imports Unit / Unit Section / Unit Section Occurrence Referrences
27 process 9 : create_uso_ins
28 Imports Unit Section Occurrence instructors and creates unit
29 section teaching responsibilites record if current instructor
30 getting imported does not already exists.
31
32 Known limitations,enhancements,remarks:
33 Change History (in reverse chronological order)
34 Who When What
35 smvk 07-Nov-2003 Bug # 3138353. Added new procedure validate_unit_dtls to do unit level cross subprocesses validation.
36 jbegum 2-June-2003 Bug # 2972950. Created Sub process create_uso_ins to import unit section occurrence
37 instructors and instructor details, as mentioned in TD.
38 ********************************************************************************************** */
39
40 --This procedure is a sub process to insert records of Unit Version and its associated Subtitle and Curriculum
41 PROCEDURE create_unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
42 p_rec_status OUT NOCOPY VARCHAR2);
43
44 --This procedure is a sub process to insert records of Teaching Responsibility.
45 PROCEDURE create_teach_resp (
46 p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type,
47 p_c_rec_status OUT NOCOPY VARCHAR2
48 );
49
50 --This procedure is a sub process to insert records of Unit Discipline.
51 PROCEDURE create_unit_discip (
52 p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type,
53 p_c_rec_status OUT NOCOPY VARCHAR2
54 ) ;
55
56 --This procedure is a sub process to insert records of Unit Grading Schema.
57 PROCEDURE create_unit_grd_sch (
58 p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type,
59 p_c_rec_status OUT NOCOPY VARCHAR2
60 ) ;
61
62 --This procedure does the validations performed across different sub process at unil level.
63 PROCEDURE validate_unit_dtls (
64 p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
65 p_rec_status OUT NOCOPY VARCHAR2
66 );
67
68 --This procedure is a sub process to insert records of Unit Section.
69 PROCEDURE create_unit_section (
70 p_usec_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_tbl_type,
71 p_c_rec_status OUT NOCOPY VARCHAR2,
72 p_calling_context IN VARCHAR2
73 ) ;
74
75 --This procedure is a sub process to insert records of Unit Section Grading Schema.
76 PROCEDURE create_usec_grd_sch (
77 p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
78 p_c_rec_status OUT NOCOPY VARCHAR2,
79 p_calling_context IN VARCHAR2
80 ) ;
81
82 --This procedure is a sub process to insert records of Unit Section Occurrence.
83 PROCEDURE create_usec_occur (
84 p_tab_usec_occur IN OUT NOCOPY igs_ps_generic_pub.uso_tbl_type,
85 p_c_rec_status OUT NOCOPY VARCHAR2,
86 p_calling_context IN VARCHAR2
87 ) ;
88
89 --This procedure is a sub process to insert records of referrence Unit
90 -- Unit Section, Unit Section Occurrence.
91 PROCEDURE create_unit_ref_code( p_tab_ref_cd IN OUT NOCOPY igs_ps_generic_pub.unit_ref_tbl_type,
92 p_c_rec_status OUT NOCOPY VARCHAR2,
93 p_calling_context IN VARCHAR2);
94
95 --This procedure is a sub process to create Unit Section Occurrence Instructors
96 --in production table(IGS_PS_USO_INSTRCTRS)
97 PROCEDURE create_uso_ins( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type,
98 p_c_rec_status OUT NOCOPY VARCHAR2 );
99
100
101 END igs_ps_unit_lgcy_pkg;