APPS.PAY_DYN_TRIGGERS dependencies on PAY_TRIGGER_PARAMETERS

Line 492: Inserts/Updates the PAY_TRIGGER_PARAMETERS table.

488: /*
489: NAME
490: create_trg_components
491: NOTES
492: Inserts/Updates the PAY_TRIGGER_PARAMETERS table.
493: */
494: procedure create_trg_parameter (p_short_name varchar2,
495: p_process_order varchar2,
496: p_legislative_code varchar2,

Line 580: update pay_trigger_parameters

576: where table_name = p_short_name;
577:
578: END IF;
579: --
580: update pay_trigger_parameters
581: set automatic = p_automatic,
582: value_name = p_value_name
583: where usage_id = l_usage_id
584: and usage_type = p_usage_type

Line 590: insert into pay_trigger_parameters

586: and upper(nvl(parameter_name, 'NULL')) =
587: upper(nvl(p_parameter_name, 'NULL'));
588: --
589: if (SQL%notfound) then
590: insert into pay_trigger_parameters
591: (
592: parameter_id,
593: usage_type,
594: usage_id,

Line 601: pay_trigger_parameters_s.nextval,

597: value_name,
598: automatic
599: )
600: select
601: pay_trigger_parameters_s.nextval,
602: p_usage_type,
603: l_usage_id,
604: p_parameter_type,
605: p_parameter_name,