837:
838: BEGIN
839: SELECT order_number
840: INTO l_order_number 841: FROM MSC_SUPPLIES 842: WHERE plan_id = p_plan_id
843: AND transaction_id = p_supply_id;
844: EXCEPTION
845: WHEN NO_DATA_FOUND THEN
Line 866: FROM MSC_SUPPLIES
862:
863: BEGIN
864: SELECT order_type
865: INTO l_order_type 866: FROM MSC_SUPPLIES 867: WHERE plan_id = p_plan_id
868: AND transaction_id = p_supply_id;
869: EXCEPTION
870: WHEN NO_DATA_FOUND THEN