eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAYWSDYG_PKG dependencies on HR_API

Line 2645: from hr_api_hooks h,

2641: is
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,

Line 2646: hr_api_modules m

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

Line 2663: -- from hr_api_hooks h, hr_api_modules m

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

Line 2778: from hr_api_hooks h, hr_api_modules m

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:

Line 3597: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;'||g_eos;

3593:
3594: p_bs := p_bs ||' /* Mechanism for event capture to know whats occurred */'||g_eol;
3595: p_bs := p_bs ||' l_mode := pay_dyn_triggers.g_dyt_mode;'||g_eol;
3596: if (upper(p_dyt_info) = 'INSERT') then
3597: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;'||g_eos;
3598: else
3599: if (p_datetracked_table = 'Y') then
3600: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;'||g_eos;
3601: else

Line 3603: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;'||g_eos;

3599: if (p_datetracked_table = 'Y') then
3600: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;'||g_eos;
3601: else
3602: if (upper(p_dyt_info) = 'UPDATE') then
3603: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;'||g_eos;
3604: else
3605: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;'||g_eos;
3606: end if;
3607: end if;

Line 3605: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;'||g_eos;

3601: else
3602: if (upper(p_dyt_info) = 'UPDATE') then
3603: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;'||g_eos;
3604: else
3605: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;'||g_eos;
3606: end if;
3607: end if;
3608: end if;
3609: --

Line 3827: from hr_api_modules

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);

Line 3856: update hr_api_hook_calls

3852: else
3853: l_hooks := 'N';
3854: end if;
3855:
3856: update hr_api_hook_calls
3857: set enabled_flag = l_hooks
3858: where api_hook_call_id in (
3859: select api_hook_call_id
3860: from hr_api_hook_calls ahc,

Line 3860: from hr_api_hook_calls ahc,

3856: update hr_api_hook_calls
3857: set enabled_flag = l_hooks
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

Line 3861: hr_api_hooks ah,

3857: set enabled_flag = l_hooks
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

Line 3862: hr_api_modules am

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

Line 3872: hr_api_user_hooks_utility.create_hooks_add_report(l_api_module_id);

3868: and am.module_name = p_table_name );
3869:
3870: for module in csr_get_id loop
3871: --Rebuild Hooks Packages
3872: hr_api_user_hooks_utility.create_hooks_add_report(l_api_module_id);
3873:
3874: end loop;
3875:
3876: end convert_tab_style;

Line 3899: from hr_api_hook_calls ahc,

3895:
3896:
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

Line 3900: hr_api_hooks ah,

3896:
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

Line 3901: hr_api_modules am

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

Line 4233: when hr_api.object_locked then

4229: --
4230: -- we need to trap the ora lock exception
4231: --
4232: exception
4233: when hr_api.object_locked then
4234: --
4235: -- the object is locked therefore we need to supply a meaningful
4236: -- error message.
4237: --