1 PACKAGE WSH_INV_INTEGRATION_GRP AUTHID CURRENT_USER AS
2 /* $Header: WSHINVIS.pls 120.1 2012/01/05 16:38:04 brana ship $ */
3
4
5 TYPE pick_slip_printer_rec_type IS RECORD (
6 printer_name WSH_REPORT_PRINTERS.PRINTER_NAME%TYPE,
7 conc_program_name varchar2(30)
8 );
9
10 TYPE pick_slip_printer_tab_type IS TABLE OF pick_slip_printer_rec_type
11 INDEX BY BINARY_INTEGER;
12
13 G_PRINTERTAB pick_slip_printer_tab_type;
14 G_ORGTAB WSH_UTIL_CORE.Column_Tab_Type ;
15 G_ORGSUBTAB WSH_UTIL_CORE.Column_Tab_Type ;
16
17 PROCEDURE Find_Printer (
18 p_subinventory IN VARCHAR2 ,
19 p_organization_id IN NUMBER ,
20 x_api_status OUT NOCOPY VARCHAR2,
21 x_error_message OUT NOCOPY VARCHAR2
22 ) ;
23
24
25
26 /*
27 Procedure :Complete_Inv_Interface
28 Description: This procedure will be called by Inventory during processing of the data from their interface
29 tables.The purpose of this procedure is to update the inventory_interfaced_flag on
30 wsh_delivery_details to 'Y' if inventory interface process has completed successfully
31 and also to update the pending_interface_flag for the corresponding trip stops to NULL.
32 */
33 PROCEDURE Complete_Inv_Interface(
34 p_api_version_number IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 p_txn_header_id IN NUMBER,
38 p_txn_batch_id IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 ) ;
43
44
45 END WSH_INV_INTEGRATION_GRP ;