APPS.ICX_POR_EXT_TEST dependencies on ICX_POR_CATEGORY_ORDER_MAP

Line 712: 'Delete test data from icx_por_category_order_map');

708: CLOSE cTestRows;
709:
710: xErrLoc:= 300;
711: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
712: 'Delete test data from icx_por_category_order_map');
713: xErrLoc:= 320;
714: xRowCount := 0;
715: OPEN cTestRows FOR
716: SELECT ROWID FROM icx_por_category_order_map

Line 716: SELECT ROWID FROM icx_por_category_order_map

712: 'Delete test data from icx_por_category_order_map');
713: xErrLoc:= 320;
714: xRowCount := 0;
715: OPEN cTestRows FOR
716: SELECT ROWID FROM icx_por_category_order_map
717: WHERE last_updated_by = TEST_USER_ID;
718: xErrLoc := 340;
719: LOOP
720: xRowIds.DELETE;

Line 729: DELETE icx_por_category_order_map

725: EXIT WHEN xRowIds.COUNT = 0;
726: xRowCount := xRowCount + xRowIds.COUNT;
727: xErrLoc := 380;
728: FORALL i IN 1..xRowIds.COUNT
729: DELETE icx_por_category_order_map
730: WHERE rowid = xRowIds(i);
731: COMMIT;
732: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
733: 'Processed records: ' || xRowCount);

Line 1262: FROM icx_por_category_order_map

1258: xErrLoc:= 180;
1259: IF p_category_type = ICX_POR_EXT_CLASS.CATEGORY_TYPE THEN
1260: SELECT 3
1261: INTO xResult
1262: FROM icx_por_category_order_map
1263: WHERE external_source_key = p_category_key
1264: AND ROWNUM = 1;
1265: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1266: 'Category[Key: ' || p_category_key || ', Name: ' ||

Line 1267: p_category_name || '] exists in ICX_POR_CATEGORY_ORDER_MAP');

1263: WHERE external_source_key = p_category_key
1264: AND ROWNUM = 1;
1265: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
1266: 'Category[Key: ' || p_category_key || ', Name: ' ||
1267: p_category_name || '] exists in ICX_POR_CATEGORY_ORDER_MAP');
1268: END IF;
1269:
1270: xErrLoc:= 200;
1271: RETURN TRUE;