APPS.GMS_ENCUMBRANCES_PKG dependencies on GMS_ENCUMBRANCE_ITEMS
Line 224: cursor items is select encumbrance_item_id from gms_encumbrance_items
220: END update_row;
221:
222:
223: procedure delete_row (x_encumbrance_id in NUMBER) is 224: cursor items is select encumbrance_item_id from gms_encumbrance_items 225: where encumbrance_id = x_encumbrance_id
226: for update of encumbrance_item_id nowait;
227: items_rec items%rowtype;
228: BEGIN
Line 242: gms_encumbrance_items_pkg.delete_row (items_rec.encumbrance_item_id);
238: fetch items into items_rec;
239: if (items%notfound) then
240: exit;
241: else 242: gms_encumbrance_items_pkg.delete_row (items_rec.encumbrance_item_id); 243: end if;
244: END LOOP;
245:
246: delete from gms_encumbrances