1 PACKAGE POS_PO_RCV_QTY AUTHID CURRENT_USER as
2 /* $Header: POSRCQTS.pls 115.3 2003/01/15 02:44:22 mji ship $ */
3
4 FUNCTION get_net_qty (x_parent_trx_id IN NUMBER,
5 x_primary_qty IN NUMBER
6 ) RETURN NUMBER;
7 FUNCTION get_receive_rcv( x_shipment_line_id in number) return number;
8 pragma restrict_references (get_net_qty,WNDS,RNPS,WNPS);
9
10
11 /* Bug 1086123
12 * We used to call the function get_net_quantity to get
13 * quantity received. But this was incorrectly handled. So created
14 * new function get_net_qty_rcv and called this from the view
15 * POS_RCV_TRANSACTIONS_V.
16 */
17 FUNCTION get_net_qty_rcv (x_shipment_line_id IN NUMBER,
18 x_primary_qty IN NUMBER
19 ) RETURN NUMBER;
20
21 pragma restrict_references (get_net_qty_rcv,WNDS,RNPS,WNPS);
22
23
24 FUNCTION get_net_received_qty (p_txn_id IN NUMBER)
25 return number;
26
27 END pos_po_rcv_qty;
28
[Home] [Help]