1 Package ghr_custom_award AUTHID CURRENT_USER as
2 /* $Header: ghcusawd.pkh 120.0.12000000.1 2007/04/25 09:16:07 utokachi noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- |-----------------------------< custom_award_salary >-----------------------|
6 -- -----------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- This procedure is provided for the customer to update to allow them to
11 -- add there own routines to determine at the Award Salary. It is called
12 -- from the award_amount_calc procedure.
13 --
14 --
15 -- In Arguments:
16 -- p_position_id -- Position ID associated with the current assignment
17 -- p_person_id -- Person ID as on the effective Date
18 -- p_prd -- Pay Rate Determinant of the current assignment
19 -- p_pay_basis -- Pay Basis of the current assignment
20 -- p_pay_plan -- Pay Plan associated with the current assignment
21 -- p_user_table_id -- Pay Table ID associated with the current assignment
22 -- p_grade_or_level -- Grade or Level associated with the current assignment
23 -- p_effective_date -- Effective date of the Award Action
24 -- p_basic_pay -- Basic Pay as on the Award RPA effective date
25 -- p_adj_basic_pay -- Adjusted Basic Pay as on the Award RPA effective date
26 -- p_duty_station_id -- Duty station ID associated with the position
27
28 --
29 -- OUT Arguments:
30 -- p_award_salary
31 --
32 -- Post Success:
33 -- Processing goes back to the award_amount_calc process.
34 -- If the customer calculated award salary, they have to set
35 -- the p_award_salary with the calculated value.
36 --
37 -- Post Failure:
38 -- SQL failure:
39 -- Processing goes back to the award_amount_calc process:
40 -- The initial value of the p_award_salary will be returned
41 -- as the result.
42 -- Developer Implementation Notes:
43 -- Customer defined.
44 --
45 -- {End of Comments}
46 -- -----------------------------------------------------------------------------
47 procedure custom_award_salary
48 (p_position_id IN NUMBER
49 ,p_person_id IN per_people_f.person_id%TYPE
50 ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
51 ,p_pay_basis IN VARCHAR2
52 ,p_pay_plan IN VARCHAR2
53 ,p_user_table_id IN NUMBER
54 ,p_grade_or_level IN VARCHAR2
55 ,p_effective_date IN DATE
56 ,p_basic_pay IN NUMBER
57 ,p_adj_basic_pay IN NUMBER
58 ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
59 ,p_award_salary IN OUT NOCOPY NUMBER
60 );
61 --
62 end ghr_custom_award;