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;
沒有留言:
張貼留言