[Home] [Help]
PACKAGE BODY: APPS.MTL_CATALOG_SEARCH_ITEMS_PKG
Source
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
15 if (SQL%NOTFOUND) then
16 Raise NO_DATA_FOUND;
17 end if;
18
19 end delete_row ;
20
21
22 procedure sav_commit is
23 begin
24 commit;
25 end sav_commit;
26
27 END MTL_CATALOG_SEARCH_ITEMS_PKG;