APPS.WMS_ATF_REG_CUST_APIS dependencies on WMS_API_HOOKED_ENTITIES

Line 623: from wms_api_hooked_entities wahe;

619: cursor c_api_hooked_entities is
620: select wahe.module_hook_id, wahe.module_type_id, wahe.business_process_id,
621: wahe.short_name_id, wahe.sysgen_custom_package, wahe.sysgen_custom_procedure,
622: wahe.hooked_package, wahe.hooked_procedure, wahe.current_package_cntr
623: from wms_api_hooked_entities wahe;
624:
625: cursor c_api_hook_calls(l_module_hook_id number) is
626: select hook_call_id, enabled_flag, called_package, called_procedure,
627: effective_from_date, effective_to_date

Line 636: from wms_api_hooked_entities

632: order by hook_call_id;
633:
634: cursor c_drop_sysgen_packages(l_module_hook_id number) is
635: select sysgen_custom_package, current_package_cntr
636: from wms_api_hooked_entities
637: where module_hook_id = l_module_hook_id;
638:
639: begin
640:

Line 832: -- Update wms_api_hooked_entities to indicate which is the current package in use

828: -- call package(s)/procedure(s)
829: execute_source(g_spec_string);
830: execute_source(g_body_string);
831:
832: -- Update wms_api_hooked_entities to indicate which is the current package in use
833: -- to avoid being updated when in use.
834: begin
835: update wms_api_hooked_entities
836: set current_package_cntr = l_current_package_cntr

Line 835: update wms_api_hooked_entities

831:
832: -- Update wms_api_hooked_entities to indicate which is the current package in use
833: -- to avoid being updated when in use.
834: begin
835: update wms_api_hooked_entities
836: set current_package_cntr = l_current_package_cntr
837: where module_hook_id = v_api_hooked_entities.module_hook_id;
838:
839: commit;

Line 843: trace(l_proc ||' Update wms_api_hooked_entities failed with error = ' || sqlerrm(sqlcode));

839: commit;
840: exception
841: when others then
842: if (l_debug = 1) then
843: trace(l_proc ||' Update wms_api_hooked_entities failed with error = ' || sqlerrm(sqlcode));
844: end if;
845: x_retcode := 2;
846: x_errbuf := 'Error';
847: return;

Line 1747: from wms_api_hooked_entities wahe,

1743: select wahe.module_hook_id, wahe.hooked_package, wahe.hooked_procedure,
1744: wahe.sysgen_custom_package, wahe.sysgen_custom_procedure,
1745: wahc.called_package, wahc.called_procedure, wahc.hook_call_id,
1746: wahc.enabled_flag, wahc.seed_flag
1747: from wms_api_hooked_entities wahe,
1748: wms_api_hook_calls wahc
1749: where wahe.module_hook_id = wahc.module_hook_id(+)
1750: and wahe.short_name_id = p_hook_short_name_id
1751: and wahc.called_package(+) = p_call_package