APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 48: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,

44: -- Validate Unit Offer Option Records before inserting them
45: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
46: p_c_cal_type IN igs_ca_type.cal_type%TYPE,
47: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
48: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,
49: p_insert_update VARCHAR2,
50: p_conc_flag OUT NOCOPY BOOLEAN);
51:
52: -- Validate Unit Section Credit Points Records before inserting them

Line 54: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

50: p_conc_flag OUT NOCOPY BOOLEAN);
51:
52: -- Validate Unit Section Credit Points Records before inserting them
53: PROCEDURE validate_cps ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
54: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_insert_update VARCHAR2) ;
56:
57: -- Validate Unit Section Referece Records before inserting them
58: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

Line 60: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

56:
57: -- Validate Unit Section Referece Records before inserting them
58: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
59: p_n_subtitle_id OUT NOCOPY igs_ps_unit_subtitle.subtitle_id%TYPE,
60: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
61: p_insert_update VARCHAR2);
62:
63: -- This procedure validates before inserting Unit Section Grading Schema records
64: PROCEDURE validate_usec_grd_sch ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,

Line 73: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

69: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN ;
70:
71: -- This procedure validates before inserting records of Unit Section Occurrence.
72: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
73: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
74: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
75: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
76: p_n_building_code IN NUMBER,
77: p_n_room_code IN NUMBER,

Line 139: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

135: PROCEDURE get_party_id(p_c_person_number IN hz_parties.party_number%TYPE,
136: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE) ;
137: --
138: PROCEDURE validate_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
139: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
140: p_insert_update VARCHAR2);
141:
142: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
143: p_calling_context IN VARCHAR2,

Line 144: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

140: p_insert_update VARCHAR2);
141:
142: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
143: p_calling_context IN VARCHAR2,
144: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
145: p_insert_update VARCHAR2);
146:
147: -- Procedure to do the post unit section occurrence instructor validation.
148: PROCEDURE post_uso_ins( p_n_ins_id IN igs_ps_uso_instrctrs.instructor_id%TYPE,

Line 149: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

145: p_insert_update VARCHAR2);
146:
147: -- Procedure to do the post unit section occurrence instructor validation.
148: PROCEDURE post_uso_ins( p_n_ins_id IN igs_ps_uso_instrctrs.instructor_id%TYPE,
149: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
150: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,
151: p_n_index IN NUMBER);
152:
153: -- Procedure to do validate the unit section section teaching responsibility record after importing unit section occurrence instructors.

Line 169: FUNCTION isexists(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

165: --Function to validate if a person is a staff/faculty
166: FUNCTION validate_staff_faculty (p_person_id IN NUMBER ) RETURN BOOLEAN ;
167:
168: --Function to validate whether a uoo_id exists in the pl/sql table p_tab_uoo
169: FUNCTION isexists(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
170: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN ;
171:
172: --Function to check whether import is allowed in context to scheduling (overlodad function)
173: FUNCTION check_import_allowed( p_unit_cd IN VARCHAR2,