APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_GR_GRADUAND

Line 131: -- Delete IGS_GR_GRADUAND_PKG records

127: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
128: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
129: IS
130: BEGIN -- del_gua
131: -- Delete IGS_GR_GRADUAND_PKG records
132: DECLARE
133:
134: CURSOR c_gua IS
135: SELECT create_dt

Line 136: FROM IGS_GR_GRADUAND gua

132: DECLARE
133:
134: CURSOR c_gua IS
135: SELECT create_dt
136: FROM IGS_GR_GRADUAND gua
137: WHERE gua.person_id = p_person_id
138: AND gua.course_cd = p_course_cd;
139:
140: CURSOR c_gua_del (

Line 141: cp_create_dt IGS_GR_GRADUAND.create_dt%TYPE) IS

137: WHERE gua.person_id = p_person_id
138: AND gua.course_cd = p_course_cd;
139:
140: CURSOR c_gua_del (
141: cp_create_dt IGS_GR_GRADUAND.create_dt%TYPE) IS
142: SELECT rowid
143: FROM IGS_GR_GRADUAND gua
144: WHERE gua.person_id = p_person_id
145: AND gua.create_dt = cp_create_dt

Line 143: FROM IGS_GR_GRADUAND gua

139:
140: CURSOR c_gua_del (
141: cp_create_dt IGS_GR_GRADUAND.create_dt%TYPE) IS
142: SELECT rowid
143: FROM IGS_GR_GRADUAND gua
144: WHERE gua.person_id = p_person_id
145: AND gua.create_dt = cp_create_dt
146: FOR UPDATE OF gua.LAST_UPDATE_DATE NOWAIT ;
147:

Line 228: -- Delete unconfirmed IGS_GR_GRADUAND records

224: IF l_entity_name IS NOT NULL THEN
225: EXIT;
226: END IF;
227:
228: -- Delete unconfirmed IGS_GR_GRADUAND records
229: FOR v_gua_del_exists IN c_gua_del(v_gua_rec.create_dt) LOOP
230: IGS_GR_GRADUAND_PKG.DELETE_ROW(
231: X_ROWID => v_gua_del_exists.rowid );
232: END LOOP;

Line 230: IGS_GR_GRADUAND_PKG.DELETE_ROW(

226: END IF;
227:
228: -- Delete unconfirmed IGS_GR_GRADUAND records
229: FOR v_gua_del_exists IN c_gua_del(v_gua_rec.create_dt) LOOP
230: IGS_GR_GRADUAND_PKG.DELETE_ROW(
231: X_ROWID => v_gua_del_exists.rowid );
232: END LOOP;
233:
234: END LOOP;