103: CURSOR c_unit_aud_att IS
104: SELECT sua.no_assessment_ind,
105: sua.unit_attempt_status,
106: NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)) credit_points
107: FROM igs_en_su_attempt sua,
108: igs_ps_unit_ver uv ,
109: igs_ps_usec_cps cps
110: WHERE sua.person_id = p_person_id
111: AND sua.course_cd = p_course_cd
127: AND uoo.uoo_id = p_uoo_id;
128:
129: CURSOR c_audit_sua IS
130: SELECT COUNT(*)
131: FROM igs_en_su_attempt
132: WHERE uoo_id=p_uoo_id
133: AND no_assessment_ind = 'Y' -- For Audit TD Bug 2641864
134: AND (( p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') ) OR
135: (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )
176: l_cross_list c_cross_list%ROWTYPE;
177: l_class_meet c_class_meet%ROWTYPE;
178: l_usec_partof_group BOOLEAN;
179: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE; --added by nishikant
180: l_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
181: l_credit_points igs_ps_unit_ver.enrolled_credit_points%type;
182: l_deny_unit_steps BOOLEAN;
183: l_warn_unit_steps BOOLEAN;
184: l_message_icon VARCHAR2(1);
1637: sua.ci_sequence_number,
1638: sua.uoo_id,
1639: sua.override_enrolled_cp ,
1640: sua.course_cd
1641: FROM igs_en_su_attempt sua, igs_ps_unit_ver psv
1642: WHERE sua.person_id = p_person_id
1643: AND ( sua.cart IS NOT NULL AND ( p_calling_obj <> 'SWAP' OR (p_calling_obj = 'SWAP' AND sua.uoo_id <> p_uoo_id) ) )
1644: AND ((p_calling_obj <> 'PLAN' AND sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM') )
1645: OR (p_calling_obj = 'PLAN' AND sua.unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM','PLANNED') )
2026: sua.ci_sequence_number,
2027: sua.uoo_id,
2028: NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)) override_enrolled_cp ,
2029: sua.course_cd
2030: FROM igs_en_su_attempt sua,
2031: igs_ps_unit_ver uv,
2032: igs_ps_usec_cps cps
2033: WHERE sua.person_id = p_person_id
2034: AND sua.unit_cd = uv.unit_cd
2520: uoo.unit_class,
2521: NVL (uocur.start_date, NVL (uoo.unit_section_start_date, lt.start_dt)) start_date,
2522: NVL (uocur.end_date, NVL (uoo.unit_section_end_date, lt.end_dt)) end_date
2523: FROM igs_ps_usec_occurs uocur,
2524: igs_en_su_attempt_all ua,
2525: igs_ca_inst lt,
2526: igs_ps_unit_ofr_opt_all uoo
2527: WHERE uocur.uoo_id = ua.uoo_id
2528: AND uoo.uoo_id = ua.uoo_id
3496: l_rowid VARCHAR2(25);
3497: l_rsv_ext_id NUMBER;
3498: l_rsv_temp_id NUMBER;
3499:
3500: CURSOR c_igs_en_su_attempt (cp_person_id igs_pe_person.person_id%TYPE,
3501: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
3502: cp_course_cd igs_en_su_attempt.course_cd%TYPE
3503: ) IS
3504: SELECT *
3498: l_rsv_temp_id NUMBER;
3499:
3500: CURSOR c_igs_en_su_attempt (cp_person_id igs_pe_person.person_id%TYPE,
3501: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
3502: cp_course_cd igs_en_su_attempt.course_cd%TYPE
3503: ) IS
3504: SELECT *
3505: FROM igs_en_su_attempt
3506: WHERE person_id = cp_person_id
3501: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
3502: cp_course_cd igs_en_su_attempt.course_cd%TYPE
3503: ) IS
3504: SELECT *
3505: FROM igs_en_su_attempt
3506: WHERE person_id = cp_person_id
3507: AND uoo_id = cp_uoo_id
3508: AND course_cd = cp_course_cd ;
3509:
3506: WHERE person_id = cp_person_id
3507: AND uoo_id = cp_uoo_id
3508: AND course_cd = cp_course_cd ;
3509:
3510: l_c_igs_en_su_attempt c_igs_en_su_attempt%ROWTYPE ;
3511:
3512:
3513: BEGIN
3514: -- fetching the enrollment maximum defined at unit section level
3552: x_mode => 'R');
3553: END IF; -- cur_rsv_ext
3554: CLOSE cur_rsv_ext;
3555:
3556: FOR l_c_igs_en_su_attempt IN c_igs_en_su_attempt (cp_person_id => p_person_id,
3557: cp_uoo_id => p_uoo_id,
3558: cp_course_cd => p_course_cd)
3559: LOOP
3560: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3556: FOR l_c_igs_en_su_attempt IN c_igs_en_su_attempt (cp_person_id => p_person_id,
3557: cp_uoo_id => p_uoo_id,
3558: cp_course_cd => p_course_cd)
3559: LOOP
3560: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3561: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3557: cp_uoo_id => p_uoo_id,
3558: cp_course_cd => p_course_cd)
3559: LOOP
3560: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3561: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3558: cp_course_cd => p_course_cd)
3559: LOOP
3560: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3561: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3559: LOOP
3560: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3561: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3560: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3561: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3561: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3562: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3563: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3564: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3565: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3566: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3567: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3568: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3569: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3570: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3571: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3572: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3573: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3574: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3575: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3576: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3577: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3578: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3579: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3580: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3581: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3582: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3583: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3584: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3585: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3586: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3587: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3588: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3595: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3589: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3595: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3596: X_CART => l_c_igs_en_su_attempt.cart ,
3597: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3590: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3595: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3596: X_CART => l_c_igs_en_su_attempt.cart ,
3597: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3598: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3591: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3595: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3596: X_CART => l_c_igs_en_su_attempt.cart ,
3597: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3598: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3599: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3592: X_MODE => 'R' ,
3593: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3595: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3596: X_CART => l_c_igs_en_su_attempt.cart ,
3597: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3598: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3599: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3600: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3594: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3595: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3596: X_CART => l_c_igs_en_su_attempt.cart ,
3597: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3598: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3599: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3600: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3601: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3596: X_CART => l_c_igs_en_su_attempt.cart ,
3597: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3598: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3599: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3600: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3601: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3598: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3599: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3600: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3601: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3599: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3600: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3601: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3600: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3601: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3601: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3602: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3603: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3604: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3605: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3606: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3607: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3608: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3609: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3610: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3611: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3612: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3613: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3614: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3615: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3616: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3617: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3618: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3619: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3620: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3621: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3622: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3630: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3623: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3630: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3631: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3624: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3630: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3631: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3632: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3625: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3630: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3631: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3632: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3633:
3626: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3627: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3630: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3631: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3632: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3633:
3634: ) ;
3628: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3629: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3630: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3631: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3632: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3633:
3634: ) ;
3635: END LOOP;
3636: -- return TRUE as the given student satisfied some priority/preference and
3681: IF cur_rsv_ext%ISOPEN THEN
3682: CLOSE cur_rsv_ext;
3683: END IF;
3684:
3685: FOR l_c_igs_en_su_attempt IN c_igs_en_su_attempt (cp_person_id => p_person_id,
3686: cp_uoo_id => p_uoo_id,
3687: cp_course_cd => p_course_cd)
3688: LOOP
3689: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3685: FOR l_c_igs_en_su_attempt IN c_igs_en_su_attempt (cp_person_id => p_person_id,
3686: cp_uoo_id => p_uoo_id,
3687: cp_course_cd => p_course_cd)
3688: LOOP
3689: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3690: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3686: cp_uoo_id => p_uoo_id,
3687: cp_course_cd => p_course_cd)
3688: LOOP
3689: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3690: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3687: cp_course_cd => p_course_cd)
3688: LOOP
3689: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3690: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3688: LOOP
3689: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3690: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3689: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
3690: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3690: X_ROWID => l_c_igs_en_su_attempt.row_id ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3691: X_PERSON_ID => l_c_igs_en_su_attempt.person_id ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3692: X_COURSE_CD => l_c_igs_en_su_attempt.course_cd ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3693: X_UNIT_CD => l_c_igs_en_su_attempt.unit_cd ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3694: X_CAL_TYPE => l_c_igs_en_su_attempt.cal_type ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3695: X_CI_SEQUENCE_NUMBER => l_c_igs_en_su_attempt.ci_sequence_number ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3696: X_VERSION_NUMBER => l_c_igs_en_su_attempt.version_number ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3697: X_LOCATION_CD => l_c_igs_en_su_attempt.location_cd ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3698: X_UNIT_CLASS => l_c_igs_en_su_attempt.unit_class ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3699: X_CI_START_DT => l_c_igs_en_su_attempt.ci_start_dt ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3700: X_CI_END_DT => l_c_igs_en_su_attempt.ci_end_dt ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3701: X_UOO_ID => l_c_igs_en_su_attempt.uoo_id ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3702: X_ENROLLED_DT => l_c_igs_en_su_attempt.enrolled_dt ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3703: X_UNIT_ATTEMPT_STATUS => l_c_igs_en_su_attempt.unit_attempt_status ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3704: X_ADMINISTRATIVE_UNIT_STATUS => l_c_igs_en_su_attempt.administrative_unit_status ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3705: X_DISCONTINUED_DT => l_c_igs_en_su_attempt.discontinued_dt ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3706: X_RULE_WAIVED_DT => l_c_igs_en_su_attempt.rule_waived_dt ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3707: X_RULE_WAIVED_PERSON_ID => l_c_igs_en_su_attempt.rule_waived_person_id ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3708: X_NO_ASSESSMENT_IND => l_c_igs_en_su_attempt.no_assessment_ind ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3709: X_SUP_UNIT_CD => l_c_igs_en_su_attempt.sup_unit_cd ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3710: X_SUP_VERSION_NUMBER => l_c_igs_en_su_attempt.sup_version_number ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3711: X_EXAM_LOCATION_CD => l_c_igs_en_su_attempt.exam_location_cd ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3712: X_ALTERNATIVE_TITLE => l_c_igs_en_su_attempt.alternative_title ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3713: X_OVERRIDE_ENROLLED_CP => l_c_igs_en_su_attempt.override_enrolled_cp ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3714: X_OVERRIDE_EFTSU => l_c_igs_en_su_attempt.override_eftsu ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3715: X_OVERRIDE_ACHIEVABLE_CP => l_c_igs_en_su_attempt.override_achievable_cp ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3716: X_OVERRIDE_OUTCOME_DUE_DT => l_c_igs_en_su_attempt.override_outcome_due_dt ,
3717: X_OVERRIDE_CREDIT_REASON => l_c_igs_en_su_attempt.override_credit_reason ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3724: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3718: X_ADMINISTRATIVE_PRIORITY => l_c_igs_en_su_attempt.administrative_priority ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3724: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3725: X_CART => l_c_igs_en_su_attempt.cart ,
3726: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3719: X_WAITLIST_DT => l_c_igs_en_su_attempt.waitlist_dt ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3724: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3725: X_CART => l_c_igs_en_su_attempt.cart ,
3726: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3727: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3720: X_DCNT_REASON_CD => l_c_igs_en_su_attempt.dcnt_reason_cd ,
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3724: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3725: X_CART => l_c_igs_en_su_attempt.cart ,
3726: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3727: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3728: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3721: X_MODE => 'R' ,
3722: X_GS_VERSION_NUMBER => l_c_igs_en_su_attempt.gs_version_number ,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3724: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3725: X_CART => l_c_igs_en_su_attempt.cart ,
3726: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3727: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3728: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3729: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3723: X_ENR_METHOD_TYPE => l_c_igs_en_su_attempt.enr_method_type ,
3724: X_FAILED_UNIT_RULE => l_c_igs_en_su_attempt.failed_unit_rule ,
3725: X_CART => l_c_igs_en_su_attempt.cart ,
3726: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3727: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3728: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3729: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3730: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3725: X_CART => l_c_igs_en_su_attempt.cart ,
3726: X_RSV_SEAT_EXT_ID => l_rsv_ext_id ,
3727: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3728: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3729: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3730: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3727: X_ORG_UNIT_CD => l_c_igs_en_su_attempt.org_unit_cd ,
3728: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3729: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3730: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3728: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
3729: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3730: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3729: X_SESSION_ID => l_c_igs_en_su_attempt.session_id,
3730: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3730: -- Added the column grading schema as a part of the bug 2037897. - aiyer
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3731: X_GRADING_SCHEMA_CODE => l_c_igs_en_su_attempt.grading_schema_code ,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3732: X_DEG_AUD_DETAIL_ID => l_c_igs_en_su_attempt.deg_aud_detail_id ,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3733: X_SUBTITLE => l_c_igs_en_su_attempt.subtitle ,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3734: X_STUDENT_CAREER_TRANSCRIPT => l_c_igs_en_su_attempt.student_career_transcript ,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3735: X_STUDENT_CAREER_STATISTICS => l_c_igs_en_su_attempt.student_career_statistics,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3736: X_ATTRIBUTE_CATEGORY => l_c_igs_en_su_attempt.attribute_category,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3737: X_ATTRIBUTE1 => l_c_igs_en_su_attempt.attribute1,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3738: X_ATTRIBUTE2 => l_c_igs_en_su_attempt.attribute2,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3739: X_ATTRIBUTE3 => l_c_igs_en_su_attempt.attribute3,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3740: X_ATTRIBUTE4 => l_c_igs_en_su_attempt.attribute4,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3741: X_ATTRIBUTE5 => l_c_igs_en_su_attempt.attribute5,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3742: X_ATTRIBUTE6 => l_c_igs_en_su_attempt.attribute6,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3743: X_ATTRIBUTE7 => l_c_igs_en_su_attempt.attribute7,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3744: X_ATTRIBUTE8 => l_c_igs_en_su_attempt.attribute8,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3745: X_ATTRIBUTE9 => l_c_igs_en_su_attempt.attribute9,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3746: X_ATTRIBUTE10 => l_c_igs_en_su_attempt.attribute10,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3747: X_ATTRIBUTE11 => l_c_igs_en_su_attempt.attribute11,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3748: X_ATTRIBUTE12 => l_c_igs_en_su_attempt.attribute12,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3749: X_ATTRIBUTE13 => l_c_igs_en_su_attempt.attribute13,
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3750: X_ATTRIBUTE14 => l_c_igs_en_su_attempt.attribute14,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3751: X_ATTRIBUTE15 => l_c_igs_en_su_attempt.attribute15,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3759: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3752: X_ATTRIBUTE16 => l_c_igs_en_su_attempt.attribute16,
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3759: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3760: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3753: X_ATTRIBUTE17 => l_c_igs_en_su_attempt.attribute17,
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3759: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3760: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3761: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3754: X_ATTRIBUTE18 => l_c_igs_en_su_attempt.attribute18,
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3759: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3760: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3761: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3762: ) ;
3755: X_ATTRIBUTE19 => l_c_igs_en_su_attempt.attribute19,
3756: X_ATTRIBUTE20 => l_c_igs_en_su_attempt.attribute20,
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3759: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3760: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3761: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3762: ) ;
3763: END LOOP ;
3757: X_WAITLIST_MANUAL_IND => l_c_igs_en_su_attempt.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
3758: X_WLST_PRIORITY_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_priority_weight_num,
3759: X_WLST_PREFERENCE_WEIGHT_NUM => l_c_igs_en_su_attempt.wlst_preference_weight_num,
3760: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
3761: X_CORE_INDICATOR_CODE => l_c_igs_en_su_attempt.core_indicator_code
3762: ) ;
3763: END LOOP ;
3764:
3765: -- return TRUE as the given student satisfied some priority/preference and
4809: -- Cursor to count the number of audit units for the student
4810: -- under all the program attempts
4811: CURSOR c_prg_audit_units IS
4812: SELECT count(*)
4813: FROM igs_en_su_attempt
4814: WHERE person_id = p_person_id
4815: AND no_assessment_ind = 'Y'
4816: AND ((p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') )
4817: OR (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )