640: END IF;
641:
642: select order_number, last_update_date
643: into g_sales_order_number, g_order_cancellation_date
644: from oe_order_headers_all
645: where header_id = p_header_id;
646:
647: g_reason := OE_GLOBALS.G_REASON_CODE;
648: -- 'OE_GLOBALS.G_REASON_COMMENTS'
686: END IF;
687:
688: select order_number
689: into g_sales_order_number
690: from oe_order_headers_all
691: where header_id = p_header_id;
692:
693: select line_number||'.'||shipment_number
694: , nvl(cancelled_quantity,0)
757: END IF;
758:
759: select order_number
760: into g_sales_order_number
761: from oe_order_headers_all
762: where header_id = p_header_id;
763:
764: select line_number||'.'||shipment_number
765: -- , ordered_quantity