APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_BATCH_RANGES

Line 701: l_range_id ben_batch_ranges.range_id%type;

697: l_person_id ben_person_actions.person_id%type;
698: l_person_action_id ben_person_actions.person_action_id%type;
699: l_object_version_number ben_person_actions.object_version_number%type;
700: l_ler_id ben_person_actions.ler_id%type;
701: l_range_id ben_batch_ranges.range_id%type;
702: l_record_number number := 0;
703: l_start_person_action_id number := 0;
704: l_end_person_action_id number := 0;
705: l_actn varchar2(80);

Line 722: From ben_batch_ranges ran

718: Cursor c_range_thread is
719: Select ran.range_id
720: ,ran.starting_person_action_id
721: ,ran.ending_person_action_id
722: From ben_batch_ranges ran
723: Where ran.range_status_cd = 'U'
724: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
725: And rownum < 2
726: For update of ran.range_status_cd;

Line 898: update ben_batch_ranges ran

894: hr_utility.set_location('range Found',10);
895: --
896: close c_range_thread;
897: --
898: update ben_batch_ranges ran
899: set ran.range_status_cd = 'P'
900: where ran.range_id = l_range_id;
901: --
902: commit;

Line 1175: l_range_id ben_batch_ranges.range_id%type;

1171: l_object_version_number ben_benefit_actions.object_version_number%type;
1172: l_person_id per_people_f.person_id%type;
1173: l_person_action_id ben_person_actions.person_action_id%type;
1174: l_ler_id ben_ler_f.ler_id%type;
1175: l_range_id ben_batch_ranges.range_id%type;
1176: l_chunk_size number := 20;
1177: l_threads number := 1;
1178: l_start_person_action_id number := 0;
1179: l_end_person_action_id number := 0;

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

1365: --
1366: benutils.g_benefit_action_id := l_benefit_action_id;
1367: --
1368: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
1369: -- Delete/clear ranges from ben_batch_ranges table
1370: --
1371: Delete from ben_batch_ranges
1372: Where benefit_action_id = l_benefit_action_id;
1373: --

Line 1371: Delete from ben_batch_ranges

1367: --
1368: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
1369: -- Delete/clear ranges from ben_batch_ranges table
1370: --
1371: Delete from ben_batch_ranges
1372: Where benefit_action_id = l_benefit_action_id;
1373: --
1374: -- Now lets create person actions for all the people we are going to
1375: -- process in the Back-out life event run

Line 1464: Ben_batch_ranges_api.create_batch_ranges

1460: If l_num_row = l_chunk_size then
1461: --
1462: -- Create a range of data to be multithreaded.
1463: --
1464: Ben_batch_ranges_api.create_batch_ranges
1465: (p_validate => false
1466: ,p_benefit_action_id => l_benefit_action_id
1467: ,p_range_id => l_range_id
1468: ,p_range_status_cd => 'U'

Line 1494: Ben_batch_ranges_api.create_batch_ranges

1490: hr_utility.set_location('l_num_row='||to_char(l_num_row),48);
1491: --
1492: If l_num_row <> 0 then
1493: --
1494: Ben_batch_ranges_api.create_batch_ranges
1495: (p_validate => false
1496: ,p_benefit_action_id => l_benefit_action_id
1497: ,p_range_id => l_range_id
1498: ,p_range_status_cd => 'U'