APPS.IGS_AD_GEN_001 dependencies on IGS_AS_SC_ATMPT_ENR

Line 976: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae

972: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
973: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
974: RETURN BOOLEAN IS
975: BEGIN -- admpl_del_scae
976: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae
977: DECLARE
978: CURSOR c_scae IS
979: SELECT ROWID, scae.*
980: FROM IGS_AS_SC_ATMPT_ENR scae

Line 980: FROM IGS_AS_SC_ATMPT_ENR scae

976: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae
977: DECLARE
978: CURSOR c_scae IS
979: SELECT ROWID, scae.*
980: FROM IGS_AS_SC_ATMPT_ENR scae
981: WHERE scae.person_id = p_person_id AND
982: scae.course_cd = p_course_cd
983: FOR UPDATE OF scae.LAST_UPDATE_DATE NOWAIT;
984: BEGIN

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

983: FOR UPDATE OF scae.LAST_UPDATE_DATE NOWAIT;
984: BEGIN
985: FOR v_scae_rec IN c_scae
986: LOOP
987: IGS_AS_SC_ATMPT_ENR_PKG.DELETE_ROW(v_scae_rec.rowid);
988: END LOOP;
989:
990: RETURN TRUE;
991: EXCEPTION

Line 996: l_entity_name := 'IGS_AS_SC_ATMPT_ENR';

992: WHEN e_resource_busy THEN
993: IF c_scae%ISOPEN THEN
994: CLOSE c_scae;
995: END IF;
996: l_entity_name := 'IGS_AS_SC_ATMPT_ENR';
997: RETURN FALSE;
998: WHEN OTHERS THEN
999: IF c_scae%ISOPEN THEN
1000: CLOSE c_scae;

Line 2102: -- Delete IGS_AS_SC_ATMPT_ENR (13)

2098: v_process_next := TRUE;
2099: END IF;
2100: END IF;
2101:
2102: -- Delete IGS_AS_SC_ATMPT_ENR (13)
2103: IF NOT v_process_next THEN
2104: IF NOT admpl_del_scae(
2105: v_sca_rec.person_id,
2106: v_sca_rec.course_cd) THEN