APPS.IGS_EN_VAL_SCA dependencies on IGS_PS_OFR_OPT

Line 1464: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;

1460: BEGIN
1461: DECLARE
1462: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
1463: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
1464: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
1465: v_coo_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE;
1466: v_forced_att_type_ind IGS_PS_OFR_OPT.forced_att_type_ind%TYPE;
1467: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
1468: v_upper_enr_load_range IGS_EN_ATD_TYPE.upper_enr_load_range%TYPE;

Line 1465: v_coo_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE;

1461: DECLARE
1462: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
1463: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
1464: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
1465: v_coo_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE;
1466: v_forced_att_type_ind IGS_PS_OFR_OPT.forced_att_type_ind%TYPE;
1467: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
1468: v_upper_enr_load_range IGS_EN_ATD_TYPE.upper_enr_load_range%TYPE;
1469: v_validation_failed BOOLEAN;

Line 1466: v_forced_att_type_ind IGS_PS_OFR_OPT.forced_att_type_ind%TYPE;

1462: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
1463: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
1464: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
1465: v_coo_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE;
1466: v_forced_att_type_ind IGS_PS_OFR_OPT.forced_att_type_ind%TYPE;
1467: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
1468: v_upper_enr_load_range IGS_EN_ATD_TYPE.upper_enr_load_range%TYPE;
1469: v_validation_failed BOOLEAN;
1470: v_concat_attendance_type VARCHAR2(100);

Line 1476: cp_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS

1472: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
1473: v_credit_points NUMBER;
1474: v_other_detail VARCHAR(255);
1475: CURSOR c_coo(
1476: cp_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS
1477: SELECT COO.course_cd,
1478: COO.attendance_type,
1479: COO.forced_att_type_ind
1480: FROM IGS_PS_OFR_OPT COO

Line 1480: FROM IGS_PS_OFR_OPT COO

1476: cp_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS
1477: SELECT COO.course_cd,
1478: COO.attendance_type,
1479: COO.forced_att_type_ind
1480: FROM IGS_PS_OFR_OPT COO
1481: WHERE COO.coo_id = cp_coo_id
1482: AND COO.delete_flag = 'N';
1483: CURSOR c_attendance_type(
1484: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE) IS

Line 1532: -- Validate the nominated attendance type against IGS_PS_OFR_OPT

1528: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
1529: l_load_seq_number IGS_CA_INST.sequence_number%TYPE;
1530:
1531: BEGIN
1532: -- Validate the nominated attendance type against IGS_PS_OFR_OPT
1533: -- IGS_AD_LOCATION code for the students enrolled course.
1534: -- The check is only done if :
1535: -- o the IGS_PS_OFR_OPT.forced_location_ind is set.
1536: -- o one of the attendance type load range values in the IGS_EN_ATD_TYPE table

Line 1535: -- o the IGS_PS_OFR_OPT.forced_location_ind is set.

1531: BEGIN
1532: -- Validate the nominated attendance type against IGS_PS_OFR_OPT
1533: -- IGS_AD_LOCATION code for the students enrolled course.
1534: -- The check is only done if :
1535: -- o the IGS_PS_OFR_OPT.forced_location_ind is set.
1536: -- o one of the attendance type load range values in the IGS_EN_ATD_TYPE table
1537: -- are set
1538: -- NOTE: This validation is reliant on the student unit attempts being checked
1539: -- against- having been committed to the database and having had the "unit