APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,

2762: WHERE ofr.uoo_id = cp_uoo_id
2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:
2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA

Line 2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:
2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA
2771: WHERE sua.person_id=cp_person_id

Line 2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:
2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA
2771: WHERE sua.person_id=cp_person_id
2772: AND sua.course_cd=cp_course_cd

Line 2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA

2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA
2771: WHERE sua.person_id=cp_person_id
2772: AND sua.course_cd=cp_course_cd
2773: AND sua.uoo_id=cp_uoo_id
2774: AND sua.unit_attempt_status='DROPPED';

Line 2904: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (

2900: --unit section was not attempted and dropped, so create new unit attempt
2901: IF c_sua%NOTFOUND THEN
2902: CLOSE c_sua;
2903:
2904: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
2905: PERSON_ID,
2906: COURSE_CD,
2907: UNIT_CD,
2908: VERSION_NUMBER,

Line 3068: UPDATE IGS_EN_SU_ATTEMPT_ALL SET

3064: ELSE
3065: -- unit attempt was attempted and dropped previously, so update that record
3066: CLOSE c_sua;
3067:
3068: UPDATE IGS_EN_SU_ATTEMPT_ALL SET
3069: VERSION_NUMBER =l_unit_dtsl_rec.version_number,
3070: LOCATION_CD = l_unit_dtsl_rec.location_cd,
3071: UNIT_CLASS = l_unit_dtsl_rec.unit_class,
3072: CI_START_DT = l_unit_dtsl_rec.start_dt,

Line 3295: --bdeviset 14-NOV-2005 Added cursor c_sua and update igs_en_su_attempt all for bug# 4723960

3291: -- Purpose : makes unit abd program step validations for the passed units along with
3292: -- preenroll units (units that are added by admin through preenrollment job or through admin self-service)
3293: --Change History:
3294: --Who When What
3295: --bdeviset 14-NOV-2005 Added cursor c_sua and update igs_en_su_attempt all for bug# 4723960
3296: -- ckasu 27-NOV-2005 modified create_planned_sua by changing direct DML insert,update with
3297: -- INSERT_ROW,UPDATE_ROW of SUA TBH as a part of bug#4666102
3298: -------------------------------------------------------------------------------------------
3299: