[Home] [Help]
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,
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:
23: begin
24: commit;
25: end sav_commit;
26:
27: END MTL_CATALOG_SEARCH_ITEMS_PKG;