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_010 dependencies on IGS_EN_GEN_015

Line 606: IGS_EN_GEN_015.get_effective_census_date(Null,Null,sua.cal_type,sua.ci_sequence_number) < TRUNC(SYSDATE) ;

602: WHERE sua.person_id = p_person_id AND
603: sua.course_cd = p_course_cd AND
604: sua.unit_set_cd = cp_unit_set_cd AND
605: sua.unit_attempt_status IN ('ENROLLED','DISCONTIN','DUPLICATE','COMPLETED') AND
606: IGS_EN_GEN_015.get_effective_census_date(Null,Null,sua.cal_type,sua.ci_sequence_number) < TRUNC(SYSDATE) ;
607: c_census_dt_rec c_chk_census_dt%ROWTYPE ;
608:
609: -- check if susa already exists and if so update it
610: CURSOR c_exists_susa(cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE ,

Line 4319: IGS_EN_GEN_015.get_effective_census_date(Null,Null,sua.cal_type,sua.ci_sequence_number) < TRUNC(SYSDATE);

4315: WHERE sua.person_id = p_person_id AND
4316: sua.course_cd = p_course_cd AND
4317: sua.unit_set_cd = cp_unit_set_cd AND
4318: sua.unit_attempt_status IN ('ENROLLED','DISCONTIN','DUPLICATE','COMPLETED') AND
4319: IGS_EN_GEN_015.get_effective_census_date(Null,Null,sua.cal_type,sua.ci_sequence_number) < TRUNC(SYSDATE);
4320: c_census_dt_rec c_chk_census_dt%ROWTYPE ;
4321: v_dummy VARCHAR2(1);
4322:
4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 8716: igs_en_gen_015.get_usec_status(p_uoo_id =>l_uoo_id,

8712: l_unit_section_status := NULL;
8713:
8714:
8715: --Following api checks the availbility of the seats for the given unit section.
8716: igs_en_gen_015.get_usec_status(p_uoo_id =>l_uoo_id,
8717: p_person_id =>p_person_id,
8718: p_unit_section_status =>l_unit_section_status,
8719: p_waitlist_ind =>l_waitlist_ind,
8720: p_load_cal_type =>p_load_cal_type,