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;