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_SU_ATTEMPT

Line 561: FROM IGS_EN_SU_ATTEMPT

557:
558: CURSOR c_get_override_enr_cp
559: IS
560: SELECT OVERRIDE_ENROLLED_CP
561: FROM IGS_EN_SU_ATTEMPT
562: WHERE person_id = p_person_id
563: AND course_cd = p_program_cd
564: AND uoo_id = p_uoo_id;
565: -- Cursor Row Type Variables

Line 605: FROM igs_en_su_attempt

601:
602: -- Cursor to get the assessment indicator value.
603: CURSOR c_assessment IS
604: SELECT no_assessment_ind
605: FROM igs_en_su_attempt
606: WHERE person_id = p_person_id
607: AND course_cd = p_program_cd
608: AND uoo_id = p_uoo_id;
609:

Line 612: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

608: AND uoo_id = p_uoo_id;
609:
610: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
611: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
612: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
613:
614:
615: BEGIN
616:

Line 987: FROM igs_en_su_attempt

983:
984: -- Cursor to get the assessment indicator value.
985: CURSOR c_assessment IS
986: SELECT no_assessment_ind
987: FROM igs_en_su_attempt
988: WHERE person_id = p_person_id
989: AND course_cd = p_program_cd
990: AND uoo_id = p_uoo_id;
991:

Line 1026: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

1022: l_dummy NUMBER;
1023: l_unit_incurred_cp NUMBER;
1024: -- Below local variable added as part of Enrl Elgbl and Validation Build. Bug#2616692
1025: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;
1026: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1027: --dummy variable to pick up audit, billing, enrolled credit points
1028: --due to signature change by EN308 Billing credit hours Bug 3782329
1029: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1030: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

Line 1361: FROM igs_en_su_attempt

1357:
1358: -- Cursor to get the assessment indicator value.
1359: CURSOR c_assessment IS
1360: SELECT no_assessment_ind
1361: FROM igs_en_su_attempt
1362: WHERE person_id = p_person_id
1363: AND course_cd = p_course_cd
1364: AND uoo_id = p_uoo_id;
1365:

Line 1377: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

1373:
1374: -- Cursor ROWTYPE variables
1375: l_min_cp_config cur_min_cp_config%ROWTYPE;
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)

Line 1622: FROM igs_en_su_attempt sua,

1618: s_student_comm_type = 'ALL');
1619:
1620: CURSOR c_get_unit_attmpt IS
1621: SELECT DISTINCT uoo_id
1622: FROM igs_en_su_attempt sua,
1623: igs_ca_load_to_teach_v ltt
1624: WHERE sua.person_id = p_person_id
1625: AND sua.course_cd = p_course_cd
1626: AND sua.unit_attempt_status = 'ENROLLED'

Line 2270: FROM igs_en_su_attempt sua,

2266: sua.override_eftsu,
2267: sua.location_cd,
2268: sua.unit_class,
2269: sua.no_assessment_ind
2270: FROM igs_en_su_attempt sua,
2271: igs_ca_load_to_teach_v ltt
2272: WHERE sua.person_id = cp_person_id AND
2273: sua.course_cd = cp_course_cd AND
2274: sua.cal_type = ltt.teach_cal_type AND

Line 2295: CURSOR c_org_unit (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

2291: (sua.uoo_id = p_uoo_id AND
2292: sua.unit_attempt_status = 'WAITLISTED') ) AND
2293: NVL(sua.no_assessment_ind ,'N') = 'N' ;
2294:
2295: CURSOR c_org_unit (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2296: SELECT uop.owner_org_unit_cd,
2297: ou.start_dt
2298: FROM igs_ps_unit_ofr_opt_all uop,
2299: igs_or_inst_org_base_v ou

Line 2308: cp_sua_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS

2304:
2305: --
2306: -- Cursor to fetch the system Unit mode once the Unit class is provided.
2307: CURSOR c_um_ucl (
2308: cp_sua_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2309: SELECT um.s_unit_mode
2310: FROM IGS_AS_UNIT_MODE um,
2311: IGS_AS_UNIT_CLASS ucl
2312: WHERE ucl.unit_class = cp_sua_unit_class AND

Line 2348: FROM igs_en_su_attempt

2344:
2345: -- Cursor to get the assessment indicator value.
2346: CURSOR c_assessment IS
2347: SELECT no_assessment_ind
2348: FROM igs_en_su_attempt
2349: WHERE person_id = p_person_id
2350: AND course_cd = p_course_cd
2351: AND uoo_id = p_uoo_id;
2352: --

Line 2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

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;
2364: l_alternate_code IGS_CA_INST.alternate_code%TYPE;