APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PERSON_ACTIONS

Line 479: ben_person_actions_api.create_person_actions

475: --
476: -- Either no person sel rule or person selection rule passed. Create a
477: -- person action row.
478: --
479: ben_person_actions_api.create_person_actions
480: (p_validate => FALSE
481: ,p_person_action_id => l_person_action_id
482: ,p_person_id => l_rec.person_id
483: ,p_benefit_action_id => l_benefit_action_id

Line 806: l_person_id ben_person_actions.person_id%type;

802: -- Local variable declaration
803: --
804: l_effective_date date;
805: l_proc varchar2(80) := g_package || '.do_multithread';
806: l_person_id ben_person_actions.person_id%type;
807: l_person_action_id ben_person_actions.person_action_id%type;
808: l_object_version_number ben_person_actions.object_version_number%type;
809: l_ler_id ben_person_actions.ler_id%type;
810: l_range_id ben_batch_ranges.range_id%type;

Line 807: l_person_action_id ben_person_actions.person_action_id%type;

803: --
804: l_effective_date date;
805: l_proc varchar2(80) := g_package || '.do_multithread';
806: l_person_id ben_person_actions.person_id%type;
807: l_person_action_id ben_person_actions.person_action_id%type;
808: l_object_version_number ben_person_actions.object_version_number%type;
809: l_ler_id ben_person_actions.ler_id%type;
810: l_range_id ben_batch_ranges.range_id%type;
811: l_record_number number := 0;

Line 808: l_object_version_number ben_person_actions.object_version_number%type;

804: l_effective_date date;
805: l_proc varchar2(80) := g_package || '.do_multithread';
806: l_person_id ben_person_actions.person_id%type;
807: l_person_action_id ben_person_actions.person_action_id%type;
808: l_object_version_number ben_person_actions.object_version_number%type;
809: l_ler_id ben_person_actions.ler_id%type;
810: l_range_id ben_batch_ranges.range_id%type;
811: l_record_number number := 0;
812: l_start_person_action_id number := 0;

Line 809: l_ler_id ben_person_actions.ler_id%type;

805: l_proc varchar2(80) := g_package || '.do_multithread';
806: l_person_id ben_person_actions.person_id%type;
807: l_person_action_id ben_person_actions.person_action_id%type;
808: l_object_version_number ben_person_actions.object_version_number%type;
809: l_ler_id ben_person_actions.ler_id%type;
810: l_range_id ben_batch_ranges.range_id%type;
811: l_record_number number := 0;
812: l_start_person_action_id number := 0;
813: l_end_person_action_id number := 0;

Line 838: from ben_person_actions ben

834: is
835: select ben.person_id
836: ,ben.person_action_id
837: ,ben.object_version_number
838: from ben_person_actions ben
839: where ben.benefit_action_id = p_benefit_action_id
840: and ben.action_status_cd <> 'P'
841: and ben.person_action_id between l_start_person_action_id
842: and l_end_person_action_id

Line 1006: update ben_person_actions

1002: l_record_number := l_record_number + 1;
1003: --
1004: l_actn := 'Updating person_ations.';
1005: --
1006: update ben_person_actions
1007: set action_status_cd = 'T'
1008: where person_action_id = l_person_action_id;
1009: --
1010: end loop;

Line 1065: update ben_person_actions

1061: g_rec.person_id := g_cache_per_proc(l_cnt).person_id;
1062: benutils.write(p_text => g_rec.text);
1063: benutils.write(p_rec => g_rec);
1064: --
1065: update ben_person_actions
1066: set action_status_cd = 'E'
1067: where person_action_id = g_cache_per_proc(l_cnt).person_action_id;
1068: --
1069: g_persons_errored := g_persons_errored + 1;