APPS.ICX_POR_EXT_TEST dependencies on ICX_POR_CATEGORY_DATA_SOURCES

Line 685: 'Delete test data from icx_por_category_data_sources');

681: CLOSE cTestRows;
682:
683: xErrLoc:= 200;
684: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
685: 'Delete test data from icx_por_category_data_sources');
686: xErrLoc:= 220;
687: xRowCount := 0;
688: OPEN cTestRows FOR
689: SELECT ROWID FROM icx_por_category_data_sources

Line 689: SELECT ROWID FROM icx_por_category_data_sources

685: 'Delete test data from icx_por_category_data_sources');
686: xErrLoc:= 220;
687: xRowCount := 0;
688: OPEN cTestRows FOR
689: SELECT ROWID FROM icx_por_category_data_sources
690: WHERE last_updated_by = TEST_USER_ID;
691: xErrLoc := 240;
692: LOOP
693: xRowIds.DELETE;

Line 702: DELETE icx_por_category_data_sources

698: EXIT WHEN xRowIds.COUNT = 0;
699: xRowCount := xRowCount + xRowIds.COUNT;
700: xErrLoc := 280;
701: FORALL i IN 1..xRowIds.COUNT
702: DELETE icx_por_category_data_sources
703: WHERE rowid = xRowIds(i);
704: COMMIT;
705: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
706: 'Processed records: ' || xRowCount);

Line 1250: FROM icx_por_category_data_sources

1246:
1247: xErrLoc:= 140;
1248: SELECT 2
1249: INTO xResult
1250: FROM icx_por_category_data_sources
1251: WHERE category_key = p_category_key
1252: AND external_source_key = p_category_key
1253: AND ROWNUM = 1;
1254: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 1256: p_category_name || '] exists in ICX_POR_CATEGORY_DATA_SOURCES');

1252: AND external_source_key = p_category_key
1253: AND ROWNUM = 1;
1254: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1255: 'Category[Key: ' || p_category_key || ', Name: ' ||
1256: p_category_name || '] exists in ICX_POR_CATEGORY_DATA_SOURCES');
1257:
1258: xErrLoc:= 180;
1259: IF p_category_type = ICX_POR_EXT_CLASS.CATEGORY_TYPE THEN
1260: SELECT 3