APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_ANL_LOAD

Line 876: v_annual_load_val IGS_PS_ANL_LOAD.annual_load_val%TYPE;

872: BEGIN
873: DECLARE
874: v_count NUMBER;
875: v_std_annual_load IGS_PS_VER.std_annual_load%TYPE;
876: v_annual_load_val IGS_PS_ANL_LOAD.annual_load_val%TYPE;
877: v_sca_cp_total NUMBER;
878: v_cumulative_load NUMBER;
879: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
880: CURSOR c_cal IS

Line 882: FROM IGS_PS_ANL_LOAD cal

878: v_cumulative_load NUMBER;
879: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
880: CURSOR c_cal IS
881: SELECT COUNT(*)
882: FROM IGS_PS_ANL_LOAD cal
883: WHERE cal.course_cd = p_course_cd AND
884: cal.version_number = p_version_number AND
885: cal.effective_start_dt <= SYSDATE AND
886: (cal.effective_end_dt IS NULL OR

Line 895: FROM IGS_PS_ANL_LOAD_U_LN calul,

891: WHERE crv.course_cd = p_course_cd AND
892: crv.version_number = p_version_number;
893: CURSOR c_calul_cal IS
894: SELECT cal.annual_load_val
895: FROM IGS_PS_ANL_LOAD_U_LN calul,
896: IGS_PS_ANL_LOAD cal
897: WHERE calul.course_cd = p_course_cd AND
898: calul.crv_version_number = p_version_number AND
899: calul.effective_start_dt <= SYSDATE AND

Line 896: IGS_PS_ANL_LOAD cal

892: crv.version_number = p_version_number;
893: CURSOR c_calul_cal IS
894: SELECT cal.annual_load_val
895: FROM IGS_PS_ANL_LOAD_U_LN calul,
896: IGS_PS_ANL_LOAD cal
897: WHERE calul.course_cd = p_course_cd AND
898: calul.crv_version_number = p_version_number AND
899: calul.effective_start_dt <= SYSDATE AND
900: calul.unit_cd = p_unit_cd AND

Line 912: FROM IGS_PS_ANL_LOAD cal

908: ORDER BY calul.effective_start_dt DESC,
909: cal.yr_num;
910: CURSOR c_cal2 IS
911: SELECT cal.annual_load_val
912: FROM IGS_PS_ANL_LOAD cal
913: WHERE cal.course_cd = p_course_cd AND
914: cal.version_number = p_version_number AND
915: cal.effective_start_dt <= SYSDATE AND
916: (cal.effective_end_dt IS NULL OR

Line 939: -- non-existence of a current IGS_PS_ANL_LOAD record for the course version.

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
942: -- credit point total. This is used when no annual load unit link is
943: -- defined (refer method 3).

Line 940: -- Method 2. By interrogating the IGS_PS_ANL_LOAD structure to determine

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
942: -- credit point total. This is used when no annual load unit link is
943: -- defined (refer method 3).
944: -- Method 3. By using the IGS_PS_ANL_LOAD_U_LN structure, which

Line 944: -- Method 3. By using the IGS_PS_ANL_LOAD_U_LN structure, which

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
942: -- credit point total. This is used when no annual load unit link is
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

Line 945: -- explicitely links the unit version to a IGS_PS_ANL_LOAD record, dictating

941: -- which annual load value is applicable, given the students current passed
942: -- credit point total. This is used when no annual load unit link is
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 -

Line 949: -- IGS_PS_ANL_LOAD record -

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;
952: FETCH c_cal INTO v_count;
953: CLOSE c_cal;

Line 1015: -- a record must exist in IGS_PS_ANL_LOAD and for the course

1011: OPEN c_crv;
1012: FETCH c_crv INTO v_std_annual_load;
1013: IF (c_crv%NOTFOUND) THEN
1014: -- At present, this will not occur because to reach this point
1015: -- a record must exist in IGS_PS_ANL_LOAD and for the course
1016: -- to exist in IGS_PS_ANL_LOAD it must exist in IGS_PS_VER.
1017: CLOSE c_crv;
1018: RETURN 0;
1019: END IF;

Line 1016: -- to exist in IGS_PS_ANL_LOAD it must exist in IGS_PS_VER.

1012: FETCH c_crv INTO v_std_annual_load;
1013: IF (c_crv%NOTFOUND) THEN
1014: -- At present, this will not occur because to reach this point
1015: -- a record must exist in IGS_PS_ANL_LOAD and for the course
1016: -- to exist in IGS_PS_ANL_LOAD it must exist in IGS_PS_VER.
1017: CLOSE c_crv;
1018: RETURN 0;
1019: END IF;
1020: CLOSE c_crv;