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_CA_VAL_QLITY dependencies on IGS_ST_DFT_LOAD_APPO

Line 336: FROM IGS_ST_DFT_LOAD_APPO dla,

332: CURSOR c_dla_cir_ci_cs (
333: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
334: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
335: SELECT 'X'
336: FROM IGS_ST_DFT_LOAD_APPO dla,
337: IGS_CA_INST_REL cir,
338: IGS_CA_INST ci,
339: IGS_CA_STAT cs
340: WHERE dla.CAL_TYPE = cp_cal_type AND

Line 1927: FROM IGS_ST_DFT_LOAD_APPO dla

1923: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1924: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1925: SELECT dla.teach_cal_type,
1926: dla.second_percentage
1927: FROM IGS_ST_DFT_LOAD_APPO dla
1928: WHERE dla.CAL_TYPE = cp_cal_type AND
1929: dla.ci_sequence_number = cp_sequence_number;
1930: -- 7. Validate that teaching period is linked to the same academic period.
1931: CURSOR c_ci_cs (

Line 1932: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE) IS

1928: WHERE dla.CAL_TYPE = cp_cal_type AND
1929: dla.ci_sequence_number = cp_sequence_number;
1930: -- 7. Validate that teaching period is linked to the same academic period.
1931: CURSOR c_ci_cs (
1932: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE) IS
1933: SELECT count(*)
1934: FROM IGS_CA_INST ci,
1935: IGS_CA_STAT cs
1936: WHERE CAL_TYPE = cp_teach_cal_type AND

Line 2372: v_total_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;

2368:
2369: v_exists_flag CHAR;
2370: v_dummy VARCHAR2(10);
2371: v_message_name VARCHAR2(30);
2372: v_total_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
2373: v_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2374: v_acad_sequence_number IGS_CA_INST.sequence_number%TYPE;
2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;

Line 2488: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE,

2484: cp_cal_type,
2485: cp_sequence_number,
2486: 'Y' ) = 'Y';
2487: CURSOR c_chk_dla (
2488: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE,
2489: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2490: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2491: SELECT dla.*
2492: FROM IGS_ST_DFT_LOAD_APPO dla

Line 2492: FROM IGS_ST_DFT_LOAD_APPO dla

2488: cp_teach_cal_type IGS_ST_DFT_LOAD_APPO.teach_cal_type%TYPE,
2489: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2490: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2491: SELECT dla.*
2492: FROM IGS_ST_DFT_LOAD_APPO dla
2493: WHERE teach_cal_type = cp_teach_cal_type AND
2494: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2495: cp_acad_cal_type,
2496: cp_acad_ci_sequence_number,

Line 2530: FROM IGS_ST_DFT_LOAD_APPO dla,

2526: CURSOR c_chk_load_ci (
2527: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2528: SELECT ci.CAL_TYPE,
2529: ci.sequence_number
2530: FROM IGS_ST_DFT_LOAD_APPO dla,
2531: IGS_CA_INST ci
2532: WHERE teach_cal_type = cp_cal_type AND
2533: ci.CAL_TYPE = dla.CAL_TYPE AND
2534: ci.sequence_number = dla.ci_sequence_number AND