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_INST_REL

Line 320: FROM IGS_CA_INST_REL cir,

316: cp_effective_end_dt_alias, 2);
317: CURSOR c_cir_cat_ci_cs IS
318: SELECT ci.CAL_TYPE,
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

Line 337: IGS_CA_INST_REL cir,

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
341: dla.ci_sequence_number = cp_sequence_number AND

Line 361: FROM IGS_CA_INST_REL cir,

357: srcc.effective_strt_dt_alias,
358: srcc.effective_end_dt_alias));
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

Line 803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

799: v_cir_4_rec_found BOOLEAN := FALSE;
800: v_daiv_1_rec_found BOOLEAN := FALSE;
801: v_daiv_2_rec_found BOOLEAN := FALSE;
802: v_daiv_3_rec_found BOOLEAN := FALSE;
803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;
805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
807: v_dummy VARCHAR2(1);

Line 804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;

800: v_daiv_1_rec_found BOOLEAN := FALSE;
801: v_daiv_2_rec_found BOOLEAN := FALSE;
802: v_daiv_3_rec_found BOOLEAN := FALSE;
803: v_cir2_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
804: v_cir2_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE;
805: v_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
806: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
807: v_dummy VARCHAR2(1);
808: v_count NUMBER;

Line 829: FROM IGS_CA_INST_REL cir,

825: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
826: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
827: SELECT cir.sup_cal_type,
828: cir.sup_ci_sequence_number
829: FROM IGS_CA_INST_REL cir,
830: IGS_CA_TYPE cat
831: WHERE cir.sub_cal_type = cp_sub_cal_type AND
832: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
833: cat.S_CAL_CAT = cst_academic AND

Line 840: FROM IGS_CA_INST_REL cir2,

836: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
837: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
838: SELECT cir2.sub_cal_type,
839: cir2.sub_ci_sequence_number
840: FROM IGS_CA_INST_REL cir2,
841: IGS_CA_TYPE cat
842: WHERE cir2.sup_cal_type = cp_sub_cal_type AND
843: cir2.sup_ci_sequence_number = cp_sub_sequence_number AND
844: cat.S_CAL_CAT = cst_enrolment AND

Line 852: FROM IGS_CA_INST_REL cir

848: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
849: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
850: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
851: SELECT 'x'
852: FROM IGS_CA_INST_REL cir
853: WHERE cir.sub_cal_type = cp_sub_cal_type AND
854: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
855: cir.sup_cal_type = cp_acad_cal_type AND
856: cir.sup_ci_sequence_number = cp_acad_sequence_number;

Line 863: FROM IGS_CA_INST_REL cir

859: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE,
860: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
861: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
862: SELECT 'x'
863: FROM IGS_CA_INST_REL cir
864: WHERE cir.sub_cal_type = cp_sub_cal_type AND
865: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
866: cir.sup_cal_type = cp_acad_cal_type AND
867: cir.sup_ci_sequence_number <> cp_acad_sequence_number;

Line 873: FROM IGS_CA_INST_REL cir,

869: cp_sub_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
870: cp_sub_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
871: SELECT cir.sup_cal_type,
872: cir.sup_ci_sequence_number
873: FROM IGS_CA_INST_REL cir,
874: IGS_CA_TYPE cat
875: WHERE cir.sub_cal_type = cp_sub_cal_type AND
876: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
877: cat.S_CAL_CAT = cst_teaching AND

Line 977: FROM igs_ca_inst_rel cir5,

973: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
974: ) IS
975: SELECT cir5.sub_cal_type,
976: cir5.sub_ci_sequence_number
977: FROM igs_ca_inst_rel cir5,
978: igs_ca_type cat
979: WHERE cir5.sup_cal_type = cp_c_sup_cal_type
980: AND cir5.sup_ci_sequence_number = cp_n_sup_sequence_number
981: AND cat.s_cal_cat = cst_load

Line 991: FROM igs_ca_inst_rel car,

987:
988: CURSOR ad_rel_load(p_cal_type igs_ca_inst_all.cal_type%TYPE,
989: p_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
990: SELECT count(car.sub_ci_sequence_number)
991: FROM igs_ca_inst_rel car,
992: igs_ca_inst_all ca,
993: igs_ca_type cat
994: WHERE
995: car.SUP_CI_SEQUENCE_NUMBER= p_sequence_number AND

Line 1720: IGS_CA_INST_REL cir

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
1724: cs.CAL_STATUS = ci.CAL_STATUS AND

Line 1809: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

1805: gv_other_detail VARCHAR2(255);
1806: BEGIN
1807: DECLARE
1808:
1809: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
1810: v_cal_type IGS_EN_ATD_TYPE_LOAD.CAL_TYPE%TYPE;
1811: v_key VARCHAR2(50);
1812: v_warning_msg VARCHAR2(2000);
1813: v_last_upper IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

Line 1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

1825: cat.S_CAL_CAT = 'LOAD' AND
1826: cat.CAL_TYPE = ci.CAL_TYPE AND
1827: cs.CAL_STATUS = ci.CAL_STATUS;
1828: CURSOR c_cir_ci_cat (
1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,

Line 1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

1827: cs.CAL_STATUS = ci.CAL_STATUS;
1828: CURSOR c_cir_ci_cat (
1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,
1834: IGS_CA_INST ci,
1835: IGS_CA_TYPE cat

Line 1833: FROM IGS_CA_INST_REL cir,

1829: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1830: cp_sub_ci_sequence_number
1831: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1832: SELECT cat.S_CAL_CAT
1833: FROM IGS_CA_INST_REL cir,
1834: IGS_CA_INST ci,
1835: IGS_CA_TYPE cat
1836: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1837: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND

Line 1868: IGS_CA_INST_REL car

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
1872: cs.s_cal_status IN ('ACTIVE','PLANNED') AND

Line 1892: FROM IGS_CA_INST_REL cir

1888: CURSOR c_cir (
1889: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1890: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1891: SELECT cir.sub_cal_type
1892: FROM IGS_CA_INST_REL cir
1893: WHERE cir.sup_cal_type = cp_cal_type AND
1894: cir.sup_ci_sequence_number = cp_sequence_number;
1895: -- 4. Check that the load calendar is not linked to
1896: -- other academic calendar instances.

Line 1901: FROM IGS_CA_INST_REL cir,

1897: CURSOR c_cir2 (
1898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1899: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1900: SELECT cir.sub_cal_type
1901: FROM IGS_CA_INST_REL cir,
1902: IGS_CA_TYPE cat
1903: WHERE cir.sub_cal_type = cp_cal_type AND
1904: cir.sub_ci_sequence_number = cp_sequence_number AND
1905: (cir.sup_cal_type <> p_acad_cal_type OR

Line 1982: FROM igs_ca_inst_rel cir6,

1978: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1979: ) IS
1980: SELECT cir6.sup_cal_type,
1981: cir6.sup_ci_sequence_number
1982: FROM igs_ca_inst_rel cir6,
1983: igs_ca_type cat
1984: WHERE cir6.sub_cal_type = cp_c_sub_cal_type
1985: AND cir6.sub_ci_sequence_number = cp_n_sub_sequence_number
1986: AND cat.S_CAL_CAT = 'AWARD'

Line 1996: FROM igs_ca_inst_rel cir9,

1992: cp_n_sub_sequence_number igs_ca_inst.sequence_number%TYPE
1993: ) IS
1994: SELECT cir9.sup_cal_type,
1995: cir9.sup_ci_sequence_number
1996: FROM igs_ca_inst_rel cir9,
1997: igs_ca_type cat
1998: WHERE cir9.sub_cal_type = cp_c_sub_cal_type
1999: AND cir9.sub_ci_sequence_number = cp_n_sub_sequence_number
2000: AND cat.S_CAL_CAT = 'ADMISSION'

Line 2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;

2375: v_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2376: v_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2377: v_p_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2378: v_p_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2379: v_chk_tch_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
2380: v_sub_not_admission BOOLEAN := FALSE;
2381: v_chk_tch_sub_rec_found BOOLEAN := FALSE;
2382: CURSOR c_acad_dates (
2383: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 2396: IGS_CA_INST_REL cir

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
2400: cir.sub_cal_type = ci.CAL_TYPE AND

Line 2412: FROM IGS_CA_INST_REL cir,

2408: ci.sequence_number,
2409: 'Y') = 'Y' OR
2410: NOT EXISTS (
2411: SELECT 'x'
2412: FROM IGS_CA_INST_REL cir,
2413: IGS_CA_INST ci,
2414: IGS_CA_TYPE cat
2415: WHERE cir.sub_cal_type = ci.CAL_TYPE AND
2416: cir.sub_ci_sequence_number = ci.sequence_number AND

Line 2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

2439: ci.CAL_TYPE,
2440: ci.sequence_number,
2441: 'Y' ) = 'Y';
2442: CURSOR c_chk_tch_sub (
2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS
2445: SELECT cir.sub_cal_type,
2446: cat2.S_CAL_CAT
2447: FROM IGS_CA_INST_REL cir,

Line 2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS

2440: ci.sequence_number,
2441: 'Y' ) = 'Y';
2442: CURSOR c_chk_tch_sub (
2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS
2445: SELECT cir.sub_cal_type,
2446: cat2.S_CAL_CAT
2447: FROM IGS_CA_INST_REL cir,
2448: IGS_CA_TYPE cat1,

Line 2447: FROM IGS_CA_INST_REL cir,

2443: cp_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2444: cp_sequence_number IGS_CA_INST_REL.sup_ci_sequence_number%TYPE ) IS
2445: SELECT cir.sub_cal_type,
2446: cat2.S_CAL_CAT
2447: FROM IGS_CA_INST_REL cir,
2448: IGS_CA_TYPE cat1,
2449: IGS_CA_TYPE cat2
2450: WHERE cir.sup_cal_type = cat1.CAL_TYPE AND
2451: cir.sub_cal_type = cat2.CAL_TYPE AND

Line 2889: FROM igs_ca_inst_rel cir8,

2885: cp_n_sup_sequence_number igs_ca_inst.sequence_number%TYPE
2886: ) IS
2887: SELECT cir8.sub_cal_type,
2888: cir8.sub_ci_sequence_number
2889: FROM igs_ca_inst_rel cir8,
2890: igs_ca_type cat
2891: WHERE cir8.sup_cal_type = cp_c_sup_cal_type
2892: AND cir8.sup_ci_sequence_number = cp_n_sup_sequence_number
2893: AND cat.s_cal_cat = 'LOAD'