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_ELGBL_PROGRAM dependencies on IGS_EN_STDNT_PS_ATT

Line 1380: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;

1376: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
1377: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1378:
1379: -- Table.Column Type Variables
1380: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
1381: l_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE; -- should be NUMBER(6,3) Instead of NUMBER(5,3)
1382: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1383: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1384: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;

Line 2233: cp_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE,

2229:
2230:
2231: -- Cursor to fetch the Cross faculty Element restrictions
2232: CURSOR c_cop (
2233: cp_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE,
2234: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
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,

Line 2234: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,

2230:
2231: -- Cursor to fetch the Cross faculty Element restrictions
2232: CURSOR c_cop (
2233: cp_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE,
2234: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
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

Line 2254: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2250: -- CURSOR c_sua_uv was modified to remove academic calendar instance relationship.
2251: -- Instead fetch all unit attempts which belong to the passed load calendar.
2252:
2253: CURSOR c_sua_uv (
2254: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2255: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2256: cp_load_cal_type IGS_CA_INST.cal_type%TYPE, -- Load Cal
2257: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS-- Load Cal
2258: SELECT DISTINCT sua.unit_cd,

Line 2255: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2251: -- Instead fetch all unit attempts which belong to the passed load calendar.
2252:
2253: CURSOR c_sua_uv (
2254: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2255: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2256: cp_load_cal_type IGS_CA_INST.cal_type%TYPE, -- Load Cal
2257: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS-- Load Cal
2258: SELECT DISTINCT sua.unit_cd,
2259: sua.version_number,

Line 2319: CURSOR c_am ( cp_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE) IS

2315:
2316: --
2317: -- Cursor to fetch the govt. Attendance mode from the user defined Attendance Mode. Government Attendance Mode of 1
2318: -- means ON CAMPUS , 2 means OFF CAMPUS and 3 means MIXED CAMPUS.
2319: CURSOR c_am ( cp_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE) IS
2320: SELECT am.govt_attendance_mode
2321: FROM IGS_EN_ATD_MODE am
2322: WHERE am.attendance_mode = cp_sca_attendance_mode;
2323: --

Line 2325: CURSOR c_cow (cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2321: FROM IGS_EN_ATD_MODE am
2322: WHERE am.attendance_mode = cp_sca_attendance_mode;
2323: --
2324: -- Cursor to check if the Organization Unit associated with the Course is the same as the Organization associated with the Unit.
2325: CURSOR c_cow (cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2326: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2327: cp_uv_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
2328: cp_uv_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE) IS
2329: SELECT cow.course_cd,

Line 2326: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

2322: WHERE am.attendance_mode = cp_sca_attendance_mode;
2323: --
2324: -- Cursor to check if the Organization Unit associated with the Course is the same as the Organization associated with the Unit.
2325: CURSOR c_cow (cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2326: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2327: cp_uv_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
2328: cp_uv_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE) IS
2329: SELECT cow.course_cd,
2330: cow.version_number,

Line 2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

2366: l_return_eftsu NUMBER := 0;
2367: v_um_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
2368: v_am_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
2369:
2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;
2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;

Line 2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

2367: v_um_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
2368: v_am_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
2369:
2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;
2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:

Line 2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;

2368: v_am_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
2369:
2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;
2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;

Line 2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;

2369:
2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;
2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;
2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;

Line 2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;

2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;
2373: l_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE;
2374: l_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
2375:
2376: l_cow_course_cd IGS_PS_OWN.course_cd%TYPE;
2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;
2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;