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_CA_STAT

Line 233: IGS_CA_STAT cs,

229: CURSOR c_ci_cs_cat IS
230: SELECT ci.CAL_TYPE,
231: ci.sequence_number
232: FROM IGS_CA_INST ci,
233: IGS_CA_STAT cs,
234: IGS_CA_TYPE cat
235: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
236: p_acad_cal_type,
237: p_acad_sequence_number,

Line 301: IGS_CA_STAT cs,

297: dai.CAL_TYPE,
298: dai.ci_sequence_number
299: FROM IGS_CA_DA_INST dai,
300: IGS_CA_INST ci,
301: IGS_CA_STAT cs,
302: IGS_CA_TYPE cat
303: WHERE dai.DT_ALIAS IN (
304: cp_effective_strt_dt_alias,
305: cp_effective_end_dt_alias) AND

Line 323: IGS_CA_STAT cs

319: ci.sequence_number
320: FROM IGS_CA_INST_REL cir,
321: IGS_CA_TYPE cat,
322: IGS_CA_INST ci,
323: IGS_CA_STAT cs
324: WHERE cir.sup_cal_type = p_acad_cal_type AND
325: cir.sup_ci_sequence_number = p_acad_sequence_number AND
326: cat.CAL_TYPE = cir.sub_cal_type AND
327: cat.S_CAL_CAT = cst_load AND

Line 339: IGS_CA_STAT cs

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
341: dla.ci_sequence_number = cp_sequence_number AND
342: cir.sup_cal_type = p_acad_cal_type AND
343: cir.sup_ci_sequence_number = p_acad_sequence_number AND

Line 363: IGS_CA_STAT cs,

359: CURSOR c_cir_ci_cs_cat IS
360: SELECT SUM(NVL(cir.load_research_percentage, 0))
361: FROM IGS_CA_INST_REL cir,
362: IGS_CA_INST ci,
363: IGS_CA_STAT cs,
364: IGS_CA_TYPE cat
365: WHERE cir.sup_cal_type = p_acad_cal_type AND
366: cir.sup_ci_sequence_number = p_acad_sequence_number AND
367: ci.CAL_TYPE = cir.sub_cal_type AND

Line 813: IGS_CA_STAT cs,

809: CURSOR c_cict IS
810: SELECT ci.CAL_TYPE,
811: ci.sequence_number
812: FROM IGS_CA_INST ci,
813: IGS_CA_STAT cs,
814: IGS_CA_TYPE cat
815: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
816: p_acad_cal_type,
817: p_acad_sequence_number,

Line 1697: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';

1693: DECLARE
1694: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
1695: cst_admission CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ADMISSION';
1696: cst_enrolment CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';
1697: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
1698: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';
1699: CURSOR c_chk_acad_ci IS
1700: SELECT ci.cal_type, ci.sequence_number, ct.S_CAL_CAT
1701: FROM IGS_CA_INST ci,

Line 1698: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';

1694: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
1695: cst_admission CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ADMISSION';
1696: cst_enrolment CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';
1697: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
1698: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';
1699: CURSOR c_chk_acad_ci IS
1700: SELECT ci.cal_type, ci.sequence_number, ct.S_CAL_CAT
1701: FROM IGS_CA_INST ci,
1702: IGS_CA_TYPE ct,

Line 1703: IGS_CA_STAT cs

1699: CURSOR c_chk_acad_ci IS
1700: SELECT ci.cal_type, ci.sequence_number, ct.S_CAL_CAT
1701: FROM IGS_CA_INST ci,
1702: IGS_CA_TYPE ct,
1703: IGS_CA_STAT cs
1704: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
1705: p_acad_cal_type,
1706: p_acad_sequence_number,
1707: ci.CAL_TYPE,

Line 1719: IGS_CA_STAT cs,

1715: SELECT cir.sup_cal_type, cir.sup_ci_sequence_number, ct2.S_CAL_CAT
1716: FROM IGS_CA_INST ci,
1717: IGS_CA_TYPE ct,
1718: IGS_CA_TYPE ct2,
1719: IGS_CA_STAT cs,
1720: IGS_CA_INST_REL cir
1721: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
1722: ct.S_CAL_CAT = cst_enrolment AND
1723: ci.CAL_TYPE = ct.CAL_TYPE AND

Line 1823: IGS_CA_STAT cs

1819: SELECT ci.CAL_TYPE,
1820: ci.sequence_number
1821: FROM IGS_CA_INST ci,
1822: IGS_CA_TYPE cat,
1823: IGS_CA_STAT cs
1824: WHERE cs.s_cal_status IN ('ACTIVE','PLANNED') AND
1825: cat.S_CAL_CAT = 'LOAD' AND
1826: cat.CAL_TYPE = ci.CAL_TYPE AND
1827: cs.CAL_STATUS = ci.CAL_STATUS;

Line 1848: IGS_CA_STAT cs

1844: SELECT ci.CAL_TYPE,
1845: ci.sequence_number
1846: FROM IGS_CA_INST ci,
1847: IGS_CA_TYPE cat,
1848: IGS_CA_STAT cs
1849: WHERE cs.s_cal_status IN ('ACTIVE','PLANNED') AND
1850: cat.S_CAL_CAT = 'LOAD' AND
1851: cs.CAL_STATUS = ci.CAL_STATUS AND
1852: cat.CAL_TYPE = ci.CAL_TYPE AND

Line 1867: IGS_CA_STAT cs,

1863: SELECT ci.alternate_code,ci.description,ci.start_dt,ci.end_dt
1864: FROM IGS_CA_INST ci,
1865: IGS_CA_INST ci2,
1866: IGS_CA_TYPE cat,
1867: IGS_CA_STAT cs,
1868: IGS_CA_INST_REL car
1869: WHERE
1870: ci2.cal_type = cp_cal_type AND
1871: ci2.sequence_number = cp_seq_num AND

Line 1935: IGS_CA_STAT cs

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
1937: cs.s_cal_status IN ('ACTIVE','PLANNED') AND
1938: ci.CAL_STATUS = cs.CAL_STATUS AND
1939: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

Line 2365: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';

2361: cst_exam CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'EXAM';
2362: cst_assessment CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ASSESSMENT';
2363: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
2364: cst_progress CONSTANT igs_ca_type.s_cal_cat%TYPE := 'PROGRESS';
2365: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
2366: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';
2367: cst_admission CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ADMISSION';
2368:
2369: v_exists_flag CHAR;

Line 2366: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';

2362: cst_assessment CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ASSESSMENT';
2363: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
2364: cst_progress CONSTANT igs_ca_type.s_cal_cat%TYPE := 'PROGRESS';
2365: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
2366: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';
2367: cst_admission CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ADMISSION';
2368:
2369: v_exists_flag CHAR;
2370: v_dummy VARCHAR2(10);

Line 2367: cst_admission CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ADMISSION';

2363: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
2364: cst_progress CONSTANT igs_ca_type.s_cal_cat%TYPE := 'PROGRESS';
2365: cst_active CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ACTIVE';
2366: cst_planned CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'PLANNED';
2367: cst_admission CONSTANT IGS_CA_STAT.s_cal_status%TYPE := 'ADMISSION';
2368:
2369: v_exists_flag CHAR;
2370: v_dummy VARCHAR2(10);
2371: v_message_name VARCHAR2(30);

Line 2395: IGS_CA_STAT cs,

2391: SELECT cir.sub_cal_type, cir.sub_ci_sequence_number, ct1.S_CAL_CAT
2392: FROM IGS_CA_INST ci,
2393: IGS_CA_TYPE ct1,
2394: IGS_CA_TYPE ct2,
2395: IGS_CA_STAT cs,
2396: IGS_CA_INST_REL cir
2397: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2398: ct2.S_CAL_CAT = cst_teaching AND
2399: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 2431: IGS_CA_STAT cs

2427: cs.s_cal_status -- Bug:2697221 cal status selected to check whether
2428: -- the status is planned or active for calculating load apportionment
2429: FROM IGS_CA_INST ci,
2430: IGS_CA_TYPE ct,
2431: IGS_CA_STAT cs
2432: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2433: cs.CAL_STATUS = ci.CAL_STATUS AND
2434: ct.S_CAL_CAT = cst_teaching AND
2435: ct.CAL_TYPE = ci.CAL_TYPE AND

Line 2476: IGS_CA_STAT cs

2472: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2473: SELECT ci.*
2474: FROM IGS_CA_INST ci,
2475: IGS_CA_TYPE ct,
2476: IGS_CA_STAT cs
2477: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2478: ct.S_CAL_CAT = cst_academic AND
2479: ci.CAL_TYPE = ct.CAL_TYPE AND
2480: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 2505: IGS_CA_STAT cs

2501: SELECT ci.CAL_TYPE,
2502: ci.sequence_number
2503: FROM IGS_CA_INST ci,
2504: IGS_CA_TYPE ct,
2505: IGS_CA_STAT cs
2506: WHERE cs.s_cal_status IN (cst_active,cst_planned) AND
2507: ci.CAL_STATUS = cs.CAL_STATUS AND
2508: ct.S_CAL_CAT = cst_teaching AND
2509: ct.CAL_TYPE = ci.CAL_TYPE AND

Line 2870: igs_ca_stat cs,

2866: ) IS
2867: SELECT ci.cal_type,
2868: ci.sequence_number
2869: FROM igs_ca_inst ci,
2870: igs_ca_stat cs,
2871: igs_ca_type cat
2872: WHERE cat.s_cal_cat = 'AWARD'
2873: AND cs.s_cal_status IN ('ACTIVE','PLANNED')
2874: AND ci.cal_type = cat.cal_type