1 PACKAGE hri_bpl_sal AS
2 /* $Header: hribsal.pkh 120.0 2005/05/29 06:54:26 appldev noship $ */
3
4 PROCEDURE fetch_currency_and_salary(p_assignment_id IN NUMBER,
5 p_date IN DATE);
6 --
7 FUNCTION get_assignment_sal(p_assignment_id IN NUMBER,
8 p_date IN DATE)
9 RETURN NUMBER;
10 --
11 FUNCTION get_assignment_currency(p_assignment_id IN NUMBER,
12 p_date IN DATE)
13 RETURN VARCHAR2;
14 --
15 FUNCTION convert_amount(p_from_currency IN VARCHAR2,
16 p_to_currency IN VARCHAR2,
17 p_conversion_date IN DATE,
18 p_amount IN NUMBER,
19 p_business_group_id IN NUMBER DEFAULT NULL)
20 RETURN NUMBER;
21 --
22 FUNCTION convert_amount(p_from_currency IN VARCHAR2,
23 p_to_currency IN VARCHAR2,
24 p_conversion_date IN DATE,
25 p_amount IN NUMBER,
26 p_rate_type IN VARCHAR2)
27 RETURN NUMBER;
28 --
29 -- ----------------------------------------------------------------------------
30 -- FUNCTION GET_PERD_ANNUALIZATION_FACTOR
31 -- ----------------------------------------------------------------------------
32 -- When the pay basis type is PERIOD then the annualization factor can be null.
33 -- In such cases the annualization factor is same as the yearly frequency of
34 -- the payroll. This function returns the annualization factor is such cases.
35 -- ----------------------------------------------------------------------------
36 --
37 FUNCTION get_perd_annualization_factor( p_assignment_id IN NUMBER,
38 p_effective_date IN DATE)
39 RETURN NUMBER;
40 --
41 END hri_bpl_sal;
[Home] [Help]