DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PAY_CALC

Line 651: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

647: and (rei.rei_information5 is null or rei.rei_information5 = 'Y')
648: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
649:
650:
651: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
653: -- Bug#4698321 created l_cur_date_from variable.
654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;

Line 652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;

648: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
649:
650:
651: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
653: -- Bug#4698321 created l_cur_date_from variable.
654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;

Line 861: IF (ghr_pay_calc.g_fwfa_pay_calc_flag) and

857: -- SKIP the following process for NOA Code 866 as it is already handled in the above code.
858: -- However, don't skip NOACs 702,740 as they may not terminate RG. In some cases, they
859: -- may have effective RG record.
860: -------Bug 5913362 -- Adding 890
861: IF (ghr_pay_calc.g_fwfa_pay_calc_flag) and
862: p_pa_request_rec.first_noa_code NOT IN ('866', '890')THEN
863:
864: BEGIN
865: -- FWFA Changes Bug#4444609 Added the IF Condition.

Line 888: IF ghr_pay_calc.g_pay_table_upd_flag THEN

884: l_new_temp_step := retained_grade_ovn.pei_information9;
885: exit;
886: END LOOP;
887:
888: IF ghr_pay_calc.g_pay_table_upd_flag THEN
889: l_new_pay_table := p_per_retained_grade.retain_pay_table_id;
890: p_per_retained_grade.per_retained_grade_flag := 'Y';
891: END IF;
892:

Line 986: WHEN ghr_pay_calc.pay_calc_message THEN

982: END IF; -- per_retained_grade_flag
983: END IF; -- l_retained_grade_rec.person_extra_info_id NOT NULL
984: EXCEPTION
985: -- IF No RG Record Exists, skip this updation.
986: WHEN ghr_pay_calc.pay_calc_message THEN
987: NULL;
988: WHEN OTHERS THEN
989: RAISE;
990: END;

Line 2027: IF ghr_pay_calc.g_pay_table_upd_flag THEN

2023: ,p_information6 => p_pos_valid_grade.pay_basis
2024: ,p_information7 => p_pos_valid_grade.employment_category_group
2025: );
2026: -- Bug#4699682
2027: IF ghr_pay_calc.g_pay_table_upd_flag THEN
2028: ghr_mlc_pkg.position_history_update (p_position_id => P_PA_REQUEST_REC.to_position_id,
2029: p_effective_date => P_PA_REQUEST_REC.effective_date,
2030: p_table_id => P_PA_REQUEST_REC.from_pay_table_identifier,
2031: p_upd_tableid => p_pos_valid_grade.pay_table_id);

Line 4762: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

4758: l_lei_date varchar2(60); -- Bug 3111719
4759: v_payroll_id number;
4760: v_asg_effective_start_date date;
4761: v_asg_effective_end_date date;
4762: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;

Line 4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;

4759: v_payroll_id number;
4760: v_asg_effective_start_date date;
4761: v_asg_effective_end_date date;
4762: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;

Line 5373: if ghr_pay_calc.g_gm_unadjd_basic_pay is not null and ghr_pay_calc.g_gm_unadjd_basic_pay <> 0 then

5369: --
5370: -- Processing Unadjusted Basic Pay
5371: --
5372: If p_pa_request_rec.to_adj_basic_pay is not null then
5373: if ghr_pay_calc.g_gm_unadjd_basic_pay is not null and ghr_pay_calc.g_gm_unadjd_basic_pay <> 0 then
5374: hr_utility.set_location(l_proc,21);
5375:
5376: ghr_element_api.process_sf52_element
5377: (p_assignment_id => p_pa_request_rec.employee_assignment_id

Line 5380: ,p_value1 => to_char(ghr_pay_calc.g_gm_unadjd_basic_pay)

5376: ghr_element_api.process_sf52_element
5377: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5378: ,p_element_name => 'Unadjusted Basic Pay'
5379: ,p_input_value_name1 => 'Amount'
5380: ,p_value1 => to_char(ghr_pay_calc.g_gm_unadjd_basic_pay)
5381: ,p_effective_date => l_effective_date
5382: ,p_process_warning => l_basic_pay_warn
5383: );
5384: end if;

Line 6224: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND

6220: -- FWFA Changes. Restrict this update if the update happens already in call_extra_info_api.
6221:
6222:
6223:
6224: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND
6225: NOT(ghr_pay_calc.g_gl_upd_flag) THEN
6226: ghr_history_api.get_g_session_var(l_session);
6227: IF p_pa_request_rec.first_noa_code = '894' and
6228: ghr_process_sf52.g_prd IS NOT NULL AND

Line 6225: NOT(ghr_pay_calc.g_gl_upd_flag) THEN

6221:
6222:
6223:
6224: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND
6225: NOT(ghr_pay_calc.g_gl_upd_flag) THEN
6226: ghr_history_api.get_g_session_var(l_session);
6227: IF p_pa_request_rec.first_noa_code = '894' and
6228: ghr_process_sf52.g_prd IS NOT NULL AND
6229: l_session.noa_id_correct IS NULL THEN

Line 7847: p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,

7843: Procedure get_wgi_dates
7844: (p_pa_request_rec in ghr_pa_requests%rowtype,
7845: p_wgi_due_date in out nocopy date,
7846: p_wgi_pay_date out nocopy date,
7847: p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,
7848: p_dlei in date
7849: )
7850: is
7851:

Line 7862: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

7858: l_wgi_pay_date date;
7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
7860: l_pay_plan ghr_pay_plans.pay_plan%type;
7861: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
7862: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
7863: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
7864: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
7865: l_user_table_id pay_user_tables.user_table_id%TYPE;
7866:

Line 7940: ghr_pay_calc.get_pay_table_value

7936: --
7937: l_user_table_id := l_pos_ei_data.poei_information5;
7938: End if;
7939: -- get table values for the given payplan.,grade or level, step or rate, pay table combination.
7940: ghr_pay_calc.get_pay_table_value
7941: (p_user_table_id => l_user_table_id,
7942: p_pay_plan => 'GS',
7943: p_grade_or_level => l_grade_or_level,
7944: p_step_or_rate => '04',

Line 7953: ghr_pay_calc.get_pay_table_value

7949: );
7950: If p_pa_request_rec.to_basic_pay < l_step4value then
7951: p_wgi_due_date := p_pa_request_rec.effective_date + 364;
7952: Else
7953: ghr_pay_calc.get_pay_table_value
7954: (p_user_table_id => l_user_table_id,
7955: p_pay_plan => 'GS',
7956: p_grade_or_level => l_grade_or_level,
7957: p_step_or_rate => '07',

Line 7966: ghr_pay_calc.get_pay_table_value

7962: );
7963: If p_pa_request_rec.to_basic_pay between l_step4value and l_step7value then
7964: p_wgi_due_date := p_pa_request_rec.effective_date + 728;
7965: Else
7966: ghr_pay_calc.get_pay_table_value
7967: (p_user_table_id => l_user_table_id,
7968: p_pay_plan => 'GS',
7969: p_grade_or_level => l_grade_or_level,
7970: p_step_or_rate => '10',

Line 8063: when ghr_pay_calc.pay_calc_message then

8059: p_retained_Grade_rec.person_extra_info_id := l_retained_grade_rec.person_extra_info_id;
8060: End if; -- If p_pa_request_rec.first_noa_code in ('867',
8061:
8062: Exception
8063: when ghr_pay_calc.pay_calc_message then
8064: Null;
8065: End;
8066:
8067: Else -- else for -- If p_pa_request_rec.pay_rate_de