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 1732: pay_trigger_events pte

1728: pte.generated_flag, pte.enabled_flag,
1729: pdt.dated_table_id, nvl(pdt.dyn_trigger_type,'T'),
1730: pdt.dyn_trigger_package_name
1731: FROM pay_dated_tables pdt,
1732: pay_trigger_events pte
1733: WHERE pte.table_name = pdt.table_name(+)
1734: AND pte.event_id = cp_id;
1735: --
1736: l_table VARCHAR2(30);

Line 1798: update pay_trigger_events

1794: if (p_ok) then
1795: hr_utility.trace(' Database Trigger '||p_name||' created with success');
1796: else
1797: hr_utility.trace(' Database Trigger '||p_name||' created with failure');
1798: update pay_trigger_events
1799: set generated_flag = 'N', enabled_flag = 'N'
1800: where event_id = p_id;
1801: l_enb_flag := 'N';
1802: end if;

Line 1834: FROM pay_trigger_events pte,

1830: SELECT pte.event_id,
1831: pte.table_name,
1832: pts.header_code,
1833: pts.body_code
1834: FROM pay_trigger_events pte,
1835: pay_trigger_support pts
1836: WHERE pte.event_id = pts.event_id
1837: AND pts.support_id = cp_id;
1838: --

Line 1880: FROM pay_trigger_events pte

1876: -- Fetch to get some more information that we need
1877: CURSOR csr_name(cp_id IN NUMBER) IS
1878: SELECT pte.table_name,
1879: pte.triggering_action
1880: FROM pay_trigger_events pte
1881: WHERE pte.event_id = cp_id;
1882: --
1883: l_table VARCHAR2(30);
1884: l_action VARCHAR2(1);

Line 2416: l_table pay_trigger_events.table_name%TYPE;

2412: PROCEDURE generate_code(p_id IN NUMBER,p_sql IN OUT NOCOPY VARCHAR2) IS
2413: --
2414: l_inits BOOLEAN;
2415: l_comps BOOLEAN;
2416: l_table pay_trigger_events.table_name%TYPE;
2417: l_name pay_trigger_events.short_name%TYPE;
2418: l_type pay_trigger_events.triggering_action%TYPE;
2419: l_desc VARCHAR2(80);
2420: l_info pay_trigger_events.description%TYPE;

Line 2417: l_name pay_trigger_events.short_name%TYPE;

2413: --
2414: l_inits BOOLEAN;
2415: l_comps BOOLEAN;
2416: l_table pay_trigger_events.table_name%TYPE;
2417: l_name pay_trigger_events.short_name%TYPE;
2418: l_type pay_trigger_events.triggering_action%TYPE;
2419: l_desc VARCHAR2(80);
2420: l_info pay_trigger_events.description%TYPE;
2421:

Line 2418: l_type pay_trigger_events.triggering_action%TYPE;

2414: l_inits BOOLEAN;
2415: l_comps BOOLEAN;
2416: l_table pay_trigger_events.table_name%TYPE;
2417: l_name pay_trigger_events.short_name%TYPE;
2418: l_type pay_trigger_events.triggering_action%TYPE;
2419: l_desc VARCHAR2(80);
2420: l_info pay_trigger_events.description%TYPE;
2421:
2422: --

Line 2420: l_info pay_trigger_events.description%TYPE;

2416: l_table pay_trigger_events.table_name%TYPE;
2417: l_name pay_trigger_events.short_name%TYPE;
2418: l_type pay_trigger_events.triggering_action%TYPE;
2419: l_desc VARCHAR2(80);
2420: l_info pay_trigger_events.description%TYPE;
2421:
2422: --
2423: -- Get some extra information about the event we're generating code for
2424: CURSOR csr_name(cp_id IN NUMBER) IS

Line 2434: FROM pay_trigger_events pte

2430: 'U','Update',
2431: 'D','Delete'
2432: ),
2433: pte.description
2434: FROM pay_trigger_events pte
2435: WHERE pte.event_id = cp_id;
2436: --
2437: BEGIN
2438: --

Line 2526: FROM pay_trigger_events pte

2522: -- Get some more information we need before we can delete the event
2523: CURSOR get_trigger(cp_id IN NUMBER) IS
2524: SELECT pte.table_name,
2525: pte.triggering_action
2526: FROM pay_trigger_events pte
2527: WHERE pte.event_id = cp_id;
2528: --
2529: -- Get all the initialisations that this event uses
2530: CURSOR get_inits(cp_id IN NUMBER) IS

Line 2964: from pay_trigger_events te, pay_trigger_components tc

2960: FROM pay_trigger_parameters
2961: WHERE parameter_type IN ('I','O')
2962: AND value_name IS NOT NULL
2963: AND usage_id in (select component_id
2964: from pay_trigger_events te, pay_trigger_components tc
2965: where te.event_id = tc.event_id
2966: and triggering_action = cp_type
2967: and te.table_name = cp_table_name)
2968: AND usage_type = 'C'

Line 3126: l_suffix pay_trigger_events.short_name%TYPE;

3122: -- | last few chars as these are often the useful identifiers. |
3123: -- +---------------------------------------------------------------------------+
3124: FUNCTION get_dyt_proc_name(p_dyt_name IN VARCHAR2) RETURN varchar2 IS
3125:
3126: l_suffix pay_trigger_events.short_name%TYPE;
3127: l_proc_name varchar2(30);
3128: BEGIN
3129:
3130: --Strip off the useful suffix (make sure its max 30chars)

Line 3194: FROM pay_trigger_events pte

3190: SELECT pte.event_id, pte.short_name,
3191: pte.triggering_action, pte.description,
3192: DECODE(pte.triggering_action, 'I','Insert','U','Update', 'D','Delete' ) info,
3193: enabled_flag,generated_flag
3194: FROM pay_trigger_events pte
3195: WHERE pte.table_name = (cp_name)
3196: AND nvl(pte.protected_flag,'N') <> 'Y';
3197:
3198: --

Line 3395: update pay_trigger_events

3391: and dated_table_id = l_tab_id;
3392: --
3393: FOR dyt_rec in csr_dyts_on_table(l_tab_name) LOOP
3394: if (p_ok) then --success so back to original
3395: update pay_trigger_events
3396: set generated_flag = l_flag,
3397: enabled_flag = dyt_rec.enabled_flag
3398: where event_id = dyt_rec.event_id;
3399: else

Line 3400: update pay_trigger_events --failure so disabled

3396: set generated_flag = l_flag,
3397: enabled_flag = dyt_rec.enabled_flag
3398: where event_id = dyt_rec.event_id;
3399: else
3400: update pay_trigger_events --failure so disabled
3401: set generated_flag = l_flag,
3402: enabled_flag = l_flag
3403: where event_id = dyt_rec.event_id;
3404: end if;

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

3428: --
3429: l_inits BOOLEAN;
3430: l_comps BOOLEAN;
3431: l_tab_name pay_dated_tables.table_name%TYPE := p_tab_name;
3432: l_dyt_id pay_trigger_events.event_id%TYPE := p_dyt_id;
3433: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3434: l_dyt_act pay_trigger_events.triggering_action%TYPE := p_dyt_act;
3435: l_dyt_info varchar2(30) := p_dyt_info;
3436: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;

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

3429: l_inits BOOLEAN;
3430: l_comps BOOLEAN;
3431: l_tab_name pay_dated_tables.table_name%TYPE := p_tab_name;
3432: l_dyt_id pay_trigger_events.event_id%TYPE := p_dyt_id;
3433: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3434: l_dyt_act pay_trigger_events.triggering_action%TYPE := p_dyt_act;
3435: l_dyt_info varchar2(30) := p_dyt_info;
3436: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;
3437:

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

3430: l_comps BOOLEAN;
3431: l_tab_name pay_dated_tables.table_name%TYPE := p_tab_name;
3432: l_dyt_id pay_trigger_events.event_id%TYPE := p_dyt_id;
3433: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3434: l_dyt_act pay_trigger_events.triggering_action%TYPE := p_dyt_act;
3435: l_dyt_info varchar2(30) := p_dyt_info;
3436: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;
3437:
3438: l_sql varchar2(32000); --Used as a temp holder.

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

3432: l_dyt_id pay_trigger_events.event_id%TYPE := p_dyt_id;
3433: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3434: l_dyt_act pay_trigger_events.triggering_action%TYPE := p_dyt_act;
3435: l_dyt_info varchar2(30) := p_dyt_info;
3436: l_dyt_desc pay_trigger_events.description%TYPE := p_dyt_desc ;
3437:
3438: l_sql varchar2(32000); --Used as a temp holder.
3439: i number;
3440: j number;

Line 3565: FROM pay_trigger_events pte

3561: CURSOR csr_dyts_on_tab(cp_name in VARCHAR2,cp_action in VARCHAR2) IS
3562: SELECT pte.event_id, pte.short_name,
3563: pte.triggering_action, pte.description,
3564: DECODE(pte.triggering_action, 'I','Insert','U','Update', 'D','Delete' ) info
3565: FROM pay_trigger_events pte
3566: WHERE pte.table_name = (cp_name)
3567: AND pte.triggering_action = (cp_action)
3568: AND nvl(pte.protected_flag,'N') <> 'Y';
3569:

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

3717: ,p_dyn_pkg_params IN g_params_tab_type
3718: ,p_tab_dyt_pkg_name in varchar2
3719: ) IS
3720: --
3721: l_dyt_name pay_trigger_events.short_name%TYPE := get_dyt_proc_name(p_dyt_name);
3722: l_sql varchar2(32000); --Used as a temp holder.
3723: l_dbt_name varchar2(80);
3724: i number;
3725: j number;

Line 3827: FROM pay_trigger_events

3823: FUNCTION trigger_enabled(p_dyt varchar2) return BOOLEAN
3824: IS
3825: cursor csr_enabled(cp_dyt varchar2) is
3826: SELECT enabled_flag
3827: FROM pay_trigger_events
3828: where short_name = cp_dyt;
3829:
3830: l_flag varchar2(1);
3831:

Line 3861: select event_id,short_name from pay_trigger_events

3857: l_ok boolean;
3858: l_api_module_id number;
3859:
3860: cursor csr_dyt_ids(cp_table_name in varchar2) is
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

Line 4172: insert into pay_trigger_events (

4168: p_created_by in number,
4169: p_creation_date in date
4170: ) is
4171: begin
4172: insert into pay_trigger_events (
4173: event_id,
4174: table_name,
4175: short_name,
4176: description,

Line 4219: update pay_trigger_events

4215: p_created_by in number,
4216: p_creation_date in date
4217: ) is
4218: begin
4219: update pay_trigger_events
4220: set table_name = p_table_name,
4221: short_name = p_short_name,
4222: description = p_description,
4223: generated_flag = p_generated_flag,

Line 4239: delete from pay_trigger_events

4235: procedure del(
4236: p_event_id in number
4237: ) is
4238: begin
4239: delete from pay_trigger_events
4240: where event_id = p_event_id;
4241: end del;
4242: --
4243: procedure lck(

Line 4248: from pay_trigger_events

4244: p_event_id in number
4245: ) is
4246: cursor c_sel1 is
4247: select *
4248: from pay_trigger_events
4249: where event_id = p_event_id
4250: for update nowait;
4251: l_old_rec c_sel1%rowtype;
4252: --

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

4273: -- the object is locked therefore we need to supply a meaningful
4274: -- error message.
4275: --
4276: fnd_message.set_name('pay', 'hr_7165_object_locked');
4277: fnd_message.set_token('table_name', 'pay_trigger_events');
4278: fnd_message.raise_error;
4279: end lck;
4280: --
4281: FUNCTION is_table_valid(p_table IN VARCHAR2) RETURN VARCHAR2 IS