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_VAL_ENCMB dependencies on IGS_PE_UNT_REQUIRMNT

Line 504: v_unit_cd IGS_PE_UNT_REQUIRMNT.unit_cd%TYPE;

500: cst_error CONSTANT VARCHAR2(1) := 'E';
501: cst_effect_type CONSTANT VARCHAR2(10) := 'RQRD_CRS_U';
502: -- boolean used to check if a warning occured.
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;

Line 505: v_pur_start_dt IGS_PE_UNT_REQUIRMNT.pur_start_dt%TYPE;

501: cst_effect_type CONSTANT VARCHAR2(10) := 'RQRD_CRS_U';
502: -- boolean used to check if a warning occured.
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;

Line 506: v_expiry_dt IGS_PE_UNT_REQUIRMNT.expiry_dt%TYPE;

502: -- boolean used to check if a warning occured.
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

Line 511: -- IGS_PE_UNT_REQUIRMNT (pur) tables.

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
514: SELECT pur.unit_cd,
515: pur.pur_start_dt,

Line 518: IGS_PE_UNT_REQUIRMNT pur

514: SELECT pur.unit_cd,
515: pur.pur_start_dt,
516: pur.expiry_dt
517: FROM IGS_PE_PERSENC_EFFCT pee,
518: IGS_PE_UNT_REQUIRMNT pur
519: WHERE pee.person_id = p_person_id AND
520: pee.s_encmb_effect_type = cst_effect_type AND
521: pee.course_cd = p_course_cd AND
522: pur.person_id = pee.person_id AND

Line 532: cp_unit_cd IGS_PE_UNT_REQUIRMNT.unit_cd%TYPE,

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,
533: cp_p_person_id IGS_PE_PERSON.person_id%TYPE,
534: cp_p_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
535: SELECT sua.ci_start_dt,
536: sua.ci_end_dt,

Line 568: -- Loop through IGS_PE_UNT_REQUIRMNT records.

564: p_return_type := cst_error;
565:
566: RETURN FALSE;
567: END IF;
568: -- Loop through IGS_PE_UNT_REQUIRMNT records.
569: FOR v_rqrd_units IN c_pee_pur LOOP
570: IF v_rqrd_units.expiry_dt IS NULL THEN
571: IF v_rqrd_units.pur_start_dt <= p_effective_dt THEN
572: OPEN c_sua(v_rqrd_units.unit_cd, p_person_id, p_course_cd);