eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_DATE dependencies on FND_DATE

Line 1: PACKAGE BODY FND_DATE as

1: PACKAGE BODY FND_DATE as
2: -- $Header: AFDDATEB.pls 120.7 2011/01/03 20:55:51 dbowles ship $
3:
4:
5: --

Line 36: FND_DATE.user_mask := my_user_mask;

32: end if;
33:
34: -- Assign the user masks. If the userDT_mask is null than derive it
35: -- from the user_mask
36: FND_DATE.user_mask := my_user_mask;
37: FND_DATE.userDT_mask := NVL(my_userDT_mask,my_user_mask||' HH24:MI:SS');
38:
39: -- Assign the output masks - for now we'll derive them from the user mask.
40: -- Strip off any FX or FM in the mask. This wouldn't actually affect

Line 37: FND_DATE.userDT_mask := NVL(my_userDT_mask,my_user_mask||' HH24:MI:SS');

33:
34: -- Assign the user masks. If the userDT_mask is null than derive it
35: -- from the user_mask
36: FND_DATE.user_mask := my_user_mask;
37: FND_DATE.userDT_mask := NVL(my_userDT_mask,my_user_mask||' HH24:MI:SS');
38:
39: -- Assign the output masks - for now we'll derive them from the user mask.
40: -- Strip off any FX or FM in the mask. This wouldn't actually affect
41: -- the output, but we use this mask as the error mask as well.

Line 42: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');

38:
39: -- Assign the output masks - for now we'll derive them from the user mask.
40: -- Strip off any FX or FM in the mask. This wouldn't actually affect
41: -- the output, but we use this mask as the error mask as well.
42: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'

Line 43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');

39: -- Assign the output masks - for now we'll derive them from the user mask.
40: -- Strip off any FX or FM in the mask. This wouldn't actually affect
41: -- the output, but we use this mask as the error mask as well.
42: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'

Line 44: FND_DATE.user_calendar := upper(p_user_calendar);

40: -- Strip off any FX or FM in the mask. This wouldn't actually affect
41: -- the output, but we use this mask as the error mask as well.
42: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'
48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then

Line 45: if not (FND_DATE.user_calendar = 'GREGORIAN'

41: -- the output, but we use this mask as the error mask as well.
42: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'
48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then
49: FND_DATE.user_calendar := 'GREGORIAN';

Line 46: or FND_DATE.user_calendar = 'THAI BUDDHA'

42: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'
48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then
49: FND_DATE.user_calendar := 'GREGORIAN';
50: end if;

Line 47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'

43: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'
48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then
49: FND_DATE.user_calendar := 'GREGORIAN';
50: end if;
51:

Line 48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then

44: FND_DATE.user_calendar := upper(p_user_calendar);
45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'
48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then
49: FND_DATE.user_calendar := 'GREGORIAN';
50: end if;
51:
52: if (FND_DATE.user_calendar <> 'GREGORIAN') then

Line 49: FND_DATE.user_calendar := 'GREGORIAN';

45: if not (FND_DATE.user_calendar = 'GREGORIAN'
46: or FND_DATE.user_calendar = 'THAI BUDDHA'
47: or FND_DATE.user_calendar = 'ARABIC HIJRAH'
48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then
49: FND_DATE.user_calendar := 'GREGORIAN';
50: end if;
51:
52: if (FND_DATE.user_calendar <> 'GREGORIAN') then
53: FND_DATE.is_non_gregorian := true;

Line 52: if (FND_DATE.user_calendar <> 'GREGORIAN') then

48: or FND_DATE.user_calendar = 'ENGLISH HIJRAH') then
49: FND_DATE.user_calendar := 'GREGORIAN';
50: end if;
51:
52: if (FND_DATE.user_calendar <> 'GREGORIAN') then
53: FND_DATE.is_non_gregorian := true;
54: else
55: FND_DATE.is_non_gregorian := false;
56: end if;

Line 53: FND_DATE.is_non_gregorian := true;

49: FND_DATE.user_calendar := 'GREGORIAN';
50: end if;
51:
52: if (FND_DATE.user_calendar <> 'GREGORIAN') then
53: FND_DATE.is_non_gregorian := true;
54: else
55: FND_DATE.is_non_gregorian := false;
56: end if;
57: end;

Line 55: FND_DATE.is_non_gregorian := false;

51:
52: if (FND_DATE.user_calendar <> 'GREGORIAN') then
53: FND_DATE.is_non_gregorian := true;
54: else
55: FND_DATE.is_non_gregorian := false;
56: end if;
57: end;
58:
59: -- to_char/to_date for non Gregorian calendar support. Private functions

Line 66: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR

62: output_mask VARCHAR2,
63: calendar_aware number) RETURN VARCHAR2 IS
64: BEGIN
65: -- Only non-Gregorian calendar.
66: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR
67: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then
68: RETURN to_char(dateval, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
69: else
70: RETURN to_char(dateval, output_mask);

Line 67: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then

63: calendar_aware number) RETURN VARCHAR2 IS
64: BEGIN
65: -- Only non-Gregorian calendar.
66: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR
67: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then
68: RETURN to_char(dateval, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
69: else
70: RETURN to_char(dateval, output_mask);
71: end if;

Line 68: RETURN to_char(dateval, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');

64: BEGIN
65: -- Only non-Gregorian calendar.
66: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR
67: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then
68: RETURN to_char(dateval, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
69: else
70: RETURN to_char(dateval, output_mask);
71: end if;
72: END to_char_intl;

Line 79: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR

75: output_mask VARCHAR2,
76: calendar_aware number) RETURN DATE IS
77: BEGIN
78: -- Only non-Gregorian calendar.
79: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR
80: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then
81: RETURN to_date(chardt, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
82: else
83: RETURN to_date(chardt, output_mask);

Line 80: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then

76: calendar_aware number) RETURN DATE IS
77: BEGIN
78: -- Only non-Gregorian calendar.
79: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR
80: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then
81: RETURN to_date(chardt, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
82: else
83: RETURN to_date(chardt, output_mask);
84: end if;

Line 81: RETURN to_date(chardt, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');

77: BEGIN
78: -- Only non-Gregorian calendar.
79: if (calendar_aware = fnd_date.calendar_aware AND fnd_date.is_non_gregorian) OR
80: (calendar_aware = fnd_date.calendar_aware_alt AND fnd_date.is_non_gregorian)then
81: RETURN to_date(chardt, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
82: else
83: RETURN to_date(chardt, output_mask);
84: end if;
85: END to_date_intl;

Line 113: return displaydate_to_date(chardate, fnd_date.calendar_aware_default);

109: --
110:
111: function displaydate_to_date(chardate varchar2) return date is
112: begin
113: return displaydate_to_date(chardate, fnd_date.calendar_aware_default);
114: end displaydate_to_date;
115:
116: function displaydate_to_date(chardate varchar2,
117: calendar_aware number) return date is

Line 126: return displayDT_to_date(charDT, fnd_date.calendar_aware_default);

122:
123: -- TZ*
124: function displayDT_to_date(charDT varchar2) return date is
125: begin
126: return displayDT_to_date(charDT, fnd_date.calendar_aware_default);
127: end displayDT_to_date;
128:
129: function displayDT_to_date(charDT varchar2,
130: calendar_aware number ) return date is

Line 138: return date_to_displaydate(dateval, fnd_date.calendar_aware_default);

134: -- *TZ
135:
136: function date_to_displaydate(dateval date) return varchar2 is
137: begin
138: return date_to_displaydate(dateval, fnd_date.calendar_aware_default);
139: end date_to_displaydate;
140:
141: function date_to_displaydate(dateval date,
142: calendar_aware number) return varchar2 is

Line 150: return date_to_displayDT(dateval, fnd_date.calendar_aware_default);

146:
147: -- TZ*
148: function date_to_displayDT(dateval date) return varchar2 is
149: begin
150: return date_to_displayDT(dateval, fnd_date.calendar_aware_default);
151: end date_to_displayDT;
152:
153: function date_to_displayDT(dateval date,
154: calendar_aware number) return varchar2 is

Line 164: return chardate_to_date(chardate, fnd_date.calendar_aware_default);

160: -- Date/CharDate functions
161:
162: function chardate_to_date(chardate varchar2) return date is
163: begin
164: return chardate_to_date(chardate, fnd_date.calendar_aware_default);
165: end chardate_to_date;
166:
167: function chardate_to_date(chardate varchar2,
168: calendar_aware number) return date is

Line 180: return charDT_to_date(chardt, fnd_date.calendar_aware_default);

176:
177: -- TZ*
178: function charDT_to_date(charDT varchar2) return date is
179: begin
180: return charDT_to_date(chardt, fnd_date.calendar_aware_default);
181: end charDT_to_date;
182:
183: function charDT_to_date(charDT varchar2,
184: calendar_aware number) return date is

Line 192: return date_to_chardate(dateval, fnd_date.calendar_aware_default);

188: -- *TZ
189:
190: function date_to_chardate(dateval date) return varchar2 is
191: begin
192: return date_to_chardate(dateval, fnd_date.calendar_aware_default);
193: end date_to_chardate;
194:
195: function date_to_chardate(dateval date,
196: calendar_aware number) return varchar2 is

Line 204: return date_to_charDT(dateval, fnd_date.calendar_aware_default);

200:
201: -- TZ*
202: function date_to_charDT(dateval date) return varchar2 is
203: begin
204: return date_to_charDT(dateval, fnd_date.calendar_aware_default);
205: end date_to_charDT;
206:
207: function date_to_charDT(dateval date,
208: calendar_aware number) return varchar2 is

Line 299: fnd_date.canonical_dt_mask));

295: RETURN VARCHAR2
296: IS
297: BEGIN
298: RETURN(To_char(string_to_date(p_string, p_mask),
299: fnd_date.canonical_dt_mask));
300: EXCEPTION
301: WHEN OTHERS THEN
302: RETURN(NULL);
303: END string_to_canonical;

Line 319: fnd_date.initialize('FMMM/DD/RRRR');

315: /*
316: --commented out to avoid aru check constraints.
317:
318: DBMS_OUTPUT.PUT_LINE('About to call initialize with FMMM/DD/RRRR');
319: fnd_date.initialize('FMMM/DD/RRRR');
320:
321: -- tz*
322: DBMS_OUTPUT.PUT_LINE('About to call timezone initialize');
323: if fnd_timezones.TIMEZONES_ENABLED = 'Y' then

Line 324: fnd_date_tz.init_timezones_for_fnd_date;

320:
321: -- tz*
322: DBMS_OUTPUT.PUT_LINE('About to call timezone initialize');
323: if fnd_timezones.TIMEZONES_ENABLED = 'Y' then
324: fnd_date_tz.init_timezones_for_fnd_date;
325: else
326: DBMS_OUTPUT.PUT_LINE('Timezones are not enabled');
327: end if;
328:

Line 337: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);

333: DBMS_OUTPUT.PUT_LINE('Client timezone is ' ||
334: nvl(fnd_timezones.GET_CLIENT_TIMEZONE_CODE,'null'));
335: -- *tz
336:
337: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
338: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
341: DBMS_OUTPUT.PUT_LINE('Display date is

Line 338: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);

334: nvl(fnd_timezones.GET_CLIENT_TIMEZONE_CODE,'null'));
335: -- *tz
336:
337: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
338: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
341: DBMS_OUTPUT.PUT_LINE('Display date is
342: '||fnd_date.date_to_displaydate(my_date));

Line 339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);

335: -- *tz
336:
337: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
338: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
341: DBMS_OUTPUT.PUT_LINE('Display date is
342: '||fnd_date.date_to_displaydate(my_date));
343: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));

Line 340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);

336:
337: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
338: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
341: DBMS_OUTPUT.PUT_LINE('Display date is
342: '||fnd_date.date_to_displaydate(my_date));
343: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
344:

Line 342: '||fnd_date.date_to_displaydate(my_date));

338: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
341: DBMS_OUTPUT.PUT_LINE('Display date is
342: '||fnd_date.date_to_displaydate(my_date));
343: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
344:
345: DBMS_OUTPUT.PUT_LINE('Valid date is '||
346:

Line 343: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));

339: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
340: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
341: DBMS_OUTPUT.PUT_LINE('Display date is
342: '||fnd_date.date_to_displaydate(my_date));
343: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
344:
345: DBMS_OUTPUT.PUT_LINE('Valid date is '||
346:
347: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2

Line 347: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2

343: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
344:
345: DBMS_OUTPUT.PUT_LINE('Valid date is '||
346:
347: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2
348: 000')));
349: DBMS_OUTPUT.PUT_LINE('Valid DT is '||
350: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
351:

Line 350: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));

346:
347: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2
348: 000')));
349: DBMS_OUTPUT.PUT_LINE('Valid DT is '||
350: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
351:
352: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));
353: DBMS_OUTPUT.PUT_LINE('and back is
354: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12

Line 352: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));

348: 000')));
349: DBMS_OUTPUT.PUT_LINE('Valid DT is '||
350: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
351:
352: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));
353: DBMS_OUTPUT.PUT_LINE('and back is
354: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12
355: 14:22:22')));
356:

Line 354: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12

350: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
351:
352: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));
353: DBMS_OUTPUT.PUT_LINE('and back is
354: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12
355: 14:22:22')));
356:
357:
358: select date_to_displayDT(sysdate+5)

Line 371: '||to_char(fnd_date.displayDT_to_date('DEC-01-2000'),'DD-MON-YYYY

367:
368: DBMS_OUTPUT.PUT_LINE('Canonical date from SQL is '||my_char);
369:
370: DBMS_OUTPUT.PUT_LINE('Valid date (w/no FX in mask) is
371: '||to_char(fnd_date.displayDT_to_date('DEC-01-2000'),'DD-MON-YYYY
372: HH24:MI:SS'));
373:
374: DBMS_OUTPUT.PUT_LINE('Next line should raise an exception.');
375: DBMS_OUTPUT.PUT_LINE('Invalid date is

Line 376: '||to_char(fnd_date.displaydate_to_date('01-MAR-1999'),'DD-MON-YYYY

372: HH24:MI:SS'));
373:
374: DBMS_OUTPUT.PUT_LINE('Next line should raise an exception.');
375: DBMS_OUTPUT.PUT_LINE('Invalid date is
376: '||to_char(fnd_date.displaydate_to_date('01-MAR-1999'),'DD-MON-YYYY
377: HH24:MI:SS'));
378:
379: DBMS_OUTPUT.PUT_LINE('Error - exception not raised.');
380: */

Line 391: return date_to_displayDT(dateval, new_client_tz_code, fnd_date.calendar_aware_default);

387: varchar2 is
388: begin
389:
390:
391: return date_to_displayDT(dateval, new_client_tz_code, fnd_date.calendar_aware_default);
392:
393: end date_to_displayDT;
394:
395: function date_to_displayDT(dateval date,

Line 405: if fnd_date.timezones_enabled then

401: begin
402:
403: t_dateval := dateval;
404:
405: if fnd_date.timezones_enabled then
406:
407: if new_client_tz_code is not null then
408: tz_code := new_client_tz_code;
409: else

Line 410: tz_code := fnd_date.client_timezone_code;

406:
407: if new_client_tz_code is not null then
408: tz_code := new_client_tz_code;
409: else
410: tz_code := fnd_date.client_timezone_code;
411: end if;
412:
413: if tz_code <> fnd_date.server_timezone_code
414: and tz_code <> 'FND_NO_CONVERT' then

Line 413: if tz_code <> fnd_date.server_timezone_code

409: else
410: tz_code := fnd_date.client_timezone_code;
411: end if;
412:
413: if tz_code <> fnd_date.server_timezone_code
414: and tz_code <> 'FND_NO_CONVERT' then
415: t_dateval := fnd_timezones_pvt.adjust_datetime(dateval
416: ,fnd_date.
417: server_timezone_code

Line 416: ,fnd_date.

412:
413: if tz_code <> fnd_date.server_timezone_code
414: and tz_code <> 'FND_NO_CONVERT' then
415: t_dateval := fnd_timezones_pvt.adjust_datetime(dateval
416: ,fnd_date.
417: server_timezone_code
418: ,tz_code);
419: end if;
420: end if;

Line 429: return displayDT_to_date(charDT,new_client_tz_code, fnd_date.calendar_aware_default);

425:
426: function displayDT_to_date(charDT varchar2,new_client_tz_code varchar2) return
427: date is
428: begin
429: return displayDT_to_date(charDT,new_client_tz_code, fnd_date.calendar_aware_default);
430:
431: end displayDT_to_date;
432:
433: function displayDT_to_date(charDT varchar2,

Line 449: if fnd_date.timezones_enabled then

445: new_charDT := charDT;
446:
447: dateval := to_date_intl(new_charDT, userDT_mask, calendar_aware);
448:
449: if fnd_date.timezones_enabled then
450:
451: if new_client_tz_code is not null then
452: tz_code := new_client_tz_code;
453: else

Line 454: tz_code := fnd_date.client_timezone_code;

450:
451: if new_client_tz_code is not null then
452: tz_code := new_client_tz_code;
453: else
454: tz_code := fnd_date.client_timezone_code;
455: end if;
456:
457: if tz_code <> fnd_date.server_timezone_code
458: and tz_code <> 'FND_NO_CONVERT' then

Line 457: if tz_code <> fnd_date.server_timezone_code

453: else
454: tz_code := fnd_date.client_timezone_code;
455: end if;
456:
457: if tz_code <> fnd_date.server_timezone_code
458: and tz_code <> 'FND_NO_CONVERT' then
459: dateval := fnd_timezones_pvt.adjust_datetime(dateval
460: ,tz_code
461: ,fnd_date.

Line 461: ,fnd_date.

457: if tz_code <> fnd_date.server_timezone_code
458: and tz_code <> 'FND_NO_CONVERT' then
459: dateval := fnd_timezones_pvt.adjust_datetime(dateval
460: ,tz_code
461: ,fnd_date.
462: server_timezone_code);
463: end if;
464: end if;
465:

Line 474: if fnd_date.timezones_enabled then

470: function adjust_datetime(date_time date
471: ,from_tz varchar2
472: ,to_tz varchar2) return date is
473: begin
474: if fnd_date.timezones_enabled then
475: return fnd_timezones_pvt.adjust_datetime(date_time,from_tz,to_tz);
476: else
477: return date_time;
478: end if;

Line 484: return nvl(fnd_profile.value_specific(name => 'FND_DATE_API_CALENDAR_AWARENESS_DEFAULT',

480:
481: -- *tz
482: function calendar_awareness_profile(p_application_id number) return varchar2 is
483: begin
484: return nvl(fnd_profile.value_specific(name => 'FND_DATE_API_CALENDAR_AWARENESS_DEFAULT',
485: application_id => p_application_id), '0');
486: end calendar_awareness_profile;
487:
488: BEGIN

Line 493: FND_DATE.user_mask := 'DD-MON-RRRR';

489:
490: -- If the initialize routine is not called (for example on the concurrent
491: -- manager side in 11.5) the routines will use the hardcoded format of
492: -- DD-MON-RRRR.
493: FND_DATE.user_mask := 'DD-MON-RRRR';
494: FND_DATE.userDT_mask := FND_DATE.user_mask||' HH24:MI:SS';
495:
496: -- Assign the output masks - for now we'll derive them from the user mask.
497: -- Strip off any FX or FM in the mask. This wouldn't actually affect

Line 494: FND_DATE.userDT_mask := FND_DATE.user_mask||' HH24:MI:SS';

490: -- If the initialize routine is not called (for example on the concurrent
491: -- manager side in 11.5) the routines will use the hardcoded format of
492: -- DD-MON-RRRR.
493: FND_DATE.user_mask := 'DD-MON-RRRR';
494: FND_DATE.userDT_mask := FND_DATE.user_mask||' HH24:MI:SS';
495:
496: -- Assign the output masks - for now we'll derive them from the user mask.
497: -- Strip off any FX or FM in the mask. This wouldn't actually affect
498: -- the output, but we use this mask as the error mask as well.

Line 499: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');

495:
496: -- Assign the output masks - for now we'll derive them from the user mask.
497: -- Strip off any FX or FM in the mask. This wouldn't actually affect
498: -- the output, but we use this mask as the error mask as well.
499: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
500: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
501:
502: -- TZ*
503: fnd_date.timezones_enabled := false;

Line 500: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');

496: -- Assign the output masks - for now we'll derive them from the user mask.
497: -- Strip off any FX or FM in the mask. This wouldn't actually affect
498: -- the output, but we use this mask as the error mask as well.
499: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
500: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
501:
502: -- TZ*
503: fnd_date.timezones_enabled := false;
504: -- *TZ

Line 503: fnd_date.timezones_enabled := false;

499: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
500: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
501:
502: -- TZ*
503: fnd_date.timezones_enabled := false;
504: -- *TZ
505: -- For non-Gregorian calendar support.
506: fnd_date.user_calendar := 'GREGORIAN';
507: fnd_date.is_non_gregorian := false;

Line 506: fnd_date.user_calendar := 'GREGORIAN';

502: -- TZ*
503: fnd_date.timezones_enabled := false;
504: -- *TZ
505: -- For non-Gregorian calendar support.
506: fnd_date.user_calendar := 'GREGORIAN';
507: fnd_date.is_non_gregorian := false;
508:
509: end FND_DATE;

Line 507: fnd_date.is_non_gregorian := false;

503: fnd_date.timezones_enabled := false;
504: -- *TZ
505: -- For non-Gregorian calendar support.
506: fnd_date.user_calendar := 'GREGORIAN';
507: fnd_date.is_non_gregorian := false;
508:
509: end FND_DATE;

Line 509: end FND_DATE;

505: -- For non-Gregorian calendar support.
506: fnd_date.user_calendar := 'GREGORIAN';
507: fnd_date.is_non_gregorian := false;
508:
509: end FND_DATE;