1 PACKAGE ICX_POR_DELETE_CATALOG AUTHID CURRENT_USER AS
2 /* $Header: ICXDELCS.pls 115.5 2004/03/31 18:45:38 vkartik ship $*/
3
4 ITEM_TABLE_LAST PLS_INTEGER := 0;
5 CATITEM_TABLE_LAST PLS_INTEGER := 1;
6
7 /**
8 ** Proc : delete_items_in_category
9 ** Procedure called when a category is deleted from ecmanager.
10 ** Desc : Deletes the items and prices in the category id specified
11 ** Deletes the category related info from icx_cat_browse_trees,
12 ** icx_por_category_data_sources, icx_por_category_order_map
13 **/
14 PROCEDURE delete_items_in_category (p_rt_category_id IN NUMBER,
15 p_category_key IN VARCHAR2);
16
17 /**
18 ** Proc : delete_items_in_category
19 ** Procedure called when a category is deleted from ecmanager.
20 ** Desc : Deletes the items and prices in the category id specified
21 ** Deletes the category related info from icx_cat_browse_trees,
22 ** icx_por_category_data_sources, icx_por_category_order_map
23 **/
24 PROCEDURE delete_items_in_category (
25 errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY VARCHAR2,
27 p_rt_category_id IN NUMBER,
28 p_category_key IN VARCHAR2);
29
30 /**
31 ** Proc : delete_items_in_catalog
32 ** Desc : Deletes the items and prices in the catalog name specified
33 **/
34 PROCEDURE delete_items_in_catalog (p_catalog_name IN VARCHAR2);
35
36 /**
37 ** Proc : delete_supplier_catalog_opUnit
38 ** Desc : Deletes the catalog for the supplier and Operating Unit specified.
39 **/
40 PROCEDURE delete_supplier_catalog_opUnit (p_supplier IN VARCHAR2,
41 p_operating_unit_id IN NUMBER DEFAULT -2);
42
43 /**
44 ** Proc : deleteCommonTables
45 ** Desc : Deletes the data from common tables used by Extractor and DeleteCatalog
46 **/
47 PROCEDURE deleteCommonTables (pRtItemIds IN dbms_sql.number_table,
48 pDeleteOrder IN PLS_INTEGER DEFAULT ITEM_TABLE_LAST);
49
50 /**
51 ** Proc : deleteCategoryRelatedInfo
52 ** Desc : Deletes the data from ICX_CAT_BROWSE_TREES,
53 ** ICX_POR_CATEGORY_ORDER_MAP, ICX_POR_CATEGORY_DATA_SOURCES
54 **/
55 PROCEDURE deleteCategoryRelatedInfo(pRtCategoryId IN NUMBER,
56 pCategoryKey IN VARCHAR2);
57
58 PROCEDURE setCommitSize(pCommitSize IN PLS_INTEGER);
59
60 END ICX_POR_DELETE_CATALOG;