APPS.IGS_EN_VAL_SUT dependencies on IGS_PS_STDNT_UNT_TRN

Line 34: -- This module validates the delete of IGS_PS_STDNT_UNT_TRN details.

30: --kkillams 28-04-2003 New parameter p_uoo_id is added to the function and modified c_sua
31: -- cursor where clause w.r.t. bug number 2829262
32: -------------------------------------------------------------------------------------------
33: BEGIN -- enrp_val_sut_delete
34: -- This module validates the delete of IGS_PS_STDNT_UNT_TRN details.
35: DECLARE
36: CURSOR c_sua IS
37: SELECT 'X'
38: FROM IGS_PS_STDNT_UNT_TRN sut, igs_en_su_attempt sua

Line 38: FROM IGS_PS_STDNT_UNT_TRN sut, igs_en_su_attempt sua

34: -- This module validates the delete of IGS_PS_STDNT_UNT_TRN details.
35: DECLARE
36: CURSOR c_sua IS
37: SELECT 'X'
38: FROM IGS_PS_STDNT_UNT_TRN sut, igs_en_su_attempt sua
39: WHERE sut.person_id = p_person_id AND
40: sut.transfer_course_cd = p_course_cd AND
41: sut.uoo_id = p_uoo_id AND
42: sua.person_id = sut.person_id AND

Line 89: -- This module validates the insert of IGS_PS_STDNT_UNT_TRN details

85: p_uoo_id IN NUMBER)
86: RETURN BOOLEAN AS
87: -------------------------------------------------------------------------------------------
88: -- enrp_val_sut_insert
89: -- This module validates the insert of IGS_PS_STDNT_UNT_TRN details
90: -- * Transferred 'from' IGS_PS_UNIT must have unit_attempt_status 'COMPLETED',
91: -- 'DUPLICATE', ('DISCONTIN' and IGS_EN_SU_ATTEMPT has a result of
92: -- 'FAIL').
93: -- * Cannot insert if transferred ?to? IGS_PS_UNIT maps to IGS_EN_STDNT_PS_ATT