[Home] [Help]
PACKAGE: APPS.FND_DATE
Source
1 PACKAGE FND_DATE AUTHID CURRENT_USER as
2 /* $Header: AFDDATES.pls 120.6 2011/01/03 20:52:37 dbowles ship $ */
3
4
5 canonical_mask varchar2(15) := 'YYYY/MM/DD';
6 canonical_DT_mask varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
7 name_in_mask varchar2(15) := 'DD-MON-YYYY';
8 name_in_DT_mask varchar2(26) := 'DD-MON-YYYY HH24:MI:SS';
9 nls_mask varchar2(20);
10 nls_DT_mask varchar2(40);
11 -- It's possible to specify multiple masks seperated
12 -- by a '|' so the user masks need to be longer.
13
14 user_mask varchar2(100);
15 userDT_mask varchar2(200);
16 output_mask varchar2(20);
17 outputDT_mask varchar2(40);
18
19 -- Initialization routine
20
21 procedure initialize(
22 p_user_mask varchar2,
23 p_userDT_mask varchar2 default NULL);
24
25 -- Date/DisplayDate functions - covers on the now obsolete Date/CharDate
26 -- functions. These functions are used to convert a date to and from
27 -- the display format.
28
29 function displaydate_to_date(
30 chardate varchar2)
31 return date;
32 PRAGMA restrict_references(displaydate_to_date, WNDS, WNPS, RNDS);
33
34 function displayDT_to_date(
35 charDT varchar2)
36 return date;
37 PRAGMA restrict_references(displayDT_to_date, WNDS, WNPS, RNDS);
38
39 function date_to_displaydate(
40 dateval date)
41 return varchar2;
42 PRAGMA restrict_references(date_to_displaydate, WNDS, WNPS, RNDS);
43
44 function date_to_displayDT(
45 dateval date)
46 return varchar2;
47 PRAGMA restrict_references(date_to_displayDT, WNDS, WNPS, RNDS);
48
49 -- Date/CharDate functions
50
51 function chardate_to_date(
52 chardate varchar2)
53 return date;
54 PRAGMA restrict_references(chardate_to_date, WNDS, WNPS, RNDS);
55
56 function charDT_to_date(
57 charDT varchar2)
58 return date;
59 PRAGMA restrict_references(charDT_to_date, WNDS, WNPS, RNDS);
60
61 function date_to_chardate(
62 dateval date)
63 return varchar2;
64 PRAGMA restrict_references(date_to_chardate, WNDS, WNPS, RNDS);
65
66 function date_to_charDT(
67 dateval date)
68 return varchar2;
69 PRAGMA restrict_references(date_to_charDT, WNDS, WNPS, RNDS);
70
71 -- Canonical functions
72
73 function canonical_to_date(
74 canonical varchar2)
75 return date;
76 PRAGMA restrict_references(canonical_to_date, WNDS, WNPS, RNDS);
77
78 function date_to_canonical(
79 dateval date)
80 return varchar2;
81 PRAGMA restrict_references(date_to_canonical, WNDS, WNPS, RNDS);
82
83 --
84 -- This function converts the given string to date
85 -- by using the given date mask, and trying
86 -- several language settings.
87 -- Language is important if the mask has 'MON' or
88 -- similar language dependent fragments.
89 --
90 FUNCTION string_to_date(p_string IN VARCHAR2,
91 p_mask IN VARCHAR2)
92 RETURN DATE;
93 PRAGMA restrict_references(string_to_date, WNDS, WNPS, RNPS);
94
95 --
96 -- This function is similar to string_to_date
97 -- but it returns the result in canonical_DT_mask format.
98 --
99 FUNCTION string_to_canonical(p_string IN VARCHAR2,
100 p_mask IN VARCHAR2)
101 RETURN VARCHAR2;
102 PRAGMA restrict_references(string_to_canonical, WNDS, WNPS);
103
104
105 -- Test procedure - used to verify functionality
106 procedure test;
107
108 -- TZ*
109 -- private TZ variables
110 -- DO NOT user outside of fnd_date.
111
112 server_timezone_code varchar2(50);
113 client_timezone_code varchar2(50);
114
115 timezones_enabled boolean;
116
117 -- over loaded function for fake dates.
118 -- pass in a new client timezone and over ride the default client timezone
119 function displayDT_to_date(charDT varchar2,new_client_tz_code varchar2) return date;
120 PRAGMA restrict_references(displayDT_to_date, WNDS, WNPS, RNDS);
121
122 -- over loaded function for fake dates.
123 -- pass in a new client timezone and over ride the default client timezone
124 function date_to_displayDT(dateval date,new_client_tz_code varchar2) return varchar2;
125 PRAGMA restrict_references(date_to_displayDT, WNDS, WNPS, RNDS);
126
127 -- public version of call for adjust_datetime.
128 function adjust_datetime(date_time date
129 ,from_tz varchar2
130 ,to_tz varchar2) return date;
131 PRAGMA restrict_references(adjust_datetime, WNDS, WNPS, RNDS);
132 -- *TZ
133
134
135 --Bug 9384487 Overloaded intialize procedure
136
137 procedure initialize_with_calendar(
138 p_user_mask varchar2,
139 p_userDT_mask varchar2 default NULL,
140 p_user_calendar varchar2 default 'GREGORIAN');
141
142
143 -- Bug 9734709 Added by non-Gregorian calendar support.
144 user_calendar varchar2(20);
145 is_non_gregorian boolean;
146 calendar_aware CONSTANT number := 1;
147 calendar_unaware CONSTANT number := 0;
148 calendar_aware_default number := calendar_unaware;
149
150 function calendar_awareness_profile(
151 p_application_id number) return varchar2;
152
153 -- Overloaded Date/DisplayDate functions - covers on the now obsolete Date/CharDate
154 -- functions. These functions are used to convert a date to and from
155 -- the display format. Supports calendar awareness
156
157 function displaydate_to_date(
158 chardate varchar2,
159 calendar_aware number )
160 return date;
161 PRAGMA restrict_references(displaydate_to_date, WNDS, WNPS, RNDS);
162
163 function displayDT_to_date(
164 charDT varchar2,
165 calendar_aware number )
166 return date;
167 PRAGMA restrict_references(displayDT_to_date, WNDS, WNPS, RNDS);
168
169 function date_to_displaydate(
170 dateval date,
171 calendar_aware number )
172 return varchar2;
173 PRAGMA restrict_references(date_to_displaydate, WNDS, WNPS, RNDS);
174
175 function date_to_displayDT(
176 dateval date,
177 calendar_aware number )
178 return varchar2;
179 PRAGMA restrict_references(date_to_displayDT, WNDS, WNPS, RNDS);
180
181 -- Date/CharDate functions
182
183 function chardate_to_date(
184 chardate varchar2,
185 calendar_aware number )
186 return date;
187 PRAGMA restrict_references(chardate_to_date, WNDS, WNPS, RNDS);
188
189 function charDT_to_date(
190 charDT varchar2,
191 calendar_aware number )
192 return date;
193 PRAGMA restrict_references(charDT_to_date, WNDS, WNPS, RNDS);
194
195 function date_to_chardate(
196 dateval date,
197 calendar_aware number )
198 return varchar2;
199 PRAGMA restrict_references(date_to_chardate, WNDS, WNPS, RNDS);
200
201 function date_to_charDT(
202 dateval date,
203 calendar_aware number )
204 return varchar2;
205 PRAGMA restrict_references(date_to_charDT, WNDS, WNPS, RNDS);
206
207 -- over loaded function for fake dates. Supports calendar awareness
208 -- pass in a new client timezone and over ride the default client timezone
209 function displayDT_to_date(charDT varchar2,
210 new_client_tz_code varchar2,
211 calendar_aware number ) return date;
212 PRAGMA restrict_references(displayDT_to_date, WNDS, WNPS, RNDS);
213
214 -- over loaded function for fake dates. Supports calendar awareness
215 -- pass in a new client timezone and over ride the default client timezone
216 function date_to_displayDT(dateval date,
217 new_client_tz_code varchar2,
218 calendar_aware number ) return varchar2;
219 PRAGMA restrict_references(date_to_displayDT, WNDS, WNPS, RNDS);
220
221 -- bug 10130806 new package variable
222 calendar_aware_alt CONSTANT number := 2;
223
224 -- Bug 10130806 to_char_intl is now a public function for 12.2
225 function to_char_intl(dateval DATE,
226 output_mask VARCHAR2,
227 calendar_aware number)
228 return varchar2;
229 PRAGMA restrict_references(to_char_intl, WNDS, WNPS, RNDS);
230
231 end FND_DATE;