[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
293: --Bug: 5438006 Adding validation for base item
294: IF(p_base_item_id IS NOT NULL) THEN
295: BEGIN
296: SELECT 1 INTO l_exists
297: FROM MTL_SYSTEM_ITEMS_B
298: WHERE inventory_item_id = p_base_item_id
299: AND organization_id = p_organization_id;
300: EXCEPTION
301: WHEN NO_DATA_FOUND THEN
341: l_ret_sts_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
342: l_item_org_valid VARCHAR2(1);
343: l_org_valid_count NUMBER;
344: l_item_id NUMBER;
345: l_master_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;
346:
347: /*
348: Bug 4964874
349: In Multi Create Copy flow
614: END process_org_assignments;
615:
616: PROCEDURE build_item_record(p_item_rec IN OUT NOCOPY INV_ITEM_API.Item_rec_type
617: ,p_master_org_id IN NUMBER
618: ,x_master_status OUT NOCOPY MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE) IS
619: BEGIN
620: SELECT
621: b.inventory_item_id
622: ,t.description
1336: ,p_item_rec.charge_periodicity_code
1337: ,p_item_rec.outsourced_assembly
1338: ,p_item_rec.subcontracting_component
1339: ,x_master_status
1340: FROM mtl_system_items_b b, mtl_system_items_tl t
1341: WHERE b.inventory_item_id = t.inventory_item_id
1342: AND b.organization_id = t.organization_id
1343: AND b.inventory_item_id = p_item_rec.inventory_item_id
1344: AND b.organization_id = p_master_org_id