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.

[Home] [Help]

APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PS_OFR_PAT

Line 2239: FROM IGS_PS_OFR_PAT cop

2235: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2236: SELECT cop.max_cross_faculty_cp,
2237: cop.max_cross_mode_cp,
2238: cop.max_cross_location_cp
2239: FROM IGS_PS_OFR_PAT cop
2240: WHERE cop.coo_id = cp_sca_coo_id AND
2241: cop.cal_type = cp_cal_type AND
2242: cop.ci_sequence_number = cp_ci_sequence_number;
2243:

Line 2354: l_cop_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE;

2350: AND course_cd = p_course_cd
2351: AND uoo_id = p_uoo_id;
2352: --
2353: -- Variables
2354: l_cop_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE;
2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;
2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;
2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;

Line 2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;

2351: AND uoo_id = p_uoo_id;
2352: --
2353: -- Variables
2354: l_cop_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE;
2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;
2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;
2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;

Line 2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;

2352: --
2353: -- Variables
2354: l_cop_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE;
2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;
2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;
2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;
2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

Line 2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;

2353: -- Variables
2354: l_cop_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE;
2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;
2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;
2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;
2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2361:

Line 2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;

2354: l_cop_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE;
2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;
2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;
2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;
2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2361:
2362: l_sua_cp IGS_PS_UNIT_VER.POINTS_MAX%TYPE;

Line 2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;

2355: l_cross_faculty_cp IGS_PS_OFR_PAT.max_cross_faculty_cp%TYPE := 0;
2356: l_cop_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE;
2357: l_cross_mode_cp IGS_PS_OFR_PAT.max_cross_mode_cp%TYPE := 0 ;
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;
2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2361:
2362: l_sua_cp IGS_PS_UNIT_VER.POINTS_MAX%TYPE;
2363: l_return_value BOOLEAN;

Line 2396: l_token_value IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;

2392:
2393: l_message VARCHAR2(2000);
2394: l_message_text VARCHAR2(2000);
2395: l_message_icon VARCHAR2(1);
2396: l_token_value IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2397: BEGIN
2398:
2399: -- This module validates that the student hasn't breached any of the cross-element restrictions held against the
2400: -- course-offering pattern for the specified academic period.

Line 2469: -- no IGS_PS_OFR_PAT records found

2465: FETCH c_cop INTO l_cop_cross_faculty_cp,
2466: l_cop_cross_mode_cp,
2467: l_cop_cross_location_cp;
2468: IF (c_cop%NOTFOUND) THEN
2469: -- no IGS_PS_OFR_PAT records found
2470: CLOSE c_cop;
2471: RETURN TRUE;
2472: END IF;
2473: CLOSE c_cop;