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_EN_GEN_014

Line 222: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

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 (
223: p_acad_cal_type,
224: p_acad_sequence_number,
225: dai.CAL_TYPE,
226: dai.ci_sequence_number, 'N') = 'Y' AND

Line 235: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

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,
239: ci.sequence_number, 'Y') = 'Y' AND

Line 584: IF IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

580:
581: IF c_dai_ci_cs_cat%ROWCOUNT > 1 AND
582: v_dai_ci_cs_cat_rec.DT_ALIAS = v_effective_strt_dt_alias THEN
583: IF v_dai_ci_cs_cat_rec.alias_val <= v_last_alias_val THEN
584: IF IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
585: p_acad_cal_type,
586: p_acad_sequence_number,
587: v_dai_ci_cs_cat_rec.CAL_TYPE,
588: v_dai_ci_cs_cat_rec.ci_sequence_number,

Line 590: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

586: p_acad_sequence_number,
587: v_dai_ci_cs_cat_rec.CAL_TYPE,
588: v_dai_ci_cs_cat_rec.ci_sequence_number,
589: 'Y') = 'Y' OR
590: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
591: p_acad_cal_type,
592: p_acad_sequence_number,
593: v_last_cal_type,
594: v_last_ci_sequence_number,

Line 621: IF IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

617:
618:
619: END IF;
620: ELSIF v_dai_ci_cs_cat_rec.alias_val > (v_last_alias_val + 1) THEN
621: IF IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
622: p_acad_cal_type,
623: p_acad_sequence_number,
624: v_dai_ci_cs_cat_rec.CAL_TYPE,
625: v_dai_ci_cs_cat_rec.ci_sequence_number,

Line 627: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

623: p_acad_sequence_number,
624: v_dai_ci_cs_cat_rec.CAL_TYPE,
625: v_dai_ci_cs_cat_rec.ci_sequence_number,
626: 'Y') = 'Y' OR
627: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (
628: p_acad_cal_type,
629: p_acad_sequence_number,
630: v_last_cal_type,
631: v_last_ci_sequence_number,

Line 815: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

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,
819: ci.sequence_number, 'N') = 'Y' AND

Line 1704: WHERE IGS_EN_GEN_014.ENRS_GET_WITHIN_CI (

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,
1708: ci.sequence_number, 'N') = 'Y' AND

Line 1853: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

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
1853: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
1854: p_acad_cal_type,
1855: p_acad_sequence_number,
1856: ci.CAL_TYPE,
1857: ci.sequence_number,

Line 1939: IGS_EN_GEN_014.ENRS_GET_WITHIN_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(
1940: p_acad_cal_type,
1941: p_acad_sequence_number,
1942: ci.CAL_TYPE,
1943: ci.sequence_number,

Line 2405: (IGS_EN_GEN_014.ENRS_GET_WITHIN_CI( p_acad_cal_type,

2401: cir.sub_ci_sequence_number = ci.sequence_number AND
2402: cir.sup_cal_type = ct1.CAL_TYPE AND
2403: ct2.CAL_TYPE = ci.CAL_TYPE AND
2404: ct1.S_CAL_CAT NOT IN ( cst_academic ) AND
2405: (IGS_EN_GEN_014.ENRS_GET_WITHIN_CI( p_acad_cal_type,
2406: p_acad_sequence_number,
2407: ci.CAL_TYPE,
2408: ci.sequence_number,
2409: 'Y') = 'Y' OR

Line 2436: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

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
2436: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2437: p_acad_cal_type,
2438: p_acad_sequence_number,
2439: ci.CAL_TYPE,
2440: ci.sequence_number,

Line 2481: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

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
2481: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2482: ci.CAL_TYPE,
2483: ci.sequence_number,
2484: cp_cal_type,
2485: cp_sequence_number,

Line 2494: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

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,
2497: dla.CAL_TYPE,
2498: dla.ci_sequence_number,

Line 2510: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

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
2510: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2511: p_acad_cal_type,
2512: p_acad_sequence_number,
2513: ci.CAL_TYPE,
2514: ci.sequence_number,

Line 2535: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

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
2535: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2536: p_acad_cal_type,
2537: p_acad_sequence_number,
2538: ci.CAL_TYPE,
2539: ci.sequence_number,

Line 2697: IF IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

2693: -- Total the percentages from all load calendars instances within academic
2694: -- years to which the teaching period is related.
2695: -- Select all of the load calendars within the academic year that match
2696: -- the default load apportionment record.
2697: IF IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
2698: v_chk_acad_pct_rec.CAL_TYPE,
2699: v_chk_acad_pct_rec.sequence_number,
2700: v_chk_dla_rec.CAL_TYPE,
2701: v_chk_dla_rec.ci_sequence_number,

Line 2722: END IF; -- IGS_EN_GEN_014.ENRS_GET_WITHIN_CI

2718: END IF;
2719: ELSE
2720: v_total_percentage := v_total_percentage + v_chk_dla_rec.percentage;
2721: END IF;
2722: END IF; -- IGS_EN_GEN_014.ENRS_GET_WITHIN_CI
2723: END LOOP; --- c_chk_dla
2724: END LOOP; --- c_chk_acad_pct
2725: IF v_total_percentage <> 100 THEN
2726: