[Home] [Help]
PACKAGE BODY: APPS.WMS_API_LOC_PACKAGE_2
Source
1 package body WMS_API_LOC_PACKAGE_2 as
2 -- Procedure for Module Hook ID 100--
3
4 Procedure GET_LOC(
5 x_return_status OUT NOCOPY VARCHAR2,
6 x_msg_count OUT NOCOPY NUMBER,
7 x_msg_data OUT NOCOPY VARCHAR2,
8 x_locator_id OUT NOCOPY NUMBER,
9 x_zone_id OUT NOCOPY NUMBER,
10 x_subinventory_code OUT NOCOPY VARCHAR2,
11 x_loc_valid OUT NOCOPY VARCHAR2,
12 p_mode IN NUMBER,
13 p_task_id IN NUMBER,
14 p_activity_type_id IN NUMBER,
15 p_locator_id IN NUMBER,
16 p_item_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 = 1 then
24 WMS_GET_DEST_LOC_LPN.WMS_DEST_LOC_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_locator_id => x_locator_id,
29 x_zone_id => x_zone_id,
30 x_subinventory_code => x_subinventory_code,
31 x_loc_valid => x_loc_valid,
32 p_mode => p_mode,
33 p_task_id => p_task_id,
34 p_activity_type_id => p_activity_type_id,
35 p_locator_id => p_locator_id,
36 p_item_id => p_item_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 = 2 then
42 WMS_GET_DEST_LOC_LPN.WMS_DEST_LOC_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_locator_id => x_locator_id,
47 x_zone_id => x_zone_id,
48 x_subinventory_code => x_subinventory_code,
49 x_loc_valid => x_loc_valid,
50 p_mode => p_mode,
51 p_task_id => p_task_id,
52 p_activity_type_id => p_activity_type_id,
53 p_locator_id => p_locator_id,
54 p_item_id => p_item_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_LOC_PACKAGE_2;