200: RETURN VARCHAR2 IS
201:
202: CURSOR asset_inventory_cur IS
203: SELECT asset_inventory
204: FROM mtl_secondary_inventories
205: WHERE secondary_inventory_name = NVL(p_destination_subinventory,'X')
206: AND organization_id = p_destination_organization_id;
207:
208: l_asset_inventory NUMBER;
311: BEGIN
312: d_progress := 50;
313: SELECT expense_account
314: INTO l_charge_account
315: FROM mtl_secondary_inventories
316: WHERE secondary_inventory_name = p_destination_subinventory
317: AND organization_id = p_destination_organization_id;
318: EXCEPTION
319: WHEN OTHERS THEN
406: BEGIN
407: d_progress := 160;
408: SELECT expense_account
409: INTO l_charge_account
410: FROM mtl_secondary_inventories
411: WHERE secondary_inventory_name = p_destination_subinventory
412: AND organization_id = p_destination_organization_id;
413: EXCEPTION
414: WHEN OTHERS THEN
445: BEGIN
446: d_progress := 200;
447: SELECT material_account
448: INTO l_charge_account
449: FROM mtl_secondary_inventories
450: WHERE secondary_inventory_name = p_destination_subinventory
451: AND organization_id = p_destination_organization_id;
452: EXCEPTION
453: WHEN OTHERS THEN