2020/08/10

rcv_accrual_sv.get_quantities

DECLARE

  ordered_po_qty    NUMBER;

  received_po_qty   NUMBER;

  corrected_po_qty  NUMBER;

  delivered_po_qty  NUMBER;

  rtv_po_qty        NUMBER;

  billed_po_qty     NUMBER;

  accepted_po_qty   NUMBER;

  rejected_po_qty   NUMBER;

  ordered_txn_qty   NUMBER;

  received_txn_qty  NUMBER;

  corrected_txn_qty NUMBER;

  delivered_txn_qty NUMBER;

  rtv_txn_qty       NUMBER;

  billed_txn_qty    NUMBER;

  accepted_txn_qty  NUMBER;

  rejected_txn_qty  NUMBER;

BEGIN

  mo_global.set_policy_context('S',00);

  rcv_accrual_sv.get_quantities(top_transaction_id    => 001,

                                ordered_po_qty        => ordered_po_qty,

                                received_po_qty       => received_po_qty,

                                corrected_po_qty      => corrected_po_qty,

                                delivered_po_qty      => delivered_po_qty,

                                rtv_po_qty            => rtv_po_qty,

                                billed_po_qty         => billed_po_qty,

                                accepted_po_qty       => accepted_po_qty,

                                rejected_po_qty       => rejected_po_qty,

                                ordered_txn_qty       => ordered_txn_qty,

                                received_txn_qty      => received_txn_qty,

                                corrected_txn_qty     => corrected_txn_qty,

                                delivered_txn_qty     => delivered_txn_qty,

                                rtv_txn_qty           => rtv_txn_qty,

                                billed_txn_qty        => billed_txn_qty,

                                accepted_txn_qty      => accepted_txn_qty,

                                rejected_txn_qty      => rejected_txn_qty,

                                p_accrual_cutoff_date => SYSDATE);

  dbms_output.put_line('ordered_po_qty:=>' || ordered_po_qty);

  dbms_output.put_line('received_po_qty:=>' || received_po_qty);

  dbms_output.put_line('corrected_po_qty:=>' || corrected_po_qty);

  dbms_output.put_line('delivered_po_qty:=>' || delivered_po_qty);

  dbms_output.put_line('rtv_po_qty:=>' || rtv_po_qty);

  dbms_output.put_line('billed_po_qty:=>' || billed_po_qty);

  dbms_output.put_line('accepted_po_qty:=>' || accepted_po_qty);

  dbms_output.put_line('rejected_po_qty:=>' || rejected_po_qty);

  dbms_output.put_line('ordered_txn_qty:=>' || ordered_txn_qty);

  dbms_output.put_line('received_txn_qty:=>' || received_txn_qty);

  dbms_output.put_line('corrected_txn_qty:=>' || corrected_txn_qty);

  dbms_output.put_line('delivered_txn_qty:=>' || delivered_txn_qty);

  dbms_output.put_line('rtv_txn_qty:=>' || rtv_txn_qty);

  dbms_output.put_line('billed_txn_qty:=>' || billed_txn_qty);

  dbms_output.put_line('accepted_txn_qty:=>' || accepted_txn_qty);

  dbms_output.put_line('rejected_txn_qty:=>' || rejected_txn_qty);


END;


沒有留言: