APPS.IGS_AD_GEN_002 dependencies on IGS_EN_SU_ATTEMPT

Line 51: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

47: -- and retured to the TAC.
48: DECLARE
49: fp_input UTL_FILE.FILE_TYPE;
50: fp_output UTL_FILE.FILE_TYPE;
51: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
52: 'ENROLLED';
53: cst_sus_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=
54: 'SUS_SRVC';
55: cst_rvk_srvc CONSTANT IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE :=

Line 215: FROM IGS_EN_SU_ATTEMPT sua

211: IGS_GE_DATE.IGSDATE('9999/12/31'),--TO_DATE('31/12/9999', 'DD/MM/YYYY'),
212: pee.expiry_dt);
213: CURSOR c_sua IS
214: SELECT sua.person_id
215: FROM IGS_EN_SU_ATTEMPT sua
216: WHERE sua.person_id = p_target_person_id AND
217: sua.unit_attempt_status = cst_enrolled;
218: BEGIN -- admpl_store_matched_table (10)
219: -- This will add the matched ID number along with the basis

Line 1292: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

1288: --
1289: -- Who When What
1290: -- knaraset 29-Apr-03 passed uoo_id in call of IGS_AS_GEN_003.assp_get_sua_grade, as part of MUS build bug 2829262
1291: --
1292: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
1293: 'DISCONTIN';
1294: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
1295: 'COMPLETED';
1296: cst_exc_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=

Line 1294: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

1290: -- knaraset 29-Apr-03 passed uoo_id in call of IGS_AS_GEN_003.assp_get_sua_grade, as part of MUS build bug 2829262
1291: --
1292: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
1293: 'DISCONTIN';
1294: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
1295: 'COMPLETED';
1296: cst_exc_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=
1297: 'EXC_COURSE';
1298: cst_exc_crs_gp CONSTANT IGS_PE_CRS_GRP_EXCL.s_encmb_effect_type%TYPE :=

Line 1381: FROM IGS_EN_SU_ATTEMPT sua,

1377: sua.override_enrolled_cp,
1378: sua.override_eftsu,
1379: sua.unit_attempt_status,
1380: sua.no_assessment_ind
1381: FROM IGS_EN_SU_ATTEMPT sua,
1382: IGS_EN_STDNT_PS_ATT sca,
1383: IGS_PS_VER crv,
1384: IGS_PS_UNIT_VER uv
1385: WHERE sua.person_id = p_matched_id AND

Line 1523: -- IGS_EN_SU_ATTEMPT records for this student

1519: v_course_sem_first_enr := 9;
1520: v_course_sem_last_enr := 0;
1521: v_sca_total_eftsu := 0.00;
1522: -- Find any IGS_EN_STDNT_PS_ATT records that have
1523: -- IGS_EN_SU_ATTEMPT records for this student
1524: FOR v_sua_sca_rec IN c_sua_sca LOOP
1525: -- We can't write the subject record until we have
1526: -- all the details for the course attempt record.
1527: IF (v_last_course_cd <> v_sua_sca_rec.course_cd OR

Line 1663: -- the IGS_EN_SU_ATTEMPT records.

1659: --------------------
1660: v_sua_eftsu := 0.000;
1661: -- We need to find the load calendars that should be
1662: -- used against the teaching calendars we have from
1663: -- the IGS_EN_SU_ATTEMPT records.
1664: FOR v_cir_cat_rec IN c_cir_cat(
1665: v_sua_sca_rec.cal_type,
1666: v_sua_sca_rec.ci_sequence_number) LOOP
1667: IF (IGS_EN_PRC_LOAD.enrp_get_load_incur(