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 2682: from hr_api_hooks h,

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

Line 2683: hr_api_modules m

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

Line 2700: -- from hr_api_hooks h, hr_api_modules m

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

Line 2815: from hr_api_hooks h, hr_api_modules m

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:

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

3631:
3632: p_bs := p_bs ||' /* Mechanism for event capture to know whats occurred */'||g_eol;
3633: p_bs := p_bs ||' l_mode := pay_dyn_triggers.g_dyt_mode;'||g_eol;
3634: if (upper(p_dyt_info) = 'INSERT') then
3635: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;'||g_eos;
3636: else
3637: if (p_datetracked_table = 'Y') then
3638: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;'||g_eos;
3639: else

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

3637: if (p_datetracked_table = 'Y') then
3638: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;'||g_eos;
3639: else
3640: if (upper(p_dyt_info) = 'UPDATE') then
3641: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;'||g_eos;
3642: else
3643: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;'||g_eos;
3644: end if;
3645: end if;

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

3639: else
3640: if (upper(p_dyt_info) = 'UPDATE') then
3641: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;'||g_eos;
3642: else
3643: p_bs := p_bs ||' pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;'||g_eos;
3644: end if;
3645: end if;
3646: end if;
3647: --

Line 3865: from hr_api_modules

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

Line 3894: update hr_api_hook_calls

3890: else
3891: l_hooks := 'N';
3892: end if;
3893:
3894: update hr_api_hook_calls
3895: set enabled_flag = l_hooks
3896: where api_hook_call_id in (
3897: select api_hook_call_id
3898: from hr_api_hook_calls ahc,

Line 3898: from hr_api_hook_calls ahc,

3894: update hr_api_hook_calls
3895: set enabled_flag = l_hooks
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

Line 3899: hr_api_hooks ah,

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

Line 3900: hr_api_modules am

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

Line 3910: hr_api_user_hooks_utility.create_hooks_add_report(l_api_module_id);

3906: and am.module_name = p_table_name );
3907:
3908: for module in csr_get_id loop
3909: --Rebuild Hooks Packages
3910: hr_api_user_hooks_utility.create_hooks_add_report(l_api_module_id);
3911:
3912: end loop;
3913:
3914: end convert_tab_style;

Line 3937: from hr_api_hook_calls ahc,

3933:
3934:
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

Line 3938: hr_api_hooks ah,

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

Line 3939: hr_api_modules am

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

Line 4271: when hr_api.object_locked then

4267: --
4268: -- we need to trap the ora lock exception
4269: --
4270: exception
4271: when hr_api.object_locked then
4272: --
4273: -- the object is locked therefore we need to supply a meaningful
4274: -- error message.
4275: --