APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 259: FROM IGS_EN_SU_ATTEMPT

255: ) AS
256:
257: CURSOR cur_unit_atmpt_dis IS
258: SELECT cal_type,ci_sequence_number,discontinued_dt
259: FROM IGS_EN_SU_ATTEMPT
260: WHERE person_id = x_person_id
261: AND course_cd = x_course_cd
262: AND discontinued_dt IS NOT NULL
263: ORDER BY discontinued_dt DESC;

Line 275: FROM IGS_EN_SU_ATTEMPT

271: ORDER BY load_start_dt DESC;
272:
273: CURSOR cur_unit_atmpt_grd IS
274: SELECT cal_type,ci_sequence_number
275: FROM IGS_EN_SU_ATTEMPT
276: WHERE person_id = x_person_id
277: AND course_cd = x_course_cd
278: AND unit_attempt_status='COMPLETED';
279:

Line 290: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;

286: ORDER BY load_end_dt DESC;
287:
288: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;
289: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;
290: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
291:
292: cur_unit_atmpt_dis_rec cur_unit_atmpt_dis%ROWTYPE;
293: cur_term_cal_rec cur_term_cal%ROWTYPE;
294: cur_unit_atmpt_grd_rec cur_unit_atmpt_grd%ROWTYPE;

Line 2162: IGS_EN_SU_ATTEMPT_H_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

2158: IGS_PR_STDNT_PR_CK_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2159: old_references.person_id,
2160: old_references.course_cd
2161: );
2162: IGS_EN_SU_ATTEMPT_H_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2163: old_references.person_id,
2164: old_references.course_cd
2165: );
2166: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

Line 2166: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

2162: IGS_EN_SU_ATTEMPT_H_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2163: old_references.person_id,
2164: old_references.course_cd
2165: );
2166: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2167: old_references.person_id,
2168: old_references.course_cd
2169: );
2170: IGS_AS_SU_SETATMPT_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

Line 3059: CURSOR cur_sua_uooid(cp_person_id igs_en_su_attempt_all.person_id%TYPE, cp_course_cd igs_en_su_attempt_all.course_cd%TYPE)

3055: spa.version_number = pv.version_number AND
3056: pv.course_type = cp_course_type;
3057: cur_pattempts_rec cur_pattempts%ROWTYPE;
3058:
3059: CURSOR cur_sua_uooid(cp_person_id igs_en_su_attempt_all.person_id%TYPE, cp_course_cd igs_en_su_attempt_all.course_cd%TYPE)
3060: IS
3061: SELECT sua.uoo_id
3062: FROM igs_en_su_attempt_all sua
3063: WHERE sua.person_id = cp_person_id AND

Line 3062: FROM igs_en_su_attempt_all sua

3058:
3059: CURSOR cur_sua_uooid(cp_person_id igs_en_su_attempt_all.person_id%TYPE, cp_course_cd igs_en_su_attempt_all.course_cd%TYPE)
3060: IS
3061: SELECT sua.uoo_id
3062: FROM igs_en_su_attempt_all sua
3063: WHERE sua.person_id = cp_person_id AND
3064: sua.course_cd = cp_course_cd AND
3065: sua.unit_attempt_status = 'UNCONFIRM';
3066: cur_sua_uooid_rec cur_sua_uooid%ROWTYPE;