DBA Data[Home] [Help]

APPS.MTL_CATALOG_SEARCH_ITEMS_PKG dependencies on MTL_CATALOG_SEARCH_ITEMS

Line 1: PACKAGE BODY MTL_CATALOG_SEARCH_ITEMS_PKG as

1: PACKAGE BODY MTL_CATALOG_SEARCH_ITEMS_PKG as
2: /* $Header: INVIVCSB.pls 120.1 2005/07/01 12:29:26 appldev ship $ */
3:
4: procedure delete_row (item_id NUMBER,
5: org_id NUMBER,

Line 10: delete from MTL_CATALOG_SEARCH_ITEMS mtl

6: handle NUMBER) IS
7:
8: begin
9:
10: delete from MTL_CATALOG_SEARCH_ITEMS mtl
11: where mtl.inventory_item_id = item_id
12: and mtl.organization_id = org_id
13: and mtl.group_handle_id = handle;
14:

Line 27: END MTL_CATALOG_SEARCH_ITEMS_PKG;

23: begin
24: commit;
25: end sav_commit;
26:
27: END MTL_CATALOG_SEARCH_ITEMS_PKG;