[Home] [Help]
PACKAGE: APPS.HRI_DBI_WMV_COUNT
Source
1 PACKAGE hri_dbi_wmv_count AS
2 /* $Header: hriwmvco.pkh 120.0 2005/05/29 07:49:50 appldev noship $ */
3 --
4 --************************************************************
5 --* Calculate total ABV count as of p_effective_start_date-1 *
6 --************************************************************
7 --
8 PROCEDURE calc_wmv_count( p_effective_start_date IN DATE
9 ,p_effective_end_date IN DATE);
10 --
11 --********************
12 --* Calculate events *
13 --********************
14 PROCEDURE calc_events( p_supervisor_id IN NUMBER DEFAULT NULL
15 ,p_location_id IN NUMBER DEFAULT NULL
16 ,p_effective_start_date IN DATE
17 ,p_effective_end_date IN DATE);
18 --
19 --************************************
20 --*Calculate new hire + transfers in *
21 --************************************
22 --
23 PROCEDURE calc_new_hire_trans_in;
24 --
25 --******************************************
26 --* Calculate terminations + transfers out *
27 --******************************************
28 --
29 PROCEDURE calc_term_trans_out;
30 --
31 --******************************************************************
32 --* Calculate location transfers - no change to supervisors or job *
33 --******************************************************************
34 --
35 PROCEDURE calc_event_loc_transfer (p_effective_start_date IN DATE
36 ,p_effective_end_date IN DATE);
37 --
38 --******************************************************************
39 --* Calculate job transfers - no change to supervisors or location *
40 --******************************************************************
41 --
42 PROCEDURE calc_event_job_transfer (p_effective_start_date IN DATE
43 ,p_effective_end_date IN DATE);
44 --
45 --***************************************************************
46 --* Calculate job/location transfers - no change to supervisors *
47 --***************************************************************
48 --
49 PROCEDURE calc_event_job_loc_transfer (p_effective_start_date IN DATE
50 ,p_effective_end_date IN DATE);
51 --
52 --*********************************************************************
53 --
54 --*****************************
55 --* Calculate distinct events *
56 --*****************************
57 --
58 PROCEDURE calc_distinct_events;
59 --
60 --************************************
61 --* Remove duplicates from Temp table*
62 --************************************
63 --
64 PROCEDURE calc_remove_duplicate;
65 --
66 --*************************************
67 --*Print Global Temp Table in Log File*
68 --*************************************
69 --
70 PROCEDURE calc_print_temp_table;
71 --
72 --****************
73 --* Full refresh *
74 --****************
75 --
76 PROCEDURE full_refresh( errbuf OUT NOCOPY VARCHAR2
77 ,retcode OUT NOCOPY NUMBER
78 ,p_effective_start_date IN VARCHAR2
79 ,p_effective_end_date IN VARCHAR2);
80 --
81 --***********************
82 --* Refresh from deltas *
83 --***********************
84 --
85 PROCEDURE refresh_from_deltas( errbuf OUT NOCOPY VARCHAR2
86 ,retcode OUT NOCOPY NUMBER);
87 --
88 --*****************************************************************
89 --* This procedure calculates period ago wmv_cout of a supervisor *
90 --*****************************************************************
91 --
92 FUNCTION period_ago_count( p_supervisor_id IN NUMBER
93 ,p_effective_start_date IN DATE
94 ,p_count_type IN VARCHAR2)
95 RETURN NUMBER;
96 --
97 --******************************************************************************
98 --* This procedure calculate period ago wmv_count of a supervisor by a country *
99 --******************************************************************************
100 FUNCTION period_ago_count_ctr( p_supervisor_id IN NUMBER
101 ,p_effective_start_date IN DATE
102 ,p_country IN VARCHAR2)
103 RETURN NUMBER;
104 --
105 --********************
106 --*Refresh MV method *
107 --*******************
108 FUNCTION refresh_mv_method RETURN VARCHAR2;
109 --
110 --****************************
111 --*Refresh materialized views*
112 --****************************
113 --
114 PROCEDURE refresh_mvs( errbuf OUT NOCOPY VARCHAR2
115 ,retcode OUT NOCOPY NUMBER
116 ,complete_refresh IN VARCHAR2 DEFAULT 'Y');
117 --
118 END hri_dbi_wmv_count;