DBA Data[Home] [Help]

APPS.GHR_WGI_PKG dependencies on GHR_PAY_CALC

Line 222: l_retained_grade ghr_pay_calc.retained_grade_rec_type;

218: l_frequency NUMBER;
219: l_message_set BOOLEAN;
220: l_calculated BOOLEAN;
221: l_nature_of_action_id ghr_nature_of_actions.nature_of_action_id%TYPE;
222: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
223: -- used for starting the wgi workflow
224: l_start_wgi_wf_flag CHAR (1) := 'N';
225: l_errbuf VARCHAR2 (2000);
226: l_retcode NUMBER := 0;

Line 247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;

243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
246: -- Added pay calc record type in/out
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;
249: l_req VARCHAR2 (15);
250: l_in_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;

Line 248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;

244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
246: -- Added pay calc record type in/out
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;
249: l_req VARCHAR2 (15);
250: l_in_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
252: -- Remarks

Line 1431: ghr_pay_calc.sql_main_pay_calc (p_pay_calc_data => l_pay_calc_in_rec_type,

1427: NULL;
1428: --Bug# 6340691
1429: l_pay_calc_in_rec_type.open_out_locality_adj := l_from_locality_adj;
1430: -- Call the pay calc
1431: ghr_pay_calc.sql_main_pay_calc (p_pay_calc_data => l_pay_calc_in_rec_type,
1432: p_pay_calc_out_data => l_pay_calc_out_rec_type,
1433: p_message_set => l_message_set,
1434: p_calculated => l_calculated
1435: );

Line 1479: ROUND(ghr_pay_calc.convert_amount(l_to_basic_pay,l_from_pay_basis,'PA')

1475: if l_from_basic_pay <> l_to_basic_pay then
1476: if l_retention_allow_percentage is null then
1477: l_ret_calc_perc := (l_to_retention_allowance / l_from_basic_pay) * 100;
1478: l_new_retention_allowance :=
1479: ROUND(ghr_pay_calc.convert_amount(l_to_basic_pay,l_from_pay_basis,'PA')
1480: * l_ret_calc_perc / 100 ,0);
1481: else
1482: l_new_retention_allowance :=
1483: ROUND(ghr_pay_calc.convert_amount(l_to_basic_pay,l_from_pay_basis,'PA')

Line 1483: ROUND(ghr_pay_calc.convert_amount(l_to_basic_pay,l_from_pay_basis,'PA')

1479: ROUND(ghr_pay_calc.convert_amount(l_to_basic_pay,l_from_pay_basis,'PA')
1480: * l_ret_calc_perc / 100 ,0);
1481: else
1482: l_new_retention_allowance :=
1483: ROUND(ghr_pay_calc.convert_amount(l_to_basic_pay,l_from_pay_basis,'PA')
1484: * l_retention_allow_percentage / 100 ,0);
1485: end if;
1486: else
1487: l_new_retention_allowance := l_to_retention_allowance;

Line 1507: + ghr_pay_calc.convert_amount(NVL(l_to_other_pay_amount,0),

1503: end if;
1504: l_pay_calc_out_rec_type.other_pay_amount := l_to_other_pay_amount;
1505:
1506: l_to_total_salary := NVL(l_to_adj_basic_pay,0)
1507: + ghr_pay_calc.convert_amount(NVL(l_to_other_pay_amount,0),
1508: 'PA',
1509: l_from_pay_basis);
1510:
1511: l_pay_calc_out_rec_type.total_salary := l_to_total_salary;