APPS.INV_CG_UPGRADE dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 2306: from mtl_physical_adjustments

2302: select
2303: rowid
2304: , subinventory_name
2305: , locator_id
2306: from mtl_physical_adjustments
2307: where organization_id = l_organization_id
2308: and cost_group_id is null;
2309:
2310: --/*

Line 2345: l_table_name := 'mtl_physical_adjustments';

2341: -- loop
2342: -- l_organization_id := c2.organization_id;
2343: -- */
2344:
2345: l_table_name := 'mtl_physical_adjustments';
2346:
2347: /* Bug 4235102 fix */
2348: /* If there is atleast one record with a costgroup upgrade not needed */
2349: BEGIN

Line 2353: mtl_physical_adjustments

2349: BEGIN
2350: SELECT cost_group_id
2351: INTO l_check_cost_group_id
2352: FROM
2353: mtl_physical_adjustments
2354: WHERE
2355: organization_id = l_organization_id
2356: AND ROWNUM=1;
2357: EXCEPTION

Line 2434: update mtl_physical_adjustments

2430: , p_organization_id => l_organization_id
2431: , p_subinventory => l_subinventory_code);
2432: end if;
2433:
2434: update mtl_physical_adjustments
2435: set
2436: cost_group_id = l_cost_group_id
2437: where rowid = l_rowid;
2438:

Line 2462: update mtl_physical_adjustments

2458: , p_subinventory => l_subinventory_code);
2459: END IF;
2460:
2461: if (l_cost_group_id > 0) then
2462: update mtl_physical_adjustments
2463: set cost_group_id = l_cost_group_id
2464: where rowid = l_rowid;
2465:
2466: end if;

Line 2494: l_return_err := 'mtl_physical_adjustments cost group upgrade:'|| l_msg_data;

2490:
2491: l_msg_data := replace(l_msg_data,chr(0),' ');
2492:
2493:
2494: l_return_err := 'mtl_physical_adjustments cost group upgrade:'|| l_msg_data;
2495:
2496: INS_ERROR( p_table_name => l_table_name,
2497: p_ROWID => l_rowid_info,
2498: p_org_id => l_organization_id,

Line 2518: l_return_err := 'mtl_physical_adjustments cost group upgrade:'|| l_msg_data;

2514: );
2515:
2516: l_msg_data := replace(l_msg_data,chr(0),' ');
2517:
2518: l_return_err := 'mtl_physical_adjustments cost group upgrade:'|| l_msg_data;
2519:
2520:
2521: INS_ERROR( p_table_name => l_table_name,
2522: p_ROWID => l_rowid_info,

Line 2548: l_return_err := 'mtl_physical_adjustments cost group upgrade:'||

2544: p_ROWID => l_rowid_info,
2545: p_org_id => l_organization_id,
2546: p_error_msg => l_msg_data,
2547: p_proc_name => l_procedure_name);
2548: l_return_err := 'mtl_physical_adjustments cost group upgrade:'||
2549: substr(sqlerrm,1,55);
2550: raise_application_error(-20000,l_return_err);
2551:
2552: end INVMPASB;