eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_DELETE_CATALOG dependencies on ICX_CAT_BROWSE_TREES

Line 24: ** Deletes the category related info from icx_cat_browse_trees,

20: /**
21: ** Proc : delete_items_in_category
22: ** Procedure called when a category is deleted from ecmanager.
23: ** Desc : Deletes the items and prices in the category id specified
24: ** Deletes the category related info from icx_cat_browse_trees,
25: ** icx_por_category_data_sources, icx_por_category_order_map
26: **/
27: PROCEDURE delete_items_in_category (
28: errbuf OUT NOCOPY VARCHAR2,

Line 50: ** Deletes the category related info from icx_cat_browse_trees,

46: /**
47: ** Proc : delete_items_in_category
48: ** Procedure called when a category is deleted from ecmanager.
49: ** Desc : Deletes the items and prices in the category id specified
50: ** Deletes the category related info from icx_cat_browse_trees,
51: ** icx_por_category_data_sources, icx_por_category_order_map
52: **/
53: PROCEDURE delete_items_in_category (p_rt_category_id IN NUMBER,
54: p_category_key IN VARCHAR2)

Line 672: ** Desc : Deletes the data from ICX_CAT_BROWSE_TREES,

668: END deleteCommonTables;
669:
670: /**
671: ** Proc : deleteCategoryRelatedInfo
672: ** Desc : Deletes the data from ICX_CAT_BROWSE_TREES,
673: ** ICX_POR_CATEGORY_ORDER_MAP, ICX_POR_CATEGORY_DATA_SOURCES
674: **/
675: PROCEDURE deleteCategoryRelatedInfo(pRtCategoryId IN NUMBER,
676: pCategoryKey IN VARCHAR2)

Line 682: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_BROWSE_TREES');

678: xErrLoc PLS_INTEGER := 0;
679: xContinue BOOLEAN := TRUE;
680:
681: BEGIN
682: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_BROWSE_TREES');
683: --Delete the item category from browse trees if it existed in any toc.
684: xErrLoc := 100;
685: DELETE FROM icx_cat_browse_trees
686: WHERE child_category_id = pRtCategoryId;

Line 685: DELETE FROM icx_cat_browse_trees

681: BEGIN
682: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_BROWSE_TREES');
683: --Delete the item category from browse trees if it existed in any toc.
684: xErrLoc := 100;
685: DELETE FROM icx_cat_browse_trees
686: WHERE child_category_id = pRtCategoryId;
687:
688: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_ORDER_MAP');
689: --Delete the mapping for the item category.