DBA Data[Home] [Help]

APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_FI_FEE_AS_RT

Line 1088: -- To delete IGS_FI_FEE_AS_RT table records

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:

Line 1095: FROM IGS_FI_FEE_AS_RT fi_fee

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;

Line 1104: IGS_FI_FEE_AS_RT_PKG.DELETE_ROW(v_del_fi_fee.rowid);

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