1084: END;
1085:
1086: END del_av;
1087:
1088: -- To delete IGS_FI_FEE_AS_RT table records
1089: PROCEDURE del_fi_fee(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1090: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1091: IS
1092:
1091: IS
1092:
1093: CURSOR c_del_fi_fee IS
1094: SELECT rowid
1095: FROM IGS_FI_FEE_AS_RT fi_fee
1096: WHERE fi_fee.person_id = p_person_id
1097: AND fi_fee.course_cd = p_course_cd;
1098:
1099: v_del_fi_fee c_del_fi_fee%ROWTYPE;
1100:
1101: BEGIN
1102: FOR v_del_fi_fee IN c_del_fi_fee LOOP
1103:
1104: IGS_FI_FEE_AS_RT_PKG.DELETE_ROW(v_del_fi_fee.rowid);
1105:
1106: END LOOP;
1107:
1108: EXCEPTION