1 PACKAGE POS_VIEW_RECEIPTS_GRP AS
2 /* $Header: POSGRCPS.pls 120.4 2006/03/13 22:59:18 bgopired noship $*/
3
4
5 /* Logic in this procedure is same as RCV_INVOICE_MATCHING_SV.get_quantities.
6 since we can not directly use the RCV function as it references secured sysnonyms,
7 same logic is incorporated here. Also, we are interested only in Return and Rejcted
8 quantities */
9
10 PROCEDURE get_quantities (
11 top_transaction_id IN NUMBER,
12 rtv_txn_qty IN OUT NOCOPY NUMBER,
13 rejected_txn_qty IN OUT NOCOPY NUMBER) ;
14
15 /**
16 * Function to find if there is an LPN or a Lot or Serial exists for the given shipment
17 line id. Logic is to check if WMS installed; if not return 0. If WMS is installed, check
18 if an LPN exist in the RCV_TRANSACTION table.
19 * parameters:
20 * p_rcv_shipment_line_id The shipment line id
21 * Returns returns 1 if there is LPN or Lot or Serial exist;
22 Return 0 if none.
23 */
24 Function IS_LpnLotSerial_Exist(p_rcv_shipment_line_id number) return number;
25
26 PROCEDURE get_po_info (
27 p_shipment_header_id IN NUMBER,
28 p_po_switch OUT NOCOPY VARCHAR2,
29 p_po_number OUT NOCOPY VARCHAR2,
30 p_po_header_id OUT NOCOPY VARCHAR2,
31 p_release_id OUT NOCOPY VARCHAR2);
32
33
34 PROCEDURE get_invoice_info (
35 p_shipment_header_id IN NUMBER,
36 p_invoice_switch OUT NOCOPY VARCHAR2,
37 p_invoice_number OUT NOCOPY VARCHAR2,
38 p_invoice_id OUT NOCOPY VARCHAR2);
39
40 PROCEDURE get_invoice_info_for_line (
41 p_shipment_line_id IN NUMBER,
42 p_invoice_switch OUT NOCOPY VARCHAR2,
43 p_invoice_number OUT NOCOPY VARCHAR2,
44 p_invoice_id OUT NOCOPY VARCHAR2);
45
46 END POS_VIEW_RECEIPTS_GRP;
47
[Home] [Help]