DBA Data[Home] [Help]

APPS.ICX_POR_EXT_PURGE dependencies on ICX_POR_DELETE_CATALOG

Line 155: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);

151: -- For Template Header, only delete that category_item association
152: IF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.CATEGORY_TYPE) THEN
153:
154: xErrLoc := 440;
155: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
156: xErrLoc := 445;
157: ICX_POR_DELETE_CATALOG.deleteCommonTables(xRtItemIds,
158: ICX_POR_DELETE_CATALOG.CATITEM_TABLE_LAST);
159:

Line 157: ICX_POR_DELETE_CATALOG.deleteCommonTables(xRtItemIds,

153:
154: xErrLoc := 440;
155: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
156: xErrLoc := 445;
157: ICX_POR_DELETE_CATALOG.deleteCommonTables(xRtItemIds,
158: ICX_POR_DELETE_CATALOG.CATITEM_TABLE_LAST);
159:
160: ELSIF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE) THEN
161:

Line 158: ICX_POR_DELETE_CATALOG.CATITEM_TABLE_LAST);

154: xErrLoc := 440;
155: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
156: xErrLoc := 445;
157: ICX_POR_DELETE_CATALOG.deleteCommonTables(xRtItemIds,
158: ICX_POR_DELETE_CATALOG.CATITEM_TABLE_LAST);
159:
160: ELSIF (gCategoryTypes(i) = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE) THEN
161:
162: xErrLoc := 450;

Line 229: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);

225: END LOOP;
226: end if;
227:
228: xErrLoc := 200;
229: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
230:
231: xErrLoc := 300;
232: ICX_POR_DELETE_CATALOG.deleteCommonTables(gRtItemIds,
233: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);

Line 232: ICX_POR_DELETE_CATALOG.deleteCommonTables(gRtItemIds,

228: xErrLoc := 200;
229: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
230:
231: xErrLoc := 300;
232: ICX_POR_DELETE_CATALOG.deleteCommonTables(gRtItemIds,
233: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);
234:
235: xErrLoc := 500;
236: clearTables('ITEM');

Line 233: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);

229: ICX_POR_DELETE_CATALOG.setCommitSize(ICX_POR_EXT_UTL.gCommitSize);
230:
231: xErrLoc := 300;
232: ICX_POR_DELETE_CATALOG.deleteCommonTables(gRtItemIds,
233: ICX_POR_DELETE_CATALOG.ITEM_TABLE_LAST);
234:
235: xErrLoc := 500;
236: clearTables('ITEM');
237: exception