APPS.IGS_EN_VAL_ENCMB dependencies on IGS_EN_SU_ATTEMPT

Line 507: v_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;

503: v_warning_ind BOOLEAN := FALSE;
504: v_unit_cd IGS_PE_UNT_REQUIRMNT.unit_cd%TYPE;
505: v_pur_start_dt IGS_PE_UNT_REQUIRMNT.pur_start_dt%TYPE;
506: v_expiry_dt IGS_PE_UNT_REQUIRMNT.expiry_dt%TYPE;
507: v_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
508: v_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
509: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
510: -- Cursor on IGS_PE_PERSENC_EFFCT (pee) and
511: -- IGS_PE_UNT_REQUIRMNT (pur) tables.

Line 508: v_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;

504: v_unit_cd IGS_PE_UNT_REQUIRMNT.unit_cd%TYPE;
505: v_pur_start_dt IGS_PE_UNT_REQUIRMNT.pur_start_dt%TYPE;
506: v_expiry_dt IGS_PE_UNT_REQUIRMNT.expiry_dt%TYPE;
507: v_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
508: v_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
509: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
510: -- Cursor on IGS_PE_PERSENC_EFFCT (pee) and
511: -- IGS_PE_UNT_REQUIRMNT (pur) tables.
512: -- Cursor validates required IGS_PS_UNIT(s).

Line 509: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

505: v_pur_start_dt IGS_PE_UNT_REQUIRMNT.pur_start_dt%TYPE;
506: v_expiry_dt IGS_PE_UNT_REQUIRMNT.expiry_dt%TYPE;
507: v_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
508: v_ci_end_dt IGS_EN_SU_ATTEMPT.ci_end_dt%TYPE;
509: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
510: -- Cursor on IGS_PE_PERSENC_EFFCT (pee) and
511: -- IGS_PE_UNT_REQUIRMNT (pur) tables.
512: -- Cursor validates required IGS_PS_UNIT(s).
513: CURSOR c_pee_pur IS

Line 528: -- Cursor on IGS_EN_SU_ATTEMPT (sua).

524: pur.pen_start_dt = pee.pen_start_dt AND
525: pur.s_encmb_effect_type = pee.s_encmb_effect_type AND
526: pur.pee_start_dt = pee.pee_start_dt AND
527: pur.pee_sequence_number = pee.sequence_number;
528: -- Cursor on IGS_EN_SU_ATTEMPT (sua).
529: -- Cursor validates which units a student is enrolled in,
530: -- for a particular IGS_PS_COURSE.
531: CURSOR c_sua (
532: cp_unit_cd IGS_PE_UNT_REQUIRMNT.unit_cd%TYPE,

Line 538: FROM IGS_EN_SU_ATTEMPT sua

534: cp_p_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
535: SELECT sua.ci_start_dt,
536: sua.ci_end_dt,
537: sua.unit_attempt_status
538: FROM IGS_EN_SU_ATTEMPT sua
539: WHERE sua.person_id = cp_p_person_id AND
540: sua.course_cd = cp_p_course_cd AND
541: sua.unit_cd = cp_unit_cd AND
542: sua.unit_attempt_status IN ('COMPLETED',