1 PACKAGE RCV_WSH_INTERFACE_PKG AUTHID CURRENT_USER AS
2 /* $Header: RCVWSHIS.pls 120.2.12020000.3 2013/02/27 13:00:26 honwei ship $*/
3
4 g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on;
5
6 PROCEDURE create_delivery_details
7 ( p_return_org_id IN NUMBER,
8 p_interface_txn_id IN NUMBER,
9 p_use_mtl_lot IN NUMBER,
10 p_use_mtl_serial IN NUMBER,
11 p_ship_to IN NUMBER,
12 p_site_use IN NUMBER
13 );
14
15 PROCEDURE interface_to_rcv
16 ( p_delivery_id IN NUMBER,
17 p_return_status OUT NOCOPY VARCHAR2);
18
19 PROCEDURE invoke_RTP
20 ( p_group_id IN NUMBER,
21 p_return_status OUT NOCOPY VARCHAR2);
22
23 PROCEDURE process_txn
24 ( p_header_id IN NUMBER,
25 p_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE load_mtl_interfaces
28 ( p_txn_desc IN VARCHAR2,
29 p_wdd_rec IN wsh_delivery_details%rowtype,
30 p_header_id IN NUMBER,
31 p_delivery_id IN NUMBER);
32
33 PROCEDURE load_rcv_interfaces
34 ( p_delivery_id IN NUMBER,
35 p_wdd_rec IN wsh_delivery_details%rowtype,
36 p_group_id IN NUMBER);
37
38 PROCEDURE load_lot_serial_interfaces
39 ( p_source IN VARCHAR2,
40 p_wdd_rec IN wsh_delivery_details%rowtype,
41 p_parent_id IN NUMBER);
42
43 PROCEDURE perform_post_tm_updates
44 ( p_TM_source IN VARCHAR2,
45 p_delivery_id IN NUMBER );
46
47 PROCEDURE adjust_rcv_quantities
48 ( p_delivery_detail_id IN NUMBER ,
49 p_item_id IN NUMBER ,
50 p_wdd_shipped_qty IN NUMBER ,
51 p_wdd_shipped_uom_code IN VARCHAR2 ,
52 p_wdd_shipped_qty2 IN NUMBER ,
53 p_wdd_shipped_uom_code2 IN VARCHAR2 ,
54 p_bkup_rti_id IN NUMBER ,
55 p_bkup_rti_quantity IN OUT NOCOPY NUMBER ,--RTV project phase 2
56 p_bkup_rti_uom IN VARCHAR2 ,
57 p_bkup_rti_puom IN VARCHAR2 ,
58 p_bkup_rti_suom IN VARCHAR2 ,
59 p_bkup_rti_src_uom IN VARCHAR2 );
60
61 PROCEDURE clean_up_after_rtp
62 ( p_delivery_id IN NUMBER,
63 p_group_id IN NUMBER);
64
65 TYPE RTI_id_tbl IS TABLE OF
66 rcv_transactions_interface.interface_transaction_id%TYPE
67 INDEX BY BINARY_INTEGER;
68
69 PROCEDURE cancel_rtv_lines
70 ( p_rti_id_tbl IN rcv_wsh_interface_pkg.RTI_id_tbl);
71
72 END RCV_WSH_INTERFACE_PKG;