eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_GENERIC_PUB

Line 18: PROCEDURE validate_facility (p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type,

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:

Line 24: PROCEDURE validate_category (p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type,

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

Line 29: PROCEDURE validate_tch_rsp_ovrd ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_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,

Line 33: FUNCTION post_tch_rsp_ovrd ( p_tab_tch_rsp_ovrd IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,

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,

Line 37: PROCEDURE validate_usec_notes(p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,

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,

Line 41: PROCEDURE validate_usec_assmnt ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,

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,

Line 50: PROCEDURE validate_usec_rsvpri(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,

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,

Line 54: PROCEDURE validate_usec_rsvprf(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,

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,

Line 58: PROCEDURE validate_usec_wlstpri(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,

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,

Line 62: PROCEDURE validate_usec_wlstprf(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,

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,

Line 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,

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,

Line 70: PROCEDURE validate_uso_cm_grp ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,

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 );

Line 77: PROCEDURE validate_uso_clas_meet ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,

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);

Line 84: PROCEDURE validate_usec_x_grp ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,

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 );

Line 91: PROCEDURE validate_usec_x_grpmem ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,

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);

Line 98: FUNCTION post_usec_cross_group(p_tab_usec_cross_group IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,

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,

Line 102: PROCEDURE validate_unitass_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,

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);

Line 109: FUNCTION post_as_us_ai ( p_tab_as_us_ai IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,

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,

Line 113: FUNCTION post_usec_meet_with(p_tab_usec_meet_with IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,

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,

Line 117: FUNCTION post_usec_rsv ( p_tab_usec_rsv IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,

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,

Line 121: FUNCTION post_usec_wlst ( p_tab_usec_wlst IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,

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;