[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
, p_mode in number -- 1. Selection 2. Validation
, p_task_id in number -- MMTT.transaction_temp_id
, p_activity_type_id in number -- 1. Inbound 2. Outbound
, p_hook_call_id in number -- Seeded/Custom API call hook id in the wms_api_hook_calls.
, p_lpn_id in number -- LPN ID for Validation purposes.
, p_item_id in number -- Item ID for Validation purposes.
, p_subinventory_code in varchar2 -- Subinventory code passed from WMSATFRB.pls
, p_locator_id in number -- Locator ID passed from WMSATFRB.pls
, p_api_version in number
, p_init_msg_list in varchar2
, p_commit in varchar2
)
is
cursor c_get_hook_call_details is
select wahe.current_package_cntr
from wms_api_hook_calls wahc, wms_api_hooked_entities wahe
where wahe.module_hook_id = wahc.module_hook_id
and wahe.short_name_id = 2 -- Restricts the output to "LPN Selection/Validation" only
and wahc.hook_call_id = p_hook_call_id;