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_CA_INST

Line 796: IGS_CA_INST_REL cir,

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
800: WHERE sua.person_id = p_person_id AND

Line 797: IGS_CA_INST ci,

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
800: WHERE sua.person_id = p_person_id AND
801: sua.course_cd = p_course_cd AND

Line 885: CURSOR c_is_unit_exists(p_load_cal_type IGS_CA_INST.cal_type%TYPE,

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));
883:
884: -- Added new cursor for performance bug 3693713
885: CURSOR c_is_unit_exists(p_load_cal_type IGS_CA_INST.cal_type%TYPE,
886: p_load_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
887: p_tch_cal_type IGS_CA_INST.cal_type%TYPE,
888: p_tch_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
889: SELECT 'x'

Line 886: p_load_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,

882: AND course_cd = p_program_cd AND ((p_uoo_id IS NULL) OR (uoo_id = p_uoo_id));
883:
884: -- Added new cursor for performance bug 3693713
885: CURSOR c_is_unit_exists(p_load_cal_type IGS_CA_INST.cal_type%TYPE,
886: p_load_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
887: p_tch_cal_type IGS_CA_INST.cal_type%TYPE,
888: p_tch_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
889: SELECT 'x'
890: FROM igs_ca_load_to_teach_v

Line 887: p_tch_cal_type IGS_CA_INST.cal_type%TYPE,

883:
884: -- Added new cursor for performance bug 3693713
885: CURSOR c_is_unit_exists(p_load_cal_type IGS_CA_INST.cal_type%TYPE,
886: p_load_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
887: p_tch_cal_type IGS_CA_INST.cal_type%TYPE,
888: p_tch_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
889: SELECT 'x'
890: FROM igs_ca_load_to_teach_v
891: WHERE load_cal_type = p_load_cal_type

Line 888: p_tch_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

884: -- Added new cursor for performance bug 3693713
885: CURSOR c_is_unit_exists(p_load_cal_type IGS_CA_INST.cal_type%TYPE,
886: p_load_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
887: p_tch_cal_type IGS_CA_INST.cal_type%TYPE,
888: p_tch_ci_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
889: SELECT 'x'
890: FROM igs_ca_load_to_teach_v
891: WHERE load_cal_type = p_load_cal_type
892: AND load_ci_sequence_number = p_load_ci_seq_number