[Home] [Help]
2679: SELECT /*+ ORDERED */ a.pls_type
2680: FROM (select /*+ NO_MERGE */
2681: DISTINCT hook_package
2682: from hr_api_hooks h,
2683: hr_api_modules m
2684: where m.api_module_id = h.api_module_id
2685: and m.module_name = cp_tab_name) V,
2686: USER_OBJECTS B,
2687: SYS.ARGUMENT$ A
2696: -- FROM USER_OBJECTS B,
2697: -- SYS.ARGUMENT$ A
2698: -- WHERE A.OBJ# = B.OBJECT_ID
2699: -- AND B.OBJECT_NAME in (select hook_package
2700: -- from hr_api_hooks h, hr_api_modules m
2701: -- where m.api_module_id = h.api_module_id
2702: -- and m.module_name = cp_tab_name)
2703: -- AND A.LEVEL# = 0
2704: -- AND A.argument = cp_param_name
2811: select hook_package pkg, hook_procedure proc
2812: ,decode(hook_procedure, 'AFTER_INSERT', 'PI',
2813: 'AFTER_UPDATE', 'PU',
2814: 'AFTER_DELETE', 'PD') usage_type
2815: from hr_api_hooks h, hr_api_modules m
2816: where m.api_module_id = h.api_module_id
2817: and m.module_name = cp_tab_name;
2818: --
2819:
3861: select event_id,short_name from pay_trigger_events
3862: where table_name = cp_table_name;
3863: cursor csr_get_id is
3864: select api_module_id
3865: from hr_api_modules
3866: where module_name = p_table_name;
3867:
3868: begin
3869: hr_utility.trace('>>> set table '||p_table_name||' to be style '||p_dyt_type);
3896: where api_hook_call_id in (
3897: select api_hook_call_id
3898: from hr_api_hook_calls ahc,
3899: hr_api_hooks ah,
3900: hr_api_modules am
3901: where ahc.api_hook_id = ah.api_hook_id
3902: and ah.api_module_id = am.api_module_id
3903: and ahc.call_package = (select dyn_trigger_package_name
3904: from pay_dated_tables
3935: cursor csr_dyt_pkg_hook is
3936: select count(*)
3937: from hr_api_hook_calls ahc,
3938: hr_api_hooks ah,
3939: hr_api_modules am
3940: where ahc.api_hook_id = ah.api_hook_id
3941: and ah.api_module_id = am.api_module_id
3942: and ahc.call_package = (select dyn_trigger_package_name
3943: from pay_dated_tables