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 PAY_DATED_TABLES

Line 1703: FROM pay_dated_tables pdt,

1699: SELECT pte.table_name, pte.triggering_action,
1700: pte.generated_flag, pte.enabled_flag,
1701: pdt.dated_table_id, nvl(pdt.dyn_trigger_type,'T'),
1702: pdt.dyn_trigger_package_name
1703: FROM pay_dated_tables pdt,
1704: pay_trigger_events pte
1705: WHERE pte.table_name = pdt.table_name(+)
1706: AND pte.event_id = cp_id;
1707: --

Line 1750: update pay_dated_tables set dyn_trigger_package_name = null

1746: -- Get the trigger name in the standard format
1747: --if weve got an old crap dyt_pkg, then dump it
1748: if (l_dyt_pkg is not null) then
1749: drop_package(l_table,l_dyt_pkg);
1750: update pay_dated_tables set dyn_trigger_package_name = null
1751: where table_name = l_dyt_pkg and dated_table_id = l_tab_id;
1752: end if;
1753: l_trigger := get_trigger_name(p_id,l_table,l_action);
1754: p_name := l_trigger;

Line 2939: from pay_dated_tables

2935: SELECT upper(parameter_name)
2936: FROM pay_trigger_parameters
2937: WHERE usage_type = 'P'||cp_type
2938: AND usage_id = (select dated_table_id
2939: from pay_dated_tables
2940: where table_name = cp_table_name);
2941:
2942: l_missing varchar2(60);
2943: l_missing_rep varchar2(60);

Line 3115: l_tab_id pay_dated_tables.dated_table_id%TYPE;

3111: PROCEDURE gen_dyt_pkg_full_code(p_tab_id IN NUMBER,
3112: p_ok IN OUT NOCOPY BOOLEAN) IS
3113: --
3114:
3115: l_tab_id pay_dated_tables.dated_table_id%TYPE;
3116: l_tab_name pay_dated_tables.table_name%TYPE;
3117: l_tab_dyt_types pay_dated_tables.dyn_trigger_type%TYPE;
3118: l_tab_dyt_pkg_name pay_dated_tables.dyn_trigger_package_name%TYPE;
3119: l_datetracked_table varchar2(5);

Line 3116: l_tab_name pay_dated_tables.table_name%TYPE;

3112: p_ok IN OUT NOCOPY BOOLEAN) IS
3113: --
3114:
3115: l_tab_id pay_dated_tables.dated_table_id%TYPE;
3116: l_tab_name pay_dated_tables.table_name%TYPE;
3117: l_tab_dyt_types pay_dated_tables.dyn_trigger_type%TYPE;
3118: l_tab_dyt_pkg_name pay_dated_tables.dyn_trigger_package_name%TYPE;
3119: l_datetracked_table varchar2(5);
3120:

Line 3117: l_tab_dyt_types pay_dated_tables.dyn_trigger_type%TYPE;

3113: --
3114:
3115: l_tab_id pay_dated_tables.dated_table_id%TYPE;
3116: l_tab_name pay_dated_tables.table_name%TYPE;
3117: l_tab_dyt_types pay_dated_tables.dyn_trigger_type%TYPE;
3118: l_tab_dyt_pkg_name pay_dated_tables.dyn_trigger_package_name%TYPE;
3119: l_datetracked_table varchar2(5);
3120:
3121: --

Line 3118: l_tab_dyt_pkg_name pay_dated_tables.dyn_trigger_package_name%TYPE;

3114:
3115: l_tab_id pay_dated_tables.dated_table_id%TYPE;
3116: l_tab_name pay_dated_tables.table_name%TYPE;
3117: l_tab_dyt_types pay_dated_tables.dyn_trigger_type%TYPE;
3118: l_tab_dyt_pkg_name pay_dated_tables.dyn_trigger_package_name%TYPE;
3119: l_datetracked_table varchar2(5);
3120:
3121: --
3122: l_hs varchar2(32000); --Used as header sql placeholders

Line 3148: FROM pay_dated_tables pdt

3144: pdt.dyn_trigger_package_name,
3145: decode(start_date_name,
3146: null, 'N',
3147: 'Y')
3148: FROM pay_dated_tables pdt
3149: WHERE pdt.dated_table_id = (cp_tab_id);
3150:
3151: -- Get details of all dyn-triggers on given table
3152: CURSOR csr_dyts_on_table(cp_name in VARCHAR2) IS

Line 3179: -- This is table specific and defined in pay_dated_tables, eg the dyn-trigger

3175: -- NB. It is important to note that there is a subtle difference between
3176: -- database triggers and dynamic triggers. The latter are defined on site giving
3177: -- great flexibility, i.e. what customer-specific calls need to be made as part of
3178: -- this process. How the code is actually stored provides more flexibility.
3179: -- This is table specific and defined in pay_dated_tables, eg the dyn-trigger
3180: -- code can be stored as database triggers, in a separate package or in both of these.
3181: -- ...
3182: -- Since continuous calc we are moving toward the idea of no database triggers,
3183: -- (negative issues with maintenance) and toward stored code as a package.

Line 3350: update pay_dated_tables

3346:
3347: --hr_utility.set_location(' -Status of database package: '||l_flag||l_proc,80);
3348: --Complete FOR WHOLE TABLE, so mark pkg gen, and all dyt as generated + enabled or vice versa
3349: -- All or nothing, either all dyt's are success, or mark all as failure
3350: update pay_dated_tables
3351: set dyn_trig_pkg_generated = l_flag
3352: where table_name = l_tab_name
3353: and dated_table_id = l_tab_id;
3354: --

Line 3393: l_tab_name pay_dated_tables.table_name%TYPE := p_tab_name;

3389: ,p_bs IN OUT NOCOPY VARCHAR2) IS
3390: --
3391: l_inits BOOLEAN;
3392: l_comps BOOLEAN;
3393: l_tab_name pay_dated_tables.table_name%TYPE := p_tab_name;
3394: l_dyt_id pay_trigger_events.event_id%TYPE := p_dyt_id;
3395: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3396: l_dyt_act pay_trigger_events.triggering_action%TYPE := p_dyt_act;
3397: l_dyt_info varchar2(30) := p_dyt_info;

Line 3833: update pay_dated_tables

3829:
3830: begin
3831: hr_utility.trace('>>> set table '||p_table_name||' to be style '||p_dyt_type);
3832: --
3833: update pay_dated_tables
3834: set dyn_trigger_type = p_dyt_type, dyn_trig_pkg_generated = 'N'
3835: where table_name = p_table_name;
3836:
3837: hr_utility.trace(' creating dyt triggers...');

Line 3866: from pay_dated_tables

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
3867: where table_name = am.module_name)
3868: and am.module_name = p_table_name );
3869:
3870: for module in csr_get_id loop

Line 3905: from pay_dated_tables

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
3906: where table_name = am.module_name)
3907: and am.module_name = p_table_name;
3908: l_hook_count number;
3909:

Line 3912: from pay_dated_tables

3908: l_hook_count number;
3909:
3910: cursor csr_tab_details is
3911: select dated_table_id,dyn_trigger_type,dyn_trigger_package_name,dyn_trig_pkg_generated
3912: from pay_dated_tables
3913: where table_name = p_table_name;
3914: l_dt_id pay_dated_tables.dated_table_id%type;
3915: l_dt_dyt_type pay_dated_tables.dyn_trigger_type%type;
3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;

Line 3914: l_dt_id pay_dated_tables.dated_table_id%type;

3910: cursor csr_tab_details is
3911: select dated_table_id,dyn_trigger_type,dyn_trigger_package_name,dyn_trig_pkg_generated
3912: from pay_dated_tables
3913: where table_name = p_table_name;
3914: l_dt_id pay_dated_tables.dated_table_id%type;
3915: l_dt_dyt_type pay_dated_tables.dyn_trigger_type%type;
3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;
3917: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;
3918:

Line 3915: l_dt_dyt_type pay_dated_tables.dyn_trigger_type%type;

3911: select dated_table_id,dyn_trigger_type,dyn_trigger_package_name,dyn_trig_pkg_generated
3912: from pay_dated_tables
3913: where table_name = p_table_name;
3914: l_dt_id pay_dated_tables.dated_table_id%type;
3915: l_dt_dyt_type pay_dated_tables.dyn_trigger_type%type;
3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;
3917: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;
3918:
3919: cursor csr_pkg_exist(cp_pkg in varchar2) is

Line 3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;

3912: from pay_dated_tables
3913: where table_name = p_table_name;
3914: l_dt_id pay_dated_tables.dated_table_id%type;
3915: l_dt_dyt_type pay_dated_tables.dyn_trigger_type%type;
3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;
3917: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;
3918:
3919: cursor csr_pkg_exist(cp_pkg in varchar2) is
3920: select status from user_objects

Line 3917: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;

3913: where table_name = p_table_name;
3914: l_dt_id pay_dated_tables.dated_table_id%type;
3915: l_dt_dyt_type pay_dated_tables.dyn_trigger_type%type;
3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;
3917: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;
3918:
3919: cursor csr_pkg_exist(cp_pkg in varchar2) is
3920: select status from user_objects
3921: where object_type = 'PACKAGE BODY'