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_SUA_API dependencies on IGS_CA_INST

Line 569: CURSOR cur_teach_to_load( p_teach_cal_type IGS_CA_INST.cal_type%TYPE,

565:
566: ------------------------------------------------------------------*/
567:
568: -- Cursor to get the load calander for the passed teaching calander.
569: CURSOR cur_teach_to_load( p_teach_cal_type IGS_CA_INST.cal_type%TYPE,
570: p_teach_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
571: SELECT load_cal_type, load_ci_sequence_number
572: FROM IGS_CA_TEACH_TO_LOAD_V
573: WHERE teach_cal_type = p_teach_cal_type

Line 570: p_teach_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

566: ------------------------------------------------------------------*/
567:
568: -- Cursor to get the load calander for the passed teaching calander.
569: CURSOR cur_teach_to_load( p_teach_cal_type IGS_CA_INST.cal_type%TYPE,
570: p_teach_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
571: SELECT load_cal_type, load_ci_sequence_number
572: FROM IGS_CA_TEACH_TO_LOAD_V
573: WHERE teach_cal_type = p_teach_cal_type
574: AND teach_ci_sequence_number = p_teach_ci_sequence_number

Line 622: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,

618: SELECT max_waitlists_student_num
619: FROM IGS_EN_INST_WL_STPS;
620:
621: CURSOR cur_count_wlsts_stud(cp_person_id igs_en_su_attempt.person_id%TYPE,
622: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
623: cp_load_seq_num IGS_CA_INST.sequence_number%TYPE) IS
624: SELECT count(*)
625: FROM igs_en_su_attempt
626: WHERE person_id = cp_person_id

Line 623: cp_load_seq_num IGS_CA_INST.sequence_number%TYPE) IS

619: FROM IGS_EN_INST_WL_STPS;
620:
621: CURSOR cur_count_wlsts_stud(cp_person_id igs_en_su_attempt.person_id%TYPE,
622: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
623: cp_load_seq_num IGS_CA_INST.sequence_number%TYPE) IS
624: SELECT count(*)
625: FROM igs_en_su_attempt
626: WHERE person_id = cp_person_id
627: AND unit_attempt_status =cst_waitlisted

Line 644: cp_cal_type IGS_CA_INST.cal_type%TYPE,

640:
641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,
642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
647: SELECT 'X'
648: FROM igs_en_su_attempt sua

Line 645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,

641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,
642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
647: SELECT 'X'
648: FROM igs_en_su_attempt sua
649: WHERE sua.person_id = cp_person_id AND

Line 661: CURSOR cur_simul_term_wlst_flag(p_load_cal_type IGS_CA_INST.cal_type%TYPE) IS

657: CURSOR cur_simul_wlst_flag IS
658: SELECT simultaneous_wlst_alwd_flag
659: FROM igs_en_inst_wl_stps;
660:
661: CURSOR cur_simul_term_wlst_flag(p_load_cal_type IGS_CA_INST.cal_type%TYPE) IS
662: SELECT 'X'
663: FROM igs_en_inst_wlst_opt
664: WHERE cal_type = p_load_cal_type AND
665: smlnes_waitlist_alwd = 'N';

Line 667: CURSOR cur_simul_org_allwd(cp_load_cal_type IGS_CA_INST.cal_type%TYPE,

663: FROM igs_en_inst_wlst_opt
664: WHERE cal_type = p_load_cal_type AND
665: smlnes_waitlist_alwd = 'N';
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