DBA Data[Home] [Help]

APPS.ICX_CAT_UTIL_PVT dependencies on MTL_ITEM_BULKLOAD_RECS

Line 230: FROM mtl_item_bulkload_recs

226: IS
227: CURSOR mtlItemBulkloadRecsCsr (p_request_id NUMBER) IS
228: SELECT inventory_item_id, organization_id, revision_id,
229: category_id, category_set_id
230: FROM mtl_item_bulkload_recs
231: WHERE request_id = p_request_id;
232:
233: l_api_name CONSTANT VARCHAR2(30) := 'logMtlItemBulkloadRecsData';
234: l_err_loc PLS_INTEGER;

Line 275: ', MTL_ITEM_BULKLOAD_RECS rowcount:' || l_inventory_item_id_tbl.COUNT);

271: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
273: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
274: 'For p_request_id:' || p_request_id ||
275: ', MTL_ITEM_BULKLOAD_RECS rowcount:' || l_inventory_item_id_tbl.COUNT);
276: END IF;
277:
278: l_err_loc := 600;
279: FOR i IN 1..l_inventory_item_id_tbl.COUNT LOOP

Line 283: 'MTL_ITEM_BULKLOAD_RECS Row # ' || i ||

279: FOR i IN 1..l_inventory_item_id_tbl.COUNT LOOP
280: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
282: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
283: 'MTL_ITEM_BULKLOAD_RECS Row # ' || i ||
284: '; l_inventory_item_id_tbl: ' || l_inventory_item_id_tbl(i) ||
285: ', l_organization_id_tbl: ' || l_organization_id_tbl(i) ||
286: ', l_revision_id_tbl: ' || l_revision_id_tbl(i) ||
287: ', l_category_id_tbl: ' || l_category_id_tbl(i) ||