APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_BATCH_RANGES

Line 3206: from ben_batch_ranges ran

3202: cursor c_range_thread is
3203: select ran.rowid,
3204: ran.starting_person_action_id,
3205: ran.ending_person_action_id
3206: from ben_batch_ranges ran
3207: where ran.range_status_cd = 'U'
3208: and ran.benefit_action_id = p_benefit_action_id
3209: and rownum < 2
3210: for update of ran.range_status_cd;

Line 3313: -- 1) Lock the rows in ben_batch_ranges that are not processed.

3309: --
3310: print_parameters;
3311: --
3312: -- The processing for this thread is as follows:
3313: -- 1) Lock the rows in ben_batch_ranges that are not processed.
3314: -- 2) Fetch the start and ending person action id for the range.
3315: -- 3) Process the rows in ben_person_action that fall in the range based on
3316: -- the trigger type.
3317: -- 4) Go to number 1 again and repeat until all ranges are processed.

Line 3331: update ben_batch_ranges

3327: end if;
3328: --
3329: close c_range_thread;
3330: --
3331: update ben_batch_ranges
3332: set range_status_cd = 'P'
3333: where rowid = l_range_rec.rowid;
3334: --
3335: commit;

Line 3484: ben_batch_ranges_api.create_batch_ranges

3480: p_ending_person_action_id := l_person_action_id;
3481: --
3482: if mod(g_person_actn_cnt, g_chunk_size) = 0 or g_chunk_size = 1 then
3483: --
3484: ben_batch_ranges_api.create_batch_ranges
3485: (p_validate => FALSE
3486: ,p_effective_date => g_parm.effective_date
3487: ,p_benefit_action_id => g_parm.benefit_action_id
3488: ,p_range_id => l_range_id

Line 3646: ben_batch_ranges_api.create_batch_ranges

3642: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3643: --
3644: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3645: --
3646: ben_batch_ranges_api.create_batch_ranges
3647: (p_validate => FALSE
3648: ,p_effective_date => g_parm.effective_date
3649: ,p_benefit_action_id => g_parm.benefit_action_id
3650: ,p_range_id => l_range_id

Line 3806: ben_batch_ranges_api.create_batch_ranges

3802: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3803: --
3804: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3805: --
3806: ben_batch_ranges_api.create_batch_ranges
3807: (p_validate => FALSE
3808: ,p_effective_date => g_parm.effective_date
3809: ,p_benefit_action_id => g_parm.benefit_action_id
3810: ,p_range_id => l_range_id

Line 4130: ben_batch_ranges_api.create_batch_ranges

4126: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4127: --
4128: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4129: --
4130: ben_batch_ranges_api.create_batch_ranges
4131: (p_validate => FALSE
4132: ,p_effective_date => g_parm.effective_date
4133: ,p_benefit_action_id => g_parm.benefit_action_id
4134: ,p_range_id => l_range_id

Line 4604: ben_batch_ranges_api.create_batch_ranges

4600: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4601: --
4602: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4603: --
4604: ben_batch_ranges_api.create_batch_ranges
4605: (p_validate => FALSE
4606: ,p_effective_date => g_parm.effective_date
4607: ,p_benefit_action_id => g_parm.benefit_action_id
4608: ,p_range_id => l_range_id

Line 4821: delete from ben_batch_ranges

4817: commit;
4818: --
4819: -- Delete batch ranges for the benefit action id
4820: --
4821: delete from ben_batch_ranges
4822: where benefit_action_id = g_parm.benefit_action_id;
4823: --
4824: commit;
4825: --