[Home] [Help]
91: order by ben.person_action_id;
92: --
93: Cursor c_parameter is
94: Select *
95: From ben_benefit_actions ben
96: Where ben.benefit_action_id = p_benefit_action_id;
97: --
98: l_parm c_parameter%rowtype;
99: --
397: ,location_id
398: ,benfts_grp_id
399: ,legal_entity_id
400: ,debug_messages_flag
401: From ben_benefit_actions ben
402: Where ben.benefit_action_id = p_benefit_action_id;
403: --
404: -- Local Variable declaration.
405: --
534: -- local variable declaration.
535: --
536: l_request_id number;
537: l_proc varchar2(80) := g_package||'.process';
538: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
539: l_object_version_number ben_benefit_actions.object_version_number%type;
540: l_person_id per_people_f.person_id%type;
541: l_person_action_id ben_person_actions.person_action_id%type;
542: l_ler_id ben_ler_f.ler_id%type;
535: --
536: l_request_id number;
537: l_proc varchar2(80) := g_package||'.process';
538: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
539: l_object_version_number ben_benefit_actions.object_version_number%type;
540: l_person_id per_people_f.person_id%type;
541: l_person_action_id ben_person_actions.person_action_id%type;
542: l_ler_id ben_ler_f.ler_id%type;
543: l_range_id ben_batch_ranges.range_id%type;
586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);
587: hr_utility.set_location('p_validate '||p_validate,10);
588: hr_utility.set_location('p_person_id '||p_person_id,10);
589: --
590: ben_benefit_actions_api.create_perf_benefit_actions
591: (p_validate_flag => p_validate
592: ,p_benefit_action_id => l_benefit_action_id
593: ,p_process_date => l_effective_date
594: ,p_mode_cd => 'S'