APPS.WMS_ATF_REG_CUST_APIS dependencies on WMS_API_HOOKED_ENTITIES

Line 630: from wms_api_hooked_entities wahe;

626: cursor c_api_hooked_entities is
627: select wahe.module_hook_id, wahe.module_type_id, wahe.business_process_id,
628: wahe.short_name_id, wahe.sysgen_custom_package, wahe.sysgen_custom_procedure,
629: wahe.hooked_package, wahe.hooked_procedure, wahe.current_package_cntr
630: from wms_api_hooked_entities wahe;
631:
632: cursor c_api_hook_calls(l_module_hook_id number) is
633: select hook_call_id, enabled_flag, called_package, called_procedure,
634: effective_from_date, effective_to_date

Line 643: from wms_api_hooked_entities

639: order by hook_call_id;
640:
641: cursor c_drop_sysgen_packages(l_module_hook_id number) is
642: select sysgen_custom_package, current_package_cntr
643: from wms_api_hooked_entities
644: where module_hook_id = l_module_hook_id;
645:
646: begin
647:

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

842: -- call package(s)/procedure(s)
843: execute_source(g_spec_string);
844: execute_source(g_body_string);
845:
846: -- Update wms_api_hooked_entities to indicate which is the current package in use
847: -- to avoid being updated when in use.
848: begin
849: update wms_api_hooked_entities
850: set current_package_cntr = l_current_package_cntr

Line 849: update wms_api_hooked_entities

845:
846: -- Update wms_api_hooked_entities to indicate which is the current package in use
847: -- to avoid being updated when in use.
848: begin
849: update wms_api_hooked_entities
850: set current_package_cntr = l_current_package_cntr
851: where module_hook_id = v_api_hooked_entities.module_hook_id;
852:
853: commit;

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

853: commit;
854: exception
855: when others then
856: if (l_debug = 1) then
857: trace(l_proc ||' Update wms_api_hooked_entities failed with error = ' || sqlerrm(sqlcode));
858: end if;
859: x_retcode := 2;
860: x_errbuf := 'Error';
861: return;

Line 1761: from wms_api_hooked_entities wahe,

1757: select wahe.module_hook_id, wahe.hooked_package, wahe.hooked_procedure,
1758: wahe.sysgen_custom_package, wahe.sysgen_custom_procedure,
1759: wahc.called_package, wahc.called_procedure, wahc.hook_call_id,
1760: wahc.enabled_flag, wahc.seed_flag
1761: from wms_api_hooked_entities wahe,
1762: wms_api_hook_calls wahc
1763: where wahe.module_hook_id = wahc.module_hook_id(+)
1764: and wahe.short_name_id = p_hook_short_name_id
1765: and wahc.called_package(+) = p_call_package