[Home] [Help]
7: -- with base table IGS_EN_NSTD_USEC_DL Bug# 2750716
8: -- prraj 06-Jan-2003 Changed message for record cutoff in function Enrp_Get_Rec_Window
9: -- as part of Bug# 2730025
10: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
11: -- table to igs_en_sua_api.update_unit_attempt.
12: -- Changes wrt ENCR031 build. Bug#2643207
13: --ayedubat 02-JUL-2002 Changed the procedure, Enrp_Dropall_Unit for the bug Fix:2423605
14: --ayedubat 30-MAY-2002 Changed the function: Enrp_Get_Rec_Window for the bug fix:2337161
15: --amuthu 10-May-2002 Commented the exception section in
34: --amuthu 26-DEC-2002 when dropping a wailtisted unit added code to create a TODO rec
35: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
36: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
37: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
38: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
39: --rvangala 07-OCT-03 Passing core_indicator_code to IGS_EN_SUA-API.UPDATE_UNIT_ATTEMPT added as part of Prevent Dropping
40: -- Core Units. Enh Bug# 3052432
41: -- gmaheswa 13-Nov-2003 Bug 3227107 address changes . stubbed Enrp_get_pa_gap.
42: -- amuthu 14-JUL-2004 Allowing the drop of duplicate unit attempt as
35: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
36: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
37: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
38: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
39: --rvangala 07-OCT-03 Passing core_indicator_code to IGS_EN_SUA-API.UPDATE_UNIT_ATTEMPT added as part of Prevent Dropping
40: -- Core Units. Enh Bug# 3052432
41: -- gmaheswa 13-Nov-2003 Bug 3227107 address changes . stubbed Enrp_get_pa_gap.
42: -- amuthu 14-JUL-2004 Allowing the drop of duplicate unit attempt as
43: -- part of IGS.M bug 3765628/ IGS.L.#R bug 3703889
857: ayedubat 02-JUL-2002 Added a new validation to check the Variation Window Cutoff Date
858: for the bug Fix:2423605
859: ayedubat 26-JUN-2002 Changed the width of the variable,l_adm_unit_status_ret to VARCHAR2(255)
860: and also removed the exception handler for the bug fix:2423605
861: rvangala 07-OCT-03 Passing core_indicator_code to IGS_EN_SUA-API.UPDATE_UNIT_ATTEMPT added as part of Prevent Dropping
862: Core Units. Enh Bug# 3052432
863: amuthu 9-Aug-2006 If the default drop reason cannot be determined then
864: -- stopping the further processing and showing a newly added message*/
865:
966: IF (l_unit_attempt = 'Y' OR c_unit_attempt_rec.unit_attempt_status = 'WAITLISTED') THEN
967:
968: -- Call the API to update the student unit attempt. This API is a
969: -- wrapper to the update row of the TBH.
970: igs_en_sua_api.update_unit_attempt (
971: X_ROWID => c_unit_attempt_rec.row_id,
972: X_PERSON_ID => c_unit_attempt_rec.person_id,
973: X_COURSE_CD => c_unit_attempt_rec.course_cd,
974: X_UNIT_CD => c_unit_attempt_rec.unit_cd,
1104: END IF;
1105:
1106: -- Call the API to update the student unit attempt. This API is a
1107: -- wrapper to the update row of the TBH.
1108: igs_en_sua_api.update_unit_attempt(
1109: X_ROWID => c_unit_attempt_rec.row_id,
1110: X_PERSON_ID => c_unit_attempt_rec.person_id,
1111: X_COURSE_CD => c_unit_attempt_rec.course_cd,
1112: X_UNIT_CD => c_unit_attempt_rec.unit_cd,