eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MRE_PKG dependencies on GHR_PAY_CALC

Line 437: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

433: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
434: l_pos_grp1_rec per_position_extra_info%rowtype;
435: --l_pos_grp2_rec per_position_extra_info%rowtype;
436:
437: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
438: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
439: l_sel_flg VARCHAR2(2);
440: l_sel_status VARCHAR2(32);
441:

Line 438: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

434: l_pos_grp1_rec per_position_extra_info%rowtype;
435: --l_pos_grp2_rec per_position_extra_info%rowtype;
436:
437: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
438: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
439: l_sel_flg VARCHAR2(2);
440: l_sel_status VARCHAR2(32);
441:
442: l_first_action_la_code1 VARCHAR2(30);

Line 471: p_retained_grade ghr_pay_calc.retained_grade_rec_type;

467: l_break VARCHAR2(1) := 'N';
468: l_appl_id VARCHAR2(20);-- Bug#4114068
469:
470: -- Bug 3663808 Variable to store retained grade details
471: p_retained_grade ghr_pay_calc.retained_grade_rec_type;
472:
473: CURSOR c_pay_tab_type(p_user_table_id pay_user_tables.user_table_id%type)
474: IS
475: SELECT range_or_match

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

803: 'Locn id '||to_char(t_duty_station_locn_id));
804: l_ind := 130;
805: --Start of Bug 3944729
806: IF ( l_duty_station_id <> t_duty_station_id )
807: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
808: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
809:
810: THEN
811: -- Bug#4388288

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

804: l_ind := 130;
805: --Start of Bug 3944729
806: IF ( l_duty_station_id <> t_duty_station_id )
807: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
808: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
809:
810: THEN
811: -- Bug#4388288
812: g_proc := 'Invalid_Duty_Station';

Line 1000: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data

996: END;
997: END IF;
998:
999: BEGIN
1000: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data
1001: ,l_pay_calc_out_data
1002: ,l_message_set
1003: ,l_calculated);
1004:

Line 1013: raise ghr_pay_calc.unable_to_calculate;

1009: hr_utility.get_message_details(l_mslerrbuf,l_appl_id);
1010: --Bug# 10194273 added GHR_38260,38253,39261,38262
1011: IF l_mslerrbuf in ('GHR_38260_NO_CALC_PAY_PLAN', 'GHR_38254_NO_CALC_PRD','GHR_38253_NO_PAY_PLAN_VALUE',
1012: 'GHR_38261_NO_CALC_FAMILY','GHR_38262_NO_CALC_PAY_BASIS') THEN
1013: raise ghr_pay_calc.unable_to_calculate;
1014: ELSE
1015: raise mass_error;
1016: END IF;
1017: ELSE

Line 1042: when ghr_pay_calc.unable_to_calculate THEN

1038: END IF;
1039: EXCEPTION
1040: when mass_error then
1041: raise;
1042: when ghr_pay_calc.unable_to_calculate THEN
1043: l_new_basic_pay := l_pay_calc_in_data.current_basic_pay;
1044: l_new_locality_adj := l_pay_calc_in_data.current_adj_basic_pay - l_pay_calc_in_data.current_basic_pay ;
1045: l_new_adj_basic_pay := l_pay_calc_in_data.current_adj_basic_pay ;
1046: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator

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

1042: when ghr_pay_calc.unable_to_calculate THEN
1043: l_new_basic_pay := l_pay_calc_in_data.current_basic_pay;
1044: l_new_locality_adj := l_pay_calc_in_data.current_adj_basic_pay - l_pay_calc_in_data.current_basic_pay ;
1045: l_new_adj_basic_pay := l_pay_calc_in_data.current_adj_basic_pay ;
1046: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator
1047: ,l_pay_calc_in_data.current_adj_basic_pay
1048: ,l_pay_calc_in_data.pay_basis);
1049: l_new_availability_pay := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.ap_premium_pay_indicator
1050: ,l_pay_calc_in_data.current_adj_basic_pay

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

1045: l_new_adj_basic_pay := l_pay_calc_in_data.current_adj_basic_pay ;
1046: l_new_au_overtime := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.auo_premium_pay_indicator
1047: ,l_pay_calc_in_data.current_adj_basic_pay
1048: ,l_pay_calc_in_data.pay_basis);
1049: l_new_availability_pay := ghr_pay_calc.get_ppi_amount (l_pay_calc_in_data.ap_premium_pay_indicator
1050: ,l_pay_calc_in_data.current_adj_basic_pay
1051: ,l_pay_calc_in_data.pay_basis);
1052:
1053: l_out_pay_rate_determinant := l_pay_calc_in_data.pay_rate_determinant;

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

1064: l_new_other_pay_amount := null;
1065: END IF;
1066: --end Bug#4114068
1067: when others then
1068: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1069: 'Err is '||sqlerrm(sqlcode),20);
1070: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '||
1071: sqlerrm(sqlcode);
1072: raise mass_error;

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

1066: --end Bug#4114068
1067: when others then
1068: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
1069: 'Err is '||sqlerrm(sqlcode),20);
1070: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '||
1071: sqlerrm(sqlcode);
1072: raise mass_error;
1073: END;
1074:

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

1597: t_position_organization);
1598:
1599: --Start of Bug 3944729
1600: IF ( l_duty_station_id <> t_duty_station_id )
1601: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1602: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
1603:
1604: THEN
1605: l_log_text := 'Error in MRE: '||p_mass_realignment_name||

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

1598:
1599: --Start of Bug 3944729
1600: IF ( l_duty_station_id <> t_duty_station_id )
1601: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1602: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date) )
1603:
1604: THEN
1605: l_log_text := 'Error in MRE: '||p_mass_realignment_name||
1606: ' for Vacant Position : '||l_position_title||'.'||l_position_NUMBER

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

1874: l_position_data_rec.location_id := l_target_duty_station_locn_id ; -- Bug 3490826
1875:
1876: -- Bug# 4388288
1877: IF ( l_duty_station_id <> t_duty_station_id )
1878: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1879: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date)) THEN
1880: l_log_text := 'Error in MRE: '||p_mass_realignment_name||
1881: ' for Vacant Position : '||l_position_title||'.'||l_position_NUMBER
1882: ||'.'||l_position_seq_no||'.'||l_sub_element_code||'. Error: ';

Line 1879: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date)) THEN

1875:
1876: -- Bug# 4388288
1877: IF ( l_duty_station_id <> t_duty_station_id )
1878: AND ( ghr_pay_calc.get_lpa_percentage(l_duty_station_id,l_effective_date) <>
1879: ghr_pay_calc.get_lpa_percentage(t_duty_station_id,l_effective_date)) THEN
1880: l_log_text := 'Error in MRE: '||p_mass_realignment_name||
1881: ' for Vacant Position : '||l_position_title||'.'||l_position_NUMBER
1882: ||'.'||l_position_seq_no||'.'||l_sub_element_code||'. Error: ';
1883: l_log_text := l_log_text||'The duty station entered results in a change in Locality Percentage.'||

Line 3240: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

3236: l_cust_rec ghr_mass_act_custom.ghr_mass_custom_out_rec_type;
3237: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
3238: ----Temp Promo Changes.
3239: l_step_or_rate VARCHAR2(30);
3240: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
3241:
3242: BEGIN
3243: g_proc := 'create_mass_act_prev';
3244: