APPS.IGS_EN_GEN_018 dependencies on IGS_EN_SU_ATTEMPT

Line 287: FROM IGS_EN_SU_ATTEMPT

283: -------------------------------------------------------------------
284:
285: CURSOR c_get_sua (cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_uoo_id VARCHAR2) IS
286: SELECT *
287: FROM IGS_EN_SU_ATTEMPT
288: WHERE person_id=cp_person_id
289: AND course_cd=cp_course_cd
290: AND uoo_id=cp_uoo_id;
291:

Line 493: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

489:
490: --Checks if the student has already attempted the specified uoo
491: CURSOR c_sua_exists (cp_person_id igs_pe_person.person_id%TYPE,
492: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
493: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
494: SELECT 'Y' FROM igs_en_su_attempt
495: WHERE person_id =cp_person_id
496: AND course_cd = cp_program_cd
497: AND uoo_id = cp_uoo_id

Line 494: SELECT 'Y' FROM igs_en_su_attempt

490: --Checks if the student has already attempted the specified uoo
491: CURSOR c_sua_exists (cp_person_id igs_pe_person.person_id%TYPE,
492: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
493: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
494: SELECT 'Y' FROM igs_en_su_attempt
495: WHERE person_id =cp_person_id
496: AND course_cd = cp_program_cd
497: AND uoo_id = cp_uoo_id
498: AND unit_attempt_status IN ('ENROLLED','UNCONFIRM','WAITLISTED');

Line 577: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

573: l_pos1 NUMBER;
574: l_pos2 NUMBER;
575: l_processed_rec BOOLEAN := FALSE; -- Boolean to indicate if any records where processed
576: l_batch_desc VARCHAR2(100);
577: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
578: l_sup_units_list VARCHAR2(2000);
579: l_sup_unit igs_ps_unit_ofr_opt.uoo_id%TYPE;
580: l_sub_success VARCHAR2(2000);
581: l_sub_waitlist VARCHAR2(2000);