APPS.INV_CG_UPGRADE dependencies on MTL_PHYSICAL_INVENTORY_TAGS

Line 2593: from mtl_physical_inventory_tags

2589: select
2590: rowid
2591: , subinventory
2592: , locator_id
2593: from mtl_physical_inventory_tags
2594: where organization_id = l_organization_id
2595: and cost_group_id is null;
2596:
2597: --/*

Line 2632: l_table_name := 'mtl_physical_inventory_tags';

2628: -- loop
2629: -- l_organization_id := c2.organization_id;
2630: -- */
2631:
2632: l_table_name := 'mtl_physical_inventory_tags';
2633:
2634: /* Bug 4235102 fix */
2635: /* If there is atleast one record with a costgroup upgrade not needed */
2636: BEGIN

Line 2640: mtl_physical_inventory_tags

2636: BEGIN
2637: SELECT cost_group_id
2638: INTO l_check_cost_group_id
2639: FROM
2640: mtl_physical_inventory_tags
2641: WHERE
2642: organization_id = l_organization_id
2643: AND ROWNUM=1;
2644: EXCEPTION

Line 2721: update mtl_physical_inventory_tags

2717: , p_organization_id => l_organization_id
2718: , p_subinventory => l_subinventory_code);
2719: end if;
2720:
2721: update mtl_physical_inventory_tags
2722: set
2723: cost_group_id = l_cost_group_id
2724: where rowid = l_rowid;
2725:

Line 2749: update mtl_physical_inventory_tags

2745: , p_subinventory => l_subinventory_code);
2746: END IF;
2747:
2748: if (l_cost_group_id > 0) then
2749: update mtl_physical_inventory_tags
2750: set cost_group_id = l_cost_group_id
2751: where rowid = l_rowid;
2752:
2753: end if;

Line 2781: l_return_err := 'mtl_physical_inventory_tags cost group upgrade:'|| l_msg_data;

2777:
2778: l_msg_data := replace(l_msg_data,chr(0),' ');
2779:
2780:
2781: l_return_err := 'mtl_physical_inventory_tags cost group upgrade:'|| l_msg_data;
2782:
2783: INS_ERROR( p_table_name => l_table_name,
2784: p_ROWID => l_rowid_info,
2785: p_org_id => l_organization_id,

Line 2805: l_return_err := 'mtl_physical_inventory_tags cost group upgrade:'|| l_msg_data;

2801: );
2802:
2803: l_msg_data := replace(l_msg_data,chr(0),' ');
2804:
2805: l_return_err := 'mtl_physical_inventory_tags cost group upgrade:'|| l_msg_data;
2806:
2807:
2808: INS_ERROR( p_table_name => l_table_name,
2809: p_ROWID => l_rowid_info,

Line 2835: l_return_err := 'mtl_physical_inventory_tags cost group upgrade:'||

2831: p_ROWID => l_rowid_info,
2832: p_org_id => l_organization_id,
2833: p_error_msg => l_msg_data,
2834: p_proc_name => l_procedure_name);
2835: l_return_err := 'mtl_physical_inventory_tags cost group upgrade:'||
2836: substr(sqlerrm,1,55);
2837: raise_application_error(-20000,l_return_err);
2838:
2839: end INVMPITSB;