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_PERSON_ACTIONS

Line 215: l_person_id ben_person_actions.person_id%type;

211: --
212: -- Local variable declaration
213: --
214: l_proc varchar2(80) := g_package||'.do_multithread';
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;

Line 216: l_person_action_id ben_person_actions.person_action_id%type;

212: -- Local variable declaration
213: --
214: l_proc varchar2(80) := g_package||'.do_multithread';
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;

Line 217: l_object_version_number ben_person_actions.object_version_number%type;

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

Line 218: l_ler_id ben_person_actions.ler_id%type;

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

Line 247: From ben_person_actions ben

243: Select ben.person_id
244: ,ben.person_action_id
245: ,ben.object_version_number
246: ,ben.ler_id
247: From ben_person_actions ben
248: Where ben.benefit_action_id = p_benefit_action_id
249: And ben.action_status_cd <> 'P'
250: And ben.person_action_id between
251: l_start_person_action_id and l_end_person_action_id

Line 607: l_person_action_id ben_person_actions.person_action_id%type;

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

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

805: --
806: -- Store data into person actions table.
807: --
808: If ( not skip) then
809: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
810:
811: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
812: Ben_person_actions_api.create_person_actions
813: (p_validate => false

Line 811: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';

807: --
808: If ( not skip) then
809: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
810:
811: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
812: Ben_person_actions_api.create_person_actions
813: (p_validate => false
814: ,p_person_action_id => l_person_action_id
815: ,p_person_id => l_person_id

Line 812: Ben_person_actions_api.create_person_actions

808: If ( not skip) then
809: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
810:
811: l_actn := 'Calling Ben_person_actions_api.create_person_actions...';
812: Ben_person_actions_api.create_person_actions
813: (p_validate => false
814: ,p_person_action_id => l_person_action_id
815: ,p_person_id => l_person_id
816: ,p_ler_id => 0