13:
14: -- Modified For : Enhancement Bug #1832130
15: -- Modified By : jbegum
16: -- Modification : The function Enrp_Upd_Sci_Ua was modified as part of the Enrollments Process build.
17: -- In the call to the update row of the table IGS_EN_SU_ATTEMPT the following columns were added:
18: -- GS_VERSION_NUMBER , ENR_METHOD_TYPE , FAILED_UNIT_RULE , CART , RSV_SEAT_EXT_ID .
19: -- In the call to the functions IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD and IGS_EN_GEN_008.ENRP_GET_UDDC_AUS
20: -- parameter UOO_ID has been added.
21: -- Also when the function IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD returns 'Y' the existing code use to have
18: -- GS_VERSION_NUMBER , ENR_METHOD_TYPE , FAILED_UNIT_RULE , CART , RSV_SEAT_EXT_ID .
19: -- In the call to the functions IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD and IGS_EN_GEN_008.ENRP_GET_UDDC_AUS
20: -- parameter UOO_ID has been added.
21: -- Also when the function IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD returns 'Y' the existing code use to have
22: -- a call to the delete row of the table IGS_EN_SU_ATTEMPT.This has been replaced with a call to update row
23: -- of the table IGS_EN_SU_ATTEMPT with the unit_attempt_status updated to 'DROPPED'
24: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
25: --
26: --nalkumar 12-Oct-2001 Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
19: -- In the call to the functions IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD and IGS_EN_GEN_008.ENRP_GET_UDDC_AUS
20: -- parameter UOO_ID has been added.
21: -- Also when the function IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD returns 'Y' the existing code use to have
22: -- a call to the delete row of the table IGS_EN_SU_ATTEMPT.This has been replaced with a call to update row
23: -- of the table IGS_EN_SU_ATTEMPT with the unit_attempt_status updated to 'DROPPED'
24: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
25: --
26: --nalkumar 12-Oct-2001 Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
27: -- Career impact Build Bug# 2027984.
20: -- parameter UOO_ID has been added.
21: -- Also when the function IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD returns 'Y' the existing code use to have
22: -- a call to the delete row of the table IGS_EN_SU_ATTEMPT.This has been replaced with a call to update row
23: -- of the table IGS_EN_SU_ATTEMPT with the unit_attempt_status updated to 'DROPPED'
24: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
25: --
26: --nalkumar 12-Oct-2001 Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
27: -- Career impact Build Bug# 2027984.
28: --kkillams 20-12-2001 Added attribute_category to attribute20 parameters are added to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
30: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career
31: -- Impact Part2 . Bug #2158626
32: --svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added to table handler
33: -- procedure calls as part of CCR - ENCR022.
34: --Nishikant 29-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
35: -- as a part of the bug 2172380.
36: --Nishikant 15-may-2002 Condition in an IF clause in the function Enrp_Upd_Sci_Ua modified as part of the bug#2364216.
37: --Who When What
38: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT
34: --Nishikant 29-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
35: -- as a part of the bug 2172380.
36: --Nishikant 15-may-2002 Condition in an IF clause in the function Enrp_Upd_Sci_Ua modified as part of the bug#2364216.
37: --Who When What
38: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT
39: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
40: --amuthu 03-OCT-2002 Modified Enrp_Upd_Sci_Ua to invoke workflow when a unit is dropped or discontinued
41: -- To do this created a new procedure invoke_drop_workflow. This was done as part of
42: -- Drop Transfer Workflow Build. Bug number 2599925.
39: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
40: --amuthu 03-OCT-2002 Modified Enrp_Upd_Sci_Ua to invoke workflow when a unit is dropped or discontinued
41: -- To do this created a new procedure invoke_drop_workflow. This was done as part of
42: -- Drop Transfer Workflow Build. Bug number 2599925.
43: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
44: -- table to igs_en_sua_api.update_unit_attempt. |
45: -- Changes wrt ENCR031 build. Bug#2643207 |
46: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
47: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
45: -- Changes wrt ENCR031 build. Bug#2643207 |
46: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
47: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
48: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
49: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
50: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
51: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
52:
53: PROCEDURE invoke_drop_workflow(p_uoo_ids IN VARCHAR2,
101: p_end_dt IN DATE ,
102: p_message_name OUT NOCOPY VARCHAR2)
103: RETURN boolean AS
104: -------------------------------------------------------------------------------------------
105: -- Update the IGS_EN_SU_ATTEMPT records as appropriate for the
106: -- student_intermission detail which has been entered.
107: -- Where the intermission start date is before the census date AND
108: -- intermission end date is after the census date,
109: -- REVISION (23/07/97): AND where the intermission start
118: -- If there are problems the routine will set the message number
119: -- and return FALSE.
120: --Change History:
121: --Who When What
122: --kkillams 28-04-2003 Modified cursor igs_en_su_attempt_cur due to change in pk of
123: -- student unit attempt w.r.t. bug number 2829262
124: --vangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
125: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
126: --bdeviset 13-SEP-2004 Added cursor c_sua_grade w.r.t bug no 3885804
128: BEGIN
129: DECLARE
130: NO_S_GEN_CAL_CONF_REC_FOUND EXCEPTION;
131: v_message_name VARCHAR2(30);
132: v_administrative_unit_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
133: v_discontinuation_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
134: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
135: v_do_remove BOOLEAN:=FALSE;
136: -- Revision 23/07/97
129: DECLARE
130: NO_S_GEN_CAL_CONF_REC_FOUND EXCEPTION;
131: v_message_name VARCHAR2(30);
132: v_administrative_unit_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
133: v_discontinuation_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
134: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
135: v_do_remove BOOLEAN:=FALSE;
136: -- Revision 23/07/97
137: e_vrn_cutoff_dt_alias_notfound EXCEPTION;
165: FROM IGS_GE_S_GEN_CAL_CON
166: WHERE s_control_num = 1;
167:
168: CURSOR c_student_unit_attempt(
169: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
170: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
171: SELECT DISTINCT sua.cal_type,
172: sua.ci_sequence_number,
173: ci.end_dt
166: WHERE s_control_num = 1;
167:
168: CURSOR c_student_unit_attempt(
169: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
170: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
171: SELECT DISTINCT sua.cal_type,
172: sua.ci_sequence_number,
173: ci.end_dt
174: FROM
171: SELECT DISTINCT sua.cal_type,
172: sua.ci_sequence_number,
173: ci.end_dt
174: FROM
175: IGS_EN_SU_ATTEMPT sua,
176: IGS_CA_INST ci
177: WHERE
178: sua.person_id = cp_person_id AND
179: sua.course_cd = cp_course_cd AND
181: ci.cal_type = sua.cal_type AND
182: ci.sequence_number = sua.ci_sequence_number;
183:
184: CURSOR c_student_unit_attempt_ci(
185: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
186: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
187: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
188: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
189: SELECT unit_cd,
182: ci.sequence_number = sua.ci_sequence_number;
183:
184: CURSOR c_student_unit_attempt_ci(
185: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
186: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
187: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
188: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
189: SELECT unit_cd,
190: version_number,
183:
184: CURSOR c_student_unit_attempt_ci(
185: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
186: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
187: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
188: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
189: SELECT unit_cd,
190: version_number,
191: cal_type,
184: CURSOR c_student_unit_attempt_ci(
185: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
186: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
187: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
188: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
189: SELECT unit_cd,
190: version_number,
191: cal_type,
192: ci_sequence_number,
194: ci_end_dt,
195: enrolled_dt,
196: uoo_id,
197: unit_attempt_status
198: FROM IGS_EN_SU_ATTEMPT
199: WHERE person_id = cp_person_id AND
200: course_cd = cp_course_cd AND
201: cal_type = cp_cal_type AND
202: ci_sequence_number = cp_ci_sequence_number AND
216:
217: -- cursor to determine of a unit attempt exists which has a finalized
218: -- or un-finalised mid-term grade or an un-finalized final grade.
219: CURSOR c_sua_grade IS
220: SELECT 'x' FROM IGS_AS_SU_STMPTOUT ou, igs_en_su_attempt sua
221: where sua . person_id = p_person_id
222: and sua .course_cd = p_course_cd
223: AND sua .unit_attempt_status = 'ENROLLED'
224: AND sua.person_id = ou.person_id
372: DECLARE
373: v_unit_cds VARCHAR2(4000);
374: v_uoo_ids VARCHAR2(4000);
375:
376: CURSOR igs_en_su_attempt_cur IS
377: SELECT igs_en_su_attempt.*
378: FROM igs_en_su_attempt
379: WHERE person_id = p_person_id AND
380: course_cd = p_course_cd AND
373: v_unit_cds VARCHAR2(4000);
374: v_uoo_ids VARCHAR2(4000);
375:
376: CURSOR igs_en_su_attempt_cur IS
377: SELECT igs_en_su_attempt.*
378: FROM igs_en_su_attempt
379: WHERE person_id = p_person_id AND
380: course_cd = p_course_cd AND
381: uoo_id = v_suaci_rec.uoo_id;
374: v_uoo_ids VARCHAR2(4000);
375:
376: CURSOR igs_en_su_attempt_cur IS
377: SELECT igs_en_su_attempt.*
378: FROM igs_en_su_attempt
379: WHERE person_id = p_person_id AND
380: course_cd = p_course_cd AND
381: uoo_id = v_suaci_rec.uoo_id;
382:
384: v_uoo_ids := null;
385: v_unit_cds := null;
386:
387:
388: FOR IGS_EN_SU_ATTEMPT_rec IN IGS_EN_SU_ATTEMPT_cur LOOP
389: -- Call the API to update the student unit attempt. This API is a
390: -- wrapper to the update row of the TBH.
391: invoke_drop_workflow(
392: p_uoo_ids => v_uoo_ids,
397: p_course_cd => p_course_cd,
398: p_message_name => v_message_name
399: );
400: igs_en_sua_api.update_unit_attempt(
401: X_ROWID => igs_en_su_attempt_rec.row_id,
402: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
398: p_message_name => v_message_name
399: );
400: igs_en_sua_api.update_unit_attempt(
401: X_ROWID => igs_en_su_attempt_rec.row_id,
402: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
399: );
400: igs_en_sua_api.update_unit_attempt(
401: X_ROWID => igs_en_su_attempt_rec.row_id,
402: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
400: igs_en_sua_api.update_unit_attempt(
401: X_ROWID => igs_en_su_attempt_rec.row_id,
402: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
401: X_ROWID => igs_en_su_attempt_rec.row_id,
402: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
402: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
403: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
404: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
405: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
406: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
414: X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
407: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
414: X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
415: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
408: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
414: X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
415: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
416: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
409: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
414: X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
415: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
416: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
417: X_DISCONTINUED_DT => v_discontinuation_dt,
410: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
411: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
414: X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
415: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
416: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
417: X_DISCONTINUED_DT => v_discontinuation_dt,
418: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
412: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
413: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
414: X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
415: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
416: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
417: X_DISCONTINUED_DT => v_discontinuation_dt,
418: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
419: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
415: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
416: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
417: X_DISCONTINUED_DT => v_discontinuation_dt,
418: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
419: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
416: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
417: X_DISCONTINUED_DT => v_discontinuation_dt,
418: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
419: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
417: X_DISCONTINUED_DT => v_discontinuation_dt,
418: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
419: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
418: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
419: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
419: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
420: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
421: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
422: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
423: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
424: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
425: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
426: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
427: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
428: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
429: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
430: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
431: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
432: X_MODE => 'R',
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
433: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
434: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
435: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
436: X_CART => igs_en_su_attempt_rec.CART,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
437: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
438: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
439: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
440: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
441: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
442: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
443: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
444: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
445: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
446: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
447: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
448: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
449: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
450: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
451: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
452: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
453: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
454: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
455: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
456: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
457: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
458: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
459: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
460: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
461: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
469: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
462: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
469: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
470: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
463: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
469: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
470: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
471: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code
464: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
469: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
470: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
471: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code
472: );
465: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
466: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
469: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
470: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
471: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code
472: );
473: IF v_unit_cds IS NULL THEN
467: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
468: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
469: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
470: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
471: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code
472: );
473: IF v_unit_cds IS NULL THEN
474: v_unit_cds := v_suaci_rec.unit_Cd;
475: ELSE
477: END IF;
478:
479:
480: IF v_uoo_ids IS NULL THEN
481: v_uoo_ids := to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
482: ELSE
483: v_uoo_ids := v_uoo_ids || ',' || to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
484: END IF;
485: END LOOP;
479:
480: IF v_uoo_ids IS NULL THEN
481: v_uoo_ids := to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
482: ELSE
483: v_uoo_ids := v_uoo_ids || ',' || to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
484: END IF;
485: END LOOP;
486:
487: END;
490: ELSE
491: -- Modified For : Enhancement Bug #1832130
492: -- Modified By : jbegum
493: -- When the function IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD returns 'Y' the existing code use to have
494: -- a call to the delete row of the table IGS_EN_SU_ATTEMPT.This has been replaced with a call to update row
495: -- of the table IGS_EN_SU_ATTEMPT with the unit_attempt_status updated to 'DROPPED'
496:
497: DECLARE
498: v_unit_cds VARCHAR2(4000);
491: -- Modified For : Enhancement Bug #1832130
492: -- Modified By : jbegum
493: -- When the function IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD returns 'Y' the existing code use to have
494: -- a call to the delete row of the table IGS_EN_SU_ATTEMPT.This has been replaced with a call to update row
495: -- of the table IGS_EN_SU_ATTEMPT with the unit_attempt_status updated to 'DROPPED'
496:
497: DECLARE
498: v_unit_cds VARCHAR2(4000);
499: v_uoo_ids VARCHAR2(4000);
496:
497: DECLARE
498: v_unit_cds VARCHAR2(4000);
499: v_uoo_ids VARCHAR2(4000);
500: CURSOR igs_en_su_attempt_cur IS
501: SELECT igs_en_su_attempt.*
502: FROM igs_en_su_attempt
503: WHERE person_id = p_person_id AND
504: course_cd = p_course_cd AND
497: DECLARE
498: v_unit_cds VARCHAR2(4000);
499: v_uoo_ids VARCHAR2(4000);
500: CURSOR igs_en_su_attempt_cur IS
501: SELECT igs_en_su_attempt.*
502: FROM igs_en_su_attempt
503: WHERE person_id = p_person_id AND
504: course_cd = p_course_cd AND
505: uoo_id = v_suaci_rec.uoo_id;
498: v_unit_cds VARCHAR2(4000);
499: v_uoo_ids VARCHAR2(4000);
500: CURSOR igs_en_su_attempt_cur IS
501: SELECT igs_en_su_attempt.*
502: FROM igs_en_su_attempt
503: WHERE person_id = p_person_id AND
504: course_cd = p_course_cd AND
505: uoo_id = v_suaci_rec.uoo_id;
506:
508:
509: v_uoo_ids := null;
510: v_unit_cds := null;
511:
512: FOR igs_en_su_attempt_rec IN igs_en_su_attempt_cur LOOP
513: -- Call the API to update the student unit attempt. This API is a
514: -- wrapper to the update row of the TBH.
515:
516: invoke_drop_workflow(
522: p_course_cd => p_course_cd,
523: p_message_name => v_message_name);
524:
525: igs_en_sua_api.update_unit_attempt(
526: X_ROWID => igs_en_su_attempt_rec.row_id,
527: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
523: p_message_name => v_message_name);
524:
525: igs_en_sua_api.update_unit_attempt(
526: X_ROWID => igs_en_su_attempt_rec.row_id,
527: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
524:
525: igs_en_sua_api.update_unit_attempt(
526: X_ROWID => igs_en_su_attempt_rec.row_id,
527: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
525: igs_en_sua_api.update_unit_attempt(
526: X_ROWID => igs_en_su_attempt_rec.row_id,
527: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
526: X_ROWID => igs_en_su_attempt_rec.row_id,
527: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
527: X_PERSON_ID => igs_en_su_attempt_rec.person_id,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
528: X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
529: X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
530: X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
531: X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
532: X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
533: X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
534: X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
535: X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
536: X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
537: X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
538: X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
539: X_UNIT_ATTEMPT_STATUS => 'DROPPED',
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
540: X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
541: X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
542: X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
543: X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
544: X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
545: X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
546: X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
547: X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
548: X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
549: X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
550: X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
551: X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
552: X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
553: X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
554: X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
555: X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
556: X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
557: X_MODE => 'R',
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
558: X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
559: X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
560: X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
561: X_CART => igs_en_su_attempt_rec.CART,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
562: X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
563: X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
564: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
565: X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
566: X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
567: X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
568: X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
569: X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
570: X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
571: X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
572: X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
573: X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
574: X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
575: X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
576: X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
577: X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
578: X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
579: X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
580: X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
581: X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
582: X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
583: X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
584: X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
585: X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
586: X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
594: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
587: X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
594: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
595: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
588: X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
594: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
595: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
596: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code);
589: X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
594: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
595: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
596: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code);
597:
590: X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
591: X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
594: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
595: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
596: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code);
597:
598: IF v_unit_cds IS NULL THEN
592: X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
593: X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
594: X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
595: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
596: X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code);
597:
598: IF v_unit_cds IS NULL THEN
599: v_unit_cds := v_suaci_rec.unit_Cd;
600: ELSE
602: END IF;
603:
604:
605: IF v_uoo_ids IS NULL THEN
606: v_uoo_ids := to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
607: ELSE
608: v_uoo_ids := v_uoo_ids || ',' || to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
609: END IF;
610:
604:
605: IF v_uoo_ids IS NULL THEN
606: v_uoo_ids := to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
607: ELSE
608: v_uoo_ids := v_uoo_ids || ',' || to_char(IGS_EN_SU_ATTEMPT_rec.uoo_id);
609: END IF;
610:
611:
612: END LOOP;