[Home] [Help]
5: G_P_TAX_CODE_CONTROL_LEVEL NUMBER;
6: --Building record from master org.
7: PROCEDURE build_item_record(p_item_rec IN OUT NOCOPY INV_ITEM_API.Item_rec_type
8: ,p_master_org_id IN NUMBER
9: ,x_master_status OUT NOCOPY MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE);
10:
11: --Procedure to org specific validations.
12: --Bug: 5438006 Added parameter base_item_id
13: PROCEDURE item_org_validations (p_org_code IN VARCHAR2
281: --Bug: 5438006 Adding validation for base item
282: IF(p_base_item_id IS NOT NULL) THEN
283: BEGIN
284: SELECT 1 INTO l_exists
285: FROM MTL_SYSTEM_ITEMS_B
286: WHERE inventory_item_id = p_base_item_id
287: AND organization_id = p_organization_id;
288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN
329: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
330: l_item_org_valid VARCHAR2(1);
331: l_org_valid_count NUMBER;
332: l_item_id NUMBER;
333: l_master_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;
334:
335: /*
336: Bug 4964874
337: In Multi Create Copy flow
593: END process_org_assignments;
594:
595: PROCEDURE build_item_record(p_item_rec IN OUT NOCOPY INV_ITEM_API.Item_rec_type
596: ,p_master_org_id IN NUMBER
597: ,x_master_status OUT NOCOPY MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE) IS
598: BEGIN
599: SELECT
600: b.inventory_item_id
601: ,t.description
1315: ,p_item_rec.charge_periodicity_code
1316: ,p_item_rec.outsourced_assembly
1317: ,p_item_rec.subcontracting_component
1318: ,x_master_status
1319: FROM mtl_system_items_b b, mtl_system_items_tl t
1320: WHERE b.inventory_item_id = t.inventory_item_id
1321: AND b.organization_id = t.organization_id
1322: AND b.inventory_item_id = p_item_rec.inventory_item_id
1323: AND b.organization_id = p_master_org_id