APPS.PAY_DYN_TRIGGERS dependencies on PAY_TRIGGER_COMPONENTS

Line 75: update pay_trigger_components

71: begin
72: --
73: for trgrec in get_trg loop
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',

Line 388: Inserts/Updates the PAY_TRIGGER_COMPONENTS table.

384: /*
385: NAME
386: create_trg_components
387: NOTES
388: Inserts/Updates the PAY_TRIGGER_COMPONENTS table.
389: */
390: procedure create_trg_components (
391: p_short_name varchar2,
392: p_legislative_code varchar2,

Line 403: l_enabled pay_trigger_components.enabled_flag%TYPE;

399: is
400: l_event_id number;
401: l_bus_grp_id number;
402: l_payroll_id number;
403: l_enabled pay_trigger_components.enabled_flag%TYPE;
404: begin
405: --
406: if (p_business_group is null) then
407: l_bus_grp_id := null;

Line 439: from pay_trigger_components

435: begin
436: -- Check if the component we want to create already exists
437: select enabled_flag
438: into l_enabled
439: from pay_trigger_components
440: where event_id = l_event_id
441: and nvl(p_legislative_code, 'CORE') = nvl (legislation_code, 'CORE')
442: and nvl(l_bus_grp_id, -1) = nvl(business_group_id, -1)
443: and nvl(l_payroll_id, -1) = nvl(payroll_id, -1)

Line 451: update pay_trigger_components

447: when others then null; -- Catch everything, leave enabled as default
448: end;
449: --
450: /* Removed 12-Apr-2001 by exjones
451: update pay_trigger_components
452: set enabled_flag = p_enabled_flag
453: where event_id = l_event_id
454: and nvl(p_legislative_code, 'CORE') = nvl (legislation_code, 'CORE')
455: and nvl(l_bus_grp_id, -1) = nvl(business_group_id, -1)

Line 463: insert into pay_trigger_components

459: --
460: /* if (SQL%notfound) then */
461: -- Need to create this component
462: if (l_enabled = 'C') then
463: insert into pay_trigger_components
464: (
465: component_id,
466: event_id,
467: legislation_code,

Line 474: pay_trigger_components_s.nextval,

470: module_name,
471: enabled_flag
472: )
473: select
474: pay_trigger_components_s.nextval,
475: l_event_id,
476: p_legislative_code,
477: l_bus_grp_id,
478: l_payroll_id,

Line 547: from pay_trigger_components

543: end if;
544: --
545: select component_id
546: into l_usage_id
547: from pay_trigger_components
548: where event_id = l_event_id
549: and nvl(p_legislative_code, 'CORE') = nvl (legislation_code, 'CORE')
550: and nvl(l_bus_grp_id, -1) = nvl(business_group_id, -1)
551: and nvl(l_payroll_id, -1) = nvl(payroll_id, -1)