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_FORFEITURE_CONCURRENT dependencies on BEN_BATCH_RANGES

Line 945: l_range_id ben_batch_ranges.range_id%type;

941: l_person_id ben_person_actions.person_id%type;
942: l_person_action_id ben_person_actions.person_action_id%type;
943: l_object_version_number ben_person_actions.object_version_number%type;
944: l_ler_id ben_person_actions.ler_id%type;
945: l_range_id ben_batch_ranges.range_id%type;
946: l_record_number number := 0;
947: l_start_person_action_id number := 0;
948: l_end_person_action_id number := 0;
949: l_actn varchar2(80);

Line 961: From ben_batch_ranges ran

957: Cursor c_range_thread is
958: Select ran.range_id
959: ,ran.starting_person_action_id
960: ,ran.ending_person_action_id
961: From ben_batch_ranges ran
962: Where ran.range_status_cd = 'U'
963: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
964: And rownum < 2
965: For update of ran.range_status_cd

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

1082: exit when c_range_thread%notfound;
1083: close c_range_thread;
1084: If(l_range_id is not NULL) then
1085: --
1086: l_actn := 'Updating ben_batch_ranges row...';
1087: --
1088: update ben_batch_ranges ran set ran.range_status_cd = 'P'
1089: where ran.range_id = l_range_id;
1090: commit;

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

1084: If(l_range_id is not NULL) then
1085: --
1086: l_actn := 'Updating ben_batch_ranges row...';
1087: --
1088: update ben_batch_ranges ran set ran.range_status_cd = 'P'
1089: where ran.range_id = l_range_id;
1090: commit;
1091: End if;
1092: --

Line 1273: l_range_id ben_batch_ranges.range_id%type;

1269: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1270: l_object_version_number ben_benefit_actions.object_version_number%type;
1271: l_person_action_id ben_person_actions.person_action_id%type;
1272: l_ler_id ben_ler_f.ler_id%type;
1273: l_range_id ben_batch_ranges.range_id%type;
1274: l_start_person_action_id number := 0;
1275: l_end_person_action_id number := 0;
1276: l_prev_person_id number := 0;
1277: -- 9999 make them start with l_

Line 1426: l_actn := 'Inserting Ben_batch_ranges.......';

1422: If l_num_row = p_chunk_size then
1423: --
1424: -- Create a range of data to be multithreaded.
1425: --
1426: l_actn := 'Inserting Ben_batch_ranges.......';
1427: hr_utility.set_location('Inserting Ben_batch_ranges',32);
1428: -- Select next sequence number for the range
1429: --
1430: select ben_batch_ranges_s.nextval

Line 1427: hr_utility.set_location('Inserting Ben_batch_ranges',32);

1423: --
1424: -- Create a range of data to be multithreaded.
1425: --
1426: l_actn := 'Inserting Ben_batch_ranges.......';
1427: hr_utility.set_location('Inserting Ben_batch_ranges',32);
1428: -- Select next sequence number for the range
1429: --
1430: select ben_batch_ranges_s.nextval
1431: into l_range_id

Line 1430: select ben_batch_ranges_s.nextval

1426: l_actn := 'Inserting Ben_batch_ranges.......';
1427: hr_utility.set_location('Inserting Ben_batch_ranges',32);
1428: -- Select next sequence number for the range
1429: --
1430: select ben_batch_ranges_s.nextval
1431: into l_range_id
1432: from sys.dual;
1433:
1434: insert into ben_batch_ranges

Line 1434: insert into ben_batch_ranges

1430: select ben_batch_ranges_s.nextval
1431: into l_range_id
1432: from sys.dual;
1433:
1434: insert into ben_batch_ranges
1435: (range_id,
1436: benefit_action_id,
1437: range_status_cd,
1438: starting_person_action_id,

Line 1460: l_actn := 'Inserting Final Ben_batch_ranges...';

1456: Close c_pl_subj_frfs;
1457: --
1458: hr_utility.set_location('l_num_row='||to_char(l_num_row),34);
1459: If (l_num_row <> 0) then
1460: l_actn := 'Inserting Final Ben_batch_ranges...';
1461: hr_utility.set_location('Inserting Final Ben_batch_ranges',38);
1462:
1463: select ben_batch_ranges_s.nextval
1464: into l_range_id

Line 1461: hr_utility.set_location('Inserting Final Ben_batch_ranges',38);

1457: --
1458: hr_utility.set_location('l_num_row='||to_char(l_num_row),34);
1459: If (l_num_row <> 0) then
1460: l_actn := 'Inserting Final Ben_batch_ranges...';
1461: hr_utility.set_location('Inserting Final Ben_batch_ranges',38);
1462:
1463: select ben_batch_ranges_s.nextval
1464: into l_range_id
1465: from sys.dual;

Line 1463: select ben_batch_ranges_s.nextval

1459: If (l_num_row <> 0) then
1460: l_actn := 'Inserting Final Ben_batch_ranges...';
1461: hr_utility.set_location('Inserting Final Ben_batch_ranges',38);
1462:
1463: select ben_batch_ranges_s.nextval
1464: into l_range_id
1465: from sys.dual;
1466:
1467: insert into ben_batch_ranges

Line 1467: insert into ben_batch_ranges

1463: select ben_batch_ranges_s.nextval
1464: into l_range_id
1465: from sys.dual;
1466:
1467: insert into ben_batch_ranges
1468: (range_id,
1469: benefit_action_id,
1470: range_status_cd,
1471: starting_person_action_id,

Line 1638: l_range_id ben_batch_ranges.range_id%type;

1634: l_object_version_number ben_benefit_actions.object_version_number%type;
1635: l_person_id per_people_f.person_id%type;
1636: l_person_action_id ben_person_actions.person_action_id%type;
1637: l_ler_id ben_ler_f.ler_id%type;
1638: l_range_id ben_batch_ranges.range_id%type;
1639: l_chunk_size number := 20;
1640: l_threads number := 1;
1641: l_start_person_action_id number := 0;
1642: l_end_person_action_id number := 0;

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

1753: ,p_program_update_date => sysdate
1754: );
1755: benutils.g_benefit_action_id := l_benefit_action_id;
1756: --
1757: -- Delete/clear ranges from ben_batch_ranges table
1758: --
1759: l_actn := 'Delete rows from ben_batch_ranges..';
1760: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
1761:

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

1755: benutils.g_benefit_action_id := l_benefit_action_id;
1756: --
1757: -- Delete/clear ranges from ben_batch_ranges table
1758: --
1759: l_actn := 'Delete rows from ben_batch_ranges..';
1760: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
1761:
1762: Delete from ben_batch_ranges
1763: Where benefit_action_id = l_benefit_action_id;

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

1756: --
1757: -- Delete/clear ranges from ben_batch_ranges table
1758: --
1759: l_actn := 'Delete rows from ben_batch_ranges..';
1760: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
1761:
1762: Delete from ben_batch_ranges
1763: Where benefit_action_id = l_benefit_action_id;
1764: --

Line 1762: Delete from ben_batch_ranges

1758: --
1759: l_actn := 'Delete rows from ben_batch_ranges..';
1760: hr_utility.set_location('Delete rows from ben_batch_ranges',16);
1761:
1762: Delete from ben_batch_ranges
1763: Where benefit_action_id = l_benefit_action_id;
1764: --
1765: -- Future enhancements for individual person processing goes here.
1766: --