APPS.INV_CG_UPGRADE dependencies on MTL_SECONDARY_INVENTORIES

Line 35: from mtl_secondary_inventories

31: , outside_processing_account
32: , expense_account
33: , encumbrance_account
34:
35: from mtl_secondary_inventories
36: where (
37: default_cost_group_id is null AND
38: organization_id = l_organization_id
39: );

Line 70: l_table_name := 'MTL_SECONDARY_INVENTORIES';

66:
67: l_primary_cost_method NUMBER;
68: l_check_cost_group_id NUMBER := NULL;/* Bug 4235102 fix */
69: begin
70: l_table_name := 'MTL_SECONDARY_INVENTORIES';
71:
72: /* Bug 4235102 fix */
73: /* If there is atleast one record with a costgroup upgrade not needed */
74: BEGIN

Line 78: mtl_secondary_inventories

74: BEGIN
75: SELECT default_cost_group_id
76: INTO l_check_cost_group_id
77: FROM
78: mtl_secondary_inventories
79: WHERE
80: organization_id = l_organization_id
81: AND ROWNUM=1;
82: EXCEPTION

Line 228: update mtl_secondary_inventories

224: /*
225: ** Stamp default cost group on subinventory record
226: */
227:
228: update mtl_secondary_inventories
229: set default_cost_group_id = l_cost_group_id
230: where organization_id = l_organization_id
231: and secondary_inventory_name = l_secondary_inventory_name;
232:

Line 253: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'|| l_msg_data;

249: );
250:
251: l_msg_data := replace(l_msg_data,chr(0),' ');
252:
253: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'|| l_msg_data;
254: INS_ERROR( p_table_name => l_table_name,
255: p_ROWID => l_rowid_info,
256: p_org_id => l_organization_id,
257: p_error_msg => l_msg_data,

Line 276: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'|| l_msg_data;

272: );
273:
274: l_msg_data := replace(l_msg_data,chr(0),' ');
275:
276: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'|| l_msg_data;
277: INS_ERROR( p_table_name => l_table_name,
278: p_ROWID => l_rowid_info,
279: p_org_id => l_organization_id,
280: p_error_msg => l_msg_data,

Line 288: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'||

284: when others then
285: rollback;
286: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
287: x_return_status := fnd_api.g_ret_sts_error ;
288: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'||
289: substrb(sqlerrm,1,55);
290: INS_ERROR(p_table_name => l_table_name,
291: p_ROWID => l_rowid_info,
292: p_org_id => l_organization_id,