APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_AS_SC_ATMPT_ENR

Line 922: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae

918: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
919: IS
920:
921: BEGIN -- del_scae
922: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae
923: DECLARE
924: CURSOR c_scae IS
925: SELECT ROWID, scae.*
926: FROM IGS_AS_SC_ATMPT_ENR scae

Line 926: FROM IGS_AS_SC_ATMPT_ENR scae

922: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae
923: DECLARE
924: CURSOR c_scae IS
925: SELECT ROWID, scae.*
926: FROM IGS_AS_SC_ATMPT_ENR scae
927: WHERE scae.person_id = p_person_id
928: AND scae.course_cd = p_course_cd
929: FOR UPDATE OF scae.LAST_UPDATE_DATE NOWAIT;
930:

Line 934: IGS_AS_SC_ATMPT_ENR_PKG.DELETE_ROW(v_scae_rec.rowid);

930:
931: BEGIN
932: FOR v_scae_rec IN c_scae LOOP
933:
934: IGS_AS_SC_ATMPT_ENR_PKG.DELETE_ROW(v_scae_rec.rowid);
935:
936: END LOOP;
937:
938: EXCEPTION