APPS.CONVERT_TEST dependencies on MTL_SECONDARY_INVENTORIES

Line 30: from mtl_secondary_inventories

26: , outside_processing_account
27: , expense_account
28: , encumbrance_account
29:
30: from mtl_secondary_inventories
31: where (
32: default_cost_group_id is null AND
33: organization_id = l_organization_id
34: );

Line 62: l_table_name := 'MTL_SECONDARY_INVENTORIES';

58: l_table_name VARCHAR2(300);
59: l_procedure_name VARCHAR2(200):= 'upgrade subinventory data INVMSISB';
60:
61: begin
62: l_table_name := 'MTL_SECONDARY_INVENTORIES';
63: for c1 in subinventory_cursor
64:
65: loop
66:

Line 172: update mtl_secondary_inventories

168:
169: /*
170: ** Stamp default cost group on subinventory record
171: */
172: update mtl_secondary_inventories
173: set default_cost_group_id = l_cost_group_id
174: where organization_id = l_organization_id
175: and secondary_inventory_name = l_secondary_inventory_name;
176:

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

193: );
194:
195: l_msg_data := replace(l_msg_data,chr(0),' ');
196:
197: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'|| l_msg_data;
198: INS_ERROR( p_table_name => l_table_name,
199: p_ROWID => l_rowid_info,
200: p_org_id => l_organization_id,
201: p_error_msg => l_msg_data,

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

216: );
217:
218: l_msg_data := replace(l_msg_data,chr(0),' ');
219:
220: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'|| l_msg_data;
221: INS_ERROR( p_table_name => l_table_name,
222: p_ROWID => l_rowid_info,
223: p_org_id => l_organization_id,
224: p_error_msg => l_msg_data,

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

228: when others then
229: rollback;
230: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
231: x_return_status := fnd_api.g_ret_sts_error ;
232: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'||
233: substrb(sqlerrm,1,55);
234: INS_ERROR(p_table_name => l_table_name,
235: p_ROWID => l_rowid_info,
236: p_org_id => l_organization_id,