APPS.PA_EXPENDITURES_PKG dependencies on PA_EXPENDITURE_ITEMS
Line 234: cursor items is select expenditure_item_id from pa_expenditure_items
230: END update_row;
231:
232:
233: procedure delete_row (x_expenditure_id in NUMBER) is 234: cursor items is select expenditure_item_id from pa_expenditure_items 235: where expenditure_id = x_expenditure_id
236: for update of expenditure_item_id nowait;
237: items_rec items%rowtype;
238: BEGIN
Line 252: pa_expenditure_items_pkg.delete_row (items_rec.expenditure_item_id);
248: fetch items into items_rec;
249: if (items%notfound) then
250: exit;
251: else 252: pa_expenditure_items_pkg.delete_row (items_rec.expenditure_item_id); 253: end if;
254: END LOOP;
255:
256: delete from pa_expenditures