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_SUSA_YEAR_V

Line 824: FROM igs_en_susa_year_v

820: --smaddali added this new cursor for YOP-EN dld bug#2156956
821: -- get the number of academic periods within the unit set
822: CURSOR c_num_acad_perd IS
823: SELECT DISTINCT acad_perd
824: FROM igs_en_susa_year_v
825: WHERE person_id = p_person_id
826: AND course_cd = p_course_cd
827: AND unit_set_cd = p_unit_set_cd ;
828: -- end of changes by smaddali

Line 952: -- for the pattern of study, if so get number of periods form igs_en_susa_year_v else use original function

948: -- Determine the number of academic periods in which the
949: -- student has been enrolled.
950: --smaddali adding code for YOP-EN dld . bug#2156956
951: -- If year of program mode is enabled then check if 'academic period within unit sets' is checked
952: -- for the pattern of study, if so get number of periods form igs_en_susa_year_v else use original function
953: --l_rec_exist checks if vt_two_pos has any values in it.
954: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' AND l_rec_exist THEN
955: IF NVL(vt_two_pos(vt_two_pos.FIRST).acad_perd_unit_set,'N') = 'Y' AND
956: p_unit_set_cd IS NOT NULL THEN

Line 2714: FROM igs_en_susa_year_v

2710: AND susa.rqrmnts_complete_dt IS NULL;
2711:
2712: CURSOR c_num_acad_perd IS
2713: SELECT DISTINCT acad_perd
2714: FROM igs_en_susa_year_v
2715: WHERE person_id = p_person_id
2716: AND course_cd = p_program_cd
2717: AND unit_set_cd = p_unit_set_cd ;
2718:

Line 2789: -- Get number of periods from igs_en_susa_year_v else use original function

2785: -- If year of program mode is enabled
2786: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' AND l_rec_exist THEN
2787:
2788: -- If 'Academic Period within Unit Sets' is checked for the pattern of study,
2789: -- Get number of periods from igs_en_susa_year_v else use original function
2790: -- igs_en_gen_004.enrp_get_perd_num.
2791: IF NVL(p_acad_perd_unit_set,'N') = 'Y' AND p_unit_set_cd IS NOT NULL THEN
2792: OPEN c_num_acad_perd;
2793: FETCH c_num_acad_perd INTO l_period_number;

Line 3139: FROM igs_en_susa_year_v

3135:
3136:
3137: CURSOR c_num_acad_perd IS
3138: SELECT DISTINCT acad_perd
3139: FROM igs_en_susa_year_v
3140: WHERE person_id = p_person_id
3141: AND course_cd = p_src_program_cd
3142: AND unit_set_cd = p_unit_set_cd ;
3143:

Line 3202: -- Get number of periods from igs_en_susa_year_v else use original function

3198: -- If year of program mode is enabled
3199: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
3200:
3201: -- If 'Academic Period within Unit Sets' is checked for the pattern of study,
3202: -- Get number of periods from igs_en_susa_year_v else use original function
3203: -- igs_en_gen_004.enrp_get_perd_num.
3204: IF NVL(p_acad_perd_unit_set,'N') = 'Y' AND p_unit_set_cd IS NOT NULL THEN
3205: OPEN c_num_acad_perd;
3206: FETCH c_num_acad_perd INTO l_period_number;