eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PREMIUM_CONCURRENT dependencies on BEN_BATCH_RANGES

Line 219: l_range_id ben_batch_ranges.range_id%type;

215: l_person_id ben_person_actions.person_id%type;
216: l_person_action_id ben_person_actions.person_action_id%type;
217: l_object_version_number ben_person_actions.object_version_number%type;
218: l_ler_id ben_person_actions.ler_id%type;
219: l_range_id ben_batch_ranges.range_id%type;
220: l_record_number number := 0;
221: l_start_person_action_id number := 0;
222: l_end_person_action_id number := 0;
223: l_actn varchar2(80);

Line 236: From ben_batch_ranges ran

232: Cursor c_range_thread is
233: Select ran.range_id
234: ,ran.starting_person_action_id
235: ,ran.ending_person_action_id
236: From ben_batch_ranges ran
237: Where ran.range_status_cd = 'U'
238: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
239: And rownum < 2
240: For update of ran.range_status_cd

Line 353: l_actn := 'Updating ben_batch_ranges row...';

349: exit when c_range_thread%notfound;
350: close c_range_thread;
351: If(l_range_id is not NULL) then
352: --
353: l_actn := 'Updating ben_batch_ranges row...';
354: --
355: update ben_batch_ranges ran set ran.range_status_cd = 'P'
356: where ran.range_id = l_range_id;
357: commit;

Line 355: update ben_batch_ranges ran set ran.range_status_cd = 'P'

351: If(l_range_id is not NULL) then
352: --
353: l_actn := 'Updating ben_batch_ranges row...';
354: --
355: update ben_batch_ranges ran set ran.range_status_cd = 'P'
356: where ran.range_id = l_range_id;
357: commit;
358: End if;
359: --

Line 609: l_range_id ben_batch_ranges.range_id%type;

605: l_object_version_number ben_benefit_actions.object_version_number%type;
606: l_person_id per_people_f.person_id%type;
607: l_person_action_id ben_person_actions.person_action_id%type;
608: l_ler_id ben_ler_f.ler_id%type;
609: l_range_id ben_batch_ranges.range_id%type;
610: l_chunk_size number := 20;
611: l_threads number := 1;
612: l_start_person_action_id number := 0;
613: l_end_person_action_id number := 0;

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

736: ,p_program_update_date => sysdate
737: );
738: benutils.g_benefit_action_id := l_benefit_action_id;
739: --
740: -- Delete/clear ranges from ben_batch_ranges table
741: --
742: l_actn := 'Delete rows from ben_batch_ranges..';
743: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
744:

Line 742: l_actn := 'Delete rows from ben_batch_ranges..';

738: benutils.g_benefit_action_id := l_benefit_action_id;
739: --
740: -- Delete/clear ranges from ben_batch_ranges table
741: --
742: l_actn := 'Delete rows from ben_batch_ranges..';
743: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
744:
745: Delete from ben_batch_ranges
746: Where benefit_action_id = l_benefit_action_id;

Line 743: hr_utility.set_location('Delete rows from ben_batch_ranges',16);

739: --
740: -- Delete/clear ranges from ben_batch_ranges table
741: --
742: l_actn := 'Delete rows from ben_batch_ranges..';
743: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
744:
745: Delete from ben_batch_ranges
746: Where benefit_action_id = l_benefit_action_id;
747: --

Line 745: Delete from ben_batch_ranges

741: --
742: l_actn := 'Delete rows from ben_batch_ranges..';
743: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
744:
745: Delete from ben_batch_ranges
746: Where benefit_action_id = l_benefit_action_id;
747: --
748: -- Now lets create person actions for all the people we are going to
749: -- process in the Premium Calculation run.

Line 833: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(in)...';

829: If l_num_row = l_chunk_size then
830: --
831: -- Create a range of data to be multithreaded.
832: --
833: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(in)...';
834: Ben_batch_ranges_api.create_batch_ranges
835: (p_validate => false
836: ,p_benefit_action_id => l_benefit_action_id
837: ,p_range_id => l_range_id

Line 834: Ben_batch_ranges_api.create_batch_ranges

830: --
831: -- Create a range of data to be multithreaded.
832: --
833: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(in)...';
834: Ben_batch_ranges_api.create_batch_ranges
835: (p_validate => false
836: ,p_benefit_action_id => l_benefit_action_id
837: ,p_range_id => l_range_id
838: ,p_range_status_cd => 'U'

Line 857: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(Last)...';

853:
854: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
855:
856: If (l_num_row <> 0) then
857: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(Last)...';
858: Ben_batch_ranges_api.create_batch_ranges
859: (p_validate => false
860: ,p_benefit_action_id => l_benefit_action_id
861: ,p_range_id => l_range_id

Line 858: Ben_batch_ranges_api.create_batch_ranges

854: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
855:
856: If (l_num_row <> 0) then
857: l_actn := 'Calling Ben_batch_ranges_api.create_batch_ranges(Last)...';
858: Ben_batch_ranges_api.create_batch_ranges
859: (p_validate => false
860: ,p_benefit_action_id => l_benefit_action_id
861: ,p_range_id => l_range_id
862: ,p_range_status_cd => 'U'