APPS.BEN_BACK_OUT_CONC dependencies on BEN_BATCH_RANGES

Line 93: l_range_id ben_batch_ranges.range_id%type;

89: l_person_id ben_person_actions.person_id%type;
90: l_person_action_id ben_person_actions.person_action_id%type;
91: l_object_version_number ben_person_actions.object_version_number%type;
92: l_ler_id ben_person_actions.ler_id%type;
93: l_range_id ben_batch_ranges.range_id%type;
94: l_record_number number := 0;
95: l_start_person_action_id number := 0;
96: l_end_person_action_id number := 0;
97: l_actn varchar2(80);

Line 111: From ben_batch_ranges ran

107: Cursor c_range_thread is
108: Select ran.range_id
109: ,ran.starting_person_action_id
110: ,ran.ending_person_action_id
111: From ben_batch_ranges ran
112: Where ran.range_status_cd = 'U'
113: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
114: And rownum < 2
115: For update of ran.range_status_cd;

Line 387: update ben_batch_ranges ran

383: hr_utility.set_location('range Found',10);
384: --
385: close c_range_thread;
386: --
387: update ben_batch_ranges ran
388: set ran.range_status_cd = 'P'
389: where ran.range_id = l_range_id;
390: --
391: commit;

Line 902: l_range_id ben_batch_ranges.range_id%type;

898: l_object_version_number ben_benefit_actions.object_version_number%type;
899: l_person_id per_people_f.person_id%type;
900: l_person_action_id ben_person_actions.person_action_id%type;
901: l_ler_id ben_ler_f.ler_id%type;
902: l_range_id ben_batch_ranges.range_id%type;
903: l_chunk_size number := 20;
904: l_threads number := 1;
905: l_start_person_action_id number := 0;
906: l_end_person_action_id number := 0;

Line 991: -- Delete/clear ranges from ben_batch_ranges table

987: ,p_ptnl_ler_for_per_stat_cd => p_bckt_stat_cd);
988: --
989: benutils.g_benefit_action_id := l_benefit_action_id;
990: --
991: -- Delete/clear ranges from ben_batch_ranges table
992: --
993: Delete from ben_batch_ranges
994: Where benefit_action_id = l_benefit_action_id;
995: --

Line 993: Delete from ben_batch_ranges

989: benutils.g_benefit_action_id := l_benefit_action_id;
990: --
991: -- Delete/clear ranges from ben_batch_ranges table
992: --
993: Delete from ben_batch_ranges
994: Where benefit_action_id = l_benefit_action_id;
995: --
996: -- Now lets create person actions for all the people we are going to
997: -- process in the Back-out life event run

Line 1062: Ben_batch_ranges_api.create_batch_ranges

1058: If l_num_row = l_chunk_size then
1059: --
1060: -- Create a range of data to be multithreaded.
1061: --
1062: Ben_batch_ranges_api.create_batch_ranges
1063: (p_validate => false
1064: ,p_benefit_action_id => l_benefit_action_id
1065: ,p_range_id => l_range_id
1066: ,p_range_status_cd => 'U'

Line 1089: Ben_batch_ranges_api.create_batch_ranges

1085: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
1086: --
1087: If l_num_row <> 0 then
1088: --
1089: Ben_batch_ranges_api.create_batch_ranges
1090: (p_validate => false
1091: ,p_benefit_action_id => l_benefit_action_id
1092: ,p_range_id => l_range_id
1093: ,p_range_status_cd => 'U'