1: PACKAGE BODY igs_en_ofr_wlst_opt as
2: /* $Header: IGSEN75B.pls 120.2 2006/01/16 22:42:18 smaddali ship $ */
3:
4:
5: EN_SUA_REC_TYPE IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
6:
7: FUNCTION ofr_enrollment_or_waitlist ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
8: p_session_id IN igs_en_su_attempt.session_id%TYPE,
9: p_waitlist_ind IN VARCHAR2,
4:
5: EN_SUA_REC_TYPE IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
6:
7: FUNCTION ofr_enrollment_or_waitlist ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
8: p_session_id IN igs_en_su_attempt.session_id%TYPE,
9: p_waitlist_ind IN VARCHAR2,
10: p_person_number IN igs_pe_person.person_number%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type IN igs_en_su_attempt.enr_method_type%TYPE,
7: FUNCTION ofr_enrollment_or_waitlist ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
8: p_session_id IN igs_en_su_attempt.session_id%TYPE,
9: p_waitlist_ind IN VARCHAR2,
10: p_person_number IN igs_pe_person.person_number%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type IN igs_en_su_attempt.enr_method_type%TYPE,
13: p_deny_or_warn OUT NOCOPY VARCHAR2,
14: p_message OUT NOCOPY VARCHAR2,
15: p_cal_type IN igs_ca_inst.cal_type%TYPE,
8: p_session_id IN igs_en_su_attempt.session_id%TYPE,
9: p_waitlist_ind IN VARCHAR2,
10: p_person_number IN igs_pe_person.person_number%TYPE,
11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type IN igs_en_su_attempt.enr_method_type%TYPE,
13: p_deny_or_warn OUT NOCOPY VARCHAR2,
14: p_message OUT NOCOPY VARCHAR2,
15: p_cal_type IN igs_ca_inst.cal_type%TYPE,
16: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
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';
78:
79: -- local rowtype variable for above cursor
80: l_c_igs_pe_person c_igs_pe_person%ROWTYPE ;
81: -- local variables
82: l_rowid igs_en_su_attempt.row_id%TYPE ;
83: l_person_id igs_pe_person.person_id%TYPE ;
84: l_result BOOLEAN DEFAULT FALSE ;
85: l_deny_or_warn_flag VARCHAR2(1000) ;
86: l_ret_flag BOOLEAN DEFAULT FALSE ;
99:
100: -- local rowtype variable for above cursor
101: l_c_igs_ps_rsv_ext c_igs_ps_rsv_ext%ROWTYPE ;
102:
103: CURSOR c_igs_en_su_attempt(cp_rowid VARCHAR2) IS
104: SELECT su.*
105: FROM igs_en_su_attempt_all su
106: WHERE su.rowid = cp_rowid ;
107:
101: l_c_igs_ps_rsv_ext c_igs_ps_rsv_ext%ROWTYPE ;
102:
103: CURSOR c_igs_en_su_attempt(cp_rowid VARCHAR2) IS
104: SELECT su.*
105: FROM igs_en_su_attempt_all su
106: WHERE su.rowid = cp_rowid ;
107:
108: l_c_igs_en_su_attempt c_igs_en_su_attempt%ROWTYPE ;
109: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%TYPE;
104: SELECT su.*
105: FROM igs_en_su_attempt_all su
106: WHERE su.rowid = cp_rowid ;
107:
108: l_c_igs_en_su_attempt c_igs_en_su_attempt%ROWTYPE ;
109: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%TYPE;
110: old_references EN_SUA_REC_TYPE%TYPE;
111: new_references EN_SUA_REC_TYPE%TYPE;
112: l_ss_src_ind igs_en_su_attempt.ss_source_ind%TYPE;
105: FROM igs_en_su_attempt_all su
106: WHERE su.rowid = cp_rowid ;
107:
108: l_c_igs_en_su_attempt c_igs_en_su_attempt%ROWTYPE ;
109: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%TYPE;
110: old_references EN_SUA_REC_TYPE%TYPE;
111: new_references EN_SUA_REC_TYPE%TYPE;
112: l_ss_src_ind igs_en_su_attempt.ss_source_ind%TYPE;
113:
108: l_c_igs_en_su_attempt c_igs_en_su_attempt%ROWTYPE ;
109: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%TYPE;
110: old_references EN_SUA_REC_TYPE%TYPE;
111: new_references EN_SUA_REC_TYPE%TYPE;
112: l_ss_src_ind igs_en_su_attempt.ss_source_ind%TYPE;
113:
114: -- cursor to get person type
115: CURSOR cur_per_typ IS
116: SELECT person_type_code
184: END IF;
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 ,
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 ,
281: p_calling_obj => p_calling_obj
282: ) ;
283: p_deny_or_warn := l_deny_or_warn_flag;
284: -- If all the validations are successful and waitlist indicator = 'N'
285: OPEN c_igs_en_su_attempt(l_rowid);
286: FETCH c_igs_en_su_attempt INTO l_c_igs_en_su_attempt ;
287: CLOSE c_igs_en_su_attempt ;
288:
289: old_references := l_c_igs_en_su_attempt ;
282: ) ;
283: p_deny_or_warn := l_deny_or_warn_flag;
284: -- If all the validations are successful and waitlist indicator = 'N'
285: OPEN c_igs_en_su_attempt(l_rowid);
286: FETCH c_igs_en_su_attempt INTO l_c_igs_en_su_attempt ;
287: CLOSE c_igs_en_su_attempt ;
288:
289: old_references := l_c_igs_en_su_attempt ;
290:
283: p_deny_or_warn := l_deny_or_warn_flag;
284: -- If all the validations are successful and waitlist indicator = 'N'
285: OPEN c_igs_en_su_attempt(l_rowid);
286: FETCH c_igs_en_su_attempt INTO l_c_igs_en_su_attempt ;
287: CLOSE c_igs_en_su_attempt ;
288:
289: old_references := l_c_igs_en_su_attempt ;
290:
291: IF (l_result AND p_waitlist_ind = 'N') THEN
285: OPEN c_igs_en_su_attempt(l_rowid);
286: FETCH c_igs_en_su_attempt INTO l_c_igs_en_su_attempt ;
287: CLOSE c_igs_en_su_attempt ;
288:
289: old_references := l_c_igs_en_su_attempt ;
290:
291: IF (l_result AND p_waitlist_ind = 'N') THEN
292:
293: -- update sua record with cart = 'y'
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 ,
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 ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
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 ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
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 ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
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 ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
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 ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
297: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
298: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
298: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
299: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
300: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
301: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
302: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
303: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
304: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
305: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
306: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
307: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
308: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
309: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
310: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
311: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
312: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
313: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
314: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
315: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
316: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
317: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
318: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
319: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
320: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
321: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
322: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
329: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
323: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
329: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
330: X_CART => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
331: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
324: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
329: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
330: X_CART => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
331: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
332: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
325: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
326: X_MODE => 'R' ,
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
329: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
330: X_CART => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
331: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
332: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
333: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
327: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
329: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
330: X_CART => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
331: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
332: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
333: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
334: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
335: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
328: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
329: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
330: X_CART => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
331: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
332: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
333: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
334: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
335: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
336: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
330: X_CART => substr(igs_en_gen_017.enrp_get_invoke_source,1,1),
331: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
332: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
333: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
334: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
335: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
336: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
337: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
332: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
333: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
334: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
335: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
336: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
337: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
334: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
335: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
336: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
337: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
335: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
336: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
337: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
336: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
337: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
337: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
338: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
339: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
340: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
341: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
342: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
343: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
344: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
345: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
346: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
347: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
348: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
349: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
350: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
351: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
352: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
353: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
354: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
355: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
356: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
357: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
358: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
366: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
359: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
366: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
367: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
360: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
366: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
367: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
368: ) ;
361: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
366: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
367: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
368: ) ;
369: l_ret_flag := TRUE ;
362: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.,
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
366: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
367: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
368: ) ;
369: l_ret_flag := TRUE ;
370:
363: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
364: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
365: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
366: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
367: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
368: ) ;
369: l_ret_flag := TRUE ;
370:
371: OPEN c_igs_en_su_attempt(l_rowid);
367: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
368: ) ;
369: l_ret_flag := TRUE ;
370:
371: OPEN c_igs_en_su_attempt(l_rowid);
372: FETCH c_igs_en_su_attempt INTO new_references;
373: CLOSE c_igs_en_su_attempt ;
374:
375: igs_en_sua_api.upd_enrollment_counts('UPDATE',
368: ) ;
369: l_ret_flag := TRUE ;
370:
371: OPEN c_igs_en_su_attempt(l_rowid);
372: FETCH c_igs_en_su_attempt INTO new_references;
373: CLOSE c_igs_en_su_attempt ;
374:
375: igs_en_sua_api.upd_enrollment_counts('UPDATE',
376: old_references,
369: l_ret_flag := TRUE ;
370:
371: OPEN c_igs_en_su_attempt(l_rowid);
372: FETCH c_igs_en_su_attempt INTO new_references;
373: CLOSE c_igs_en_su_attempt ;
374:
375: igs_en_sua_api.upd_enrollment_counts('UPDATE',
376: old_references,
377: new_references);
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 ,
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 ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
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 ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
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 ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
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 ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
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 ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
387: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
388: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
388: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
389: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
390: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
391: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
392: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
393: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
394: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
395: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
396: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
397: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
398: X_UNIT_ATTEMPT_STATUS => l_cst_waitlisted ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
399: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
400: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
401: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
402: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
403: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
404: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
405: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
406: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
407: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
408: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
409: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
410: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
411: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
412: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
419: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
413: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
419: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
420: X_CART => 'N' ,
421: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
414: X_WAITLIST_DT => SYSDATE, --l_c_igs_en_su_attempt.waitlist_dt , -- modification done as per the Bug# 2335455
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
419: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
420: X_CART => 'N' ,
421: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
422: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
415: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
416: X_MODE => 'R' ,
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
419: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
420: X_CART => 'N' ,
421: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
422: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
423: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
417: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
419: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
420: X_CART => 'N' ,
421: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
422: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
423: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
424: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
425: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
418: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
419: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
420: X_CART => 'N' ,
421: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
422: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
423: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
424: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
425: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
426: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
420: X_CART => 'N' ,
421: X_RSV_SEAT_EXT_ID => l_c_igs_en_su_attempt.rsv_seat_ext_id ,
422: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
423: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
424: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
425: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
426: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
427: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
422: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
423: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
424: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
425: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
426: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
427: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
424: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
425: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
426: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
427: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
425: -- Added the column grading schema as a part pf the bug 2037897. - aiyer
426: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
427: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
426: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
427: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
427: --Added the column Deg_Aud_Detail_Id as part of Degree Audit Interface build. (Bug# 2033208)- pradhakr
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
428: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
429: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
430: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
431: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
432: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
433: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
434: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
435: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
436: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
437: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
438: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
439: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
440: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
441: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
442: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
443: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
444: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
445: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
446: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
447: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
448: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
449: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
457: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
450: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
457: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
458: ) ;
451: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
457: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
458: ) ;
459: --increase the waitlist actual by 1
452: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
457: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
458: ) ;
459: --increase the waitlist actual by 1
460: /* the waitlist actual will be incremented through the TBH of IGS_EN_SU_ATTEMPT
453: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
454: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
455: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code,
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
457: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
458: ) ;
459: --increase the waitlist actual by 1
460: /* the waitlist actual will be incremented through the TBH of IGS_EN_SU_ATTEMPT
461: this has been done to centralize the updation of all the statistics and status related columns */
456: X_UPD_AUDIT_FLAG => l_c_igs_en_su_attempt.upd_audit_flag,
457: X_SS_SOURCE_IND => l_c_igs_en_su_attempt.ss_source_ind
458: ) ;
459: --increase the waitlist actual by 1
460: /* the waitlist actual will be incremented through the TBH of IGS_EN_SU_ATTEMPT
461: this has been done to centralize the updation of all the statistics and status related columns */
462:
463: p_deny_or_warn := l_deny_or_warn_flag;
464: l_ret_flag := TRUE;
470: IGS_SS_EN_WRAPPERS.call_fee_ass (
471: p_person_id => l_person_id,
472: p_cal_type => p_cal_type, -- load
473: p_sequence_number => p_ci_sequence_number, -- load
474: p_course_cd => l_c_igs_en_su_attempt.course_cd,
475: p_unit_cd => l_c_igs_en_su_attempt.unit_cd,
476: p_uoo_id => l_c_igs_en_su_attempt.uoo_id
477: );
478:
471: p_person_id => l_person_id,
472: p_cal_type => p_cal_type, -- load
473: p_sequence_number => p_ci_sequence_number, -- load
474: p_course_cd => l_c_igs_en_su_attempt.course_cd,
475: p_unit_cd => l_c_igs_en_su_attempt.unit_cd,
476: p_uoo_id => l_c_igs_en_su_attempt.uoo_id
477: );
478:
479:
472: p_cal_type => p_cal_type, -- load
473: p_sequence_number => p_ci_sequence_number, -- load
474: p_course_cd => l_c_igs_en_su_attempt.course_cd,
475: p_unit_cd => l_c_igs_en_su_attempt.unit_cd,
476: p_uoo_id => l_c_igs_en_su_attempt.uoo_id
477: );
478:
479:
480: OPEN c_igs_en_su_attempt(l_rowid);
476: p_uoo_id => l_c_igs_en_su_attempt.uoo_id
477: );
478:
479:
480: OPEN c_igs_en_su_attempt(l_rowid);
481: FETCH c_igs_en_su_attempt INTO new_references;
482: CLOSE c_igs_en_su_attempt ;
483:
484: igs_en_sua_api.upd_enrollment_counts( 'UPDATE',
477: );
478:
479:
480: OPEN c_igs_en_su_attempt(l_rowid);
481: FETCH c_igs_en_su_attempt INTO new_references;
482: CLOSE c_igs_en_su_attempt ;
483:
484: igs_en_sua_api.upd_enrollment_counts( 'UPDATE',
485: old_references,
478:
479:
480: OPEN c_igs_en_su_attempt(l_rowid);
481: FETCH c_igs_en_su_attempt INTO new_references;
482: CLOSE c_igs_en_su_attempt ;
483:
484: igs_en_sua_api.upd_enrollment_counts( 'UPDATE',
485: old_references,
486: new_references);
486: new_references);
487:
488:
489: ELSIF ( NOT l_result AND l_deny_or_warn_flag = 'DENY' ) THEN
490: -- update igs_ps_rsv_ext only when l_c_igs_en_su_attempt.rsv_seat_ext_id is not null
491: IF l_c_igs_en_su_attempt.rsv_seat_ext_id IS NOT NULL THEN
492: OPEN c_igs_ps_rsv_ext(cp_rsv_ext_id => l_c_igs_en_su_attempt.rsv_seat_ext_id ) ;
493: FETCH c_igs_ps_rsv_ext INTO l_c_igs_ps_rsv_ext ;
494: igs_ps_rsv_ext_pkg.update_row(
487:
488:
489: ELSIF ( NOT l_result AND l_deny_or_warn_flag = 'DENY' ) THEN
490: -- update igs_ps_rsv_ext only when l_c_igs_en_su_attempt.rsv_seat_ext_id is not null
491: IF l_c_igs_en_su_attempt.rsv_seat_ext_id IS NOT NULL THEN
492: OPEN c_igs_ps_rsv_ext(cp_rsv_ext_id => l_c_igs_en_su_attempt.rsv_seat_ext_id ) ;
493: FETCH c_igs_ps_rsv_ext INTO l_c_igs_ps_rsv_ext ;
494: igs_ps_rsv_ext_pkg.update_row(
495: x_rowid => l_c_igs_ps_rsv_ext.rowid ,
488:
489: ELSIF ( NOT l_result AND l_deny_or_warn_flag = 'DENY' ) THEN
490: -- update igs_ps_rsv_ext only when l_c_igs_en_su_attempt.rsv_seat_ext_id is not null
491: IF l_c_igs_en_su_attempt.rsv_seat_ext_id IS NOT NULL THEN
492: OPEN c_igs_ps_rsv_ext(cp_rsv_ext_id => l_c_igs_en_su_attempt.rsv_seat_ext_id ) ;
493: FETCH c_igs_ps_rsv_ext INTO l_c_igs_ps_rsv_ext ;
494: igs_ps_rsv_ext_pkg.update_row(
495: x_rowid => l_c_igs_ps_rsv_ext.rowid ,
496: x_rsv_ext_id => l_c_igs_ps_rsv_ext.rsv_ext_id ,