APPS.PAY_DYN_TRIGGERS dependencies on PAY_TRIGGER_DECLARATIONS

Line 288: Inserts/Updates the PAY_TRIGGER_DECLARATIONS table.

284: /*
285: NAME
286: create_trg_declaration
287: NOTES
288: Inserts/Updates the PAY_TRIGGER_DECLARATIONS table.
289: */
290: procedure create_trg_declaration (
291: p_short_name varchar2,
292: p_variable_name varchar2,

Line 306: update pay_trigger_declarations

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,
308: variable_size = p_variable_size
309: where event_id = l_event_id
310: and variable_name = p_variable_name;

Line 313: insert into pay_trigger_declarations

309: where event_id = l_event_id
310: and variable_name = p_variable_name;
311: --
312: if (SQL%notfound) then
313: insert into pay_trigger_declarations
314: (
315: declaration_id,
316: event_id,
317: variable_name,

Line 322: pay_trigger_declarations_s.nextval,

318: data_type,
319: variable_size
320: )
321: select
322: pay_trigger_declarations_s.nextval,
323: l_event_id,
324: p_variable_name,
325: p_data_type,
326: p_variable_size