[Home] [Help]
90: --
91: -- Local variable declaration
92: --
93: l_proc varchar2(80) := g_package||'.do_multithread';
94: l_person_id ben_person_actions.person_id%type;
95: l_person_action_id ben_person_actions.person_action_id%type;
96: l_object_version_number ben_person_actions.object_version_number%type;
97: l_ler_id ben_person_actions.ler_id%type;
98: l_range_id ben_batch_ranges.range_id%type;
91: -- Local variable declaration
92: --
93: l_proc varchar2(80) := g_package||'.do_multithread';
94: l_person_id ben_person_actions.person_id%type;
95: l_person_action_id ben_person_actions.person_action_id%type;
96: l_object_version_number ben_person_actions.object_version_number%type;
97: l_ler_id ben_person_actions.ler_id%type;
98: l_range_id ben_batch_ranges.range_id%type;
99: l_record_number number := 0;
92: --
93: l_proc varchar2(80) := g_package||'.do_multithread';
94: l_person_id ben_person_actions.person_id%type;
95: l_person_action_id ben_person_actions.person_action_id%type;
96: l_object_version_number ben_person_actions.object_version_number%type;
97: l_ler_id ben_person_actions.ler_id%type;
98: l_range_id ben_batch_ranges.range_id%type;
99: l_record_number number := 0;
100: l_start_person_action_id number := 0;
93: l_proc varchar2(80) := g_package||'.do_multithread';
94: l_person_id ben_person_actions.person_id%type;
95: l_person_action_id ben_person_actions.person_action_id%type;
96: l_object_version_number ben_person_actions.object_version_number%type;
97: l_ler_id ben_person_actions.ler_id%type;
98: l_range_id ben_batch_ranges.range_id%type;
99: l_record_number number := 0;
100: l_start_person_action_id number := 0;
101: l_end_person_action_id number := 0;
121: --
122: cursor c_person_thread is
123: select ben.person_id,
124: ben.person_action_id
125: from ben_person_actions ben
126: where ben.benefit_action_id = p_benefit_action_id
127: and ben.action_status_cd not in ('P','E')
128: and ben.person_action_id
129: between l_start_person_action_id
525: --
526:
527: /*Bug 9818852: When Back-out Life Events Process is run in Rollback mode, because of the
528: commit statement(after update statement), backed out results of successfully processed employees are committed.
529: When Back-out Life Events Process is run Rollback mode, only ben_person_actions table update should be commited.
530: For a employee for whom the results are successfully backed out, results should be rolled back */
531: hr_utility.set_location('before rollback',10);
532: if p_validate = 'Y' then
533: rollback to last_place;
560: --
561: -- If we get here it was successful.
562: --
563: hr_utility.set_location('before update',10);
564: update ben_person_actions
565: set action_status_cd = 'P'
566: where person_id = l_person_id
567: and benefit_action_id = p_benefit_action_id;
568: hr_utility.set_location('after update',10);
592: --
593: rollback to last_place;
594: benutils.rollback_cache;
595: --
596: update ben_person_actions
597: set action_status_cd = 'E'
598: where person_id = l_person_id
599: and benefit_action_id = p_benefit_action_id;
600: --
922: l_proc varchar2(80) := g_package||'.process';
923: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
924: l_object_version_number ben_benefit_actions.object_version_number%type;
925: l_person_id per_people_f.person_id%type;
926: l_person_action_id ben_person_actions.person_action_id%type;
927: l_ler_id ben_ler_f.ler_id%type;
928: l_range_id ben_batch_ranges.range_id%type;
929: l_chunk_size number := 20;
930: l_threads number := 1;
1059: -- Store person_id into person actions table.
1060: --
1061: If l_person_ok = 'Y' then
1062: --
1063: Ben_person_actions_api.create_person_actions
1064: (p_validate => false
1065: ,p_person_action_id => l_person_action_id
1066: ,p_person_id => l_person_id
1067: ,p_ler_id => l_ler_id