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_CA_TYPE

Line 638: igs_ca_type cal

634: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
635: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
636: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
637: igs_ca_inst ci,
638: igs_ca_type cal
639: WHERE rel.sup_cal_type = p_acad_cal_type
640: AND rel.sup_ci_sequence_number = p_acad_seq_num
641: AND rel.sub_cal_type = ci.cal_type
642: AND rel.sub_ci_sequence_number = ci.sequence_number

Line 1108: igs_ca_type ct,

1104: CURSOR cur_catalog_details(p_commencement_date DATE,p_cal_type igs_ca_inst.cal_type%type) IS
1105: SELECT ci.cal_type catalog_cal_type,
1106: ci.sequence_number catalog_seq_num
1107: FROM igs_ca_inst ci,
1108: igs_ca_type ct,
1109: igs_ca_stat cs,
1110: igs_ca_inst_rel cir
1111: WHERE ci.cal_type = ct.cal_type
1112: AND ct.s_cal_cat = 'LOAD'

Line 2730: IGS_CA_TYPE cat,

2726: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
2727: SELECT ci.sequence_number
2728: FROM IGS_CA_INST_REL cir,
2729: IGS_CA_INST ci,
2730: IGS_CA_TYPE cat,
2731: IGS_CA_STAT cs
2732: WHERE cir.sup_cal_type = p_acad_cal_type AND
2733: cir.sup_ci_sequence_number = p_acad_sequence_number AND
2734: ci.cal_type = cir.sub_cal_type AND

Line 4327: igs_ca_type cal

4323: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
4324: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
4325: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
4326: igs_ca_inst ci,
4327: igs_ca_type cal
4328: WHERE rel.sup_cal_type = p_acad_cal_type
4329: AND rel.sup_ci_sequence_number = p_acad_seq_num
4330: AND rel.sub_cal_type = ci.cal_type
4331: AND rel.sub_ci_sequence_number = ci.sequence_number

Line 4377: IGS_CA_TYPE cat,

4373: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
4374: SELECT ci.sequence_number
4375: FROM IGS_CA_INST_REL cir,
4376: IGS_CA_INST ci,
4377: IGS_CA_TYPE cat,
4378: IGS_CA_STAT cs
4379: WHERE cir.sup_cal_type = p_acad_cal_type AND
4380: cir.sup_ci_sequence_number = p_acad_sequence_number AND
4381: ci.cal_type = cir.sub_cal_type AND

Line 6048: igs_ca_type ct,

6044: SELECT cir.sub_cal_type term_cal_type,
6045: cir.sub_ci_sequence_number term_sequence_number
6046: FROM igs_ca_inst_rel cir,
6047: igs_ca_inst ci,
6048: igs_ca_type ct,
6049: igs_ca_stat cs
6050: WHERE cir.sup_cal_type = cp_acad_cal_type
6051: AND ct.cal_type = cir.sub_cal_type
6052: AND ct.s_cal_cat = 'LOAD'