APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_DSCP

Line 685: v_funding_index_1 IGS_PS_DSCP.funding_index_1%TYPE;

681: RETURN NUMBER AS
682:
683: BEGIN
684: DECLARE
685: v_funding_index_1 IGS_PS_DSCP.funding_index_1%TYPE;
686: v_funding_index_2 IGS_PS_DSCP.funding_index_2%TYPE;
687: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE;
688: v_unit_level IGS_PS_UNIT_VER.unit_level%TYPE;
689: v_unit_int_course_level_cd IGS_PS_UNIT_VER.unit_int_course_level_cd%TYPE;

Line 686: v_funding_index_2 IGS_PS_DSCP.funding_index_2%TYPE;

682:
683: BEGIN
684: DECLARE
685: v_funding_index_1 IGS_PS_DSCP.funding_index_1%TYPE;
686: v_funding_index_2 IGS_PS_DSCP.funding_index_2%TYPE;
687: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE;
688: v_unit_level IGS_PS_UNIT_VER.unit_level%TYPE;
689: v_unit_int_course_level_cd IGS_PS_UNIT_VER.unit_int_course_level_cd%TYPE;
690: v_count NUMBER;

Line 696: FROM IGS_PS_DSCP di

692: v_local_ins_deakin_ind VARCHAR2(1);
693: CURSOR c_di IS
694: SELECT di.funding_index_1,
695: di.funding_index_2
696: FROM IGS_PS_DSCP di
697: WHERE di.discipline_group_cd = p_discipline_group_cd;
698: CURSOR c_uv_uicl IS
699: SELECT uicl.weftsu_factor,
700: uv.unit_level,

Line 714: -- This routine requires the IGS_PS_DSCP group code and org unit code as

710: WHERE ins.govt_institution_cd = 3030 AND
711: local_institution_ind = 'Y';
712: BEGIN
713: -- Routine calculates the WEFTSU figure for a Student unit Attempt.
714: -- This routine requires the IGS_PS_DSCP group code and org unit code as
715: -- parameters, so where units are split across multiples the calling
716: -- routine must call this function multiple times and sum the results.
717: -- Special Logic:
718: -- Deakin University has two special scenarios which involve using the second

Line 719: -- funding index for particular matches on IGS_PS_DSCP group code, org unit,

715: -- parameters, so where units are split across multiples the calling
716: -- routine must call this function multiple times and sum the results.
717: -- Special Logic:
718: -- Deakin University has two special scenarios which involve using the second
719: -- funding index for particular matches on IGS_PS_DSCP group code, org unit,
720: -- unit internal course level and unit level. These senarios have been coded,
721: -- but surrounded by a check as to whether the local INSTITUTION (in which
722: -- the system is running) is Deakin - all other institutions will revert to
723: -- the standard check.

Line 727: -- Load the funding indexes from the IGS_PS_DSCP table.

723: -- the standard check.
724: IF (p_sua_eftsu = 0.000) THEN
725: RETURN 0.000;
726: END IF;
727: -- Load the funding indexes from the IGS_PS_DSCP table.
728: OPEN c_di;
729: FETCH c_di INTO v_funding_index_1,
730: v_funding_index_2;
731: IF (c_di%NOTFOUND) THEN

Line 840: -- being split across organisational units and IGS_PS_DSCP groups, truncate the

836: -- EFTSU - this is in accordance with the DEETYA guidelines, and is required
837: -- to be able to reconcile EFTSU figures calculated on a day to day basis
838: -- with those reported in the DEETYA submissions.
839: -- This routine will 'roll down the EFTSU to the lowest common denominator,
840: -- being split across organisational units and IGS_PS_DSCP groups, truncate the
841: -- value and then 'roll up' to the required level.
842: -- Refer to Enrolments Analysis Document for example of this logic.
843: -- Note: This routine is assuming that load has already been split across load
844: -- calendars (ie: Semesters) and that there can be not further splitting of

Line 845: -- the values below OU/IGS_PS_DSCP.

841: -- value and then 'roll up' to the required level.
842: -- Refer to Enrolments Analysis Document for example of this logic.
843: -- Note: This routine is assuming that load has already been split across load
844: -- calendars (ie: Semesters) and that there can be not further splitting of
845: -- the values below OU/IGS_PS_DSCP.
846: v_eftsu_total := 0.000;
847: FOR v_tr_rec IN c_tr LOOP
848: FOR v_ud_rec IN c_ud LOOP
849: v_eftsu_total := v_eftsu_total +