DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on GHR_PAY_CALC

Line 431: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

427: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
428: l_pos_grp1_rec per_position_extra_info%rowtype;
429: --l_pos_grp2_rec per_position_extra_info%rowtype;
430:
431: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
432: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
433: l_sel_flg VARCHAR2(2);
434: l_sel_status VARCHAR2(32);
435:

Line 432: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

428: l_pos_grp1_rec per_position_extra_info%rowtype;
429: --l_pos_grp2_rec per_position_extra_info%rowtype;
430:
431: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
432: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
433: l_sel_flg VARCHAR2(2);
434: l_sel_status VARCHAR2(32);
435:
436: l_first_action_la_code1 VARCHAR2(30);

Line 465: p_retained_grade ghr_pay_calc.retained_grade_rec_type;

461: l_break VARCHAR2(1) := 'N';
462: l_appl_id VARCHAR2(20);-- Bug#4114068
463:
464: -- Bug 3663808 Variable to store retained grade details
465: p_retained_grade ghr_pay_calc.retained_grade_rec_type;
466:
467: CURSOR c_pay_tab_type(p_user_table_id pay_user_tables.user_table_id%type)
468: IS
469: SELECT range_or_match

Line 796: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>

792: 'Locn id '||to_char(t_duty_station_locn_id));
793: l_ind := 130;
794: --Start of Bug 3944729
795: IF ( l_duty_station_id <> t_duty_station_id )
796: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
797: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
798:
799: THEN
800: -- Bug#4388288

Line 797: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )

793: l_ind := 130;
794: --Start of Bug 3944729
795: IF ( l_duty_station_id <> t_duty_station_id )
796: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
797: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
798:
799: THEN
800: -- Bug#4388288
801: g_proc := 'Invalid_Duty_Station';

Line 980: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

976: END;
977: END IF;
978:
979: BEGIN
980: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
981: ,l_pay_calc_out_data
982: ,l_message_set
983: ,l_calculated);
984:

Line 991: raise ghr_pay_calc.unable_to_calculate;

987: l_calculated := FALSE;
988: --Begin Bug#4114068
989: hr_utility.get_message_details(l_mslerrbuf,l_appl_id);
990: IF l_mslerrbuf = 'GHR_38254_NO_CALC_PRD' THEN
991: raise ghr_pay_calc.unable_to_calculate;
992: ELSE
993: raise mass_error;
994: END IF;
995: ELSE

Line 1020: when ghr_pay_calc.unable_to_calculate THEN

1016: END IF;
1017: EXCEPTION
1018: when mass_error then
1019: raise;
1020: when ghr_pay_calc.unable_to_calculate THEN
1021: l_new_basic_pay := l_pay_calc_in_data.current_basic_pay;
1022: l_new_locality_adj := l_pay_calc_in_data.current_adj_basic_pay - l_pay_calc_in_data.current_basic_pay ;
1023: l_new_adj_basic_pay := l_pay_calc_in_data.current_adj_basic_pay ;
1024: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator

Line 1024: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator

1020: when ghr_pay_calc.unable_to_calculate THEN
1021: l_new_basic_pay := l_pay_calc_in_data.current_basic_pay;
1022: l_new_locality_adj := l_pay_calc_in_data.current_adj_basic_pay - l_pay_calc_in_data.current_basic_pay ;
1023: l_new_adj_basic_pay := l_pay_calc_in_data.current_adj_basic_pay ;
1024: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator
1025: ,l_pay_calc_in_data.current_adj_basic_pay
1026: ,l_pay_calc_in_data.pay_basis);
1027: l_new_availability_pay := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.ap_premium_pay_indicator
1028: ,l_pay_calc_in_data.current_adj_basic_pay

Line 1027: l_new_availability_pay := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.ap_premium_pay_indicator

1023: l_new_adj_basic_pay := l_pay_calc_in_data.current_adj_basic_pay ;
1024: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator
1025: ,l_pay_calc_in_data.current_adj_basic_pay
1026: ,l_pay_calc_in_data.pay_basis);
1027: l_new_availability_pay := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.ap_premium_pay_indicator
1028: ,l_pay_calc_in_data.current_adj_basic_pay
1029: ,l_pay_calc_in_data.pay_basis);
1030:
1031: l_out_pay_rate_determinant := l_pay_calc_in_data.pay_rate_determinant;

Line 1046: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||

1042: l_new_other_pay_amount := null;
1043: END IF;
1044: --end Bug#4114068
1045: when others then
1046: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1047: 'Err is '||sqlerrm(sqlcode),20);
1048: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '||
1049: sqlerrm(sqlcode);
1050: raise mass_error;

Line 1048: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '||

1044: --end Bug#4114068
1045: when others then
1046: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1047: 'Err is '||sqlerrm(sqlcode),20);
1048: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '||
1049: sqlerrm(sqlcode);
1050: raise mass_error;
1051: END;
1052:

Line 1571: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>

1567: t_position_organization);
1568:
1569: --Start of Bug 3944729
1570: IF ( l_duty_station_id <> t_duty_station_id )
1571: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1572: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
1573:
1574: THEN
1575: l_log_text := 'Error in MRE: '||p_mass_realignment_name||

Line 1572: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )

1568:
1569: --Start of Bug 3944729
1570: IF ( l_duty_station_id <> t_duty_station_id )
1571: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1572: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
1573:
1574: THEN
1575: l_log_text := 'Error in MRE: '||p_mass_realignment_name||
1576: ' for Vacant Position : '||l_position_title||'.'||l_position_NUMBER

Line 1813: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>

1809: l_position_data_rec.location_id := l_target_duty_station_locn_id ; -- Bug 3490826
1810:
1811: -- Bug# 4388288
1812: IF ( l_duty_station_id <> t_duty_station_id )
1813: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1814: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
1815:
1816: THEN
1817: l_log_text := 'Error in MRE: '||p_mass_realignment_name||

Line 1814: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )

1810:
1811: -- Bug# 4388288
1812: IF ( l_duty_station_id <> t_duty_station_id )
1813: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1814: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
1815:
1816: THEN
1817: l_log_text := 'Error in MRE: '||p_mass_realignment_name||
1818: ' for Vacant Position : '||l_position_title||'.'||l_position_NUMBER

Line 3077: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3073: l_cust_rec ghr_mass_act_custom.ghr_mass_custom_out_rec_type;
3074: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
3075: ----Temp Promo Changes.
3076: l_step_or_rate VARCHAR2(30);
3077: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3078:
3079: BEGIN
3080: g_proc := 'create_mass_act_prev';
3081: