eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_004 dependencies on IGS_EN_SU_ATTEMPT

Line 10: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt

6: -- prraj 10-Jan-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V
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

Line 23: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697

19: --Updated by Sudhir.
20: --Update Date: 28-Feb-2002.
21: --Added a new parameter p_admin_unit_sta to the procedure enrp_dropall_unit and the logic for processing it.
22:
23: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
24: --Aiyer 10-Oct-2001 Added the column grading schema code in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
25: --svenkata 20-Dec-2001 Added the columns student_career_transcript,student_career_statistics in all Tbh calls of
26: -- IGS_EN_SU_ATTEMPT_PKG as a part of the bug # 2158626
27: --vvutukur 7-Jan-2002 Added primary_program_type,key_program as part of cursor c_sca_hist, for SFCR007 Build, bug 2162747

Line 24: --Aiyer 10-Oct-2001 Added the column grading schema code in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.

20: --Update Date: 28-Feb-2002.
21: --Added a new parameter p_admin_unit_sta to the procedure enrp_dropall_unit and the logic for processing it.
22:
23: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
24: --Aiyer 10-Oct-2001 Added the column grading schema code in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
25: --svenkata 20-Dec-2001 Added the columns student_career_transcript,student_career_statistics in all Tbh calls of
26: -- IGS_EN_SU_ATTEMPT_PKG as a part of the bug # 2158626
27: --vvutukur 7-Jan-2002 Added primary_program_type,key_program as part of cursor c_sca_hist, for SFCR007 Build, bug 2162747
28: --svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added to table handler procedure calls as part of

Line 26: -- IGS_EN_SU_ATTEMPT_PKG as a part of the bug # 2158626

22:
23: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
24: --Aiyer 10-Oct-2001 Added the column grading schema code in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
25: --svenkata 20-Dec-2001 Added the columns student_career_transcript,student_career_statistics in all Tbh calls of
26: -- IGS_EN_SU_ATTEMPT_PKG as a part of the bug # 2158626
27: --vvutukur 7-Jan-2002 Added primary_program_type,key_program as part of cursor c_sca_hist, for SFCR007 Build, bug 2162747
28: --svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added to table handler procedure calls as part of
29: -- CCR - ENCR022.
30: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG

Line 30: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG

26: -- IGS_EN_SU_ATTEMPT_PKG as a part of the bug # 2158626
27: --vvutukur 7-Jan-2002 Added primary_program_type,key_program as part of cursor c_sca_hist, for SFCR007 Build, bug 2162747
28: --svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added to table handler procedure calls as part of
29: -- CCR - ENCR022.
30: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
31: -- as a part of the bug 2172380.
32: --Nishikant 15-may-2002 Condition in an IF clause in the function Enrp_Dropall_Unit modified as part of the bug#2364216.
33: --sudhir 23-MAY-2002 Raise exception if multiple admin unit status found.
34: --amuthu 26-DEC-2002 when dropping a wailtisted unit added code to create a TODO rec

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

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

Line 795: FROM IGS_EN_SU_ATTEMPT sua,

791: v_record_count NUMBER;
792: CURSOR c_sua_cir_ci_cat_cs IS
793: SELECT DISTINCT cir.sup_cal_type,
794: cir.sup_ci_sequence_number
795: FROM IGS_EN_SU_ATTEMPT sua,
796: IGS_CA_INST_REL cir,
797: IGS_CA_INST ci,
798: IGS_CA_TYPE cat,
799: IGS_CA_STAT cs

Line 851: -- Update all the unit attempt records of a student in the table IGS_EN_SU_ATTEMPT with

847:
848: AS
849:
850: BEGIN -- Enrp_Dropall_Unit
851: -- Update all the unit attempt records of a student in the table IGS_EN_SU_ATTEMPT with
852: -- unit_attempt_status as 'DROPPED' or 'DISCONTIN'
853: /* HISTORY
854: WHO WHEN WHAT
855: mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT

Line 855: mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT

851: -- Update all the unit attempt records of a student in the table IGS_EN_SU_ATTEMPT with
852: -- unit_attempt_status as 'DROPPED' or 'DISCONTIN'
853: /* HISTORY
854: WHO WHEN WHAT
855: mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT
856: for Bug 2554109 MINI Waitlist Build for Jan 03 Release
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)

Line 878: FROM IGS_EN_SU_ATTEMPT U

874: l_val VARCHAR2(1);
875: --modified cursor for performance bug 3693713
876: CURSOR c_unit_attempt IS
877: SELECT U.*
878: FROM IGS_EN_SU_ATTEMPT U
879: WHERE person_id = p_person_id
880: AND ((unit_attempt_status IN ('ENROLLED','INVALID','WAITLISTED'))
881: OR (unit_attempt_status = 'DUPLICATE' AND P_UOO_ID IS NOT NULL))
882: AND course_cd = p_program_cd AND ((p_uoo_id IS NULL) OR (uoo_id = p_uoo_id));

Line 957: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(X_ROWID => c_unit_attempt_rec.row_id);

953:
954: -- if it is a duplicate unit attempt then delete the unit attempt instead of dropping it.
955:
956: IF c_unit_attempt_rec.unit_attempt_status = 'DUPLICATE' THEN
957: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(X_ROWID => c_unit_attempt_rec.row_id);
958: RETURN;
959: END If;
960:
961: -- If dropping of the 'unit attempt BY a student ' is allowed within the nominated teaching calendar instance at the nominated