1 PACKAGE igs_ps_validate_generic_pkg AS
2 /* $Header: IGSPS92S.pls 120.1 2005/09/08 16:13:10 appldev noship $ */
3
4 /***********************************************************************************************
5 Created By : Sanjeeb Rakshit, Somnath Mukherjee
6 Date Created By: 17-Jun-2005
7 Purpose : This package has the some validation function which will be called from sub processes,
8 in igs_ps_create_generic_pkg package.
9
10 Known limitations,enhancements,remarks:
11 Change History (in reverse chronological order)
12 Who When What
13 ********************************************************************************************** */
14
15
16
17 -- Validate Unit Section Occurence Facility Records before inserting them
18 PROCEDURE validate_facility (p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type,
19 p_n_uoo_id IN NUMBER,
20 p_uso_id IN NUMBER,
21 p_calling_context IN VARCHAR2);
22
23 -- Validate Unit Section Category Records before inserting them
24 PROCEDURE validate_category (p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type,
25 p_n_uoo_id IN NUMBER);
26
27
28 -- This procedure validates before inserting Unit Section Grading Schema records
29 PROCEDURE validate_tch_rsp_ovrd ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type,
30 p_n_uoo_id IN NUMBER);
31
32 -- This function does validations after inserting Unit Section Grading Schema Records
33 FUNCTION post_tch_rsp_ovrd ( p_tab_tch_rsp_ovrd IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,
34 p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN ;
35
36 -- This procedure validates before inserting Unit Section Notes
37 PROCEDURE validate_usec_notes(p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,
38 p_n_uoo_id IN NUMBER);
39
40 -- This procedure validates before inserting Unit Section Assessment records
41 PROCEDURE validate_usec_assmnt ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,
42 p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
43 p_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE,
44 p_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE,
45 p_n_building_id NUMBER,
46 p_n_room_id NUMBER,
47 p_insert_update VARCHAR2);
48
49 -- This procedure validates before inserting Unit Section Reserved Seating Records
50 PROCEDURE validate_usec_rsvpri(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,
51 p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
52 p_insert_update IN VARCHAR2);
53
54 PROCEDURE validate_usec_rsvprf(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,
55 p_insert_update IN VARCHAR2);
56
57 -- This procedure validates before inserting Unit Section Waitlist Records
58 PROCEDURE validate_usec_wlstpri(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,
59 p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
60 p_insert_update VARCHAR2);
61
62 PROCEDURE validate_usec_wlstprf(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,
63 p_insert_update IN VARCHAR2);
64
65 -- This procedure validates before inserting/updating Unit Section Assessment item group records
66 PROCEDURE validate_as_us_ai_group ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,
67 p_n_uoo_id NUMBER);
68
69 -- This procedure validates before inserting/updating Unit Section meet with class group records
70 PROCEDURE validate_uso_cm_grp ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,
71 p_c_cal_type VARCHAR2 ,
72 p_n_seq_num NUMBER,
73 p_insert_update VARCHAR2,
74 p_class_meet_rec IN OUT NOCOPY igs_ps_create_generic_pkg.class_meet_rec_type );
75
76 -- This procedure validates before inserting/updating Unit Section meet with class records
77 PROCEDURE validate_uso_clas_meet ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,
78 p_n_uoo_id NUMBER,
79 p_n_class_meet_group_id NUMBER,
80 p_c_cal_type VARCHAR2,
81 p_n_seq_num NUMBER);
82
83 -- This procedure validates before inserting/updating cross listed Unit Section records
84 PROCEDURE validate_usec_x_grp ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,
85 p_c_cal_type VARCHAR2,
86 p_n_seq_num NUMBER,
87 p_insert_update VARCHAR2,
88 p_cross_group_rec IN OUT NOCOPY igs_ps_create_generic_pkg.cross_group_rec_type );
89
90 -- This procedure validates before inserting/updating cross listed Unit Section records
91 PROCEDURE validate_usec_x_grpmem ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,
92 p_n_uoo_id NUMBER,
93 p_n_usec_x_listed_group_id NUMBER,
94 p_c_cal_type VARCHAR2,
95 p_n_seq_num NUMBER);
96
97 -- This procedure validates after inserting/updating cross listed Unit Section records
98 FUNCTION post_usec_cross_group(p_tab_usec_cross_group IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,
99 p_cross_group_tab IN igs_ps_create_generic_pkg.cross_group_rec_tbl_type) RETURN BOOLEAN;
100
101 -- This procedure validates before inserting/updating Unit Section Assessment item records
102 PROCEDURE validate_unitass_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,
103 p_cal_type IN VARCHAR2,
104 p_ci_sequence_number NUMBER,
105 p_n_uoo_id NUMBER,
106 p_insert VARCHAR2);
107
108 -- This function does validations after inserting/updating Unit Section Assessment item records
109 FUNCTION post_as_us_ai ( p_tab_as_us_ai IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,
110 p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN;
111
112 -- This function does validations after inserting/updating Unit Section meet with class group records
113 FUNCTION post_usec_meet_with(p_tab_usec_meet_with IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,
114 p_class_meet_tab IN igs_ps_create_generic_pkg.class_meet_rec_tbl_type) RETURN BOOLEAN;
115
116 -- This function does validations after inserting Unit Section Reserved Seating Records
117 FUNCTION post_usec_rsv ( p_tab_usec_rsv IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,
118 p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN;
119
120 -- This procedure validates after inserting Unit Section Waitlist Records
121 FUNCTION post_usec_wlst ( p_tab_usec_wlst IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,
122 p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN;
123
124
125 END igs_ps_validate_generic_pkg;