1 PACKAGE hri_dbi_salary AS
2 /* $Header: hrisalsu.pkh 120.0 2005/05/29 07:48:12 appldev noship $ */
3
4 PROCEDURE full_refresh( p_start_date IN DATE,
5 p_end_date IN DATE );
6
7 PROCEDURE full_refresh( errbuf OUT NOCOPY VARCHAR2,
8 retcode OUT NOCOPY NUMBER,
9 p_start_date IN VARCHAR2,
10 p_end_date IN VARCHAR2 );
11
12 PROCEDURE refresh_direct( p_start_date IN DATE,
13 p_end_date IN DATE );
14
15 PROCEDURE refresh_from_deltas( errbuf OUT NOCOPY VARCHAR2,
16 retcode OUT NOCOPY NUMBER);
17
18 --
19 -- ***********************************************************************
20 -- * Function to convert salary
21 -- ***********************************************************************
22 Function convert_salary(
23 p_from_currency IN VARCHAR2,
24 p_to_currency IN VARCHAR2,
25 p_amount IN NUMBER,
26 p_effective_date IN DATE,
27 p_rate_type IN VARCHAR2
28 ) return number;
29
30 --
31 --*********************************************************************
32 --* This procedure calculates period ago total salary of a supervisor *
33 --*********************************************************************
34 --
35 FUNCTION period_ago_salary( p_supervisor_id IN NUMBER
36 ,p_effective_start_date IN DATE
37 ,p_salary_type IN VARCHAR2
38 ,p_currency_conv_date IN DATE)
39 RETURN NUMBER;
40
41 --
42 --**************************************************************************
43 --* This procedure calculates period ago salary by country of a supervisor *
44 --**************************************************************************
45 --
46
47 FUNCTION period_ago_sal_ctr( p_supervisor_id IN NUMBER
48 ,p_effective_start_date IN DATE
49 ,p_country IN VARCHAR2
50 ,p_currency_conv_date IN DATE)
51
52 RETURN NUMBER;
53 --
54 --*******************
55 --*Refresh MV Method*
56 --*******************
57 --
58 FUNCTION refresh_mv_method RETURN VARCHAR2;
59 --
60 --****************************
61 --*Refresh Materialized Views*
62 --****************************
63 PROCEDURE refresh_mvs( errbuf OUT NOCOPY VARCHAR2
64 ,retcode OUT NOCOPY NUMBER
65 ,complete_refresh IN VARCHAR2 DEFAULT 'Y');
66
67 END hri_dbi_salary;