APPS.BEN_REOPEN_LER_CONC dependencies on BEN_PERSON_ACTIONS

Line 292: ben_person_actions_api.create_person_actions

288: --
289: -- Either no person sel rule or person selection rule passed. Create a
290: -- person action row.
291: --
292: ben_person_actions_api.create_person_actions
293: (p_validate => FALSE,
294: p_person_action_id => l_person_action_id,
295: p_person_id => l_rec.person_id,
296: p_ler_id => l_rec.per_in_ler_id,

Line 588: l_person_id ben_person_actions.person_id%TYPE;

584: -- Local variable declaration
585: --
586: l_proc VARCHAR2 (80)
587: := g_package || '.do_multithread';
588: l_person_id ben_person_actions.person_id%TYPE;
589: l_person_action_id ben_person_actions.person_action_id%TYPE;
590: l_object_version_number ben_person_actions.object_version_number%TYPE;
591: l_lf_evt_ocrd_dt DATE;
592: l_ler_id ben_person_actions.ler_id%TYPE;

Line 589: l_person_action_id ben_person_actions.person_action_id%TYPE;

585: --
586: l_proc VARCHAR2 (80)
587: := g_package || '.do_multithread';
588: l_person_id ben_person_actions.person_id%TYPE;
589: l_person_action_id ben_person_actions.person_action_id%TYPE;
590: l_object_version_number ben_person_actions.object_version_number%TYPE;
591: l_lf_evt_ocrd_dt DATE;
592: l_ler_id ben_person_actions.ler_id%TYPE;
593: l_range_id ben_batch_ranges.range_id%TYPE;

Line 590: l_object_version_number ben_person_actions.object_version_number%TYPE;

586: l_proc VARCHAR2 (80)
587: := g_package || '.do_multithread';
588: l_person_id ben_person_actions.person_id%TYPE;
589: l_person_action_id ben_person_actions.person_action_id%TYPE;
590: l_object_version_number ben_person_actions.object_version_number%TYPE;
591: l_lf_evt_ocrd_dt DATE;
592: l_ler_id ben_person_actions.ler_id%TYPE;
593: l_range_id ben_batch_ranges.range_id%TYPE;
594: l_record_number NUMBER := 0;

Line 592: l_ler_id ben_person_actions.ler_id%TYPE;

588: l_person_id ben_person_actions.person_id%TYPE;
589: l_person_action_id ben_person_actions.person_action_id%TYPE;
590: l_object_version_number ben_person_actions.object_version_number%TYPE;
591: l_lf_evt_ocrd_dt DATE;
592: l_ler_id ben_person_actions.ler_id%TYPE;
593: l_range_id ben_batch_ranges.range_id%TYPE;
594: l_record_number NUMBER := 0;
595: l_start_person_action_id NUMBER := 0;
596: l_end_person_action_id NUMBER := 0;

Line 627: FROM ben_person_actions ben

623: IS
624: -- to fetch all the persons actions
625: SELECT ben.person_id, ben.person_action_id,
626: ben.object_version_number, ben.ler_id
627: FROM ben_person_actions ben
628: WHERE ben.benefit_action_id = p_benefit_action_id
629: AND ben.action_status_cd <> 'P'
630: AND ben.person_action_id BETWEEN l_start_person_action_id
631: AND l_end_person_action_id

Line 787: UPDATE ben_person_actions

783: l_record_number := l_record_number + 1;
784: --
785: l_actn := 'Updating person_ations.';
786: --
787: UPDATE ben_person_actions
788: SET action_status_cd = 'T'
789: WHERE person_action_id = l_person_action_id;
790: --
791: END LOOP;

Line 841: UPDATE ben_person_actions

837: p_object_version_number => l_object_version_number,
838: p_validate => l_validate
839: );
840:
841: UPDATE ben_person_actions
842: SET action_status_cd = 'P'
843: WHERE person_action_id = g_cache_per_proc (l_cnt).person_action_id;
844:
845: fnd_message.set_name ('BEN', 'BEN_94646_LF_EVT_REOPENED');

Line 884: UPDATE ben_person_actions

880: g_rec.person_id := g_cache_per_proc (l_cnt).person_id;
881:
882: benutils.WRITE (p_rec => g_rec);
883:
884: UPDATE ben_person_actions
885: SET action_status_cd = 'E'
886: WHERE person_action_id = g_cache_per_proc(l_cnt).person_action_id;
887:
888: g_persons_errored := g_persons_errored + 1;