1 PACKAGE POS_PO_RCV_QTY AUTHID CURRENT_USER as
2 /* $Header: POSRCQTS.pls 120.3 2010/06/16 11:18:17 ramkandu 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 /* Bug 9648379
18 modified the function to pass the transaction id of the received shipment transaction
19 which can be used to get correct net received quantity for a particular distribution
20 */
21 FUNCTION get_net_qty_rcv (x_shipment_line_id IN NUMBER,
22 x_primary_qty IN NUMBER,
23 x_transaction_id IN NUMBER
24 ) RETURN NUMBER;
25
26 pragma restrict_references (get_net_qty_rcv,WNDS,RNPS,WNPS);
27
28
29 FUNCTION get_net_received_qty (p_txn_id IN NUMBER)
30 return number;
31
32 /* Bug 9648379
33 added this function to pass the transaction id of the received shipment transaction
34 which can be used to get correct net received amount for a particular distribution
35 */
36 FUNCTION get_net_rcv_amt(x_shipment_line_id IN NUMBER,
37 x_primary_amt IN NUMBER,
38 x_transaction_id IN NUMBER
39 ) RETURN NUMBER;
40
41
42 /* Code changes for bug - 9502912 - Start
43 Added this funtion to get the qty_received from po_line_locations_all table
44 if the value in po_line_locations_archive_all is zero.
45 */
46
47 FUNCTION get_qty_rcv (line_loc_id IN NUMBER)
48 return number;
49
50
51 END pos_po_rcv_qty;
52