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_PR_GEN_002 dependencies on IGS_EN_STDNT_PS_ATT

Line 304: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

300: -- prgp_get_sua_prg_prd routine where appropriate.
301: DECLARE
302: cst_progress CONSTANT VARCHAR2(10) := 'PROGRESS';
303: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
304: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
305: v_number_processed NUMBER DEFAULT 0;
306: v_enrolled_in_prg_period BOOLEAN DEFAULT FALSE;
307: v_contributes_to_period BOOLEAN DEFAULT FALSE;
308: CURSOR c_sca IS

Line 310: FROM IGS_EN_STDNT_PS_ATT sca

306: v_enrolled_in_prg_period BOOLEAN DEFAULT FALSE;
307: v_contributes_to_period BOOLEAN DEFAULT FALSE;
308: CURSOR c_sca IS
309: SELECT sca.version_number
310: FROM IGS_EN_STDNT_PS_ATT sca
311: WHERE sca.person_id = p_person_id AND
312: sca.course_cd = p_course_cd;
313: CURSOR c_cat_ci (
314: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

Line 314: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

310: FROM IGS_EN_STDNT_PS_ATT sca
311: WHERE sca.person_id = p_person_id AND
312: sca.course_cd = p_course_cd;
313: CURSOR c_cat_ci (
314: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
315: SELECT ci1.cal_type,
316: ci1.sequence_number
317: FROM IGS_CA_TYPE cat,
318: IGS_CA_STAT cs,

Line 472: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;
469: v_prev_prg_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
470: v_previous_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
471: v_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
472: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
473: v_dummy VARCHAR2(1);
474: CURSOR c_cir IS
475: SELECT 'X'
476: FROM IGS_CA_INST_REL cir

Line 494: FROM IGS_EN_STDNT_PS_ATT sca

490: sua.course_cd = p_course_cd AND
491: sua.uoo_id = p_uoo_id;
492: CURSOR c_sca IS
493: SELECT sca.version_number
494: FROM IGS_EN_STDNT_PS_ATT sca
495: WHERE sca.person_id = p_person_id AND
496: sca.course_cd = p_course_cd;
497: CURSOR c_ci_cir_ct_cs1 (
498: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

Line 498: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

494: FROM IGS_EN_STDNT_PS_ATT sca
495: WHERE sca.person_id = p_person_id AND
496: sca.course_cd = p_course_cd;
497: CURSOR c_ci_cir_ct_cs1 (
498: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
499: SELECT cir.sup_cal_type,
500: cir.sup_ci_sequence_number
501: FROM IGS_CA_INST ci1,
502: IGS_CA_INST_REL cir,

Line 525: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

521: WHERE ci2.cal_type = p_prg_cal_type AND
522: ci2.sequence_number = p_prg_ci_sequence_number)
523: ORDER BY ci1.start_dt DESC;
524: CURSOR c_ci_cir_ct_cs2 (
525: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
526: SELECT 'X'
527: FROM IGS_CA_INST ci1,
528: IGS_CA_INST_REL cir,
529: IGS_CA_TYPE ct,

Line 574: -- Get the IGS_EN_STDNT_PS_ATT version_number from student IGS_PS_COURSE attempt

570: ELSE
571: v_discontinued_dt := p_discontinued_dt;
572: v_unit_attempt_status := p_unit_attempt_status;
573: END IF;
574: -- Get the IGS_EN_STDNT_PS_ATT version_number from student IGS_PS_COURSE attempt
575: OPEN c_sca;
576: FETCH c_sca INTO v_sca_version_number;
577: CLOSE c_sca;
578: -- Eliminate status which don't apply