1 PACKAGE WMS_Cross_Dock_Pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSCRDKS.pls 120.3 2010/05/09 20:30:19 mchemban 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 --9695544-Added below procedure
48 procedure insert_xdock_criteria( p_move_order_line_id IN NUMBER
49 , p_crossdock_criterion_id IN NUMBER
50 , x_return_status OUT nocopy VARCHAR2
51 , x_msg_data OUT nocopy VARCHAR2
52 , x_msg_count OUT nocopy NUMBER
53 );
54
55
56 END WMS_Cross_Dock_Pvt;
57
58
59
60