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.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_PERSON_ACTIONS

Line 412: l_person_id ben_person_actions.person_id%type;

408: --
409: -- Local variable declaration
410: --
411: l_proc varchar2(80) := g_package||'.do_multithread';
412: l_person_id ben_person_actions.person_id%type;
413: l_person_action_id ben_person_actions.person_action_id%type;
414: l_object_version_number ben_person_actions.object_version_number%type;
415: l_ler_id ben_person_actions.ler_id%type;
416: l_range_id ben_batch_ranges.range_id%type;

Line 413: l_person_action_id ben_person_actions.person_action_id%type;

409: -- Local variable declaration
410: --
411: l_proc varchar2(80) := g_package||'.do_multithread';
412: l_person_id ben_person_actions.person_id%type;
413: l_person_action_id ben_person_actions.person_action_id%type;
414: l_object_version_number ben_person_actions.object_version_number%type;
415: l_ler_id ben_person_actions.ler_id%type;
416: l_range_id ben_batch_ranges.range_id%type;
417: l_record_number number := 0;

Line 414: l_object_version_number ben_person_actions.object_version_number%type;

410: --
411: l_proc varchar2(80) := g_package||'.do_multithread';
412: l_person_id ben_person_actions.person_id%type;
413: l_person_action_id ben_person_actions.person_action_id%type;
414: l_object_version_number ben_person_actions.object_version_number%type;
415: l_ler_id ben_person_actions.ler_id%type;
416: l_range_id ben_batch_ranges.range_id%type;
417: l_record_number number := 0;
418: l_start_person_action_id number := 0;

Line 415: l_ler_id ben_person_actions.ler_id%type;

411: l_proc varchar2(80) := g_package||'.do_multithread';
412: l_person_id ben_person_actions.person_id%type;
413: l_person_action_id ben_person_actions.person_action_id%type;
414: l_object_version_number ben_person_actions.object_version_number%type;
415: l_ler_id ben_person_actions.ler_id%type;
416: l_range_id ben_batch_ranges.range_id%type;
417: l_record_number number := 0;
418: l_start_person_action_id number := 0;
419: l_end_person_action_id number := 0;

Line 443: From ben_person_actions ben

439: Select ben.person_id
440: ,ben.person_action_id
441: ,ben.object_version_number
442: ,ben.ler_id
443: From ben_person_actions ben
444: Where ben.benefit_action_id = p_benefit_action_id
445: And ben.action_status_cd <> 'P'
446: And ben.person_action_id between
447: l_start_person_action_id and l_end_person_action_id

Line 1026: select ben_person_actions_s.nextval

1022: l_person_action_id.extend(1);
1023: --
1024: -- Get Primary Key value
1025: --
1026: select ben_person_actions_s.nextval
1027: into l_person_action_id(l_num_rows)
1028: from sys.dual;
1029: --
1030: -- Extend person_id type

Line 1041: insert into ben_person_actions

1037: -- Bulk bind in person actions
1038: --
1039: forall l_count in 1..l_num_rows
1040: --
1041: insert into ben_person_actions
1042: (person_action_id,
1043: person_id,
1044: ler_id,
1045: benefit_action_id,

Line 1107: insert into ben_person_actions

1103: forall l_count in 1..l_num_rows
1104: --
1105: -- Bulk bind in person actions
1106: --
1107: insert into ben_person_actions
1108: (person_action_id,
1109: person_id,
1110: ler_id,
1111: benefit_action_id,

Line 2028: l_actn := 'Calling ben_person_actions_api.update_person_actions...';

2024: );
2025: --
2026: If p_person_action_id is not null then
2027: --
2028: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
2029: --
2030: update ben_person_actions
2031: set action_status_cd = 'P'
2032: where person_action_id = p_person_action_id;

Line 2030: update ben_person_actions

2026: If p_person_action_id is not null then
2027: --
2028: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
2029: --
2030: update ben_person_actions
2031: set action_status_cd = 'P'
2032: where person_action_id = p_person_action_id;
2033: --
2034: End if;

Line 2074: ben_person_actions_api.update_person_actions

2070: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
2071: ,p_effective_date => p_effective_date
2072: );
2073: If p_person_action_id is not null then
2074: ben_person_actions_api.update_person_actions
2075: (p_person_action_id => p_person_action_id
2076: ,p_action_status_cd => 'E'
2077: ,p_object_version_number => p_object_version_number
2078: ,p_effective_date => p_effective_date