[Home] [Help]
73: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
74: l_object_version_number ghr_pa_remarks.object_version_number%type;
75: l_description ghr_remarks.description%type;
76: l_user_table_name pay_user_tables.user_table_name%type;
77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
78: l_retained_grade varchar2(10);
79: -- Bug # 7269520
80: l_to_pay_plan ghr_pa_requests.to_pay_plan%type;
81: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%type;
443: l_health_plan pay_element_entry_values.screen_entry_value%type;
444: l_error_flag boolean;
445: --
446: l_pa_request_id ghr_pa_requests.pa_request_id%type;
447: l_pay_calc_in_rec ghr_pay_calc.pay_calc_in_rec_type;
448: l_pay_calc_out_rec ghr_pay_calc.pay_calc_out_rec_type;
449: l_message_set boolean;
450: l_calculated boolean;
451: -- Benefits EIT Sundar
444: l_error_flag boolean;
445: --
446: l_pa_request_id ghr_pa_requests.pa_request_id%type;
447: l_pay_calc_in_rec ghr_pay_calc.pay_calc_in_rec_type;
448: l_pay_calc_out_rec ghr_pay_calc.pay_calc_out_rec_type;
449: l_message_set boolean;
450: l_calculated boolean;
451: -- Benefits EIT Sundar
452: l_errbuf varchar2(2000);
900: hr_utility.set_location(l_proc,20);
901:
902: -- FWFA Changes Bug#4444609
903: -- Bug#4701896
904: IF ghr_pay_calc.g_pay_table_upd_flag THEN
905: IF p_imm_pa_request_rec.input_pay_rate_determinant IN ('A','B','E','F','U','V')
906: AND l_imm_per_retained_grade.temp_step IS NULL THEN
907: --Begin Bug# 4691288
908: BEGIN
926: WHEN OTHERS THEN
927: NULL;
928: END;
929: --end Bug# 4691288
930: l_imm_per_retained_grade.retain_pay_plan := nvl(ghr_pay_calc.g_out_to_pay_plan,l_imm_per_retained_grade.retain_pay_plan);
931: l_imm_per_retained_grade.retain_pay_table_id := p_imm_pa_request_rec.to_pay_table_identifier;
932: l_imm_per_retained_grade.per_retained_grade_flag := 'Y';
933: ELSE
934: l_imm_pos_valid_grade.pay_table_id := p_imm_pa_request_rec.to_pay_table_identifier;