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_POR_CATEGORY_DATA_SOURCES

Line 25: ** icx_por_category_data_sources, icx_por_category_order_map

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,
29: retcode OUT NOCOPY VARCHAR2,

Line 51: ** icx_por_category_data_sources, icx_por_category_order_map

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)
55: IS

Line 673: ** ICX_POR_CATEGORY_ORDER_MAP, ICX_POR_CATEGORY_DATA_SOURCES

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)
677: IS

Line 694: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');

690: xErrLoc := 200;
691: DELETE FROM icx_por_category_order_map
692: WHERE rt_category_id = pRtCategoryId;
693:
694: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');
695: --Delete the mapping for the item category.
696: xErrLoc := 300;
697: DELETE FROM icx_por_category_data_sources
698: WHERE category_key = pCategoryKey;

Line 697: DELETE FROM icx_por_category_data_sources

693:
694: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');
695: --Delete the mapping for the item category.
696: xErrLoc := 300;
697: DELETE FROM icx_por_category_data_sources
698: WHERE category_key = pCategoryKey;
699:
700: EXCEPTION
701: WHEN OTHERS THEN