APPS.IGS_AD_GEN_001 dependencies on IGS_EN_STDNTPSHECSOP

Line 909: -- (3) Delete IGS_EN_STDNTPSHECSOP records

905: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
906: RETURN BOOLEAN
907: IS
908: BEGIN -- admpl_del_scho
909: -- (3) Delete IGS_EN_STDNTPSHECSOP records
910: DECLARE
911: CURSOR c_scho IS
912: SELECT scho.start_dt
913: FROM IGS_EN_STDNTPSHECSOP scho

Line 913: FROM IGS_EN_STDNTPSHECSOP scho

909: -- (3) Delete IGS_EN_STDNTPSHECSOP records
910: DECLARE
911: CURSOR c_scho IS
912: SELECT scho.start_dt
913: FROM IGS_EN_STDNTPSHECSOP scho
914: WHERE scho.person_id = p_person_id AND
915: scho.course_cd = p_course_cd;
916: CURSOR c_scho_del (
917: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS

Line 917: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS

913: FROM IGS_EN_STDNTPSHECSOP scho
914: WHERE scho.person_id = p_person_id AND
915: scho.course_cd = p_course_cd;
916: CURSOR c_scho_del (
917: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
918: SELECT ROWID, scho.*
919: FROM IGS_EN_STDNTPSHECSOP scho
920: WHERE scho.person_id = p_person_id AND
921: scho.course_cd = p_course_cd AND

Line 919: FROM IGS_EN_STDNTPSHECSOP scho

915: scho.course_cd = p_course_cd;
916: CURSOR c_scho_del (
917: cp_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
918: SELECT ROWID, scho.*
919: FROM IGS_EN_STDNTPSHECSOP scho
920: WHERE scho.person_id = p_person_id AND
921: scho.course_cd = p_course_cd AND
922: scho.start_dt = cp_start_dt
923: FOR UPDATE OF

Line 930: -- Delete unconfirmed IGS_EN_STDNTPSHECSOP

926: BEGIN
927: v_error_flag := FALSE;
928: FOR v_scho_rec IN c_scho LOOP
929:
930: -- Delete unconfirmed IGS_EN_STDNTPSHECSOP
931: FOR v_scho_del_exists IN c_scho_del(v_scho_rec.start_dt) LOOP
932: IGS_EN_STDNTPSHECSOP_PKG.DELETE_ROW (
933: X_ROWID => V_SCHO_DEL_EXISTS.ROWID );
934: END LOOP;

Line 932: IGS_EN_STDNTPSHECSOP_PKG.DELETE_ROW (

928: FOR v_scho_rec IN c_scho LOOP
929:
930: -- Delete unconfirmed IGS_EN_STDNTPSHECSOP
931: FOR v_scho_del_exists IN c_scho_del(v_scho_rec.start_dt) LOOP
932: IGS_EN_STDNTPSHECSOP_PKG.DELETE_ROW (
933: X_ROWID => V_SCHO_DEL_EXISTS.ROWID );
934: END LOOP;
935:
936: END LOOP;

Line 950: l_entity_name := 'IGS_EN_STDNTPSHECSOP';

946: END IF;
947: IF c_scho_del%ISOPEN THEN
948: CLOSE c_scho_del;
949: END IF;
950: l_entity_name := 'IGS_EN_STDNTPSHECSOP';
951: RETURN FALSE;
952: WHEN OTHERS THEN
953: IF c_scho%ISOPEN THEN
954: CLOSE c_scho;

Line 2091: -- Delete IGS_EN_STDNTPSHECSOP (12)

2087: v_process_next := TRUE;
2088: END IF;
2089: END IF;
2090:
2091: -- Delete IGS_EN_STDNTPSHECSOP (12)
2092: IF NOT v_process_next THEN
2093: IF NOT admpl_del_scho(
2094: v_sca_rec.person_id,
2095: v_sca_rec.course_cd) THEN