PACKAGE: APPS.HRI_DBI_WMV_BUDGET

Source

1 PACKAGE hri_dbi_wmv_budget AUTHID CURRENT_USER AS
2 /* $Header: hribdgco.pkh 115.4 2003/04/14 12:03:13 jtitmas ship $ */
3     --
4     --********************
5     --* Calculate events *
6     --********************
7     PROCEDURE calc_events( p_effective_start_date IN DATE
8                           ,p_effective_end_date   IN DATE);
9     --
10     --******************************
11     --*Calculate budgeted headcount*
12     --*******************************
13     PROCEDURE get_budgeted_headcount;
14     --
15     --***************************
16     --* Full refresh *
17     --****************************
18      PROCEDURE full_refresh( errbuf                 OUT NOCOPY VARCHAR2
19                             ,retcode                OUT NOCOPY NUMBER
20                             ,p_effective_start_date IN VARCHAR2
21                             ,p_effective_end_date   IN VARCHAR2);
22 
23     --
24     --***********************
25     --* Refresh from deltas *
26     --***********************
27     PROCEDURE refresh_from_deltas( errbuf  OUT NOCOPY VARCHAR2
28                                   ,retcode OUT NOCOPY NUMBER);
29     --
30     --****************************
31     --*Refresh Materialized Views*
32     --****************************
33     PROCEDURE refresh_mvs( errbuf  OUT NOCOPY VARCHAR2
34                           ,retcode OUT NOCOPY NUMBER);
35     --
36     --****************************
37     --*Compare Dates             *
38     --****************************
39     FUNCTION comp_date(p_effective_start_date IN DATE,
40                        p_effective_end_date IN DATE) RETURN VARCHAR2;
41     --
42 END hri_dbi_wmv_budget;