1 PACKAGE inv_lpn_reservations_pvt AUTHID CURRENT_USER as
2 /* $Header: INVRSVLS.pls 120.3 2010/09/13 09:02:09 avuppala ship $*/
3
4
5 --Create_LPN_Reservations
6 --
7 -- This API is designed to be called from the Reservations Form.
8 -- This procedure will create a separate reservation for each lot and
9 -- revision in that LPN. The procedure assumes that the LPN passed as
10 -- a parameter is an innermost LPN. Only material residing directly
11 -- within the given LPN, without a level of nesting, will be reserved.
12
13 PROCEDURE Create_LPN_Reservations
14 (
15 x_return_status OUT NOCOPY VARCHAR2
16 ,x_msg_count OUT NOCOPY NUMBER
17 ,x_msg_data OUT NOCOPY VARCHAR2
18 ,p_organization_id IN NUMBER
19 ,p_inventory_item_id IN NUMBER
20 ,p_demand_source_type_id IN NUMBER
21 ,p_demand_source_header_id IN NUMBER
22 ,p_demand_source_line_id IN NUMBER
23 ,p_demand_source_name IN VARCHAR2
24 ,p_need_by_date IN DATE
25 ,p_lpn_id IN NUMBER
26 );
27
28
29 --Transfer_LPN_Reservations
30 --
31 -- This API is designed to be called from the mobile subinventory transfer
32 -- and putaway forms. This procedure will transfer all the reservations
33 -- for a given LPN from the current subinventory and locator to a new
34 -- subinventory and locator. This is useful for moving reserved LPNs around
35 -- the warehouse.
36 PROCEDURE Transfer_LPN_Reservations
37 (
38 x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 ,p_organization_id IN NUMBER
42 ,p_inventory_item_id IN NUMBER default NULL
43 ,p_lpn_id IN NUMBER
44 ,p_to_subinventory_code IN VARCHAR2
45 ,p_to_locator_id IN NUMBER
46 ,p_system_task_type IN NUMBER default NULL --9794776
47 );
48
49
50 -- ER 7307189 changes start
51
52 PROCEDURE transfer_reserved_lpn_contents
53 (
54 x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ,p_organization_id IN NUMBER
58 ,p_inventory_item_id IN NUMBER default NULL
59 ,p_lpn_id IN NUMBER
60 ,p_transfer_lpn_id IN NUMBER
61 ,p_to_subinventory_code IN VARCHAR2
62 ,p_to_locator_id IN NUMBER
63 , p_system_task_type IN NUMBER DEFAULT NULL -- 9794776
64 );
65
66 -- ER 7307189 changes end
67
68
69 END inv_lpn_reservations_pvt;