DBA Data[Home] [Help]

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