APPS.INV_OPM_ITEM_MIGRATION dependencies on INV_ITEM_API

Line 239: l_item_rec INV_ITEM_API.Item_rec_type;

235: , p_commit IN VARCHAR2
236: , x_inventory_item_id OUT NOCOPY NUMBER
237: , x_failure_count OUT NOCOPY NUMBER
238: ) IS
239: l_item_rec INV_ITEM_API.Item_rec_type;
240: --BEGIN Bug 14364505
241: l_item_tl_rec INV_ITEM_API.Item_TL_rec_type;
242: --END Bug 14364505
243: o_item_rec INV_ITEM_API.Item_rec_type;

Line 241: l_item_tl_rec INV_ITEM_API.Item_TL_rec_type;

237: , x_failure_count OUT NOCOPY NUMBER
238: ) IS
239: l_item_rec INV_ITEM_API.Item_rec_type;
240: --BEGIN Bug 14364505
241: l_item_tl_rec INV_ITEM_API.Item_TL_rec_type;
242: --END Bug 14364505
243: o_item_rec INV_ITEM_API.Item_rec_type;
244: l_opm_item IC_ITEM_MST_B%ROWTYPE;
245: l_inventory_item_id NUMBER;

Line 243: o_item_rec INV_ITEM_API.Item_rec_type;

239: l_item_rec INV_ITEM_API.Item_rec_type;
240: --BEGIN Bug 14364505
241: l_item_tl_rec INV_ITEM_API.Item_TL_rec_type;
242: --END Bug 14364505
243: o_item_rec INV_ITEM_API.Item_rec_type;
244: l_opm_item IC_ITEM_MST_B%ROWTYPE;
245: l_inventory_item_id NUMBER;
246: l_organization_code VARCHAR2(3);
247: l_action VARCHAR2(1);

Line 407: OPEN INV_ITEM_API.Item_TL_csr

403: END IF;
404:
405: IF l_get_item_description = 'Y' then
406:
407: OPEN INV_ITEM_API.Item_TL_csr
408: (
409: p_Item_ID => l_inventory_item_id
410: , p_Org_ID => l_org_id
411: , p_fetch_Master => FND_API.g_TRUE

Line 414: FETCH INV_ITEM_API.Item_TL_csr INTO l_item_tl_rec;

410: , p_Org_ID => l_org_id
411: , p_fetch_Master => FND_API.g_TRUE
412: , p_fetch_Orgs => FND_API.g_FALSE
413: );
414: FETCH INV_ITEM_API.Item_TL_csr INTO l_item_tl_rec;
415: CLOSE INV_ITEM_API.Item_TL_csr;
416:
417:
418: END IF;

Line 415: CLOSE INV_ITEM_API.Item_TL_csr;

411: , p_fetch_Master => FND_API.g_TRUE
412: , p_fetch_Orgs => FND_API.g_FALSE
413: );
414: FETCH INV_ITEM_API.Item_TL_csr INTO l_item_tl_rec;
415: CLOSE INV_ITEM_API.Item_TL_csr;
416:
417:
418: END IF;
419: