APPS.IGS_EN_OFR_WLST_OPT dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 41: -- IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW and IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW

37: --Who When What
38: --myoganat 26-May-2003 Removed the code setting the override achievable CP as zero
39: -- in case of an audit attempt - (Bug# 2855870)
40: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to
41: -- IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW and IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW
42: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
43: -------------------------------------------------------------------
44:
45: l_cst_unconfirm CONSTANT igs_ps_unit_ofr_opt.unit_section_status%TYPE DEFAULT 'UNCONFIRM';

Line 189: igs_en_su_attempt_pkg.insert_row (

185:
186: FOR l_c_igs_ps_unit_ofr_opt IN c_igs_ps_unit_ofr_opt(cp_uoo_id => p_uoo_id)
187: LOOP
188: -- creates a record in the table igs_en_su_attempt with unit_attempt_status = unconfirm
189: igs_en_su_attempt_pkg.insert_row (
190: X_ROWID => l_rowid ,
191: X_PERSON_ID => l_person_id ,
192: X_COURSE_CD => p_course_cd ,
193: X_UNIT_CD => l_c_igs_ps_unit_ofr_opt.unit_cd ,

Line 294: igs_en_su_attempt_pkg.update_row (

290:
291: IF (l_result AND p_waitlist_ind = 'N') THEN
292:
293: -- update sua record with cart = 'y'
294: igs_en_su_attempt_pkg.update_row (
295: X_ROWID => l_rowid ,
296: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
297: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
298: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,

Line 384: igs_en_su_attempt_pkg.update_row (

380: -- if validations are successful and waitlist indicator = 'Y' or validations fail and deny_warn_flag = 'warn' and waitlist indicator = 'Y'
381: ELSIF ((l_result AND p_waitlist_ind = 'Y') OR (NOT l_result AND l_deny_or_warn_flag = 'WARN' AND p_waitlist_ind = 'Y' )) THEN
382: -- update sua record with cart = 'n' and unit_attempt_status = 'waitlisted'
383:
384: igs_en_su_attempt_pkg.update_row (
385: X_ROWID => l_rowid ,
386: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
387: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
388: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,