APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_BATCH_RANGES

Line 626: l_range_id ben_batch_ranges.range_id%type;

622: l_person_id ben_person_actions.person_id%type;
623: l_person_action_id ben_person_actions.person_action_id%type;
624: l_object_version_number ben_person_actions.object_version_number%type;
625: l_ler_id ben_person_actions.ler_id%type;
626: l_range_id ben_batch_ranges.range_id%type;
627: l_record_number number := 0;
628: l_start_person_action_id number := 0;
629: l_end_person_action_id number := 0;
630: l_actn varchar2(80);

Line 647: From ben_batch_ranges ran

643: Cursor c_range_thread is
644: Select ran.range_id
645: ,ran.starting_person_action_id
646: ,ran.ending_person_action_id
647: From ben_batch_ranges ran
648: Where ran.range_status_cd = 'U'
649: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
650: And rownum < 2
651: For update of ran.range_status_cd;

Line 823: update ben_batch_ranges ran

819: hr_utility.set_location('range Found',10);
820: --
821: close c_range_thread;
822: --
823: update ben_batch_ranges ran
824: set ran.range_status_cd = 'P'
825: where ran.range_id = l_range_id;
826: --
827: commit;

Line 1099: l_range_id ben_batch_ranges.range_id%type;

1095: l_object_version_number ben_benefit_actions.object_version_number%type;
1096: l_person_id per_people_f.person_id%type;
1097: l_person_action_id ben_person_actions.person_action_id%type;
1098: l_ler_id ben_ler_f.ler_id%type;
1099: l_range_id ben_batch_ranges.range_id%type;
1100: l_chunk_size number := 20;
1101: l_threads number := 1;
1102: l_start_person_action_id number := 0;
1103: l_end_person_action_id number := 0;

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

1285: --
1286: benutils.g_benefit_action_id := l_benefit_action_id;
1287: --
1288: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
1289: -- Delete/clear ranges from ben_batch_ranges table
1290: --
1291: Delete from ben_batch_ranges
1292: Where benefit_action_id = l_benefit_action_id;
1293: --

Line 1291: Delete from ben_batch_ranges

1287: --
1288: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
1289: -- Delete/clear ranges from ben_batch_ranges table
1290: --
1291: Delete from ben_batch_ranges
1292: Where benefit_action_id = l_benefit_action_id;
1293: --
1294: -- Now lets create person actions for all the people we are going to
1295: -- process in the Back-out life event run

Line 1384: Ben_batch_ranges_api.create_batch_ranges

1380: If l_num_row = l_chunk_size then
1381: --
1382: -- Create a range of data to be multithreaded.
1383: --
1384: Ben_batch_ranges_api.create_batch_ranges
1385: (p_validate => false
1386: ,p_benefit_action_id => l_benefit_action_id
1387: ,p_range_id => l_range_id
1388: ,p_range_status_cd => 'U'

Line 1414: Ben_batch_ranges_api.create_batch_ranges

1410: hr_utility.set_location('l_num_row='||to_char(l_num_row),48);
1411: --
1412: If l_num_row <> 0 then
1413: --
1414: Ben_batch_ranges_api.create_batch_ranges
1415: (p_validate => false
1416: ,p_benefit_action_id => l_benefit_action_id
1417: ,p_range_id => l_range_id
1418: ,p_range_status_cd => 'U'