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 298: l_person_id ben_person_actions.person_id%type;

294: --
295: -- Local variable declaration
296: --
297: l_proc varchar2(80) := g_package||'.do_multithread';
298: l_person_id ben_person_actions.person_id%type;
299: l_person_action_id ben_person_actions.person_action_id%type;
300: l_object_version_number ben_person_actions.object_version_number%type;
301: l_ler_id ben_person_actions.ler_id%type;
302: l_range_id ben_batch_ranges.range_id%type;

Line 299: l_person_action_id ben_person_actions.person_action_id%type;

295: -- Local variable declaration
296: --
297: l_proc varchar2(80) := g_package||'.do_multithread';
298: l_person_id ben_person_actions.person_id%type;
299: l_person_action_id ben_person_actions.person_action_id%type;
300: l_object_version_number ben_person_actions.object_version_number%type;
301: l_ler_id ben_person_actions.ler_id%type;
302: l_range_id ben_batch_ranges.range_id%type;
303: l_record_number number := 0;

Line 300: l_object_version_number ben_person_actions.object_version_number%type;

296: --
297: l_proc varchar2(80) := g_package||'.do_multithread';
298: l_person_id ben_person_actions.person_id%type;
299: l_person_action_id ben_person_actions.person_action_id%type;
300: l_object_version_number ben_person_actions.object_version_number%type;
301: l_ler_id ben_person_actions.ler_id%type;
302: l_range_id ben_batch_ranges.range_id%type;
303: l_record_number number := 0;
304: l_start_person_action_id number := 0;

Line 301: l_ler_id ben_person_actions.ler_id%type;

297: l_proc varchar2(80) := g_package||'.do_multithread';
298: l_person_id ben_person_actions.person_id%type;
299: l_person_action_id ben_person_actions.person_action_id%type;
300: l_object_version_number ben_person_actions.object_version_number%type;
301: l_ler_id ben_person_actions.ler_id%type;
302: l_range_id ben_batch_ranges.range_id%type;
303: l_record_number number := 0;
304: l_start_person_action_id number := 0;
305: l_end_person_action_id number := 0;

Line 329: From ben_person_actions ben

325: Select ben.person_id
326: ,ben.person_action_id
327: ,ben.object_version_number
328: ,ben.ler_id
329: From ben_person_actions ben
330: Where ben.benefit_action_id = p_benefit_action_id
331: And ben.action_status_cd <> 'P'
332: And ben.person_action_id between
333: l_start_person_action_id and l_end_person_action_id

Line 755: l_person_action_id ben_person_actions.person_action_id%type;

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

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

908: --
909: -- Store person_id into person actions table.
910: --
911: If ( not skip) then
912: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
913: Ben_person_actions_api.create_person_actions
914: (p_validate => false
915: ,p_person_action_id => l_person_action_id
916: ,p_person_id => l_person_id

Line 913: Ben_person_actions_api.create_person_actions

909: -- Store person_id into person actions table.
910: --
911: If ( not skip) then
912: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
913: Ben_person_actions_api.create_person_actions
914: (p_validate => false
915: ,p_person_action_id => l_person_action_id
916: ,p_person_id => l_person_id
917: ,p_ler_id => 0

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

1840: End loop;
1841: --
1842: If p_person_action_id is not null then
1843: --
1844: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1845: --
1846: ben_person_actions_api.update_person_actions
1847: (p_person_action_id => p_person_action_id
1848: ,p_action_status_cd => 'P'

Line 1846: ben_person_actions_api.update_person_actions

1842: If p_person_action_id is not null then
1843: --
1844: l_actn := 'Calling ben_person_actions_api.update_person_actions...';
1845: --
1846: ben_person_actions_api.update_person_actions
1847: (p_person_action_id => p_person_action_id
1848: ,p_action_status_cd => 'P'
1849: ,p_object_version_number => p_object_version_number
1850: ,p_effective_date => p_effective_date

Line 1871: ben_person_actions_api.update_person_actions

1867: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1868: ,p_effective_date => p_effective_date
1869: );
1870: If p_person_action_id is not null then
1871: ben_person_actions_api.update_person_actions
1872: (p_person_action_id => p_person_action_id
1873: ,p_action_status_cd => 'E'
1874: ,p_object_version_number => p_object_version_number
1875: ,p_effective_date => p_effective_date