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

Line 1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

1445: SELECT cat.arts_teaching_cal_type_cd
1446: FROM IGS_CA_TYPE cat
1447: WHERE cat.cal_type = cp_cal_type;
1448: CURSOR c_cir_cat (
1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1450: cp_teach_ci_sequence_number
1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number

Line 1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

1447: WHERE cat.cal_type = cp_cal_type;
1448: CURSOR c_cir_cat (
1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1450: cp_teach_ci_sequence_number
1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,

Line 1454: FROM IGS_CA_INST_REL cir1,

1450: cp_teach_ci_sequence_number
1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,
1456: IGS_CA_TYPE cat1,
1457: IGS_CA_TYPE cat2
1458: WHERE cir1.sup_cal_type = cat1.cal_type AND

Line 1455: IGS_CA_INST_REL cir2,

1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,
1456: IGS_CA_TYPE cat1,
1457: IGS_CA_TYPE cat2
1458: WHERE cir1.sup_cal_type = cat1.cal_type AND
1459: cat1.s_cal_cat = cst_academic AND

Line 2265: p_acad_cal_type igs_ca_inst.cal_type%type;

2261: p_acad_perd IN VARCHAR2,
2262: p_input_file IN VARCHAR2,
2263: p_org_id IN NUMBER)
2264: IS
2265: p_acad_cal_type igs_ca_inst.cal_type%type;
2266: p_acad_ci_sequence_number igs_ca_inst.sequence_number%type ;
2267: BEGIN -- admp_ext_vtac_return
2268: --Block for Parameter Validation/Splitting of Parameters
2269:

Line 2266: p_acad_ci_sequence_number igs_ca_inst.sequence_number%type ;

2262: p_input_file IN VARCHAR2,
2263: p_org_id IN NUMBER)
2264: IS
2265: p_acad_cal_type igs_ca_inst.cal_type%type;
2266: p_acad_ci_sequence_number igs_ca_inst.sequence_number%type ;
2267: BEGIN -- admp_ext_vtac_return
2268: --Block for Parameter Validation/Splitting of Parameters
2269:
2270: -- The following code is added for disabling of OSS in R12.IGS.A - Bug 4955192

Line 2841: FROM IGS_CA_INST_REL cir,

2837: cp_adm_cal_type IN IGS_AD_PS_APPL_INST.adm_cal_type%TYPE,
2838: cp_adm_ci_sequence_number IN
2839: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE) IS
2840: SELECT ci.alternate_code, ci.start_dt
2841: FROM IGS_CA_INST_REL cir,
2842: IGS_CA_INST ci
2843: WHERE cir.sup_cal_type = cp_acad_cal_type AND
2844: cir.sub_cal_type = cp_adm_cal_type AND
2845: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND

Line 2842: IGS_CA_INST ci

2838: cp_adm_ci_sequence_number IN
2839: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE) IS
2840: SELECT ci.alternate_code, ci.start_dt
2841: FROM IGS_CA_INST_REL cir,
2842: IGS_CA_INST ci
2843: WHERE cir.sup_cal_type = cp_acad_cal_type AND
2844: cir.sub_cal_type = cp_adm_cal_type AND
2845: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND
2846: cir.sup_cal_type = ci.cal_type AND

Line 2850: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

2846: cir.sup_cal_type = ci.cal_type AND
2847: cir.sup_ci_sequence_number = ci.sequence_number
2848: ORDER BY ci.start_dt;
2849: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
2850: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
2851: v_start_dt IGS_CA_INST.start_dt%TYPE;
2852: BEGIN
2853: IF p_acad_cal_type IS NULL THEN
2854: OPEN c_aa;

Line 2851: v_start_dt IGS_CA_INST.start_dt%TYPE;

2847: cir.sup_ci_sequence_number = ci.sequence_number
2848: ORDER BY ci.start_dt;
2849: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
2850: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
2851: v_start_dt IGS_CA_INST.start_dt%TYPE;
2852: BEGIN
2853: IF p_acad_cal_type IS NULL THEN
2854: OPEN c_aa;
2855: FETCH c_aa INTO v_acad_cal_type;