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.PAY_DYN_TRIGGERS dependencies on PAY_TRIGGER_EVENTS

Line 66: pay_trigger_events pte

62: select pte.short_name,
63: pte.event_id
64: from pay_functional_areas pfa,
65: pay_functional_triggers pft,
66: pay_trigger_events pte
67: where pte.event_id = pft.event_id
68: and pft.area_id = pfa.area_id
69: and pfa.short_name = p_short_name;
70: --

Line 78: update pay_trigger_events

74: --
75: update pay_trigger_components
76: set enabled_flag = 'Y'
77: where event_id = trgrec.event_id;
78: update pay_trigger_events
79: set generated_flag = 'Y',
80: enabled_flag = 'Y'
81: where event_id = trgrec.event_id;
82: --

Line 110: pay_trigger_events pte

106: cursor get_trg is
107: select distinct pte.short_name
108: from pay_functional_areas pfa,
109: pay_functional_triggers pft,
110: pay_trigger_events pte
111: where pte.event_id = pft.event_id
112: and pft.area_id = pfa.area_id
113: and pfa.short_name like p_short_name;
114: begin

Line 131: l_table_name pay_trigger_events.table_name%TYPE;

127: Generates and enables the trigger if the relevent flags are set.
128: */
129: procedure generate_trigger_event(p_short_name varchar2)
130: is
131: l_table_name pay_trigger_events.table_name%TYPE;
132: l_triggering_action pay_trigger_events.triggering_action%TYPE;
133: l_protected_flag pay_trigger_events.protected_flag%TYPE;
134: l_generated_flag pay_trigger_events.generated_flag%TYPE;
135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;

Line 132: l_triggering_action pay_trigger_events.triggering_action%TYPE;

128: */
129: procedure generate_trigger_event(p_short_name varchar2)
130: is
131: l_table_name pay_trigger_events.table_name%TYPE;
132: l_triggering_action pay_trigger_events.triggering_action%TYPE;
133: l_protected_flag pay_trigger_events.protected_flag%TYPE;
134: l_generated_flag pay_trigger_events.generated_flag%TYPE;
135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
136: l_event_id pay_trigger_events.event_id%TYPE;

Line 133: l_protected_flag pay_trigger_events.protected_flag%TYPE;

129: procedure generate_trigger_event(p_short_name varchar2)
130: is
131: l_table_name pay_trigger_events.table_name%TYPE;
132: l_triggering_action pay_trigger_events.triggering_action%TYPE;
133: l_protected_flag pay_trigger_events.protected_flag%TYPE;
134: l_generated_flag pay_trigger_events.generated_flag%TYPE;
135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
136: l_event_id pay_trigger_events.event_id%TYPE;
137: l_trigger_name varchar2(50);

Line 134: l_generated_flag pay_trigger_events.generated_flag%TYPE;

130: is
131: l_table_name pay_trigger_events.table_name%TYPE;
132: l_triggering_action pay_trigger_events.triggering_action%TYPE;
133: l_protected_flag pay_trigger_events.protected_flag%TYPE;
134: l_generated_flag pay_trigger_events.generated_flag%TYPE;
135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
136: l_event_id pay_trigger_events.event_id%TYPE;
137: l_trigger_name varchar2(50);
138: l_sql varchar2(32767);

Line 135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;

131: l_table_name pay_trigger_events.table_name%TYPE;
132: l_triggering_action pay_trigger_events.triggering_action%TYPE;
133: l_protected_flag pay_trigger_events.protected_flag%TYPE;
134: l_generated_flag pay_trigger_events.generated_flag%TYPE;
135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
136: l_event_id pay_trigger_events.event_id%TYPE;
137: l_trigger_name varchar2(50);
138: l_sql varchar2(32767);
139:

Line 136: l_event_id pay_trigger_events.event_id%TYPE;

132: l_triggering_action pay_trigger_events.triggering_action%TYPE;
133: l_protected_flag pay_trigger_events.protected_flag%TYPE;
134: l_generated_flag pay_trigger_events.generated_flag%TYPE;
135: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
136: l_event_id pay_trigger_events.event_id%TYPE;
137: l_trigger_name varchar2(50);
138: l_sql varchar2(32767);
139:
140: l_dyt_type pay_dated_tables.dyn_trigger_type%TYPE;

Line 161: from pay_trigger_events pte,

157: l_triggering_action,
158: l_protected_flag,
159: l_dyt_type,
160: l_tab_id
161: from pay_trigger_events pte,
162: pay_dated_tables pdt
163: where pte.table_name = pdt.table_name(+)
164: and pte.short_name = p_short_name;
165: --

Line 207: Inserts/Updates the PAY_TRIGGER_EVENTS table.

203: /*
204: NAME
205: create_trigger_event
206: NOTES
207: Inserts/Updates the PAY_TRIGGER_EVENTS table.
208: */
209: procedure create_trigger_event (
210: p_short_name varchar2,
211: p_table_name varchar2,

Line 220: l_generated_flag pay_trigger_events.generated_flag%TYPE;

216: p_owner varchar2,
217: p_protected_flag varchar2 default 'N'
218: )
219: is
220: l_generated_flag pay_trigger_events.generated_flag%TYPE;
221: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
222: l_event_id pay_trigger_events.event_id%TYPE;
223: l_trigger_name varchar2(50);
224: begin

Line 221: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;

217: p_protected_flag varchar2 default 'N'
218: )
219: is
220: l_generated_flag pay_trigger_events.generated_flag%TYPE;
221: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
222: l_event_id pay_trigger_events.event_id%TYPE;
223: l_trigger_name varchar2(50);
224: begin
225: --

Line 222: l_event_id pay_trigger_events.event_id%TYPE;

218: )
219: is
220: l_generated_flag pay_trigger_events.generated_flag%TYPE;
221: l_enabled_flag pay_trigger_events.enabled_flag%TYPE;
222: l_event_id pay_trigger_events.event_id%TYPE;
223: l_trigger_name varchar2(50);
224: begin
225: --
226: begin

Line 234: from pay_trigger_events

230: event_id
231: into l_generated_flag,
232: l_enabled_flag,
233: l_event_id
234: from pay_trigger_events
235: where short_name = p_short_name;
236: --
237: if (l_generated_flag = 'Y') then
238: -- Need to drop trigger

Line 246: update pay_trigger_events

242: p_triggering_action);
243: paywsdyg_pkg.drop_trigger(l_trigger_name);
244: end if;
245: --
246: update pay_trigger_events
247: set
248: table_name = p_table_name,
249: triggering_action = p_triggering_action,
250: description = p_description,

Line 258: insert into pay_trigger_events

254: where short_name = p_short_name;
255: --
256: exception
257: when no_data_found then
258: insert into pay_trigger_events
259: (
260: event_id,
261: table_name,
262: description,

Line 270: pay_trigger_events_s.nextval,

266: short_name,
267: protected_flag
268: )
269: select
270: pay_trigger_events_s.nextval,
271: p_table_name,
272: p_description,
273: p_generated_flag,
274: p_enabled_flag,

Line 303: from pay_trigger_events

299: begin
300: --
301: select event_id
302: into l_event_id
303: from pay_trigger_events
304: where short_name = p_short_name;
305: --
306: update pay_trigger_declarations
307: set data_type = p_data_type,

Line 353: from pay_trigger_events

349: begin
350: --
351: select event_id
352: into l_event_id
353: from pay_trigger_events
354: where short_name = p_short_name;
355: --
356: update pay_trigger_initialisations
357: set plsql_code = p_plsql_code,

Line 431: from pay_trigger_events

427: end if;
428: --
429: select event_id
430: into l_event_id
431: from pay_trigger_events
432: where short_name = p_short_name;
433: --
434: l_enabled := 'X'; -- Default
435: begin

Line 519: from pay_trigger_events

515: IF (p_usage_type = 'C') then
516:
517: select event_id
518: into l_event_id
519: from pay_trigger_events
520: where short_name = p_short_name;
521:
522: if (p_business_group is null) then
523: l_bus_grp_id := null;

Line 560: from pay_trigger_events

556: -- It must be an initialisation.
557: --
558: select event_id
559: into l_event_id
560: from pay_trigger_events
561: where short_name = p_short_name;
562:
563: select initialisation_id
564: into l_usage_id

Line 669: from pay_trigger_events

665: begin
666: --
667: select event_id
668: into l_event_id
669: from pay_trigger_events
670: where short_name = p_short_name;
671: --
672: select area_id
673: into l_area_id