215:
216: --Bug#5132113 added new parameter p_open_range_out_basic_pay
217:
218: FUNCTION populate_in_rec_structure
219: (p_person_id IN per_people_f.person_id%TYPE
220: ,p_position_id IN hr_all_positions_f.position_id%TYPE
221: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
222: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
223: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
1697: RAISE;
1698:
1699: END get_total_salary;
1700:
1701: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%TYPE
1702: ,p_position_id IN hr_all_positions_f.position_id%TYPE
1703: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
1704: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1705: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
1798:
1799: cursor cur_ex_emp is
1800: select 1
1801: from per_person_types pet1,
1802: per_people_f per1
1803: where pet1.person_type_id = per1.person_type_id
1804: and per1.person_id = p_person_id
1805: and nvl(p_effective_date,trunc(sysdate))
1806: between per1.effective_start_date and per1.effective_end_date
5328: ,p_adj_basic_pay IN NUMBER
5329: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
5330: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
5331: ,p_pay_basis IN VARCHAR2
5332: ,p_person_id IN per_people_f.person_id%TYPE
5333: ,p_award_amount OUT NOCOPY NUMBER
5334: ,p_award_salary OUT NOCOPY NUMBER
5335: ) IS
5336: l_pay_table VARCHAR2(4);