APPS.ICX_POR_EXT_CLASS dependencies on ICX_POR_CATEGORY_DATA_SOURCES

Line 197: ICX_POR_EXT_UTL.debug('Create ICX_POR_CATEGORY_DATA_SOURCES records');

193: xErrLoc := 400;
194: xMode := 'ADDNEW';
195:
196: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
197: ICX_POR_EXT_UTL.debug('Create ICX_POR_CATEGORY_DATA_SOURCES records');
198: END IF;
199:
200: -- Creates ICX_POR_CATEGORY_DATA_SOURCES records
201:

Line 200: -- Creates ICX_POR_CATEGORY_DATA_SOURCES records

196: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
197: ICX_POR_EXT_UTL.debug('Create ICX_POR_CATEGORY_DATA_SOURCES records');
198: END IF;
199:
200: -- Creates ICX_POR_CATEGORY_DATA_SOURCES records
201:
202: -- Bug#3011247 : srmani - Adding back the Not Exists Clause.
203: -- Workaround, as Bulktable cannot be referenced inside a not exists clause.
204:

Line 206: INSERT INTO icx_por_category_data_sources (

202: -- Bug#3011247 : srmani - Adding back the Not Exists Clause.
203: -- Workaround, as Bulktable cannot be referenced inside a not exists clause.
204:
205: FORALL i IN 1..gAddRtCategoryIds.COUNT
206: INSERT INTO icx_por_category_data_sources (
207: -- Bug: 3291430 - Also populate rt_category_id with value from icx_cat_categories_tl
208: rt_category_id,
209: category_key,
210: external_source, external_source_key,

Line 225: from icx_por_category_data_sources

221: WHERE
222: rt_category_id = gAddRtCategoryIds(i) and
223: language = gAddLanguages(i) and
224: not exists (select 1
225: from icx_por_category_data_sources
226: where external_source = 'Oracle'
227: and external_source_key = key);
228:
229: xErrLoc := 500;