APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,

4: --package variables
5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua

Line 9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua
13: WHERE person_id = cp_person_id AND

Line 10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua
13: WHERE person_id = cp_person_id AND
14: course_cd = cp_course_cd AND

Line 12: FROM IGS_EN_SU_ATTEMPT_ALL sua

8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua
13: WHERE person_id = cp_person_id AND
14: course_cd = cp_course_cd AND
15: uoo_id = cp_uoo_id
16: FOR UPDATE NOWAIT;