APPS.BEN_IREC_BACK_OUT_CONC dependencies on BEN_PERSON_ACTIONS

Line 57: l_person_id ben_person_actions.person_id%type;

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

Line 58: l_person_action_id ben_person_actions.person_action_id%type;

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

Line 59: l_object_version_number ben_person_actions.object_version_number%type;

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

Line 60: l_ler_id ben_person_actions.ler_id%type;

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

Line 91: from ben_person_actions ben

87: --
88: cursor c_person_thread is
89: select ben.person_id,
90: ben.person_action_id
91: from ben_person_actions ben
92: where ben.benefit_action_id = p_benefit_action_id
93: and ben.action_status_cd not in ('P','E')
94: and ben.person_action_id
95: between l_start_person_action_id

Line 323: update ben_person_actions

319: close c_ler_thread;
320: --
321: -- If we get here it was successful.
322: --
323: update ben_person_actions
324: set action_status_cd = 'P'
325: where person_id = l_person_id
326: and benefit_action_id = p_benefit_action_id;
327: --

Line 348: update ben_person_actions

344: --
345: rollback to last_place;
346: benutils.rollback_cache;
347: --
348: update ben_person_actions
349: set action_status_cd = 'E'
350: where person_id = l_person_id
351: and benefit_action_id = p_benefit_action_id;
352: --

Line 471: l_person_action_id ben_person_actions.person_action_id%type;

467: l_request_id number;
468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
469: l_object_version_number ben_benefit_actions.object_version_number%type;
470: l_person_id per_people_f.person_id%type;
471: l_person_action_id ben_person_actions.person_action_id%type;
472: l_ler_id ben_ler_f.ler_id%type;
473: l_range_id ben_batch_ranges.range_id%type;
474: l_chunk_size number := 20;
475: l_threads number := 1;

Line 720: Ben_person_actions_api.create_person_actions

716: --
717: If (not skip) then
718: --
719: hr_utility.set_location ('person passed selection rule '||l_person_id,35);
720: Ben_person_actions_api.create_person_actions
721: (p_validate => false
722: ,p_person_action_id => l_person_action_id
723: ,p_person_id => l_person_id
724: ,p_ler_id => l_ler_id