APPS.PAY_DYN_TRIGGERS dependencies on PAY_TRIGGER_INITIALISATIONS

Line 338: Inserts/Updates the PAY_TRIGGER_INITIALISATIONS table.

334: /*
335: NAME
336: create_trg_initialisation
337: NOTES
338: Inserts/Updates the PAY_TRIGGER_INITIALISATIONS table.
339: */
340: procedure create_trg_initialisation (
341: p_short_name varchar2,
342: p_process_order varchar2,

Line 356: update pay_trigger_initialisations

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,
358: process_type = p_process_type
359: where event_id = l_event_id
360: and process_order = p_process_order;

Line 363: insert into pay_trigger_initialisations

359: where event_id = l_event_id
360: and process_order = p_process_order;
361: --
362: if (SQL%notfound) then
363: insert into pay_trigger_initialisations
364: (
365: initialisation_id,
366: event_id,
367: process_order,

Line 372: pay_trigger_initialisations_s.nextval,

368: plsql_code,
369: process_type
370: )
371: select
372: pay_trigger_initialisations_s.nextval,
373: l_event_id,
374: p_process_order,
375: p_plsql_code,
376: p_process_type

Line 565: from pay_trigger_initialisations

561: where short_name = p_short_name;
562:
563: select initialisation_id
564: into l_usage_id
565: from pay_trigger_initialisations
566: where event_id = l_event_id
567: and process_order = p_process_order;
568: --
569: ELSE