[Home] [Help]
334: Order by ben.person_action_id
335: ;
336: Cursor c_parameter is
337: Select *
338: From ben_benefit_actions ben
339: Where ben.benefit_action_id = p_benefit_action_id
340: ;
341: l_parm c_parameter%rowtype;
342: l_commit number;
543: ,location_id
544: ,legal_entity_id
545: ,payroll_id
546: ,debug_messages_flag
547: From ben_benefit_actions ben
548: Where ben.benefit_action_id = p_benefit_action_id;
549: --
550: -- Local Variable declaration.
551: --
748: -- local variable declaration.
749: --
750: l_request_id number;
751: l_proc varchar2(80) := g_package||'.process';
752: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
753: l_object_version_number ben_benefit_actions.object_version_number%type;
754: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;
755: l_person_action_id ben_person_actions.person_action_id%type;
756: l_ler_id ben_ler_f.ler_id%type;
749: --
750: l_request_id number;
751: l_proc varchar2(80) := g_package||'.process';
752: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
753: l_object_version_number ben_benefit_actions.object_version_number%type;
754: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;
755: l_person_action_id ben_person_actions.person_action_id%type;
756: l_ler_id ben_ler_f.ler_id%type;
757: l_range_id ben_batch_ranges.range_id%type;
826: -- Do not create is a benefit action already exists, in other words
827: -- we are doing a restart.
828: --
829: If(p_benefit_action_id is null) then
830: ben_benefit_actions_api.create_benefit_actions
831: (p_validate => false
832: ,p_benefit_action_id => l_benefit_action_id
833: ,p_process_date => l_effective_date
834: ,p_mode_cd => 'S'