1 PACKAGE POA_TIME_API AUTHID CURRENT_USER AS
2 /* $Header: POAQTRSS.pls 115.3 2002/01/24 17:59:47 pkm ship $ */
3
4 -- -------------------------------------------------------------------
5 -- Name: get_today
6 -- Desc: Returns today's date with time element. If the profile
7 -- POA_FIXED_DATE is set, then it returns the fixed date. Otherwise
8 -- it returnes sysdate
9 -- Output: Todays date
10 -- Error: If any sql errors occurs, an exception is raised.
11 -- --------------------------------------------------------------------
12 FUNCTION get_today RETURN DATE;
13
14 -- -------------------------------------------------------------------
15 -- Name: get_cqtr_start
16 -- Desc: Returns quarter start date for current year current
17 -- quarter (cycq) in the enterprise calendar. Current quarter
18 -- calculated based on sysdate. Info is cached after initial access
19 -- Output: Enterprise calendar current quarter start date
20 -- Error: If any sql errors occurs, an exception is raised.
21 -- --------------------------------------------------------------------
22 Function get_cqtr_start return DATE;
23
24 -- -------------------------------------------------------------------
25 -- Name: get_cqtr_end
26 -- Desc: Returns quarter end date for current year current
27 -- quarter (cycq) in the enterprise calendar. Current quarter
28 -- calculated based on sysdate. Info is cached after initial access
29 -- Output: Enterprise calendar current quarter end date
30 -- Error: If any sql errors occurs, an exception is raised.
31 -- --------------------------------------------------------------------
32 Function get_cqtr_end return DATE;
33
34 -- -------------------------------------------------------------------
35 -- Name: get_lycq_start
36 -- Desc: Returns quarter start date for last year current quarter
37 -- (lycq) in the enterprise calendar. Info is cached after
38 -- initial access
39 -- Output: Enterprise calendar last year same quarter start date
40 -- Error: If any sql errors occurs, an exception is raised.
41 -- --------------------------------------------------------------------
42 Function get_lycq_start return DATE;
43
44 -- -------------------------------------------------------------------
45 -- Name: get_lycq_end
46 -- Desc: Returns quarter end date for last year current quarter
47 -- (lycq) in the enterprise calendar. Info is cached after
48 -- initial access
49 -- Output: Enterprise calendar last year same quarter end date
50 -- Error: If any sql errors occurs, an exception is raised.
51 -- --------------------------------------------------------------------
52 Function get_lycq_end return DATE;
53
54 -- -------------------------------------------------------------------
55 -- Name: get_lycq_today
56 -- Desc: Returns today's equavalent day in the same quarter from last
57 -- year in the enterprise calendar. The equavlent day is
58 -- established by counting backwards the same # of days from
59 -- the end of the quarter. Info is cached after initial access
60 -- Output: Enterprise calendar last year same quarter today (variation 1)
61 -- Error: If any sql errors occurs, an exception is raised.
62 -- --------------------------------------------------------------------
63 Function get_lycq_today return DATE;
64
65 -- -------------------------------------------------------------------
66 -- Name: get_cy_start
67 -- Desc: Returns year start date for current year in the enterprise calendar.
68 -- Current year calculated based on sysdate.
69 -- Info is cached after initial access
70 -- Output: Enterprise calendar current year start date
71 -- Error: If any sql errors occurs, an exception is raised.
72 -- --------------------------------------------------------------------
73 Function get_cy_start return DATE;
74
75 -- -------------------------------------------------------------------
76 -- Name: get_cy_end
77 -- Desc: Returns year end date for current year in the enterprise calendar.
78 -- Current year calculated based on sysdate.
79 -- Info is cached after initial access
80 -- Output: Enterprise calendar current year end date
81 -- Error: If any sql errors occurs, an exception is raised.
82 -- --------------------------------------------------------------------
83 Function get_cy_end return DATE;
84
85 -- -------------------------------------------------------------------
86 -- Name: get_ly_start
87 -- Desc: Returns year start date for last year in the enterprise calendar.
88 -- Current year calculated based on sysdate.
89 -- Info is cached after initial access
90 -- Output: Enterprise calendar last year start date
91 -- Error: If any sql errors occurs, an exception is raised.
92 -- --------------------------------------------------------------------
93 Function get_ly_start return DATE;
94
95 -- -------------------------------------------------------------------
96 -- Name: get_ly_end
97 -- Desc: Returns year end date for last year in the enterprise calendar.
98 -- Current year calculated based on sysdate.
99 -- Info is cached after initial access
100 -- Output: Enterprise calendar last year end date
101 -- Error: If any sql errors occurs, an exception is raised.
102 -- --------------------------------------------------------------------
103 Function get_ly_end return DATE;
104
105 PRAGMA RESTRICT_REFERENCES (get_today, WNDS);
106 PRAGMA RESTRICT_REFERENCES (get_cqtr_start, WNDS);
107 PRAGMA RESTRICT_REFERENCES (get_cqtr_end, WNDS);
108 PRAGMA RESTRICT_REFERENCES (get_lycq_start, WNDS);
109 PRAGMA RESTRICT_REFERENCES (get_lycq_end, WNDS);
110 PRAGMA RESTRICT_REFERENCES (get_lycq_today, WNDS);
111 PRAGMA RESTRICT_REFERENCES (get_cy_start, WNDS);
112 PRAGMA RESTRICT_REFERENCES (get_cy_end, WNDS);
113 PRAGMA RESTRICT_REFERENCES (get_ly_start, WNDS);
114 PRAGMA RESTRICT_REFERENCES (get_ly_end, WNDS);
115
116 end;
[Home] [Help]