DBA Data[Home] [Help]

PACKAGE: APPS.WMS_ATF_DEST_LPN

Source


1 package wms_atf_dest_lpn AUTHID CURRENT_USER as
2  /* $Header: WMSDLPNS.pls 115.6 2003/11/03 21:16:58 joabraha noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- |------------------------< get_dest_lpn >------------------------------------|
6 -- -----------------------------------------------------------------------------
7 -- API name    : get_dest_lpn
8 -- Type        : Private
9 -- Function    : Returns Sub/Loc or Locator Validation Status.
10 -- Input Parameters  :
11 --             As shown below.
12 --
13 -- Output Parameters:
14 --             As shown below.
15 -- Version     :
16 -- Current version 1.0
17 --
18 -- Notes       :
19 -- Date           Modification       Author
20 -- ------------   ------------       ------------------
21 --
22 PROCEDURE get_dest_lpn(
23    x_return_status       out nocopy varchar2
24 ,  x_msg_count           out nocopy number
25 ,  x_msg_data            out nocopy varchar2
26 ,  x_lpn_id              out nocopy number
27 ,  x_valid_flag          out nocopy varchar2
28 ,  p_mode                in  number default 1    -- 1. Selection  2. Validation
29 ,  p_task_id             in  number              -- MMTT.transaction_temp_id
30 ,  p_activity_type_id    in  number default 1    -- 1. Inbound   2. Outbound
31 ,  p_hook_call_id	 in  number              -- Seeded/Custom API call hook id in the wms_api_hook_calls.
32 ,  p_lpn_id              in  number default null -- LPN ID for Validation pruposes.
33 ,  p_item_id             in  number default null -- Item ID for Validation purposes.
34 ,  p_subinventory_code   in  varchar2            -- Subinventory code passed from WMSATFRB.pls
35 ,  p_locator_id          in  number              -- Locator ID passed from WMSATFRB.pls
36 ,  p_api_version         in  number
37 ,  p_init_msg_list       in  varchar2
38 ,  p_commit              in  varchar2
39 );
40 --
41 --
42 Procedure trace(
43    p_message  in varchar2
44 ,  p_level    in number default 4
45 );
46 end wms_atf_dest_lpn;