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

Line 370: FROM igs_ca_inst_rel cir, igs_en_su_attempt_all sua

366:
367:
368: CURSOR c_acad IS
369: SELECT DISTINCT cir.sup_cal_type acad_cal_type, cir.sup_ci_sequence_number acad_ci_sequence_number
370: FROM igs_ca_inst_rel cir, igs_en_su_attempt_all sua
371: WHERE sua.cal_type = cir.sub_cal_type
372: AND sua.ci_sequence_number = cir.sub_ci_sequence_number
373: AND sua.person_id = p_person_id
374: AND sua.course_cd = p_course_cd

Line 379: CURSOR c_sua(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_acad_seq_num igs_ca_inst.sequence_number%TYPE) IS

375: AND cir.sup_cal_type = NVL(p_acad_cal_type,cir.sup_cal_type)
376: AND cir.sup_ci_sequence_number = NVL(p_acad_ci_sequence_number,cir.sup_ci_sequence_number);
377:
378:
379: CURSOR c_sua(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_acad_seq_num igs_ca_inst.sequence_number%TYPE) IS
380: SELECT
381: sua2.cal_type sua_cal_type,
382: sua2.ci_sequence_number sua_ci_sequence_number,
383: sua2.discontinued_dt,

Line 394: IGS_CA_INST_ALL loadcal,

390: IGS_EN_SU_ATTEMPT_all sua1,
391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,
397: IGS_CA_STAT cs2 ,
398: IGS_ST_DFT_LOAD_APPO l2t,

Line 395: IGS_CA_INST_REL acadterm,

391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,
397: IGS_CA_STAT cs2 ,
398: IGS_ST_DFT_LOAD_APPO l2t,
399: IGS_ST_DFT_LOAD_APPO l2tsua2

Line 414: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach

410: AND uv2.unit_cd = sua2.unit_cd
411: AND uv2.version_number =sua2.version_number
412: AND uv1.research_unit_ind = 'Y'
413: AND uv2.research_unit_ind = 'Y'
414: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach
415: WHERE acadteach.sup_cal_type = cp_acad_cal_type
416: AND acadteach.sup_ci_sequence_number = cp_acad_seq_num
417: AND acadteach.sub_cal_type = sua1.cal_type
418: AND acadteach.sub_ci_sequence_number = sua1.ci_sequence_number)

Line 419: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach

415: WHERE acadteach.sup_cal_type = cp_acad_cal_type
416: AND acadteach.sup_ci_sequence_number = cp_acad_seq_num
417: AND acadteach.sub_cal_type = sua1.cal_type
418: AND acadteach.sub_ci_sequence_number = sua1.ci_sequence_number)
419: AND EXISTS (SELECT 'x' FROM IGS_CA_INST_REL acadteach
420: WHERE acadteach.sup_cal_type = cp_acad_cal_type
421: AND acadteach.sup_ci_sequence_number = cp_acad_seq_num
422: AND acadteach.sub_cal_type = sua2.cal_type
423: AND acadteach.sub_ci_sequence_number = sua2.ci_sequence_number)

Line 524: IGS_CA_INST ci,

520: SELECT daiv.alias_val,
521: ci.start_dt,
522: ci.end_dt
523: FROM IGS_CA_DA_INST_V daiv,
524: IGS_CA_INST ci,
525: IGS_GE_S_GEN_CAL_CON sgcc
526: WHERE daiv.cal_type = p_cal_type AND
527: daiv.ci_sequence_number = p_ci_sequence_number AND
528: daiv.dt_alias = sgcc.census_dt_alias AND

Line 848: FROM IGS_CA_INST ci

844: -- IGS_EN_STDNT_PS_ATT.
845: DECLARE
846: CURSOR c_ci IS
847: SELECT ci.end_dt
848: FROM IGS_CA_INST ci
849: WHERE ci.cal_type = p_cal_type AND
850: ci.sequence_number = p_ci_sequence_number;
851: v_ci_rec c_ci%ROWTYPE;
852: CURSOR c_sca IS

Line 2672: CURSOR c_get_load_cal_dtls(cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,

2668: WHERE person_id = cp_person_id AND
2669: course_cd = cp_course_cd AND
2670: uoo_id = cp_uoo_id;
2671:
2672: CURSOR c_get_load_cal_dtls(cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2673: cp_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2674: SELECT load_cal_type,load_ci_sequence_number
2675: FROM IGS_CA_TEACH_TO_LOAD_V
2676: WHERE teach_cal_type = cp_teach_cal_type AND

Line 2673: cp_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE) IS

2669: course_cd = cp_course_cd AND
2670: uoo_id = cp_uoo_id;
2671:
2672: CURSOR c_get_load_cal_dtls(cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2673: cp_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2674: SELECT load_cal_type,load_ci_sequence_number
2675: FROM IGS_CA_TEACH_TO_LOAD_V
2676: WHERE teach_cal_type = cp_teach_cal_type AND
2677: teach_ci_sequence_number = cp_teach_cal_seq_num ;

Line 2690: l_teach_cal_type IGS_CA_INST.cal_type%TYPE;

2686: l_enr_cal_seq_num IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE;
2687: l_enr_method_type IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2688: l_dummy VARCHAR2(255);
2689: l_notification_flag IGS_EN_CPD_EXT.notification_flag%TYPE;
2690: l_teach_cal_type IGS_CA_INST.cal_type%TYPE;
2691: l_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2692: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
2693: l_load_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2694: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 2691: l_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE;

2687: l_enr_method_type IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2688: l_dummy VARCHAR2(255);
2689: l_notification_flag IGS_EN_CPD_EXT.notification_flag%TYPE;
2690: l_teach_cal_type IGS_CA_INST.cal_type%TYPE;
2691: l_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2692: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
2693: l_load_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2694: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2695: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 2692: l_load_cal_type IGS_CA_INST.cal_type%TYPE;

2688: l_dummy VARCHAR2(255);
2689: l_notification_flag IGS_EN_CPD_EXT.notification_flag%TYPE;
2690: l_teach_cal_type IGS_CA_INST.cal_type%TYPE;
2691: l_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2692: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
2693: l_load_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2694: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2695: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2696: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 2693: l_load_cal_seq_num IGS_CA_INST.sequence_number%TYPE;

2689: l_notification_flag IGS_EN_CPD_EXT.notification_flag%TYPE;
2690: l_teach_cal_type IGS_CA_INST.cal_type%TYPE;
2691: l_teach_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2692: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
2693: l_load_cal_seq_num IGS_CA_INST.sequence_number%TYPE;
2694: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2695: l_message_name1 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2696: l_message_name2 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2697: l_return_status VARCHAR2(10);

Line 3737: l_en_cal_type igs_ca_inst.cal_type%TYPE;

3733: l_sub_sua IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
3734: l_ovrrd_chk VARCHAR2(1);
3735: l_ovrrd_drop VARCHAR2(1);
3736: l_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;
3737: l_en_cal_type igs_ca_inst.cal_type%TYPE;
3738: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;
3739: l_commencement_type VARCHAR2(10);
3740: l_dummy VARCHAR2(255);
3741: l_total_credit_points NUMBER;

Line 3738: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;

3734: l_ovrrd_chk VARCHAR2(1);
3735: l_ovrrd_drop VARCHAR2(1);
3736: l_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;
3737: l_en_cal_type igs_ca_inst.cal_type%TYPE;
3738: l_en_ci_seq_num igs_ca_inst.sequence_number%TYPE;
3739: l_commencement_type VARCHAR2(10);
3740: l_dummy VARCHAR2(255);
3741: l_total_credit_points NUMBER;
3742: l_att_type VARCHAR2(100);