[Home] [Help]
PACKAGE: APPS.PQH_EMPLOYEE_SALARY
Source
1 Package pqh_employee_salary as
2 /* $Header: pqempsal.pkh 120.1 2005/06/05 23:58 ggnanagu noship $ */
3 --
4 Procedure get_employee_salary
5 (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
6 P_Effective_Date In Date,
7 p_salary OUT nocopy number,
8 p_frequency OUT nocopy varchar2,
9 p_annual_salary OUT nocopy number,
10 p_pay_basis OUT nocopy varchar2,
11 p_reason_cd OUT nocopy varchar2,
12 p_currency OUT nocopy varchar2,
13 p_status OUT nocopy number,
14 p_pay_basis_frequency OUT nocopy varchar2
15 );
16
17
18 --
19 Procedure check_grade_ladder_exists(p_business_group_id in number,
20 p_effective_date in date,
21 p_grd_ldr_exists_flag out nocopy varchar2);
22 --
23 Procedure check_grade_ladder_exists(p_business_group_id in number,
24 p_effective_date in date ,
25 p_grd_ldr_exists_flag out nocopy boolean);
26
27 Function pgm_to_annual (p_ref_perd_cd in varchar2,
28 p_pgm_currency in varchar2,
29 p_amount in number)
30 RETURN NUMBER;
31
32 Procedure get_emp_proposed_salary
33 (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
34 P_Effective_Date In Date,
35 p_proposed_salary OUT nocopy number,
36 p_sal_chg_dt OUT nocopy date,
37 p_frequency OUT nocopy varchar2,
38 p_annual_salary OUT nocopy number,
39 p_pay_basis OUT nocopy varchar2,
40 p_reason_cd OUT nocopy varchar2,
41 p_currency OUT nocopy varchar2,
42 p_status OUT nocopy number
43 );
44 --
45 End;