APPS.BEN_BACK_OUT_CONC dependencies on BEN_PERSON_ACTIONS

Line 89: l_person_id ben_person_actions.person_id%type;

85: --
86: -- Local variable declaration
87: --
88: l_proc varchar2(80) := g_package||'.do_multithread';
89: l_person_id ben_person_actions.person_id%type;
90: l_person_action_id ben_person_actions.person_action_id%type;
91: l_object_version_number ben_person_actions.object_version_number%type;
92: l_ler_id ben_person_actions.ler_id%type;
93: l_range_id ben_batch_ranges.range_id%type;

Line 90: l_person_action_id ben_person_actions.person_action_id%type;

86: -- Local variable declaration
87: --
88: l_proc varchar2(80) := g_package||'.do_multithread';
89: l_person_id ben_person_actions.person_id%type;
90: l_person_action_id ben_person_actions.person_action_id%type;
91: l_object_version_number ben_person_actions.object_version_number%type;
92: l_ler_id ben_person_actions.ler_id%type;
93: l_range_id ben_batch_ranges.range_id%type;
94: l_record_number number := 0;

Line 91: l_object_version_number ben_person_actions.object_version_number%type;

87: --
88: l_proc varchar2(80) := g_package||'.do_multithread';
89: l_person_id ben_person_actions.person_id%type;
90: l_person_action_id ben_person_actions.person_action_id%type;
91: l_object_version_number ben_person_actions.object_version_number%type;
92: l_ler_id ben_person_actions.ler_id%type;
93: l_range_id ben_batch_ranges.range_id%type;
94: l_record_number number := 0;
95: l_start_person_action_id number := 0;

Line 92: l_ler_id ben_person_actions.ler_id%type;

88: l_proc varchar2(80) := g_package||'.do_multithread';
89: l_person_id ben_person_actions.person_id%type;
90: l_person_action_id ben_person_actions.person_action_id%type;
91: l_object_version_number ben_person_actions.object_version_number%type;
92: l_ler_id ben_person_actions.ler_id%type;
93: l_range_id ben_batch_ranges.range_id%type;
94: l_record_number number := 0;
95: l_start_person_action_id number := 0;
96: l_end_person_action_id number := 0;

Line 120: from ben_person_actions ben

116: --
117: cursor c_person_thread is
118: select ben.person_id,
119: ben.person_action_id
120: from ben_person_actions ben
121: where ben.benefit_action_id = p_benefit_action_id
122: and ben.action_status_cd not in ('P','E')
123: and ben.person_action_id
124: between l_start_person_action_id

Line 539: update ben_person_actions

535: close c_ler_thread;
536: --
537: -- If we get here it was successful.
538: --
539: update ben_person_actions
540: set action_status_cd = 'P'
541: where person_id = l_person_id
542: and benefit_action_id = p_benefit_action_id;
543: --

Line 570: update ben_person_actions

566: --
567: rollback to last_place;
568: benutils.rollback_cache;
569: --
570: update ben_person_actions
571: set action_status_cd = 'E'
572: where person_id = l_person_id
573: and benefit_action_id = p_benefit_action_id;
574: --

Line 900: l_person_action_id ben_person_actions.person_action_id%type;

896: l_proc varchar2(80) := g_package||'.process';
897: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
898: l_object_version_number ben_benefit_actions.object_version_number%type;
899: l_person_id per_people_f.person_id%type;
900: l_person_action_id ben_person_actions.person_action_id%type;
901: l_ler_id ben_ler_f.ler_id%type;
902: l_range_id ben_batch_ranges.range_id%type;
903: l_chunk_size number := 20;
904: l_threads number := 1;

Line 1037: Ben_person_actions_api.create_person_actions

1033: -- Store person_id into person actions table.
1034: --
1035: If l_person_ok = 'Y' then
1036: --
1037: Ben_person_actions_api.create_person_actions
1038: (p_validate => false
1039: ,p_person_action_id => l_person_action_id
1040: ,p_person_id => l_person_id
1041: ,p_ler_id => l_ler_id