[Home] [Help]
78: -- p_override_eftsu - if specified, this is passed to the enrp_clc_sua_load and
79: -- is used
80: -- as the basis for the eftsu calculation. The figure is still split across
81: -- load calendars
82: -- and truncated according to the standard logic.
83: --Change History:
84: --Who When What
85: --kkillams 28-04-2003 Modified c_sua cursor due to change in pk of the student unit attempt
86: -- w.r.t. bug number 2829262
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.
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.
781: v_weftsu_factor;
782: END IF;
783: ELSE
784: -- The institution is not Deakin University;
785: -- apply the standard calculation.
786: v_sua_weftsu := p_sua_eftsu *
787: v_funding_index_1 *
788: v_weftsu_factor;
789: END IF;
933: BEGIN
934: -- Get the annual load figure of a student unit attempt within a course
935: -- version.
936: -- This figure may come from one of three places:
937: -- Method 1. If the IGS_PS_COURSE has a standard annual load across all years then
938: -- the IGS_PS_VER.std_annual_load figure is used. This is defined by the
939: -- non-existence of a current IGS_PS_ANL_LOAD record for the course version.
940: -- Method 2. By interrogating the IGS_PS_ANL_LOAD structure to determine
941: -- which annual load value is applicable, given the students current passed
943: -- defined (refer method 3).
944: -- Method 3. By using the IGS_PS_ANL_LOAD_U_LN structure, which
945: -- explicitely links the unit version to a IGS_PS_ANL_LOAD record, dictating
946: -- the annual load figure.
947: -- 1. Check whether course version has a 'standard' annual load across all
948: -- years - this is done by searching for the existence of a current
949: -- IGS_PS_ANL_LOAD record -
950: -- no records means a 'standard' structure.
951: OPEN c_cal;
946: -- the annual load figure.
947: -- 1. Check whether course version has a 'standard' annual load across all
948: -- years - this is done by searching for the existence of a current
949: -- IGS_PS_ANL_LOAD record -
950: -- no records means a 'standard' structure.
951: OPEN c_cal;
952: FETCH c_cal INTO v_count;
953: CLOSE c_cal;
954: IF (v_count = 0) THEN