APPS.WMS_ATF_DEST_LOCATOR dependencies on WMS_API_HOOK_CALLS

Line 69: , p_hook_call_id in number -- Seeded/Custom API call hook id in the wms_api_hook_calls.

65: , x_loc_valid out nocopy varchar2
66: , p_mode in number -- 1. Selection 2. Validation
67: , p_task_id in number -- MMTT.transaction_temp_id
68: , p_activity_type_id in number -- 1. Inbound 2. Outbound
69: , p_hook_call_id in number -- Seeded/Custom API call hook id in the wms_api_hook_calls.
70: , p_locator_id in number -- Locator_id for Validation pruposes.
71: , p_item_id in number -- Item ID for Validation purposes.
72: , p_api_version in number
73: , p_init_msg_list in varchar2

Line 87: from wms_api_hook_calls wahc, wms_api_hooked_entities wahe

83:
84: -- Added the wahc.effective_to_date to the select on December 24th 2003.
85: cursor c_get_hook_call_details is
86: select wahe.current_package_cntr, wahc.effective_to_date
87: from wms_api_hook_calls wahc, wms_api_hooked_entities wahe
88: where wahe.module_hook_id = wahc.module_hook_id
89: -- Restricts the output to "Locator Selection/Validation" only
90: and wahe.short_name_id = 1
91: and wahc.hook_call_id = p_hook_call_id;