[Home] [Help]
PACKAGE BODY: APPS.WMS_API_LPN_PACKAGE_2
Source
1 package body WMS_API_LPN_PACKAGE_2 as
2 -- Procedure for Module Hook ID 200--
3
4 Procedure GET_LPN(
5 x_return_status OUT NOCOPY VARCHAR2,
6 x_msg_count OUT NOCOPY NUMBER,
7 x_msg_data OUT NOCOPY VARCHAR2,
8 x_lpn_id OUT NOCOPY NUMBER,
9 x_lpn_valid OUT NOCOPY VARCHAR2,
10 p_mode IN NUMBER,
11 p_task_id IN NUMBER,
12 p_activity_type_id IN NUMBER,
13 p_lpn_id IN NUMBER,
14 p_item_id IN NUMBER,
15 p_subinventory_code IN VARCHAR2,
16 p_locator_id IN NUMBER,
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2,
19 p_commit IN VARCHAR2,
20 p_hook_call_id IN NUMBER
21 ) is
22 begin
23 If p_hook_call_id = 3 then
24 WMS_GET_DEST_LOC_LPN.WMS_DEST_LPN_W_ITEM(
25 x_return_status => x_return_status,
26 x_msg_count => x_msg_count,
27 x_msg_data => x_msg_data,
28 x_lpn_id => x_lpn_id,
29 x_lpn_valid => x_lpn_valid,
30 p_mode => p_mode,
31 p_task_id => p_task_id,
32 p_activity_type_id => p_activity_type_id,
33 p_lpn_id => p_lpn_id,
34 p_item_id => p_item_id,
35 p_subinventory_code => p_subinventory_code,
36 p_locator_id => p_locator_id,
37 p_api_version => p_api_version,
38 p_init_msg_list => p_init_msg_list,
39 p_commit => p_commit
40 );
41 elsif p_hook_call_id = 4 then
42 WMS_GET_DEST_LOC_LPN.WMS_DEST_LPN_WO_ITEM(
43 x_return_status => x_return_status,
44 x_msg_count => x_msg_count,
45 x_msg_data => x_msg_data,
46 x_lpn_id => x_lpn_id,
47 x_lpn_valid => x_lpn_valid,
48 p_mode => p_mode,
49 p_task_id => p_task_id,
50 p_activity_type_id => p_activity_type_id,
51 p_lpn_id => p_lpn_id,
52 p_item_id => p_item_id,
53 p_subinventory_code => p_subinventory_code,
54 p_locator_id => p_locator_id,
55 p_api_version => p_api_version,
56 p_init_msg_list => p_init_msg_list,
57 p_commit => p_commit
58 );
59 end if;
60 end;
61
62 end WMS_API_LPN_PACKAGE_2;