APPS.BEN_EVALUATE_ELIG_CONC dependencies on BEN_PERSON_ACTIONS

Line 55: l_person_id ben_person_actions.person_id%type;

51: --
52: -- Local variable declaration
53: --
54: l_proc varchar2(80) := g_package||'.do_multithread';
55: l_person_id ben_person_actions.person_id%type;
56: l_person_action_id ben_person_actions.person_action_id%type;
57: l_object_version_number ben_person_actions.object_version_number%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;

Line 56: l_person_action_id ben_person_actions.person_action_id%type;

52: -- Local variable declaration
53: --
54: l_proc varchar2(80) := g_package||'.do_multithread';
55: l_person_id ben_person_actions.person_id%type;
56: l_person_action_id ben_person_actions.person_action_id%type;
57: l_object_version_number ben_person_actions.object_version_number%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;
60: l_start_person_action_id number := 0;

Line 57: l_object_version_number ben_person_actions.object_version_number%type;

53: --
54: l_proc varchar2(80) := g_package||'.do_multithread';
55: l_person_id ben_person_actions.person_id%type;
56: l_person_action_id ben_person_actions.person_action_id%type;
57: l_object_version_number ben_person_actions.object_version_number%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;
60: l_start_person_action_id number := 0;
61: l_end_person_action_id number := 0;

Line 85: from ben_person_actions ben

81: --
82: cursor c_person_thread is
83: select ben.person_id,
84: ben.person_action_id
85: from ben_person_actions ben
86: where ben.benefit_action_id = p_benefit_action_id
87: and ben.action_status_cd not in ('P','E')
88: and ben.person_action_id
89: between l_start_person_action_id

Line 268: update ben_person_actions

264: benutils.write(p_rec => g_rec);
265: --
266: -- If we get here it was successful.
267: --
268: update ben_person_actions
269: set action_status_cd = 'P'
270: where person_id = l_person_id
271: and benefit_action_id = p_benefit_action_id;
272: --

Line 285: update ben_person_actions

281: hr_utility.set_location(sqlerrm,10);
282: rollback to last_place;
283: benutils.rollback_cache;
284: --
285: update ben_person_actions
286: set action_status_cd = 'E'
287: where person_id = l_person_id
288: and benefit_action_id = p_benefit_action_id;
289: --

Line 541: l_person_action_id ben_person_actions.person_action_id%type;

537: l_proc varchar2(80) := g_package||'.process';
538: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
539: l_object_version_number ben_benefit_actions.object_version_number%type;
540: l_person_id per_people_f.person_id%type;
541: l_person_action_id ben_person_actions.person_action_id%type;
542: l_ler_id ben_ler_f.ler_id%type;
543: l_range_id ben_batch_ranges.range_id%type;
544: l_chunk_size number := 20;
545: l_threads number := 1;

Line 666: Ben_person_actions_api.create_person_actions

662: -- Store person_id into person actions table.
663: --
664: If (not skip) then
665: --
666: Ben_person_actions_api.create_person_actions
667: (p_validate => false
668: ,p_person_action_id => l_person_action_id
669: ,p_person_id => l_person_id
670: ,p_benefit_action_id => l_benefit_action_id