1 PACKAGE WMS_WIP_XDock_Pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSWIPCS.pls 120.0.12010000.1 2008/07/28 18:38:25 appldev 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 wip_chk_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 wip_complete_crossdock
24 ( p_org_id IN NUMBER
25 , p_temp_id IN NUMBER
26 , p_wip_id IN NUMBER
27 , p_inventory_item_id IN NUMBER
28 , x_return_status OUT NOCOPY VARCHAR2
29 , x_msg_count OUT NOCOPY NUMBER
30 , x_msg_data OUT NOCOPY VARCHAR2
31 );
32
33
34
35 PROCEDURE mark_wip(
36 p_line_id IN NUMBER ,
37 P_WIP_ENTITY_ID IN NUMBER ,
38 P_OPERATION_SEQ_NUM IN NUMBER ,
39 P_INVENTORY_ITEM_ID IN NUMBER ,
40 P_REPETITIVE_SCHEDULE_ID IN NUMBER,
41 P_PRIMARY_QUANTITY IN NUMBER,
42 x_quantity_allocated OUT NOCOPY NUMBER,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44 X_MSG_DATA OUT NOCOPY VARCHAR2,
45 p_primary_uom IN VARCHAR2,
46 p_uom VARCHAR2);
47
48 PROCEDURE insert_new_mmtt_row_like
49 (
50 p_txn_temp_id IN number,
51 x_new_temp_id OUT NOCOPY number,
52 x_new_hdr_id OUT NOCOPY number
53 );
54
55
56 END wms_wip_xdock_pvt;
57
58
59
60