DBA Data[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;