APPS.IGS_PR_GEN_004 dependencies on IGS_EN_SU_ATTEMPT

Line 15: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT

11: -- p_legacy. Bug#2661533.
12: --amuthu 01-Oct-2002 Added call to drop_all_workflow as part of Drop Transfer Build.
13: -- the calls to the drop_all workflow is done after either dropping or
14: -- discontinuing a unit attempt. created new local procedure invoke_drop_workflow Bug 2599925.
15: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT
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.

Line 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.

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.

Line 26: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures

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: --

Line 765: FROM IGS_EN_SU_ATTEMPT sua

761: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
762: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
763: SELECT
764: sua.*, sua.ROWID
765: FROM IGS_EN_SU_ATTEMPT sua
766: WHERE sua.person_id = cp_spo_person_id AND
767: sua.course_cd = cp_spo_course_cd AND
768: sua.unit_attempt_status = cst_enrolled AND
769: sua.unit_cd IN

Line 784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

780: --
781: CURSOR c_suao (
782: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
787: cp_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
788: SELECT 'X'

Line 785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

781: CURSOR c_suao (
782: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
787: cp_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
788: SELECT 'X'
789: FROM IGS_AS_SU_STMPTOUT suao

Line 786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

782: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
787: cp_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
788: SELECT 'X'
789: FROM IGS_AS_SU_STMPTOUT suao
790: WHERE suao.person_id = cp_spo_person_id AND

Line 787: cp_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
787: cp_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
788: SELECT 'X'
789: FROM IGS_AS_SU_STMPTOUT suao
790: WHERE suao.person_id = cp_spo_person_id AND
791: suao.course_cd = cp_spo_course_cd AND

Line 1883: UPDATE IGS_EN_SU_ATTEMPT

1879: ELSE
1880:
1881: -- Discontinue unit attempt
1882: /*
1883: UPDATE IGS_EN_SU_ATTEMPT
1884: SET discontinued_dt = v_spo_rec.decision_dt,
1885: administrative_unit_status = v_administrative_unit_status
1886: WHERE CURRENT OF c_sua;
1887: */

Line 2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';

2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --
2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';
2892: --
2893: -- Append Person ID Group filter to the Where clause only when it is passed
2894: --
2895: IF (p_group_id IS NOT NULL) THEN