[Home] [Help]
16: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
17: --Nishikant 15-may-2002 Condition in an IF clause in the procedure IGS_PR_upd_out_apply modified as part of the bug#2364216.
18: -- And also the unit attempt was being deleted earlier if any student unit attempt outcome record not found for the person,
19: -- now its modified to be update the unit attempt record to DROPPED status.
20: -- pradhakr 15-Dec-2002 Changed the call to the update_row of igs_en_su_attempt table to igs_en_sua_api.update_unit_attempt.
21: -- Changes wrt ENCR031 build. Bug#2643207
22: --anilk 03-Jan-2003 Removed the message numbers and used the appropriate IGS messages, Bug# 2413841
23: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
24: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
22: --anilk 03-Jan-2003 Removed the message numbers and used the appropriate IGS messages, Bug# 2413841
23: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
24: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
25: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
26: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
27: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
28: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
29: --------------------------------------------------------------------------------
30: --
23: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
24: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
25: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
26: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
27: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
28: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
29: --------------------------------------------------------------------------------
30: --
31: -- kdande; 23-Apr-2003; Bug# 2829262
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
806: p_message_name VARCHAR2,
807: p_text IGS_GE_s_log_entry.text%TYPE
808: ) IS
809: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
810: --added as part of Prevent Dropping Core Units. Enh Bug# 3052432
811: BEGIN -- prgpl_ins_log_entry
812: -- create a log entry
813: DECLARE
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,
928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)
929: RETURN BOOLEAN
930: IS
931: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
932: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
933: BEGIN -- prgpl_upd_spo
934: DECLARE
935: CURSOR c_spo IS
1733: p_teach_ci_sequence_number => v_sua_rec.ci_sequence_number,
1734: p_person_id => v_sua_rec.person_id,
1735: p_course_cd => v_sua_rec.course_cd,
1736: p_message_name => v_message_name);
1737: igs_en_sua_api.update_unit_attempt (
1738: X_ROWID => v_sua_rec.rowid,
1739: X_PERSON_ID => v_sua_rec.person_id,
1740: X_COURSE_CD => v_sua_rec.course_cd,
1741: X_UNIT_CD => v_sua_rec.unit_cd,
1892: p_teach_ci_sequence_number => v_sua_rec.ci_sequence_number,
1893: p_person_id => v_sua_rec.person_id,
1894: p_course_cd => v_sua_rec.course_cd,
1895: p_message_name => v_message_name );
1896: igs_en_sua_api.update_unit_attempt(
1897: X_ROWID => v_sua_rec.ROWID,
1898: X_PERSON_ID => v_sua_rec.PERSON_ID,
1899: X_COURSE_CD => v_sua_rec.COURSE_CD,
1900: X_UNIT_CD => v_sua_rec.UNIT_CD,