1 PACKAGE INV_EXPRESS_PICK_PUB AS
2 /* $Header: INVEXPRS.pls 120.2 2006/09/14 10:12:09 bradha noship $ */
3 TYPE INV_SPLIT_DELIVERY_DETAILS_TBL IS TABLE OF NUMBER
4 INDEX BY BINARY_INTEGER;
5
6 TYPE p_pick_release_status_rec IS RECORD
7 (
8 Delivery_detail_id NUMBER,
9 Pick_status VARCHAR2(1),
10 Split_Delivery_Id NUMBER
11 );
12 TYPE p_pick_release_status_tbl is TABLE OF p_pick_release_status_rec
13 INDEX BY BINARY_INTEGER;
14
15
16
17 PROCEDURE PICK_RELEASE
18 (
19 p_api_version IN NUMBER
20 ,p_init_msg_list IN VARCHAR2
21 ,P_commit IN VARCHAR2
22 ,x_return_status OUT NOCOPY VARCHAR2
23 ,x_msg_count OUT NOCOPY NUMBER
24 ,x_msg_data OUT NOCOPY VARCHAR2
25 ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
26 ,p_grouping_rule_id IN NUMBER
27 ,p_allow_partial_pick IN VARCHAR2
28 ,p_reservations_tbl IN inv_reservation_global.mtl_reservation_tbl_type
29 , p_pick_release_status_tbl OUT NOCOPY INV_EXPRESS_PICK_PUB.p_pick_release_status_tbl
30 );
31 PROCEDURE STAGE_DD_RSV(P_mo_line_REC IN INV_Move_Order_PUB.Trolin_Rec_Type
32 ,p_Reservation_tbl IN inv_reservation_global.mtl_reservation_tbl_type
33 ,p_pick_release_status_tbl IN OUT NOCOPY INV_EXPRESS_PICK_PUB.p_pick_release_status_tbl
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2);
37 PROCEDURE PICK_SERIAL_NUMBERS(
38 p_inventory_item_id IN NUMBER
39 , p_organization_id IN NUMBER
40 , p_revision IN VARCHAR2
41 , p_lot_number IN VARCHAR2
42 , p_subinventory_code IN VARCHAR2
43 , p_locator_id IN NUMBER
44 , p_required_sl_qty IN NUMBER
45 , p_unit_number IN NUMBER
46 , p_reservation_id IN NUMBER -- Bug 5517498
47 , x_available_sl_qty OUT NOCOPY NUMBER
48 , g_transaction_temp_id OUT NOCOPY NUMBER
49 , x_serial_index OUT NOCOPY NUMBER
50 , x_return_status OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 , x_msg_data OUT NOCOPY VARCHAR2
53 , x_serial_number OUT NOCOPY VARCHAR2 -- Bug 5517498
54 );
55
56 END INV_EXPRESS_PICK_PUB;