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_009 dependencies on IGS_EN_SU_ATTEMPT

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

1: PACKAGE BODY Igs_En_Gen_009 AS
2: /* $Header: IGSEN09B.pls 120.1 2005/09/30 02:59:37 appldev ship $ */
3:
4: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
5: --sarakshi 16-Nov-2004 Enh#4000939, added column APPROVED_DATE,EFFECTIVE_TERM_CAL_TYPE,EFFECTIVE_TERM_SEQUENCE_NUM and
6: -- DISCONTINUE_SOURCE_FLAG in the insert row call of IGS_PS_STDNT_TRN_PKG in procedure Enrp_Ins_Sct_Trnsfr
7: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
8: -- table to igs_en_sua_api.update_unit_attempt.

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

3:
4: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
5: --sarakshi 16-Nov-2004 Enh#4000939, added column APPROVED_DATE,EFFECTIVE_TERM_CAL_TYPE,EFFECTIVE_TERM_SEQUENCE_NUM and
6: -- DISCONTINUE_SOURCE_FLAG in the insert row call of IGS_PS_STDNT_TRN_PKG in procedure Enrp_Ins_Sct_Trnsfr
7: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
8: -- table to igs_en_sua_api.update_unit_attempt.
9: -- Changes wrt ENCR031 build. Bug#2643207
10: -- Aiyer 10-Oct-2001 Added the columns grading schema code and gs_version_number in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
11: -- kkillams 13-11-2001 Added the columns primary_program_type, primary_prog_type_source, catalog_cal_type, catalog_seq_num,key_program as part of the bug 2027984

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

6: -- DISCONTINUE_SOURCE_FLAG in the insert row call of IGS_PS_STDNT_TRN_PKG in procedure Enrp_Ins_Sct_Trnsfr
7: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
8: -- table to igs_en_sua_api.update_unit_attempt.
9: -- Changes wrt ENCR031 build. Bug#2643207
10: -- Aiyer 10-Oct-2001 Added the columns grading schema code and gs_version_number in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
11: -- kkillams 13-11-2001 Added the columns primary_program_type, primary_prog_type_source, catalog_cal_type, catalog_seq_num,key_program as part of the bug 2027984
12: -- Nalin Kumar 23-Nov-2001 Added enrp_ins_award_aim procedure as the part of
13: -- UK Award Aims DLD Bug ID: 1366899
14: -- pradhakr 06-Dec-2001 Added a column deg_aud_detail_id in the TBH call of IGS_EN_SU_ATTEMPT as part of

Line 14: -- pradhakr 06-Dec-2001 Added a column deg_aud_detail_id in the TBH call of IGS_EN_SU_ATTEMPT as part of

10: -- Aiyer 10-Oct-2001 Added the columns grading schema code and gs_version_number in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
11: -- kkillams 13-11-2001 Added the columns primary_program_type, primary_prog_type_source, catalog_cal_type, catalog_seq_num,key_program as part of the bug 2027984
12: -- Nalin Kumar 23-Nov-2001 Added enrp_ins_award_aim procedure as the part of
13: -- UK Award Aims DLD Bug ID: 1366899
14: -- pradhakr 06-Dec-2001 Added a column deg_aud_detail_id in the TBH call of IGS_EN_SU_ATTEMPT as part of
15: -- Degree Audit Interface build (Bug# 2033208)
16: -- svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career
17: -- Impact Part2 . Bug #2158626
18: -- svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added

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

16: -- svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career
17: -- Impact Part2 . Bug #2158626
18: -- svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added
19: -- to table handler procedure calls as part of CCR - ENCR022.
20: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
21: -- as a part of the bug 2172380.
22: -- svenkata 25-02-02 Removed the procedure ENRP_INS_ENRL_FORM as part of CCR
23: -- ENCR024 .Bug # 2239050
24: -- Nishikant 13- JUN-2002 The code got modified to set the out NOCOPY parameter p_message instead of 'IGS_EN_NOT_CUR_ENROL'. as per the bug#2413811.

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

616:
617: /**********************************/
618: --Change History :-
619: --Who When What
620: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in insert row of IGS_EN_SU_ATTEMPT
621: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
622: --pradhakr 23-Sep-2002 Added a new parameter p_units_indicator in the package spec and body
623: -- as part of Core Vs Optional DLD. Bug# 2581270
624: --svanukur 09-jul-2003 Created the variable l_rec_exist to check if the cursor c_pos returns any

Line 832: FROM IGS_EN_SU_ATTEMPT sua

828: -- end of changes by smaddali
829:
830: CURSOR c_uoo_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
831: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
832: FROM IGS_EN_SU_ATTEMPT sua
833: WHERE sua.person_id = p_person_id AND
834: sua.course_cd = p_course_cd AND
835: sua.uoo_id = p_uoo_id;
836:

Line 858: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

854: cst_core_only VARCHAR2(10) := 'CORE_ONLY';
855: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
856: --smaddali added this cursor for YOP-EN dld
857: CURSOR c_sua (
858: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
859: SELECT 'x'
860: FROM IGS_EN_SU_ATTEMPT sua
861: WHERE person_id = p_person_id AND
862: course_cd = p_course_cd AND

Line 860: FROM IGS_EN_SU_ATTEMPT sua

856: --smaddali added this cursor for YOP-EN dld
857: CURSOR c_sua (
858: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
859: SELECT 'x'
860: FROM IGS_EN_SU_ATTEMPT sua
861: WHERE person_id = p_person_id AND
862: course_cd = p_course_cd AND
863: uoo_id = cp_uoo_id ;
864: v_sua_rec VARCHAR2(1);

Line 867: l_core_indicator_code IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;

863: uoo_id = cp_uoo_id ;
864: v_sua_rec VARCHAR2(1);
865:
866: l_rec_exist BOOLEAN;
867: l_core_indicator_code IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
868:
869: l_waitlist_flag VARCHAR2(1) := NULL;
870: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
871: l_enr_uoo_ids VARCHAR2(2000);

Line 2974: CURSOR chk_dest_core_ind (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,

2970:
2971: RETURN VARCHAR2
2972: IS
2973:
2974: CURSOR chk_dest_core_ind (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
2975: cp_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
2976: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
2977: SELECT core_indicator_code
2978: FROM IGS_EN_SU_ATTEMPT

Line 2975: cp_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,

2971: RETURN VARCHAR2
2972: IS
2973:
2974: CURSOR chk_dest_core_ind (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
2975: cp_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
2976: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
2977: SELECT core_indicator_code
2978: FROM IGS_EN_SU_ATTEMPT
2979: WHERE person_id = cp_person_id

Line 2976: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS

2972: IS
2973:
2974: CURSOR chk_dest_core_ind (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
2975: cp_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
2976: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
2977: SELECT core_indicator_code
2978: FROM IGS_EN_SU_ATTEMPT
2979: WHERE person_id = cp_person_id
2980: AND course_cd = cp_course_cd

Line 2978: FROM IGS_EN_SU_ATTEMPT

2974: CURSOR chk_dest_core_ind (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
2975: cp_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
2976: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
2977: SELECT core_indicator_code
2978: FROM IGS_EN_SU_ATTEMPT
2979: WHERE person_id = cp_person_id
2980: AND course_cd = cp_course_cd
2981: AND uoo_id = cp_uoo_id;
2982:

Line 3099: l_dest_core_ind IGS_EN_SU_ATTEMPT.CORE_INDICATOR_CODE%TYPE;

3095: susa.student_confirmed_ind = 'Y' AND
3096: susa.end_dt IS NULL);
3097:
3098: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;
3099: l_dest_core_ind IGS_EN_SU_ATTEMPT.CORE_INDICATOR_CODE%TYPE;
3100: l_message VARCHAR2(100);
3101: l_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
3102: l_row_count NUMBER;
3103: l_pos_count NUMBER;