[Home] [Help]
2642: SELECT /*+ ORDERED */ a.pls_type
2643: FROM (select /*+ NO_MERGE */
2644: DISTINCT hook_package
2645: from hr_api_hooks h,
2646: hr_api_modules m
2647: where m.api_module_id = h.api_module_id
2648: and m.module_name = cp_tab_name) V,
2649: USER_OBJECTS B,
2650: SYS.ARGUMENT$ A
2659: -- FROM USER_OBJECTS B,
2660: -- SYS.ARGUMENT$ A
2661: -- WHERE A.OBJ# = B.OBJECT_ID
2662: -- AND B.OBJECT_NAME in (select hook_package
2663: -- from hr_api_hooks h, hr_api_modules m
2664: -- where m.api_module_id = h.api_module_id
2665: -- and m.module_name = cp_tab_name)
2666: -- AND A.LEVEL# = 0
2667: -- AND A.argument = cp_param_name
2774: select hook_package pkg, hook_procedure proc
2775: ,decode(hook_procedure, 'AFTER_INSERT', 'PI',
2776: 'AFTER_UPDATE', 'PU',
2777: 'AFTER_DELETE', 'PD') usage_type
2778: from hr_api_hooks h, hr_api_modules m
2779: where m.api_module_id = h.api_module_id
2780: and m.module_name = cp_tab_name;
2781: --
2782:
3823: select event_id,short_name from pay_trigger_events
3824: where table_name = cp_table_name;
3825: cursor csr_get_id is
3826: select api_module_id
3827: from hr_api_modules
3828: where module_name = p_table_name;
3829:
3830: begin
3831: hr_utility.trace('>>> set table '||p_table_name||' to be style '||p_dyt_type);
3858: where api_hook_call_id in (
3859: select api_hook_call_id
3860: from hr_api_hook_calls ahc,
3861: hr_api_hooks ah,
3862: hr_api_modules am
3863: where ahc.api_hook_id = ah.api_hook_id
3864: and ah.api_module_id = am.api_module_id
3865: and ahc.call_package = (select dyn_trigger_package_name
3866: from pay_dated_tables
3897: cursor csr_dyt_pkg_hook is
3898: select count(*)
3899: from hr_api_hook_calls ahc,
3900: hr_api_hooks ah,
3901: hr_api_modules am
3902: where ahc.api_hook_id = ah.api_hook_id
3903: and ah.api_module_id = am.api_module_id
3904: and ahc.call_package = (select dyn_trigger_package_name
3905: from pay_dated_tables