100: END IF;
101:
102: xErrLoc := 100;
103: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
104: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');
105: END IF;
106: FORALL i IN 1..gCategoryKeys.COUNT
107: DELETE FROM icx_por_category_data_sources
108: WHERE category_key = gCategoryKeys(i)
103: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
104: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');
105: END IF;
106: FORALL i IN 1..gCategoryKeys.COUNT
107: DELETE FROM icx_por_category_data_sources
108: WHERE category_key = gCategoryKeys(i)
109: AND external_source = 'Oracle';
110:
111: ICX_POR_EXT_UTL.extCommit;