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_TRIGGER_EVENTS

Line 597: FROM pay_trigger_events

593: --
594: CURSOR get_info(cp_id IN NUMBER) IS
595: SELECT table_name,
596: triggering_action
597: FROM pay_trigger_events
598: WHERE event_id = cp_id;
599: --
600: l_table VARCHAR2(30);
601: l_mode VARCHAR2(1);

Line 1704: pay_trigger_events pte

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: --
1708: l_table VARCHAR2(30);

Line 1769: update pay_trigger_events

1765: if (p_ok) then
1766: hr_utility.trace(' Database Trigger '||p_name||' created with success');
1767: else
1768: hr_utility.trace(' Database Trigger '||p_name||' created with failure');
1769: update pay_trigger_events
1770: set generated_flag = 'N', enabled_flag = 'N'
1771: where event_id = p_id;
1772: l_enb_flag := 'N';
1773: end if;

Line 1805: FROM pay_trigger_events pte,

1801: SELECT pte.event_id,
1802: pte.table_name,
1803: pts.header_code,
1804: pts.body_code
1805: FROM pay_trigger_events pte,
1806: pay_trigger_support pts
1807: WHERE pte.event_id = pts.event_id
1808: AND pts.support_id = cp_id;
1809: --

Line 1851: FROM pay_trigger_events pte

1847: -- Fetch to get some more information that we need
1848: CURSOR csr_name(cp_id IN NUMBER) IS
1849: SELECT pte.table_name,
1850: pte.triggering_action
1851: FROM pay_trigger_events pte
1852: WHERE pte.event_id = cp_id;
1853: --
1854: l_table VARCHAR2(30);
1855: l_action VARCHAR2(1);

Line 2387: l_table pay_trigger_events.table_name%TYPE;

2383: PROCEDURE generate_code(p_id IN NUMBER,p_sql IN OUT NOCOPY VARCHAR2) IS
2384: --
2385: l_inits BOOLEAN;
2386: l_comps BOOLEAN;
2387: l_table pay_trigger_events.table_name%TYPE;
2388: l_name pay_trigger_events.short_name%TYPE;
2389: l_type pay_trigger_events.triggering_action%TYPE;
2390: l_desc VARCHAR2(80);
2391: l_info pay_trigger_events.description%TYPE;

Line 2388: l_name pay_trigger_events.short_name%TYPE;

2384: --
2385: l_inits BOOLEAN;
2386: l_comps BOOLEAN;
2387: l_table pay_trigger_events.table_name%TYPE;
2388: l_name pay_trigger_events.short_name%TYPE;
2389: l_type pay_trigger_events.triggering_action%TYPE;
2390: l_desc VARCHAR2(80);
2391: l_info pay_trigger_events.description%TYPE;
2392:

Line 2389: l_type pay_trigger_events.triggering_action%TYPE;

2385: l_inits BOOLEAN;
2386: l_comps BOOLEAN;
2387: l_table pay_trigger_events.table_name%TYPE;
2388: l_name pay_trigger_events.short_name%TYPE;
2389: l_type pay_trigger_events.triggering_action%TYPE;
2390: l_desc VARCHAR2(80);
2391: l_info pay_trigger_events.description%TYPE;
2392:
2393: --

Line 2391: l_info pay_trigger_events.description%TYPE;

2387: l_table pay_trigger_events.table_name%TYPE;
2388: l_name pay_trigger_events.short_name%TYPE;
2389: l_type pay_trigger_events.triggering_action%TYPE;
2390: l_desc VARCHAR2(80);
2391: l_info pay_trigger_events.description%TYPE;
2392:
2393: --
2394: -- Get some extra information about the event we're generating code for
2395: CURSOR csr_name(cp_id IN NUMBER) IS

Line 2405: FROM pay_trigger_events pte

2401: 'U','Update',
2402: 'D','Delete'
2403: ),
2404: pte.description
2405: FROM pay_trigger_events pte
2406: WHERE pte.event_id = cp_id;
2407: --
2408: BEGIN
2409: --

Line 2496: FROM pay_trigger_events pte

2492: -- Get some more information we need before we can delete the event
2493: CURSOR get_trigger(cp_id IN NUMBER) IS
2494: SELECT pte.table_name,
2495: pte.triggering_action
2496: FROM pay_trigger_events pte
2497: WHERE pte.event_id = cp_id;
2498: --
2499: -- Get all the initialisations that this event uses
2500: CURSOR get_inits(cp_id IN NUMBER) IS

Line 2927: from pay_trigger_events te, pay_trigger_components tc

2923: FROM pay_trigger_parameters
2924: WHERE parameter_type IN ('I','O')
2925: AND value_name IS NOT NULL
2926: AND usage_id in (select component_id
2927: from pay_trigger_events te, pay_trigger_components tc
2928: where te.event_id = tc.event_id
2929: and triggering_action = cp_type
2930: and te.table_name = cp_table_name)
2931: AND usage_type = 'C'

Line 3089: l_suffix pay_trigger_events.short_name%TYPE;

3085: -- | last few chars as these are often the useful identifiers. |
3086: -- +---------------------------------------------------------------------------+
3087: FUNCTION get_dyt_proc_name(p_dyt_name IN VARCHAR2) RETURN varchar2 IS
3088:
3089: l_suffix pay_trigger_events.short_name%TYPE;
3090: l_proc_name varchar2(30);
3091: BEGIN
3092:
3093: --Strip off the useful suffix (make sure its max 30chars)

Line 3157: FROM pay_trigger_events pte

3153: SELECT pte.event_id, pte.short_name,
3154: pte.triggering_action, pte.description,
3155: DECODE(pte.triggering_action, 'I','Insert','U','Update', 'D','Delete' ) info,
3156: enabled_flag,generated_flag
3157: FROM pay_trigger_events pte
3158: WHERE pte.table_name = (cp_name)
3159: AND nvl(pte.protected_flag,'N') <> 'Y';
3160:
3161: --

Line 3357: update pay_trigger_events

3353: and dated_table_id = l_tab_id;
3354: --
3355: FOR dyt_rec in csr_dyts_on_table(l_tab_name) LOOP
3356: if (p_ok) then --success so back to original
3357: update pay_trigger_events
3358: set generated_flag = l_flag,
3359: enabled_flag = dyt_rec.enabled_flag
3360: where event_id = dyt_rec.event_id;
3361: else

Line 3362: update pay_trigger_events --failure so disabled

3358: set generated_flag = l_flag,
3359: enabled_flag = dyt_rec.enabled_flag
3360: where event_id = dyt_rec.event_id;
3361: else
3362: update pay_trigger_events --failure so disabled
3363: set generated_flag = l_flag,
3364: enabled_flag = l_flag
3365: where event_id = dyt_rec.event_id;
3366: end if;

Line 3394: l_dyt_id pay_trigger_events.event_id%TYPE := p_dyt_id;

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;
3398: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;

Line 3395: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);

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;
3398: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;
3399:

Line 3396: l_dyt_act pay_trigger_events.triggering_action%TYPE := p_dyt_act;

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;
3398: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;
3399:
3400: l_sql varchar2(32000); --Used as a temp holder.

Line 3398: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;

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;
3398: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;
3399:
3400: l_sql varchar2(32000); --Used as a temp holder.
3401: i number;
3402: j number;

Line 3527: FROM pay_trigger_events pte

3523: CURSOR csr_dyts_on_tab(cp_name in VARCHAR2,cp_action in VARCHAR2) IS
3524: SELECT pte.event_id, pte.short_name,
3525: pte.triggering_action, pte.description,
3526: DECODE(pte.triggering_action, 'I','Insert','U','Update', 'D','Delete' ) info
3527: FROM pay_trigger_events pte
3528: WHERE pte.table_name = (cp_name)
3529: AND pte.triggering_action = (cp_action)
3530: AND nvl(pte.protected_flag,'N') <> 'Y';
3531:

Line 3683: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);

3679: ,p_dyn_pkg_params IN g_params_tab_type
3680: ,p_tab_dyt_pkg_name in varchar2
3681: ) IS
3682: --
3683: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3684: l_sql varchar2(32000); --Used as a temp holder.
3685: l_dbt_name varchar2(80);
3686: i number;
3687: j number;

Line 3789: FROM pay_trigger_events

3785: FUNCTION trigger_enabled(p_dyt varchar2) return BOOLEAN
3786: IS
3787: cursor csr_enabled(cp_dyt varchar2) is
3788: SELECT enabled_flag
3789: FROM pay_trigger_events
3790: where short_name = cp_dyt;
3791:
3792: l_flag varchar2(1);
3793:

Line 3823: select event_id,short_name from pay_trigger_events

3819: l_ok boolean;
3820: l_api_module_id number;
3821:
3822: cursor csr_dyt_ids(cp_table_name in varchar2) is
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

Line 4134: insert into pay_trigger_events (

4130: p_created_by in number,
4131: p_creation_date in date
4132: ) is
4133: begin
4134: insert into pay_trigger_events (
4135: event_id,
4136: table_name,
4137: short_name,
4138: description,

Line 4181: update pay_trigger_events

4177: p_created_by in number,
4178: p_creation_date in date
4179: ) is
4180: begin
4181: update pay_trigger_events
4182: set table_name = p_table_name,
4183: short_name = p_short_name,
4184: description = p_description,
4185: generated_flag = p_generated_flag,

Line 4201: delete from pay_trigger_events

4197: procedure del(
4198: p_event_id in number
4199: ) is
4200: begin
4201: delete from pay_trigger_events
4202: where event_id = p_event_id;
4203: end del;
4204: --
4205: procedure lck(

Line 4210: from pay_trigger_events

4206: p_event_id in number
4207: ) is
4208: cursor c_sel1 is
4209: select *
4210: from pay_trigger_events
4211: where event_id = p_event_id
4212: for update nowait;
4213: l_old_rec c_sel1%rowtype;
4214: --

Line 4239: fnd_message.set_token('table_name', 'pay_trigger_events');

4235: -- the object is locked therefore we need to supply a meaningful
4236: -- error message.
4237: --
4238: fnd_message.set_name('pay', 'hr_7165_object_locked');
4239: fnd_message.set_token('table_name', 'pay_trigger_events');
4240: fnd_message.raise_error;
4241: end lck;
4242: --
4243: FUNCTION is_table_valid(p_table IN VARCHAR2) RETURN VARCHAR2 IS