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 (
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.
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.
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.
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.
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:
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:
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:
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
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;