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_TYPE

Line 218: IGS_CA_TYPE cat

214: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
215: SELECT dai.CAL_TYPE,
216: cat.S_CAL_CAT
217: FROM IGS_CA_DA_INST dai,
218: IGS_CA_TYPE cat
219: WHERE dai.DT_ALIAS IN (
220: cp_effective_strt_dt_alias,
221: cp_effective_end_dt_alias) AND
222: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

Line 234: IGS_CA_TYPE cat

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,
238: ci.CAL_TYPE,

Line 302: IGS_CA_TYPE cat

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
306: ci.CAL_TYPE = dai.CAL_TYPE AND

Line 321: IGS_CA_TYPE cat,

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
325: cir.sup_ci_sequence_number = p_acad_sequence_number AND

Line 364: IGS_CA_TYPE cat

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
368: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 814: IGS_CA_TYPE cat

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,
818: ci.CAL_TYPE,

Line 830: IGS_CA_TYPE cat

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
834: cir.sup_cal_type = cat.CAL_TYPE;

Line 841: IGS_CA_TYPE cat

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
845: cir2.sub_cal_type = cat.CAL_TYPE;

Line 874: IGS_CA_TYPE cat

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
878: cir.sup_cal_type = cat.CAL_TYPE;

Line 978: igs_ca_type cat

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
982: AND cir5.sub_cal_type = cat.cal_type;

Line 993: igs_ca_type cat

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
996: car.SUP_CAL_type = p_cal_type AND
997: ca.cal_type = car.sub_cal_type AND

Line 1505: cst_load constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'LOAD';

1501: p_s_log_type IN VARCHAR2 ,
1502: p_log_creation_dt IN DATE )
1503: AS
1504: lv_param_values VARCHAR2(1080);
1505: cst_load constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'LOAD';
1506: cst_academic constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
1507: cst_teaching constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
1508: cst_enrolment constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';
1509: gv_other_detail VARCHAR2(255);

Line 1506: cst_academic constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';

1502: p_log_creation_dt IN DATE )
1503: AS
1504: lv_param_values VARCHAR2(1080);
1505: cst_load constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'LOAD';
1506: cst_academic constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
1507: cst_teaching constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
1508: cst_enrolment constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';
1509: gv_other_detail VARCHAR2(255);
1510: BEGIN

Line 1507: cst_teaching constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';

1503: AS
1504: lv_param_values VARCHAR2(1080);
1505: cst_load constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'LOAD';
1506: cst_academic constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
1507: cst_teaching constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
1508: cst_enrolment constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';
1509: gv_other_detail VARCHAR2(255);
1510: BEGIN
1511: DECLARE

Line 1508: cst_enrolment constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';

1504: lv_param_values VARCHAR2(1080);
1505: cst_load constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'LOAD';
1506: cst_academic constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
1507: cst_teaching constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
1508: cst_enrolment constant IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';
1509: gv_other_detail VARCHAR2(255);
1510: BEGIN
1511: DECLARE
1512: CURSOR c_chk_dt_aliases IS

Line 1523: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ) IS

1519: FROM IGS_EN_CAL_CONF
1520: WHERE s_control_num = 1;
1521: CURSOR c_chk_da_exists (
1522: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1523: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ) IS
1524: SELECT 'x'
1525: FROM IGS_CA_DA_INST_V daiv,
1526: IGS_CA_TYPE ct
1527: WHERE daiv.DT_ALIAS = cp_dt_alias AND

Line 1526: IGS_CA_TYPE ct

1522: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1523: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ) IS
1524: SELECT 'x'
1525: FROM IGS_CA_DA_INST_V daiv,
1526: IGS_CA_TYPE ct
1527: WHERE daiv.DT_ALIAS = cp_dt_alias AND
1528: daiv.CAL_TYPE = ct.CAL_TYPE AND
1529: ct.S_CAL_CAT <> cp_s_cal_cat;
1530: CURSOR c_chk_da_exists1 (

Line 1532: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ,

1528: daiv.CAL_TYPE = ct.CAL_TYPE AND
1529: ct.S_CAL_CAT <> cp_s_cal_cat;
1530: CURSOR c_chk_da_exists1 (
1531: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1532: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ,
1533: cp_s_cal_cat1 IGS_CA_TYPE.S_CAL_CAT%TYPE) IS
1534: SELECT 'x'
1535: FROM IGS_CA_DA_INST_V daiv,
1536: IGS_CA_TYPE ct

Line 1533: cp_s_cal_cat1 IGS_CA_TYPE.S_CAL_CAT%TYPE) IS

1529: ct.S_CAL_CAT <> cp_s_cal_cat;
1530: CURSOR c_chk_da_exists1 (
1531: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1532: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ,
1533: cp_s_cal_cat1 IGS_CA_TYPE.S_CAL_CAT%TYPE) IS
1534: SELECT 'x'
1535: FROM IGS_CA_DA_INST_V daiv,
1536: IGS_CA_TYPE ct
1537: WHERE daiv.DT_ALIAS = cp_dt_alias AND

Line 1536: IGS_CA_TYPE ct

1532: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ,
1533: cp_s_cal_cat1 IGS_CA_TYPE.S_CAL_CAT%TYPE) IS
1534: SELECT 'x'
1535: FROM IGS_CA_DA_INST_V daiv,
1536: IGS_CA_TYPE ct
1537: WHERE daiv.DT_ALIAS = cp_dt_alias AND
1538: daiv.CAL_TYPE = ct.CAL_TYPE AND
1539: ct.S_CAL_CAT <> cp_s_cal_cat AND
1540: ct.S_CAL_CAT <> cp_s_cal_cat1;

Line 1694: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';

1690: gv_other_detail VARCHAR2(255);
1691:
1692: BEGIN
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';

Line 1695: cst_admission CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ADMISSION';

1691:
1692: BEGIN
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

Line 1696: cst_enrolment CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ENROLMENT';

1692: BEGIN
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

Line 1702: IGS_CA_TYPE ct,

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,
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,

Line 1717: IGS_CA_TYPE ct,

1713:
1714: CURSOR c_chk_enr_ci (cp_cal_type IGS_CA_INST.cal_type%type, cp_sequence_number IGS_CA_INST.sequence_number%type) IS
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

Line 1718: IGS_CA_TYPE ct2,

1714: CURSOR c_chk_enr_ci (cp_cal_type IGS_CA_INST.cal_type%type, cp_sequence_number IGS_CA_INST.sequence_number%type) IS
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

Line 1822: IGS_CA_TYPE cat,

1818: CURSOR c_ci_cat_cs IS
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

Line 1835: IGS_CA_TYPE cat

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
1838: ci.CAL_TYPE = cir.sup_cal_type AND
1839: ci.sequence_number = cir.sup_ci_sequence_number AND

Line 1847: IGS_CA_TYPE cat,

1843: CURSOR c_load_calendars IS
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

Line 1866: IGS_CA_TYPE cat,

1862: IS
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

Line 1902: IGS_CA_TYPE cat

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
1906: cir.sup_ci_sequence_number <> p_acad_sequence_number) AND

Line 1983: igs_ca_type cat

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'
1987: AND cir6.sup_cal_type = cat.cal_type;

Line 1997: igs_ca_type cat

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'
2001: AND cir9.sup_cal_type = cat.cal_type;

Line 2359: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';

2355: -- all applicable load calendars for any administrative IGS_PS_UNIT
2356: -- statuses which can be used in the teaching period.
2357: DECLARE
2358:
2359: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';
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';

Line 2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';

2356: -- statuses which can be used in the teaching period.
2357: DECLARE
2358:
2359: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';
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';

Line 2361: cst_exam CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'EXAM';

2357: DECLARE
2358:
2359: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';
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';

Line 2362: cst_assessment CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ASSESSMENT';

2358:
2359: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';
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';

Line 2363: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';

2359: cst_academic CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'ACADEMIC';
2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';
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';

Line 2364: cst_progress CONSTANT igs_ca_type.s_cal_cat%TYPE := 'PROGRESS';

2360: cst_fee CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'FEE';
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:

Line 2393: IGS_CA_TYPE ct1,

2389: sequence_number = cp_acad_sequence_number;
2390: CURSOR c_chk_acad_fee_ci IS
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

Line 2394: IGS_CA_TYPE ct2,

2390: CURSOR c_chk_acad_fee_ci IS
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

Line 2414: IGS_CA_TYPE cat

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
2417: cir.sup_cal_type = ci.CAL_TYPE AND
2418: cir.sup_ci_sequence_number = ci.sequence_number AND

Line 2430: IGS_CA_TYPE ct,

2426: ci.sequence_number,
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

Line 2448: IGS_CA_TYPE cat1,

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
2452: cir.sup_cal_type = cp_cal_type AND

Line 2449: IGS_CA_TYPE cat2

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
2452: cir.sup_cal_type = cp_cal_type AND
2453: cir.sup_ci_sequence_number = cp_sequence_number;

Line 2475: IGS_CA_TYPE ct,

2471: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
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

Line 2504: IGS_CA_TYPE ct,

2500: CURSOR c_chk_tch_ci_aus IS
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

Line 2871: igs_ca_type cat

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
2875: AND ci.cal_status = cs.cal_status

Line 2890: igs_ca_type cat

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'
2894: AND cir8.sub_cal_type = cat.cal_type;