35: --curosr to get student unit attempt status
36:
37: CURSOR sua_status is
38: Select unit_Attempt_Status
39: FROM igs_En_su_Attempt
40: where person_Id = p_person_id
41: AND course_cd = p_course_cd
42: AND uoo_id = p_uoo_id;
43:
41: AND course_cd = p_course_cd
42: AND uoo_id = p_uoo_id;
43:
44: -- Cursor to get the Unit Attempt Details .
45: CURSOR igs_en_su_attempt_cur IS
46: SELECT igs_en_su_attempt.*
47: FROM igs_en_su_attempt
48: WHERE person_id = p_person_id AND
49: course_cd = p_course_cd AND
42: AND uoo_id = p_uoo_id;
43:
44: -- Cursor to get the Unit Attempt Details .
45: CURSOR igs_en_su_attempt_cur IS
46: SELECT igs_en_su_attempt.*
47: FROM igs_en_su_attempt
48: WHERE person_id = p_person_id AND
49: course_cd = p_course_cd AND
50: uoo_id = p_uoo_id;
43:
44: -- Cursor to get the Unit Attempt Details .
45: CURSOR igs_en_su_attempt_cur IS
46: SELECT igs_en_su_attempt.*
47: FROM igs_en_su_attempt
48: WHERE person_id = p_person_id AND
49: course_cd = p_course_cd AND
50: uoo_id = p_uoo_id;
51:
48: WHERE person_id = p_person_id AND
49: course_cd = p_course_cd AND
50: uoo_id = p_uoo_id;
51:
52: igs_en_su_attempt_rec igs_en_su_attempt_cur%ROWTYPE;
53: l_uoo_status uoo_status%ROWTYPE;
54: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
55: l_enr_cal_type VARCHAR2(20);
56: l_enr_ci_seq NUMBER(20);
64: l_alternate_code igs_ca_inst.alternate_code%type;
65: l_acad_message varchar2(100);
66: l_message VARCHAR2(1200);
67: l_return_status VARCHAR2(10);
68: l_sua_Status igs_En_Su_Attempt.unit_Attempt_Status%TYPE;
69:
70: BEGIN
71: --check if the unit is in discontinued state .
72: OPEN sua_status;
126: IF l_enr_comm = 'BOTH' THEN
127: l_enr_comm :='ALL';
128: END IF;
129:
130: OPEN igs_en_su_attempt_cur;
131: FETCH igs_en_su_attempt_cur INTO igs_en_su_attempt_rec;
132: CLOSE igs_en_su_attempt_cur;
133:
134: igs_en_sua_api.update_unit_attempt(
127: l_enr_comm :='ALL';
128: END IF;
129:
130: OPEN igs_en_su_attempt_cur;
131: FETCH igs_en_su_attempt_cur INTO igs_en_su_attempt_rec;
132: CLOSE igs_en_su_attempt_cur;
133:
134: igs_en_sua_api.update_unit_attempt(
135: X_ROWID => igs_en_su_attempt_rec.row_id,
128: END IF;
129:
130: OPEN igs_en_su_attempt_cur;
131: FETCH igs_en_su_attempt_cur INTO igs_en_su_attempt_rec;
132: CLOSE igs_en_su_attempt_cur;
133:
134: igs_en_sua_api.update_unit_attempt(
135: X_ROWID => igs_en_su_attempt_rec.row_id,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
131: FETCH igs_en_su_attempt_cur INTO igs_en_su_attempt_rec;
132: CLOSE igs_en_su_attempt_cur;
133:
134: igs_en_sua_api.update_unit_attempt(
135: X_ROWID => igs_en_su_attempt_rec.row_id,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
132: CLOSE igs_en_su_attempt_cur;
133:
134: igs_en_sua_api.update_unit_attempt(
135: X_ROWID => igs_en_su_attempt_rec.row_id,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
133:
134: igs_en_sua_api.update_unit_attempt(
135: X_ROWID => igs_en_su_attempt_rec.row_id,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
134: igs_en_sua_api.update_unit_attempt(
135: X_ROWID => igs_en_su_attempt_rec.row_id,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
135: X_ROWID => igs_en_su_attempt_rec.row_id,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
136: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
137: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
138: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
139: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
147: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
140: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
147: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
148: X_UNIT_ATTEMPT_STATUS => 'ENROLLED',
141: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
147: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
148: X_UNIT_ATTEMPT_STATUS => 'ENROLLED',
149: X_ADMINISTRATIVE_UNIT_STATUS => NULL,
142: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
147: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
148: X_UNIT_ATTEMPT_STATUS => 'ENROLLED',
149: X_ADMINISTRATIVE_UNIT_STATUS => NULL,
150: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
143: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
144: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
145: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
147: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
148: X_UNIT_ATTEMPT_STATUS => 'ENROLLED',
149: X_ADMINISTRATIVE_UNIT_STATUS => NULL,
150: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
151: X_DISCONTINUED_DT => NULL,
146: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
147: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
148: X_UNIT_ATTEMPT_STATUS => 'ENROLLED',
149: X_ADMINISTRATIVE_UNIT_STATUS => NULL,
150: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
151: X_DISCONTINUED_DT => NULL,
152: X_DCNT_REASON_CD => NULL,
153: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
149: X_ADMINISTRATIVE_UNIT_STATUS => NULL,
150: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
151: X_DISCONTINUED_DT => NULL,
152: X_DCNT_REASON_CD => NULL,
153: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
150: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
151: X_DISCONTINUED_DT => NULL,
152: X_DCNT_REASON_CD => NULL,
153: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
151: X_DISCONTINUED_DT => NULL,
152: X_DCNT_REASON_CD => NULL,
153: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
152: X_DCNT_REASON_CD => NULL,
153: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
153: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
154: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
155: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
156: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
157: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
158: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
159: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
160: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
161: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
162: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
163: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
164: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
165: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
166: X_MODE => 'R',
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
167: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
168: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
169: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
170: X_CART => igs_en_su_attempt_rec.CART,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
171: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
172: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
173: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
174: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
175: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
176: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
177: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
178: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
179: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
180: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
181: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
182: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
183: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
184: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
185: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
186: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
187: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
188: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
189: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
190: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
191: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
192: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
193: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
194: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
195: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
196: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
197: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
198: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
199: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
200: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
201: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
202: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
203: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code );
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
204:
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
212: p_uoo_id => igs_en_su_attempt_rec.uoo_id,
205: IF NOT igs_en_enroll_wlst.validate_unit( p_unit_cd => igs_en_su_attempt_rec.unit_cd,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
212: p_uoo_id => igs_en_su_attempt_rec.uoo_id,
213: p_message_name => p_message,
206: p_version_number => igs_en_su_attempt_rec.version_number,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
212: p_uoo_id => igs_en_su_attempt_rec.uoo_id,
213: p_message_name => p_message,
214: p_deny_warn => p_deny_warn,
207: p_cal_type => igs_en_su_attempt_rec.cal_type,
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
212: p_uoo_id => igs_en_su_attempt_rec.uoo_id,
213: p_message_name => p_message,
214: p_deny_warn => p_deny_warn,
215: p_course_cd => igs_en_su_attempt_rec.course_cd ) THEN
208: p_ci_sequence_number => igs_en_su_attempt_rec.ci_sequence_number,
209: p_location_cd => igs_en_su_attempt_rec.location_cd,
210: p_person_id => igs_en_su_attempt_rec.person_id,
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
212: p_uoo_id => igs_en_su_attempt_rec.uoo_id,
213: p_message_name => p_message,
214: p_deny_warn => p_deny_warn,
215: p_course_cd => igs_en_su_attempt_rec.course_cd ) THEN
216: p_return_status := 'FALSE';
211: p_unit_class => igs_en_su_attempt_rec.unit_class,
212: p_uoo_id => igs_en_su_attempt_rec.uoo_id,
213: p_message_name => p_message,
214: p_deny_warn => p_deny_warn,
215: p_course_cd => igs_en_su_attempt_rec.course_cd ) THEN
216: p_return_status := 'FALSE';
217: RETURN;
218: END IF; --END OF igs_en_enroll_wlst.validate_unit
219: