APPS.IGS_EN_GEN_017 dependencies on IGS_EN_SU_ATTEMPT

Line 61: l_us_status igs_en_su_attempt.unit_attempt_status%TYPE;

57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_primary_code igs_ps_ver.course_cd%TYPE;
59: l_primary_version igs_ps_ver.version_number%TYPE;
60: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
61: l_us_status igs_en_su_attempt.unit_attempt_status%TYPE;
62: l_ret_status VARCHAR2(6):='TRUE';
63: l_waitlist_ind VARCHAR2(1);
64: l_message_count NUMBER;
65: l_message_data VARCHAR2(2000) := NULL;

Line 356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;

352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);

Line 357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);
361: l_error_message VARCHAR2(1000);

Line 358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);
361: l_error_message VARCHAR2(1000);
362: l_return_stat VARCHAR2(10);

Line 373: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

369: l_message_count NUMBER := NULL;
370: l_message_data VARCHAR2(1000);
371:
372: CURSOR cur_uoo_id (cp_person_id igs_pe_person.person_id%TYPE,
373: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
374: cp_cal_type igs_ca_inst.cal_type%TYPE,
375: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS
376: SELECT uoo_id
377: FROM igs_en_su_attempt

Line 377: FROM igs_en_su_attempt

373: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
374: cp_cal_type igs_ca_inst.cal_type%TYPE,
375: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS
376: SELECT uoo_id
377: FROM igs_en_su_attempt
378: WHERE person_id = cp_person_id
379: AND unit_attempt_status IN ('INVALID','WAITLIST','ENROLLED')
380: AND course_cd = cp_course_cd
381: AND (cal_type , ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number