[Home] [Help]
PACKAGE: APPS.PQH_EMPLOYEE_SALARY
Source
1 Package pqh_employee_salary AUTHID CURRENT_USER as
2 /* $Header: pqempsal.pkh 120.1.12020000.2 2012/08/22 10:11:28 lbodired ship $ */
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
33 -- fix for the bug#12613915
34 Function pgm_to_annual1 (p_ref_perd_cd in varchar2,
35 p_pgm_currency in varchar2,
36 p_amount in number,
37 P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
38 P_Effective_Date In Date)
39 RETURN NUMBER;
40 -- fix for the bug#12613915
41
42 Procedure get_emp_proposed_salary
43 (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
44 P_Effective_Date In Date,
45 p_proposed_salary OUT nocopy number,
46 p_sal_chg_dt OUT nocopy date,
47 p_frequency OUT nocopy varchar2,
48 p_annual_salary OUT nocopy number,
49 p_pay_basis OUT nocopy varchar2,
50 p_reason_cd OUT nocopy varchar2,
51 p_currency OUT nocopy varchar2,
52 p_status OUT nocopy number
53 );
54 --
55 End;