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.

APPS.IGS_EN_VAL_SCA dependencies on IGS_EN_ATD_TYPE

Line 399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;

395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
401: CURSOR c_sca IS
402: SELECT sca.attendance_type,
403: sca.student_confirmed_ind

Line 400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
401: CURSOR c_sca IS
402: SELECT sca.attendance_type,
403: sca.student_confirmed_ind
404: FROM IGS_EN_STDNT_PS_ATT sca

Line 454: FROM IGS_EN_ATD_TYPE_LOAD atl

450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
451: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
452: SELECT atl.lower_enr_load_range,
453: atl.upper_enr_load_range
454: FROM IGS_EN_ATD_TYPE_LOAD atl
455: WHERE atl.cal_type = cp_load_cal_type AND
456: atl.attendance_type = cp_attendance_type;
457: BEGIN
458: -- Set the default message number

Line 500: -- from IGS_EN_ATD_TYPE

496: RETURN TRUE;
497: ELSE -- RecordFOUND
498: CLOSE c_ca;
499: -- Check does not apply if attendance percentage is defaulting
500: -- from IGS_EN_ATD_TYPE
501: IF v_attendance_percentage IS NULL THEN
502: RETURN TRUE;
503: END IF;
504: END IF;

Line 1467: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;

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);
1471: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;

Line 1468: v_upper_enr_load_range IGS_EN_ATD_TYPE.upper_enr_load_range%TYPE;

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);
1471: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
1472: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;

Line 1471: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%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);
1471: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
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(

Line 1472: v_period_load IGS_EN_ATD_TYPE_LOAD.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);
1471: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
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

Line 1484: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE) IS

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
1485: SELECT ATT.lower_enr_load_range,
1486: ATT.upper_enr_load_range
1487: FROM IGS_EN_ATD_TYPE ATT
1488: WHERE ATT.attendance_type = cp_attendance_type;

Line 1487: FROM IGS_EN_ATD_TYPE ATT

1483: CURSOR c_attendance_type(
1484: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE) IS
1485: SELECT ATT.lower_enr_load_range,
1486: ATT.upper_enr_load_range
1487: FROM IGS_EN_ATD_TYPE ATT
1488: WHERE ATT.attendance_type = cp_attendance_type;
1489: CURSOR c_cal_type_instance(
1490: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1491: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS

Line 1536: -- o one of the attendance type load range values in the IGS_EN_ATD_TYPE table

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
1540: -- attempt statuses" derived.