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_PERSON_ACTIONS

Line 941: l_person_id ben_person_actions.person_id%type;

937: -- Local variable declaration
938: -- 9999 Check all the local variables and delete them if not used after arcsin.
939: --
940: l_proc varchar2(80) := g_package||'.do_multithread';
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;

Line 942: l_person_action_id ben_person_actions.person_action_id%type;

938: -- 9999 Check all the local variables and delete them if not used after arcsin.
939: --
940: l_proc varchar2(80) := g_package||'.do_multithread';
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;

Line 943: l_object_version_number ben_person_actions.object_version_number%type;

939: --
940: l_proc varchar2(80) := g_package||'.do_multithread';
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;

Line 944: l_ler_id ben_person_actions.ler_id%type;

940: l_proc varchar2(80) := g_package||'.do_multithread';
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;

Line 972: From ben_person_actions ben

968: Select ben.person_id
969: ,ben.person_action_id
970: ,ben.object_version_number
971: ,ben.ler_id
972: From ben_person_actions ben
973: Where ben.benefit_action_id = p_benefit_action_id
974: And ben.action_status_cd <> 'P'
975: And ben.person_action_id between
976: l_start_person_action_id and l_end_person_action_id

Line 1140: update ben_person_actions

1136: g_persons_processed := g_persons_processed + 1;
1137: --
1138: -- If we get here it was successful.
1139: --
1140: update ben_person_actions
1141: set action_status_cd = 'P'
1142: where person_id = g_cache_person_process(l_cnt).person_id
1143: and benefit_action_id = p_benefit_action_id;
1144: --

Line 1152: update ben_person_actions

1148: --
1149: -- Need to write to reporting tables as well
1150: -- by calling benutils.write(p_rec => g_rec);
1151: --
1152: update ben_person_actions
1153: set action_status_cd = 'E'
1154: where person_id = g_cache_person_process(l_cnt).person_id
1155: and benefit_action_id = p_benefit_action_id;
1156: --

Line 1271: l_person_action_id ben_person_actions.person_action_id%type;

1267: l_request_id number;
1268: l_proc varchar2(80) := g_package||'.process_by_plan';
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;

Line 1391: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);

1387: --
1388: -- Store pl_id into person actions table.
1389: --
1390: If ( not skip) then
1391: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
1392: l_actn := 'Inserting Ben_person_actions...';
1393: select ben_person_actions_s.nextval
1394: into l_person_action_id
1395: from sys.dual;

Line 1392: l_actn := 'Inserting Ben_person_actions...';

1388: -- Store pl_id into person actions table.
1389: --
1390: If ( not skip) then
1391: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
1392: l_actn := 'Inserting Ben_person_actions...';
1393: select ben_person_actions_s.nextval
1394: into l_person_action_id
1395: from sys.dual;
1396:

Line 1393: select ben_person_actions_s.nextval

1389: --
1390: If ( not skip) then
1391: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
1392: l_actn := 'Inserting Ben_person_actions...';
1393: select ben_person_actions_s.nextval
1394: into l_person_action_id
1395: from sys.dual;
1396:
1397: insert into ben_person_actions

Line 1397: insert into ben_person_actions

1393: select ben_person_actions_s.nextval
1394: into l_person_action_id
1395: from sys.dual;
1396:
1397: insert into ben_person_actions
1398: (person_action_id,
1399: person_id,
1400: ler_id,
1401: benefit_action_id,

Line 1636: l_person_action_id ben_person_actions.person_action_id%type;

1632: l_proc varchar2(80) := g_package||'.process';
1633: l_benefit_action_id ben_benefit_actions.benefit_action_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;