APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_PERSON_ACTIONS

Line 316: l_person_id ben_person_actions.person_id%type;

312: --
313: -- Local variable declaration
314: --
315: l_proc varchar2(80) := g_package||'.do_multithread';
316: l_person_id ben_person_actions.person_id%type;
317: l_person_action_id ben_person_actions.person_action_id%type;
318: l_object_version_number ben_person_actions.object_version_number%type;
319: l_ler_id ben_person_actions.ler_id%type;
320: l_range_id ben_batch_ranges.range_id%type;

Line 317: l_person_action_id ben_person_actions.person_action_id%type;

313: -- Local variable declaration
314: --
315: l_proc varchar2(80) := g_package||'.do_multithread';
316: l_person_id ben_person_actions.person_id%type;
317: l_person_action_id ben_person_actions.person_action_id%type;
318: l_object_version_number ben_person_actions.object_version_number%type;
319: l_ler_id ben_person_actions.ler_id%type;
320: l_range_id ben_batch_ranges.range_id%type;
321: l_record_number number := 0;

Line 318: l_object_version_number ben_person_actions.object_version_number%type;

314: --
315: l_proc varchar2(80) := g_package||'.do_multithread';
316: l_person_id ben_person_actions.person_id%type;
317: l_person_action_id ben_person_actions.person_action_id%type;
318: l_object_version_number ben_person_actions.object_version_number%type;
319: l_ler_id ben_person_actions.ler_id%type;
320: l_range_id ben_batch_ranges.range_id%type;
321: l_record_number number := 0;
322: l_start_person_action_id number := 0;

Line 319: l_ler_id ben_person_actions.ler_id%type;

315: l_proc varchar2(80) := g_package||'.do_multithread';
316: l_person_id ben_person_actions.person_id%type;
317: l_person_action_id ben_person_actions.person_action_id%type;
318: l_object_version_number ben_person_actions.object_version_number%type;
319: l_ler_id ben_person_actions.ler_id%type;
320: l_range_id ben_batch_ranges.range_id%type;
321: l_record_number number := 0;
322: l_start_person_action_id number := 0;
323: l_end_person_action_id number := 0;

Line 348: from ben_person_actions ben

344: --
345: cursor c_person_thread is
346: select ben.person_id,
347: ben.person_action_id
348: from ben_person_actions ben
349: where ben.benefit_action_id = p_benefit_action_id
350: and ben.action_status_cd not in ('P','E')
351: and ben.person_action_id
352: between l_start_person_action_id

Line 591: update ben_person_actions

587: l_popl_cnt := 0;
588: --
589: -- If we get here it was successful.
590: --
591: update ben_person_actions
592: set action_status_cd = 'P'
593: where person_id = l_person_id
594: and benefit_action_id = p_benefit_action_id;
595: --

Line 614: update ben_person_actions

610: --
611: rollback to last_place;
612: benutils.rollback_cache;
613: --
614: update ben_person_actions
615: set action_status_cd = 'E'
616: where person_id = l_person_id
617: and benefit_action_id = p_benefit_action_id;
618: --

Line 972: l_person_action_id ben_person_actions.person_action_id%type;

968: l_proc varchar2(80) := g_package||'.process';
969: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
970: l_object_version_number ben_benefit_actions.object_version_number%type;
971: l_person_id per_people_f.person_id%type;
972: l_person_action_id ben_person_actions.person_action_id%type;
973: l_ler_id ben_ler_f.ler_id%type;
974: l_range_id ben_batch_ranges.range_id%type;
975: l_chunk_size number := 20;
976: l_threads number := 1;

Line 1139: Ben_person_actions_api.create_person_actions

1135: -- Store person_id into person actions table.
1136: --
1137: If l_person_ok = 'Y' then
1138: --
1139: Ben_person_actions_api.create_person_actions
1140: (p_validate => false
1141: ,p_person_action_id => l_person_action_id
1142: ,p_person_id => l_person_id
1143: ,p_ler_id => l_ler_id