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.

[Home] [Help]

APPS.IGS_EN_SUA_API dependencies on IGS_EN_OR_UNIT_WLST

Line 102: SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst_v

98: -- Getting the maximum students per waitlist from organization level.
99: CURSOR c_max_std_per_wait_org (cp_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE,
100: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
101: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS
102: SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst_v
103: WHERE org_unit_cd = cp_org_unit_cd
104: AND cal_type = cp_cal_type
105: AND sequence_number = cp_ci_sequence_number ;
106: l_max_std_per_wait_org igs_en_or_unit_wlst_v.max_stud_per_wlst%TYPE;

Line 106: l_max_std_per_wait_org igs_en_or_unit_wlst_v.max_stud_per_wlst%TYPE;

102: SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst_v
103: WHERE org_unit_cd = cp_org_unit_cd
104: AND cal_type = cp_cal_type
105: AND sequence_number = cp_ci_sequence_number ;
106: l_max_std_per_wait_org igs_en_or_unit_wlst_v.max_stud_per_wlst%TYPE;
107:
108: -- end of the added three cursors. pmarada
109: -- Cursor to Check if Waitlisting is allowed at the unit section level .
110: CURSOR c_wait_allow_unit_section ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 670: FROM igs_En_or_unit_wlst

666:
667: CURSOR cur_simul_org_allwd(cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
668: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
669: SELECT smtanus_wlst_unit_enr_alwd
670: FROM igs_En_or_unit_wlst
671: WHERE cal_type = cp_load_cal_type AND
672: closed_flag = 'N' AND
673: org_unit_cd = (SELECT nvl(uoo.owner_org_unit_Cd, uv.owner_org_unit_cd)
674: FROM igs_ps_unit_ofr_opt uoo,