1 PACKAGE WMS_Cross_Dock_Pvt AS
2 /* $Header: WMSCRDKS.pls 120.2 2005/09/15 15:35:16 mankuma ship $ */
3
4
5 PROCEDURE mydebug(msg in varchar2) ;
6
7
8 -- This API will be to determine whether cross docking opportunities
9 -- exist. If so, it will call pick release for the order(s) in question and
10 -- direct the User to the staging location(s)
11
12
13 PROCEDURE crossdock
14 ( p_org_id IN NUMBER
15 , p_lpn IN NUMBER:=NULL
16 , x_ret OUT NOCOPY NUMBER
17 , x_return_status OUT NOCOPY VARCHAR2
18 , x_msg_count OUT NOCOPY NUMBER
19 , x_msg_data OUT NOCOPY VARCHAR2
20 , p_move_order_line_id IN NUMBER DEFAULT NULL -- added for ATF_J
21 );
22
23 PROCEDURE complete_crossdock
24 ( p_org_id IN NUMBER
25 , p_temp_id IN NUMBER
26 , x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_count OUT NOCOPY NUMBER
28 , x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31
32
33 PROCEDURE mark_delivery
34 (p_del_id IN NUMBER
35 , x_ret OUT NOCOPY VARCHAR2
36 , x_return_status OUT NOCOPY VARCHAR2
37 , x_msg_count OUT NOCOPY NUMBER
38 , x_msg_data OUT NOCOPY VARCHAR2);
39
40 --New api to be called from WMS Control Board.
41 PROCEDURE cancel_crossdock_task(p_transaction_temp_id IN NUMBER
42 , x_return_status OUT nocopy VARCHAR2
43 , x_msg_data OUT nocopy VARCHAR2
44 , x_msg_count OUT nocopy NUMBER
45 );
46
47
48 END WMS_Cross_Dock_Pvt;
49
50
51
52