[RCV Transactions] 取得交易數量

DECLARE

  vTopTransactionId NUMBER:=00; 

  vOrgId            NUMBER:=00;

  vCutoffDate       DATE := SYSDATE;

  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', vOrgId);

  rcv_accrual_sv.get_quantities(top_transaction_id => vTopTransactionId,

                                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;