6:
7: FUNCTION get_retained_grade_details (p_person_id IN NUMBER
8: ,p_effective_date IN DATE
9: ,p_pa_request_id IN NUMBER DEFAULT NULL)
10: RETURN ghr_pay_calc.retained_grade_rec_type;
11: --
12: -- Bug#4016384 Created the following function to get the RG record available
13: -- before the MSL effective date.
14: FUNCTION get_expired_rg_details (p_person_id IN NUMBER
13: -- before the MSL effective date.
14: FUNCTION get_expired_rg_details (p_person_id IN NUMBER
15: ,p_effective_date IN DATE
16: ,p_pa_request_id IN NUMBER DEFAULT NULL)
17: RETURN ghr_pay_calc.retained_grade_rec_type;
18: --
19: PROCEDURE get_min_pay_table_value (p_user_table_id IN NUMBER
20: ,p_pay_plan IN VARCHAR2
21: ,p_grade_or_level IN VARCHAR2
46: ,p_PT_value OUT NOCOPY NUMBER
47: ,p_PT_eff_start_date OUT NOCOPY DATE
48: ,p_PT_eff_end_date OUT NOCOPY DATE);
49: --
50: PROCEDURE get_basic_pay_SAL894_6step(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
51: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
52: ,p_pay_table_data IN VARCHAR2
53: ,p_basic_pay OUT NOCOPY NUMBER
54: ,p_PT_eff_start_date OUT NOCOPY DATE
47: ,p_PT_eff_start_date OUT NOCOPY DATE
48: ,p_PT_eff_end_date OUT NOCOPY DATE);
49: --
50: PROCEDURE get_basic_pay_SAL894_6step(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
51: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
52: ,p_pay_table_data IN VARCHAR2
53: ,p_basic_pay OUT NOCOPY NUMBER
54: ,p_PT_eff_start_date OUT NOCOPY DATE
55: ,p_7dp OUT NOCOPY NUMBER);
53: ,p_basic_pay OUT NOCOPY NUMBER
54: ,p_PT_eff_start_date OUT NOCOPY DATE
55: ,p_7dp OUT NOCOPY NUMBER);
56:
57: PROCEDURE get_basic_pay_SAL894_PRDM (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
58: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
59: ,p_basic_pay OUT NOCOPY NUMBER
60: ,p_prd OUT NOCOPY VARCHAR2
61: ,p_PT_eff_start_date OUT NOCOPY DATE);
54: ,p_PT_eff_start_date OUT NOCOPY DATE
55: ,p_7dp OUT NOCOPY NUMBER);
56:
57: PROCEDURE get_basic_pay_SAL894_PRDM (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
58: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
59: ,p_basic_pay OUT NOCOPY NUMBER
60: ,p_prd OUT NOCOPY VARCHAR2
61: ,p_PT_eff_start_date OUT NOCOPY DATE);
62: --
59: ,p_basic_pay OUT NOCOPY NUMBER
60: ,p_prd OUT NOCOPY VARCHAR2
61: ,p_PT_eff_start_date OUT NOCOPY DATE);
62: --
63: PROCEDURE get_basic_pay (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
64: ,p_pay_calc_out_data OUT NOCOPY ghr_pay_calc.pay_calc_out_rec_type
65: ,p_retained_grade IN OUT NOCOPY ghr_pay_calc.retained_grade_rec_type);
66: --
67: FUNCTION get_next_WGI_step (p_pay_plan IN VARCHAR2
60: ,p_prd OUT NOCOPY VARCHAR2
61: ,p_PT_eff_start_date OUT NOCOPY DATE);
62: --
63: PROCEDURE get_basic_pay (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
64: ,p_pay_calc_out_data OUT NOCOPY ghr_pay_calc.pay_calc_out_rec_type
65: ,p_retained_grade IN OUT NOCOPY ghr_pay_calc.retained_grade_rec_type);
66: --
67: FUNCTION get_next_WGI_step (p_pay_plan IN VARCHAR2
68: ,p_current_step IN VARCHAR2)
61: ,p_PT_eff_start_date OUT NOCOPY DATE);
62: --
63: PROCEDURE get_basic_pay (p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
64: ,p_pay_calc_out_data OUT NOCOPY ghr_pay_calc.pay_calc_out_rec_type
65: ,p_retained_grade IN OUT NOCOPY ghr_pay_calc.retained_grade_rec_type);
66: --
67: FUNCTION get_next_WGI_step (p_pay_plan IN VARCHAR2
68: ,p_current_step IN VARCHAR2)
69: RETURN VARCHAR2;
94: ,p_new_adj_basic_pay OUT NOCOPY NUMBER
95: ,p_new_locality_adj OUT NOCOPY NUMBER
96: );
97: --5470182 new procedure added for calculation of 6 step process
98: PROCEDURE get_basic_pay_SAL890_6step(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
99: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
100: ,p_pay_table_data IN VARCHAR2
101: ,p_basic_pay OUT NOCOPY NUMBER
102: );
95: ,p_new_locality_adj OUT NOCOPY NUMBER
96: );
97: --5470182 new procedure added for calculation of 6 step process
98: PROCEDURE get_basic_pay_SAL890_6step(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type
99: ,p_retained_grade IN ghr_pay_calc.retained_grade_rec_type
100: ,p_pay_table_data IN VARCHAR2
101: ,p_basic_pay OUT NOCOPY NUMBER
102: );
103: