1 PACKAGE AMS_DCF_DEFAULT_VALUES AUTHID CURRENT_USER AS
2 /* $Header: amsvdohs.pls 115.8 2002/05/21 10:40:04 pkm ship $ */
3
4 -- FUNCTION
5 -- get events default aggregate_by
6 FUNCTION get_events_aggregate(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
7
8 -- FUNCTION
9 -- get campaigns default aggregate by
10 FUNCTION get_campaigns_aggregate(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
11
12
13 -- FUNCTION
14 -- get funds default aggregate by
15 FUNCTION get_funds_aggregate(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
16
17
18 -- FUNCTION
19 -- get Events default year
20 FUNCTION get_events_year(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
21
22 -- FUNCTION
23 -- get events default quarter
24 FUNCTION get_events_quarter(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
25
26 -- FUNCTION
27 -- get campaigns default year
28 FUNCTION get_campaigns_year(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
29
30 -- FUNCTION
31 -- get campaigns default quarter
32 FUNCTION get_campaigns_quarter(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
33
34 -- FUNCTION
35 -- get funds default year
36 FUNCTION get_funds_year(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
37
38 -- FUNCTION
39 -- get funds default quarter
40 FUNCTION get_funds_quarter(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
41
42 -- FUNCTION
43 -- get default period
44 FUNCTION get_default_period (parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
45
46 -- FUNCTION
47 -- get default period incremental
48 FUNCTION get_default_period_inc (parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
49
50
51 FUNCTION get_default_quarter(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
52
53 FUNCTION get_default_year(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
54
55 FUNCTION get_default_period_hom(parameters IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
56
57
58 END AMS_DCF_DEFAULT_VALUES;
59 --show errors;
[Home] [Help]