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