APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_ITEM_LOCATIONS

Line 920: g_entity_names := Get_Err_Mtl_Item_Locations;

916: /*-----------------------------------
917: ---- Locators -------
918: -----------------------------------*/
919: Init_Vars('LOCATORS');
920: g_entity_names := Get_Err_Mtl_Item_Locations;
921: Put_Report_Data;
922:
923: /*-----------------------------------
924: ---- Hierarchy Relations -------

Line 2594: -- FUNCTION NAME : Get_Err_Mtl_Item_Locations

2590: RAISE;
2591:
2592: END Get_Err_Mtl_Items_Subinv;
2593: --=============================================================================
2594: -- FUNCTION NAME : Get_Err_Mtl_Item_Locations
2595: -- PRE-CONDITIONS: None.
2596: -- DESCRIPTION : Validate Item Locations created for new org against
2597: -- those in model org.
2598: -- PARAMETERS : None.

Line 2602: FUNCTION Get_Err_Mtl_Item_Locations RETURN Char_Array

2598: -- PARAMETERS : None.
2599: -- EXCEPTIONS : None.
2600: --
2601: --=============================================================================
2602: FUNCTION Get_Err_Mtl_Item_Locations RETURN Char_Array
2603: IS
2604: l_api_name VARCHAR2(100):= ' Get_Err_Mtl_Item_Locations ';
2605: l_entity_arr_idx NUMBER := 1;
2606: l_entity_names Char_Array := Char_Array();

Line 2604: l_api_name VARCHAR2(100):= ' Get_Err_Mtl_Item_Locations ';

2600: --
2601: --=============================================================================
2602: FUNCTION Get_Err_Mtl_Item_Locations RETURN Char_Array
2603: IS
2604: l_api_name VARCHAR2(100):= ' Get_Err_Mtl_Item_Locations ';
2605: l_entity_arr_idx NUMBER := 1;
2606: l_entity_names Char_Array := Char_Array();
2607: --l_entity_type VARCHAR2(100):= ' Item Locations ';
2608: l_item_name VARCHAR2(100);

Line 2617: FROM MTL_ITEM_LOCATIONS loc1

2613: , p_organization_id NUMBER
2614: )
2615: IS
2616: SELECT kfv1.CONCATENATED_SEGMENTS
2617: FROM MTL_ITEM_LOCATIONS loc1
2618: , MTL_ITEM_LOCATIONS_KFV kfv1
2619: WHERE kfv1.ORGANIZATION_ID=loc1.ORGANIZATION_ID
2620: AND kfv1.INVENTORY_LOCATION_ID=loc1.INVENTORY_LOCATION_ID
2621: AND loc1.ORGANIZATION_ID=p_model_org_id

Line 2618: , MTL_ITEM_LOCATIONS_KFV kfv1

2614: )
2615: IS
2616: SELECT kfv1.CONCATENATED_SEGMENTS
2617: FROM MTL_ITEM_LOCATIONS loc1
2618: , MTL_ITEM_LOCATIONS_KFV kfv1
2619: WHERE kfv1.ORGANIZATION_ID=loc1.ORGANIZATION_ID
2620: AND kfv1.INVENTORY_LOCATION_ID=loc1.INVENTORY_LOCATION_ID
2621: AND loc1.ORGANIZATION_ID=p_model_org_id
2622: AND NOT EXISTS

Line 2624: FROM MTL_ITEM_LOCATIONS loc2

2620: AND kfv1.INVENTORY_LOCATION_ID=loc1.INVENTORY_LOCATION_ID
2621: AND loc1.ORGANIZATION_ID=p_model_org_id
2622: AND NOT EXISTS
2623: ( SELECT 'x'
2624: FROM MTL_ITEM_LOCATIONS loc2
2625: , MTL_ITEM_LOCATIONS_KFV kfv2
2626: WHERE loc2.ORGANIZATION_ID=p_organization_id
2627: AND kfv2.INVENTORY_LOCATION_ID=loc2.INVENTORY_LOCATION_ID
2628: AND kfv2.ORGANIZATION_ID=loc2.ORGANIZATION_ID

Line 2625: , MTL_ITEM_LOCATIONS_KFV kfv2

2621: AND loc1.ORGANIZATION_ID=p_model_org_id
2622: AND NOT EXISTS
2623: ( SELECT 'x'
2624: FROM MTL_ITEM_LOCATIONS loc2
2625: , MTL_ITEM_LOCATIONS_KFV kfv2
2626: WHERE loc2.ORGANIZATION_ID=p_organization_id
2627: AND kfv2.INVENTORY_LOCATION_ID=loc2.INVENTORY_LOCATION_ID
2628: AND kfv2.ORGANIZATION_ID=loc2.ORGANIZATION_ID
2629: AND kfv2.CONCATENATED_SEGMENTS=kfv1.CONCATENATED_SEGMENTS

Line 2635: FROM MTL_ITEM_LOCATIONS loc

2631:
2632: CURSOR l_cnt_csr ( p_org_id NUMBER )
2633: IS
2634: SELECT COUNT(loc.INVENTORY_LOCATION_ID)
2635: FROM MTL_ITEM_LOCATIONS loc
2636: WHERE loc.ORGANIZATION_ID=p_org_id;
2637:
2638: BEGIN
2639:

Line 2686: END Get_Err_Mtl_Item_Locations;

2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2683: FND_MSG_PUB.Add;
2684: RAISE;
2685:
2686: END Get_Err_Mtl_Item_Locations;
2687: --=============================================================================
2688: -- FUNCTION NAME : Get_Unique_List
2689: -- PRE-CONDITIONS: None.
2690: -- DESCRIPTION : Remove duplicate entries from an array.