APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_GR_SPECIAL_AWARD

Line 341: -- (1) Delete IGS_GR_SPECIAL_AWARD records

337: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
338: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
339: IS
340: BEGIN -- del_gsa
341: -- (1) Delete IGS_GR_SPECIAL_AWARD records
342: DECLARE
343: CURSOR c_gsa IS
344: SELECT award_cd,award_dt
345: FROM IGS_GR_SPECIAL_AWARD gsa

Line 345: FROM IGS_GR_SPECIAL_AWARD gsa

341: -- (1) Delete IGS_GR_SPECIAL_AWARD records
342: DECLARE
343: CURSOR c_gsa IS
344: SELECT award_cd,award_dt
345: FROM IGS_GR_SPECIAL_AWARD gsa
346: WHERE gsa.person_id = p_person_id
347: AND gsa.course_cd = p_course_cd;
348:
349: CURSOR c_gsa_del (

Line 350: cp_award_cd IGS_GR_SPECIAL_AWARD.award_cd%TYPE,

346: WHERE gsa.person_id = p_person_id
347: AND gsa.course_cd = p_course_cd;
348:
349: CURSOR c_gsa_del (
350: cp_award_cd IGS_GR_SPECIAL_AWARD.award_cd%TYPE,
351: cp_award_dt IGS_GR_SPECIAL_AWARD.award_dt%TYPE) IS
352: SELECT rowid
353: FROM IGS_GR_SPECIAL_AWARD gsa
354: WHERE gsa.person_id = p_person_id

Line 351: cp_award_dt IGS_GR_SPECIAL_AWARD.award_dt%TYPE) IS

347: AND gsa.course_cd = p_course_cd;
348:
349: CURSOR c_gsa_del (
350: cp_award_cd IGS_GR_SPECIAL_AWARD.award_cd%TYPE,
351: cp_award_dt IGS_GR_SPECIAL_AWARD.award_dt%TYPE) IS
352: SELECT rowid
353: FROM IGS_GR_SPECIAL_AWARD gsa
354: WHERE gsa.person_id = p_person_id
355: AND gsa.course_cd = p_course_cd

Line 353: FROM IGS_GR_SPECIAL_AWARD gsa

349: CURSOR c_gsa_del (
350: cp_award_cd IGS_GR_SPECIAL_AWARD.award_cd%TYPE,
351: cp_award_dt IGS_GR_SPECIAL_AWARD.award_dt%TYPE) IS
352: SELECT rowid
353: FROM IGS_GR_SPECIAL_AWARD gsa
354: WHERE gsa.person_id = p_person_id
355: AND gsa.course_cd = p_course_cd
356: AND gsa.award_cd = cp_award_cd
357: AND gsa.award_dt = cp_award_dt

Line 368: IGS_GR_SPECIAL_AWARD_PKG.DELETE_ROW(X_ROWID => v_gsa_del_exists.rowid );

364: FOR v_gsa_rec IN c_gsa LOOP
365: FOR v_gsa_del_exists IN c_gsa_del(v_gsa_rec.award_cd,
366: v_gsa_rec.award_dt ) LOOP
367:
368: IGS_GR_SPECIAL_AWARD_PKG.DELETE_ROW(X_ROWID => v_gsa_del_exists.rowid );
369:
370: END LOOP;
371:
372: END LOOP;