[Home] [Help]
339: Order by ben.person_action_id
340: ;
341: Cursor c_parameter is
342: Select *
343: From ben_benefit_actions ben
344: Where ben.benefit_action_id = p_benefit_action_id
345: ;
346: l_parm c_parameter%rowtype;
347: l_commit number;
548: ,location_id
549: ,legal_entity_id
550: ,payroll_id
551: ,debug_messages_flag
552: From ben_benefit_actions ben
553: Where ben.benefit_action_id = p_benefit_action_id;
554: --
555: -- Local Variable declaration.
556: --
753: -- local variable declaration.
754: --
755: l_request_id number;
756: l_proc varchar2(80) := g_package||'.process';
757: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
758: l_object_version_number ben_benefit_actions.object_version_number%type;
759: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;
760: l_person_action_id ben_person_actions.person_action_id%type;
761: l_ler_id ben_ler_f.ler_id%type;
754: --
755: l_request_id number;
756: l_proc varchar2(80) := g_package||'.process';
757: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
758: l_object_version_number ben_benefit_actions.object_version_number%type;
759: l_person_id /*per_people_f*/ per_all_people_f.person_id%type;
760: l_person_action_id ben_person_actions.person_action_id%type;
761: l_ler_id ben_ler_f.ler_id%type;
762: l_range_id ben_batch_ranges.range_id%type;
831: -- Do not create is a benefit action already exists, in other words
832: -- we are doing a restart.
833: --
834: If(p_benefit_action_id is null) then
835: ben_benefit_actions_api.create_benefit_actions
836: (p_validate => false
837: ,p_benefit_action_id => l_benefit_action_id
838: ,p_process_date => l_effective_date
839: ,p_mode_cd => 'S'