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_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PERSON_ACTIONS

Line 303: l_person_id ben_person_actions.person_id%type;

299: --
300: -- Local variable declaration
301: --
302: l_proc varchar2(80) := g_package||'.do_multithread';
303: l_person_id ben_person_actions.person_id%type;
304: l_person_action_id ben_person_actions.person_action_id%type;
305: l_object_version_number ben_person_actions.object_version_number%type;
306: l_ler_id ben_person_actions.ler_id%type;
307: l_range_id ben_batch_ranges.range_id%type;

Line 304: l_person_action_id ben_person_actions.person_action_id%type;

300: -- Local variable declaration
301: --
302: l_proc varchar2(80) := g_package||'.do_multithread';
303: l_person_id ben_person_actions.person_id%type;
304: l_person_action_id ben_person_actions.person_action_id%type;
305: l_object_version_number ben_person_actions.object_version_number%type;
306: l_ler_id ben_person_actions.ler_id%type;
307: l_range_id ben_batch_ranges.range_id%type;
308: l_record_number number := 0;

Line 305: l_object_version_number ben_person_actions.object_version_number%type;

301: --
302: l_proc varchar2(80) := g_package||'.do_multithread';
303: l_person_id ben_person_actions.person_id%type;
304: l_person_action_id ben_person_actions.person_action_id%type;
305: l_object_version_number ben_person_actions.object_version_number%type;
306: l_ler_id ben_person_actions.ler_id%type;
307: l_range_id ben_batch_ranges.range_id%type;
308: l_record_number number := 0;
309: l_start_person_action_id number := 0;

Line 306: l_ler_id ben_person_actions.ler_id%type;

302: l_proc varchar2(80) := g_package||'.do_multithread';
303: l_person_id ben_person_actions.person_id%type;
304: l_person_action_id ben_person_actions.person_action_id%type;
305: l_object_version_number ben_person_actions.object_version_number%type;
306: l_ler_id ben_person_actions.ler_id%type;
307: l_range_id ben_batch_ranges.range_id%type;
308: l_record_number number := 0;
309: l_start_person_action_id number := 0;
310: l_end_person_action_id number := 0;

Line 334: From ben_person_actions ben

330: Select ben.person_id
331: ,ben.person_action_id
332: ,ben.object_version_number
333: ,ben.ler_id
334: From ben_person_actions ben
335: Where ben.benefit_action_id = p_benefit_action_id
336: And ben.action_status_cd <> 'P'
337: And ben.person_action_id between
338: l_start_person_action_id and l_end_person_action_id

Line 760: l_person_action_id ben_person_actions.person_action_id%type;

756: l_proc varchar2(80) := g_package||'.process';
757: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
758: l_object_version_number ben_benefit_actions.object_version_number%type;
759: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;
760: l_person_action_id ben_person_actions.person_action_id%type;
761: l_ler_id ben_ler_f.ler_id%type;
762: l_range_id ben_batch_ranges.range_id%type;
763: l_chunk_size number := 20;
764: l_threads number := 1;

Line 917: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';

913: --
914: -- Store person_id into person actions table.
915: --
916: If ( not skip) then
917: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
918: Ben_person_actions_api.create_person_actions
919: (p_validate => false
920: ,p_person_action_id => l_person_action_id
921: ,p_person_id => l_person_id

Line 918: Ben_person_actions_api.create_person_actions

914: -- Store person_id into person actions table.
915: --
916: If ( not skip) then
917: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
918: Ben_person_actions_api.create_person_actions
919: (p_validate => false
920: ,p_person_action_id => l_person_action_id
921: ,p_person_id => l_person_id
922: ,p_ler_id => 0

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

1861: End loop;
1862: --
1863: If p_person_action_id is not null then
1864: --
1865: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1866: --
1867: ben_person_actions_api.update_person_actions
1868: (p_person_action_id => p_person_action_id
1869: ,p_action_status_cd => 'P'

Line 1867: ben_person_actions_api.update_person_actions

1863: If p_person_action_id is not null then
1864: --
1865: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1866: --
1867: ben_person_actions_api.update_person_actions
1868: (p_person_action_id => p_person_action_id
1869: ,p_action_status_cd => 'P'
1870: ,p_object_version_number => p_object_version_number
1871: ,p_effective_date => p_effective_date

Line 1892: ben_person_actions_api.update_person_actions

1888: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1889: ,p_effective_date => p_effective_date
1890: );
1891: If p_person_action_id is not null then
1892: ben_person_actions_api.update_person_actions
1893: (p_person_action_id => p_person_action_id
1894: ,p_action_status_cd => 'E'
1895: ,p_object_version_number => p_object_version_number
1896: ,p_effective_date => p_effective_date