7127: END LOOP;
7128: END IF;
7129:
7130: xErrLoc := 240;
7131: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
7132:
7133: xErrLoc := 300;
7134: ICX_POR_DELETE_CATALOG.deleteCommonTables(gDIRtItemIds,
7135: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);
7130: xErrLoc := 240;
7131: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
7132:
7133: xErrLoc := 300;
7134: ICX_POR_DELETE_CATALOG.deleteCommonTables(gDIRtItemIds,
7135: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);
7136:
7137: xErrLoc := 340;
7138: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
7131: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
7132:
7133: xErrLoc := 300;
7134: ICX_POR_DELETE_CATALOG.deleteCommonTables(gDIRtItemIds,
7135: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);
7136:
7137: xErrLoc := 340;
7138: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
7139: 'Processed records: ' || xRowCount);