[API] get header record

DECLARE

  vHeaderId  oe_order_headers_all.header_id%TYPE := 1595;

  xHeaderRec oe_order_pub.Header_Rec_Type;

BEGIN

  xHeaderRec := oe_header_util.Query_Row(p_header_id => vHeaderId);

  dbms_output.put_line(xHeaderRec.booked_flag);

  dbms_output.put_line(xHeaderRec.order_number);

  dbms_output.put_line(oe_id_to_value.Salesrep(p_salesrep_id => xHeaderRec.salesrep_id));

  dbms_output.put_line(oe_id_to_value.Flow_Status(p_flow_status_code => xHeaderRec.flow_status_code));

END;