448: Order by ben.person_action_id
449: ;
450: Cursor c_parameter is
451: Select *
452: From ben_benefit_actions ben
453: Where ben.benefit_action_id = p_benefit_action_id
454: ;
455: l_parm c_parameter%rowtype;
456: l_commit number;
655: ,legal_entity_id
656: ,payroll_id
657: ,debug_messages_flag
658: ,audit_log_flag
659: From ben_benefit_actions ben
660: Where ben.benefit_action_id = p_benefit_action_id;
661: --
662: -- Local Variable declaration.
663: --
743: --
744: l_effective_date date;
745: l_request_id number;
746: l_proc varchar2(80) := g_package||'.process';
747: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
748: l_object_version_number ben_benefit_actions.object_version_number%type;
749: l_person_id_out per_people_f.person_id%type;
750: l_range_id ben_batch_ranges.range_id%type;
751: l_chunk_size number;
744: l_effective_date date;
745: l_request_id number;
746: l_proc varchar2(80) := g_package||'.process';
747: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
748: l_object_version_number ben_benefit_actions.object_version_number%type;
749: l_person_id_out per_people_f.person_id%type;
750: l_range_id ben_batch_ranges.range_id%type;
751: l_chunk_size number;
752: l_threads number;
929: -- we are doing a restart.
930: --
931: if p_benefit_action_id is null then
932: --
933: ben_benefit_actions_api.create_perf_benefit_actions
934: (p_validate => false
935: ,p_benefit_action_id => l_benefit_action_id
936: ,p_process_date => l_effective_date
937: ,p_mode_cd => 'S'