APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_BATCH_RANGES

Line 3148: from ben_batch_ranges ran

3144: cursor c_range_thread is
3145: select ran.rowid,
3146: ran.starting_person_action_id,
3147: ran.ending_person_action_id
3148: from ben_batch_ranges ran
3149: where ran.range_status_cd = 'U'
3150: and ran.benefit_action_id = p_benefit_action_id
3151: and rownum < 2
3152: for update of ran.range_status_cd;

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

3251: --
3252: print_parameters;
3253: --
3254: -- The processing for this thread is as follows:
3255: -- 1) Lock the rows in ben_batch_ranges that are not processed.
3256: -- 2) Fetch the start and ending person action id for the range.
3257: -- 3) Process the rows in ben_person_action that fall in the range based on
3258: -- the trigger type.
3259: -- 4) Go to number 1 again and repeat until all ranges are processed.

Line 3273: update ben_batch_ranges

3269: end if;
3270: --
3271: close c_range_thread;
3272: --
3273: update ben_batch_ranges
3274: set range_status_cd = 'P'
3275: where rowid = l_range_rec.rowid;
3276: --
3277: commit;

Line 3426: ben_batch_ranges_api.create_batch_ranges

3422: p_ending_person_action_id := l_person_action_id;
3423: --
3424: if mod(g_person_actn_cnt, g_chunk_size) = 0 or g_chunk_size = 1 then
3425: --
3426: ben_batch_ranges_api.create_batch_ranges
3427: (p_validate => FALSE
3428: ,p_effective_date => g_parm.effective_date
3429: ,p_benefit_action_id => g_parm.benefit_action_id
3430: ,p_range_id => l_range_id

Line 3588: ben_batch_ranges_api.create_batch_ranges

3584: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3585: --
3586: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3587: --
3588: ben_batch_ranges_api.create_batch_ranges
3589: (p_validate => FALSE
3590: ,p_effective_date => g_parm.effective_date
3591: ,p_benefit_action_id => g_parm.benefit_action_id
3592: ,p_range_id => l_range_id

Line 3748: ben_batch_ranges_api.create_batch_ranges

3744: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3745: --
3746: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3747: --
3748: ben_batch_ranges_api.create_batch_ranges
3749: (p_validate => FALSE
3750: ,p_effective_date => g_parm.effective_date
3751: ,p_benefit_action_id => g_parm.benefit_action_id
3752: ,p_range_id => l_range_id

Line 4069: ben_batch_ranges_api.create_batch_ranges

4065: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4066: --
4067: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4068: --
4069: ben_batch_ranges_api.create_batch_ranges
4070: (p_validate => FALSE
4071: ,p_effective_date => g_parm.effective_date
4072: ,p_benefit_action_id => g_parm.benefit_action_id
4073: ,p_range_id => l_range_id

Line 4539: ben_batch_ranges_api.create_batch_ranges

4535: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4536: --
4537: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4538: --
4539: ben_batch_ranges_api.create_batch_ranges
4540: (p_validate => FALSE
4541: ,p_effective_date => g_parm.effective_date
4542: ,p_benefit_action_id => g_parm.benefit_action_id
4543: ,p_range_id => l_range_id

Line 4756: delete from ben_batch_ranges

4752: commit;
4753: --
4754: -- Delete batch ranges for the benefit action id
4755: --
4756: delete from ben_batch_ranges
4757: where benefit_action_id = g_parm.benefit_action_id;
4758: --
4759: commit;
4760: --