[Home] [Help]
7: call as a part of bug 3544927.
8: --npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkgs call
9: -- modified for the new employment category column added in the table
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: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
14: -- Added four new parameters to call it as per the Bug# 2027984.
15: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
41: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
42: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
43: --smaddali 04-jul-03 modified procedure enrp_upd_sca_coo for bug 3035523 , to update igs_he_st_spa_all.version_number
44: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
45: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
46: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
47: -- and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
48: --ptandon 05-DEC-2003 Modified cursor c_sua in Function Enrp_Upd_Sca_Discont as per Placements build. Bug# 3052438.
49: --vkarthik 19-Apr-2004 Modified exception handling section to handle no_ausl_record_found
42: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
43: --smaddali 04-jul-03 modified procedure enrp_upd_sca_coo for bug 3035523 , to update igs_he_st_spa_all.version_number
44: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
45: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
46: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
47: -- and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
48: --ptandon 05-DEC-2003 Modified cursor c_sua in Function Enrp_Upd_Sca_Discont as per Placements build. Bug# 3052438.
49: --vkarthik 19-Apr-2004 Modified exception handling section to handle no_ausl_record_found
50: for bug 3526251 in Enrp_Upd_Sca_Discont
832: || Value will be passed if function is invoked from program transfer
833: || else null value wil come w.r.t bug 2863707
834: || kkillams 28-04-2003 Modified c_suao_check,c_sua_drop and c_igs_en_su_attempt cursors in this function
835: || due to change in pk of student unit attempt w.r.t. bug number 2829262
836: || rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
837: || and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
838: || ptandon 05-DEC-2003 Modified the cursor c_sua to include the order by clause to select the subordinate units first
839: || for discontinuation. Placements build. Bug# 3052438.
840: || vkarthik 19-Apr-2004 Modified exception handling section to handle no_ausl_record_found
1044: FOR sua_drop_rec IN c_sua_drop LOOP
1045: --Following validation is added as part of bug fix.2860412
1046: --Cursor will checks the context unit attempt got transferred or not.
1047: --If Unit got transferred then call the direct tbh call else
1048: --call the igs_en_sua_api.update_unit_attempt.
1049: --Reason is,igs_en_sua_api.update_unit_attempt function will
1050: --decrement available seats for that unit section.
1051: tr_flag:=0;
1052: OPEN c_trans_cd(sua_drop_rec.uoo_id);
1045: --Following validation is added as part of bug fix.2860412
1046: --Cursor will checks the context unit attempt got transferred or not.
1047: --If Unit got transferred then call the direct tbh call else
1048: --call the igs_en_sua_api.update_unit_attempt.
1049: --Reason is,igs_en_sua_api.update_unit_attempt function will
1050: --decrement available seats for that unit section.
1051: tr_flag:=0;
1052: OPEN c_trans_cd(sua_drop_rec.uoo_id);
1053: FETCH c_trans_cd INTO tr_flag;
1065: IF (p_transf_course_cd IS NULL OR tr_flag =0)
1066: THEN
1067: -- Call the API to update the student unit attempt. This API is a
1068: -- wrapper to the update row of the TBH.
1069: igs_en_sua_api.update_unit_attempt(
1070: X_ROWID => sua_drop_rec.ROWID,
1071: X_PERSON_ID => sua_drop_rec.PERSON_ID,
1072: X_COURSE_CD => sua_drop_rec.COURSE_CD ,
1073: X_UNIT_CD => sua_drop_rec.UNIT_CD,
1297:
1298: --Following validation is added as part of bug fix.2860412
1299: --Cursor will checks the context unit attempt got transferred or not.
1300: --If Unit got transferred then call the direct tbh call else
1301: --call the igs_en_sua_api.update_unit_attempt.
1302: --Reason is,igs_en_sua_api.update_unit_attempt function will
1303: --decrement available seats for the unit section.
1304: invoke_drop_workflow(
1305: p_uoo_ids => v_uoo_ids,
1298: --Following validation is added as part of bug fix.2860412
1299: --Cursor will checks the context unit attempt got transferred or not.
1300: --If Unit got transferred then call the direct tbh call else
1301: --call the igs_en_sua_api.update_unit_attempt.
1302: --Reason is,igs_en_sua_api.update_unit_attempt function will
1303: --decrement available seats for the unit section.
1304: invoke_drop_workflow(
1305: p_uoo_ids => v_uoo_ids,
1306: p_unit_cds => v_unit_cds,
1312: p_message_name => v_message_name
1313: );
1314: -- Call the API to update the student unit attempt. This API is a
1315: -- wrapper to the update row of the TBH.
1316: igs_en_sua_api.update_unit_attempt(
1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,
1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
3109: --Change History:
3110: --Who When What
3111: --kkillams 28-04-2003 Modified code in this function due to change in pk of student
3112: -- unit attempt w.r.t. bug number 2829262
3113: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
3114: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
3115: -------------------------------------------------------------------------------------------
3116: RETURN BOOLEAN AS
3117: gv_other_detail VARCHAR2(255);
3280: BEGIN
3281: FOR c_assu_rec IN c_assu LOOP
3282: -- Call the API to update the student unit attempt. This API is a
3283: -- wrapper to the update row of the TBH.
3284: igs_en_sua_api.update_unit_attempt(
3285: x_rowid => c_assu_rec.rowid,
3286: x_person_id => c_assu_rec.person_id,
3287: x_course_cd => c_assu_rec.course_cd ,
3288: x_unit_cd => c_assu_rec.unit_cd,
3551: BEGIN
3552: FOR c_suatt_rec IN c_suatt LOOP
3553: -- Call the API to update the student unit attempt. This API is a
3554: -- wrapper to the update row of the TBH.
3555: igs_en_sua_api.update_unit_attempt(
3556: X_ROWID => c_suatt_rec.ROWID,
3557: X_PERSON_ID => c_suatt_rec.PERSON_ID,
3558: X_COURSE_CD => c_suatt_rec.COURSE_CD ,
3559: X_UNIT_CD => c_suatt_rec.UNIT_CD,