DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on GHR_PAY_CALC

Line 659: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

655: l_sub_element_code varchar2(300);
656: l_position_title varchar2(300);
657: l_position_number varchar2(20);
658: l_position_seq_no varchar2(20);
659: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
660: l_occ_series ghr_pa_requests.from_occ_code%type;
661: l_mnoa_occ_series ghr_pa_requests.from_occ_code%type;
662: l_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
663: l_flsa_category ghr_pa_requests.flsa_category%type;

Line 1104: IF (ghr_pay_calc.get_lpa_percentage (p_duty_station_id, p_effective_date)

1100: l_new_lwop_nte := l_nte_date;
1101: END IF;
1102: END IF;
1103: IF l_noa_code = '792' THEN
1104: IF (ghr_pay_calc.get_lpa_percentage (p_duty_station_id, p_effective_date)
1105: <> ghr_pay_calc.get_lpa_percentage (p_to_duty_station_id, p_effective_date)) THEN
1106: l_temp_noa_code := '894';
1107: ELSE
1108: l_temp_noa_code := l_noa_code;

Line 1105: <> ghr_pay_calc.get_lpa_percentage (p_to_duty_station_id, p_effective_date)) THEN

1101: END IF;
1102: END IF;
1103: IF l_noa_code = '792' THEN
1104: IF (ghr_pay_calc.get_lpa_percentage (p_duty_station_id, p_effective_date)
1105: <> ghr_pay_calc.get_lpa_percentage (p_to_duty_station_id, p_effective_date)) THEN
1106: l_temp_noa_code := '894';
1107: ELSE
1108: l_temp_noa_code := l_noa_code;
1109: END IF;

Line 1582: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
1579: l_errbuf varchar2(2000);
1580: l_retcode number;
1581: l_pos_ei_data per_position_extra_info%ROWTYPE;
1582: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1583: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1584: l_sel_flg varchar2(2);
1585: l_first_action_la_code1 varchar2(30);
1586: l_first_action_la_code2 varchar2(30);

Line 1583: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

1579: l_errbuf varchar2(2000);
1580: l_retcode number;
1581: l_pos_ei_data per_position_extra_info%ROWTYPE;
1582: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1583: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1584: l_sel_flg varchar2(2);
1585: l_first_action_la_code1 varchar2(30);
1586: l_first_action_la_code2 varchar2(30);
1587: l_remark_code1 varchar2(30);

Line 2609: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data, l_pay_calc_out_data

2605:
2606: BEGIN
2607: hr_utility.set_location ('Pay calc Calling :'|| l_pay_calc_in_data.noa_code, 123);
2608:
2609: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data, l_pay_calc_out_data
2610: , l_message_set, l_calculated);
2611:
2612: IF l_message_set THEN
2613: hr_utility.set_location (l_proc, 40);

Line 2619: g_proc := 'ghr_pay_calc';

2615: l_noaerrbuf := hr_utility.get_message;
2616: END IF;
2617: EXCEPTION
2618: WHEN mnoa_error THEN
2619: g_proc := 'ghr_pay_calc';
2620: RAISE;
2621: WHEN others THEN
2622: hr_utility.set_location ('Pay Calc Exception :'|| l_pay_calc_in_data.noa_code, 124);
2623:

Line 2624: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' THEN

2620: RAISE;
2621: WHEN others THEN
2622: hr_utility.set_location ('Pay Calc Exception :'|| l_pay_calc_in_data.noa_code, 124);
2623:
2624: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' THEN
2625: l_comment := 'MNOA:Error: Unadjusted Basic Pay must be entered in Employee record.';
2626: ELSE
2627: l_comment := 'MNOA:Error: See process log for details.';
2628: END IF;

Line 2681: hr_utility.set_location ('Error in Ghr_pay_calc.sql_main_pay_calc '|| 'Err is '|| sqlerrm (sqlcode), 20);

2677: ins_upd_per_extra_info (p_person_id, l_effective_date
2678: , l_sel_flg, l_comment
2679: , p_mass_salary_id);
2680: l_comment := NULL;
2681: hr_utility.set_location ('Error in Ghr_pay_calc.sql_main_pay_calc '|| 'Err is '|| sqlerrm (sqlcode), 20);
2682: l_noaerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm (sqlcode);
2683: g_proc := 'ghr_pay_calc';
2684: RAISE mnoa_error;
2685: END;

Line 2682: l_noaerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm (sqlcode);

2678: , l_sel_flg, l_comment
2679: , p_mass_salary_id);
2680: l_comment := NULL;
2681: hr_utility.set_location ('Error in Ghr_pay_calc.sql_main_pay_calc '|| 'Err is '|| sqlerrm (sqlcode), 20);
2682: l_noaerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm (sqlcode);
2683: g_proc := 'ghr_pay_calc';
2684: RAISE mnoa_error;
2685: END;
2686: --Begin Bug# 14751973, for some NOAs with step 00 to pay values are getting null

Line 2683: g_proc := 'ghr_pay_calc';

2679: , p_mass_salary_id);
2680: l_comment := NULL;
2681: hr_utility.set_location ('Error in Ghr_pay_calc.sql_main_pay_calc '|| 'Err is '|| sqlerrm (sqlcode), 20);
2682: l_noaerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm (sqlcode);
2683: g_proc := 'ghr_pay_calc';
2684: RAISE mnoa_error;
2685: END;
2686: --Begin Bug# 14751973, for some NOAs with step 00 to pay values are getting null
2687: l_pay_calc_out_data.basic_pay := nvl(l_pay_calc_out_data.basic_pay,l_old_basic_pay);