[API] oe_line_status_pub

Example : 

DECLARE

  vLineId oe_order_lines_all.line_id%TYPE := 00;

  xResult VARCHAR2(1);

BEGIN

  oe_line_status_pub.Get_ship_Status(p_line_id => vLineId,

                                     x_result => xResult);

  dbms_output.put_line('Shiped ? => ' || xResult);

  oe_line_status_pub.Get_Cancelled_status(p_line_id => vLineId,

                                          x_result => xResult);

  dbms_output.put_line('Cancelled ? => ' || xResult);

  oe_line_status_pub.Get_Closed_Status(p_line_id => vLineId,

                                       x_result => xResult);

  dbms_output.put_line('Closed ? => ' || xResult);

  oe_line_status_pub.Get_Invoiced_Status(p_line_id => vLineId,

                                         x_result => xResult);

  dbms_output.put_line('Invoiced ? => ' || xResult);

  oe_line_status_pub.Get_pick_Status(p_line_id => vLineId,

                                     x_result => xResult);

  dbms_output.put_line('in Pick  ? => ' || xResult);

END;