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.1 2005/07/02 04:04:35 appldev ship $
3:
4:
5: --

Line 26: FND_DATE.user_mask := my_user_mask;

22: end if;
23:
24: -- Assign the user masks. If the userDT_mask is null than derive it
25: -- from the user_mask
26: FND_DATE.user_mask := my_user_mask;
27: FND_DATE.userDT_mask := NVL(my_userDT_mask,my_user_mask||' HH24:MI:SS');
28:
29: -- Assign the output masks - for now we'll derive them from the user mask.
30: -- Strip off any FX or FM in the mask. This wouldn't actually affect

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

23:
24: -- Assign the user masks. If the userDT_mask is null than derive it
25: -- from the user_mask
26: FND_DATE.user_mask := my_user_mask;
27: FND_DATE.userDT_mask := NVL(my_userDT_mask,my_user_mask||' HH24:MI:SS');
28:
29: -- Assign the output masks - for now we'll derive them from the user mask.
30: -- Strip off any FX or FM in the mask. This wouldn't actually affect
31: -- the output, but we use this mask as the error mask as well.

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

28:
29: -- Assign the output masks - for now we'll derive them from the user mask.
30: -- Strip off any FX or FM in the mask. This wouldn't actually affect
31: -- the output, but we use this mask as the error mask as well.
32: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
33: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
34: end;
35:
36:

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

29: -- Assign the output masks - for now we'll derive them from the user mask.
30: -- Strip off any FX or FM in the mask. This wouldn't actually affect
31: -- the output, but we use this mask as the error mask as well.
32: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
33: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
34: end;
35:
36:
37:

Line 199: fnd_date.canonical_dt_mask));

195: RETURN VARCHAR2
196: IS
197: BEGIN
198: RETURN(To_char(string_to_date(p_string, p_mask),
199: fnd_date.canonical_dt_mask));
200: EXCEPTION
201: WHEN OTHERS THEN
202: RETURN(NULL);
203: END string_to_canonical;

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

215: /*
216: --commented out to avoid aru check constraints.
217:
218: DBMS_OUTPUT.PUT_LINE('About to call initialize with FMMM/DD/RRRR');
219: fnd_date.initialize('FMMM/DD/RRRR');
220:
221: -- tz*
222: DBMS_OUTPUT.PUT_LINE('About to call timezone initialize');
223: if fnd_timezones.TIMEZONES_ENABLED = 'Y' then

Line 224: fnd_date_tz.init_timezones_for_fnd_date;

220:
221: -- tz*
222: DBMS_OUTPUT.PUT_LINE('About to call timezone initialize');
223: if fnd_timezones.TIMEZONES_ENABLED = 'Y' then
224: fnd_date_tz.init_timezones_for_fnd_date;
225: else
226: DBMS_OUTPUT.PUT_LINE('Timezones are not enabled');
227: end if;
228:

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

233: DBMS_OUTPUT.PUT_LINE('Client timezone is ' ||
234: nvl(fnd_timezones.GET_CLIENT_TIMEZONE_CODE,'null'));
235: -- *tz
236:
237: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
238: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
239: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
240: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
241: DBMS_OUTPUT.PUT_LINE('Display date is

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

234: nvl(fnd_timezones.GET_CLIENT_TIMEZONE_CODE,'null'));
235: -- *tz
236:
237: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
238: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
239: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
240: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
241: DBMS_OUTPUT.PUT_LINE('Display date is
242: '||fnd_date.date_to_displaydate(my_date));

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

235: -- *tz
236:
237: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
238: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
239: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
240: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
241: DBMS_OUTPUT.PUT_LINE('Display date is
242: '||fnd_date.date_to_displaydate(my_date));
243: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));

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

236:
237: DBMS_OUTPUT.PUT_LINE('User date mask is '||fnd_date.user_mask);
238: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
239: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
240: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
241: DBMS_OUTPUT.PUT_LINE('Display date is
242: '||fnd_date.date_to_displaydate(my_date));
243: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
244:

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

238: DBMS_OUTPUT.PUT_LINE('Output date mask is '||fnd_date.output_mask);
239: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
240: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
241: DBMS_OUTPUT.PUT_LINE('Display date is
242: '||fnd_date.date_to_displaydate(my_date));
243: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
244:
245: DBMS_OUTPUT.PUT_LINE('Valid date is '||
246:

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

239: DBMS_OUTPUT.PUT_LINE('UserDT mask is '||fnd_date.userDT_mask);
240: DBMS_OUTPUT.PUT_LINE('OutputDT mask is '||fnd_date.outputDT_mask);
241: DBMS_OUTPUT.PUT_LINE('Display date is
242: '||fnd_date.date_to_displaydate(my_date));
243: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
244:
245: DBMS_OUTPUT.PUT_LINE('Valid date is '||
246:
247: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2

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

243: DBMS_OUTPUT.PUT_LINE('Display DT is '||fnd_date.date_to_displayDT(my_date));
244:
245: DBMS_OUTPUT.PUT_LINE('Valid date is '||
246:
247: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2
248: 000')));
249: DBMS_OUTPUT.PUT_LINE('Valid DT is '||
250: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
251:

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

246:
247: date_to_displayDT(fnd_date.displaydate_to_date('02/01/2
248: 000')));
249: DBMS_OUTPUT.PUT_LINE('Valid DT is '||
250: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
251:
252: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));
253: DBMS_OUTPUT.PUT_LINE('and back is
254: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12

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

248: 000')));
249: DBMS_OUTPUT.PUT_LINE('Valid DT is '||
250: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
251:
252: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));
253: DBMS_OUTPUT.PUT_LINE('and back is
254: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12
255: 14:22:22')));
256:

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

250: date_to_displayDT(fnd_date.displayDT_to_date(my_char)));
251:
252: DBMS_OUTPUT.PUT_LINE('Canon date is '||fnd_date.date_to_canonical(sysdate));
253: DBMS_OUTPUT.PUT_LINE('and back is
254: '||fnd_date.date_to_displayDT(fnd_date.canonical_to_date('2001/03/12
255: 14:22:22')));
256:
257:
258: select date_to_displayDT(sysdate+5)

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

267:
268: DBMS_OUTPUT.PUT_LINE('Canonical date from SQL is '||my_char);
269:
270: DBMS_OUTPUT.PUT_LINE('Valid date (w/no FX in mask) is
271: '||to_char(fnd_date.displayDT_to_date('DEC-01-2000'),'DD-MON-YYYY
272: HH24:MI:SS'));
273:
274: DBMS_OUTPUT.PUT_LINE('Next line should raise an exception.');
275: DBMS_OUTPUT.PUT_LINE('Invalid date is

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

272: HH24:MI:SS'));
273:
274: DBMS_OUTPUT.PUT_LINE('Next line should raise an exception.');
275: DBMS_OUTPUT.PUT_LINE('Invalid date is
276: '||to_char(fnd_date.displaydate_to_date('01-MAR-1999'),'DD-MON-YYYY
277: HH24:MI:SS'));
278:
279: DBMS_OUTPUT.PUT_LINE('Error - exception not raised.');
280: */

Line 294: if fnd_date.timezones_enabled then

290: begin
291:
292: t_dateval := dateval;
293:
294: if fnd_date.timezones_enabled then
295:
296: if new_client_tz_code is not null then
297: tz_code := new_client_tz_code;
298: else

Line 299: tz_code := fnd_date.client_timezone_code;

295:
296: if new_client_tz_code is not null then
297: tz_code := new_client_tz_code;
298: else
299: tz_code := fnd_date.client_timezone_code;
300: end if;
301:
302: if tz_code <> fnd_date.server_timezone_code
303: and tz_code <> 'FND_NO_CONVERT' then

Line 302: if tz_code <> fnd_date.server_timezone_code

298: else
299: tz_code := fnd_date.client_timezone_code;
300: end if;
301:
302: if tz_code <> fnd_date.server_timezone_code
303: and tz_code <> 'FND_NO_CONVERT' then
304: t_dateval := fnd_timezones_pvt.adjust_datetime(dateval
305: ,fnd_date.
306: server_timezone_code

Line 305: ,fnd_date.

301:
302: if tz_code <> fnd_date.server_timezone_code
303: and tz_code <> 'FND_NO_CONVERT' then
304: t_dateval := fnd_timezones_pvt.adjust_datetime(dateval
305: ,fnd_date.
306: server_timezone_code
307: ,tz_code);
308: end if;
309: end if;

Line 329: if fnd_date.timezones_enabled then

325: new_charDT := charDT;
326:
327: dateval := to_date(new_charDT, userDT_mask);
328:
329: if fnd_date.timezones_enabled then
330:
331: if new_client_tz_code is not null then
332: tz_code := new_client_tz_code;
333: else

Line 334: tz_code := fnd_date.client_timezone_code;

330:
331: if new_client_tz_code is not null then
332: tz_code := new_client_tz_code;
333: else
334: tz_code := fnd_date.client_timezone_code;
335: end if;
336:
337: if tz_code <> fnd_date.server_timezone_code
338: and tz_code <> 'FND_NO_CONVERT' then

Line 337: if tz_code <> fnd_date.server_timezone_code

333: else
334: tz_code := fnd_date.client_timezone_code;
335: end if;
336:
337: if tz_code <> fnd_date.server_timezone_code
338: and tz_code <> 'FND_NO_CONVERT' then
339: dateval := fnd_timezones_pvt.adjust_datetime(dateval
340: ,tz_code
341: ,fnd_date.

Line 341: ,fnd_date.

337: if tz_code <> fnd_date.server_timezone_code
338: and tz_code <> 'FND_NO_CONVERT' then
339: dateval := fnd_timezones_pvt.adjust_datetime(dateval
340: ,tz_code
341: ,fnd_date.
342: server_timezone_code);
343: end if;
344: end if;
345:

Line 354: if fnd_date.timezones_enabled then

350: function adjust_datetime(date_time date
351: ,from_tz varchar2
352: ,to_tz varchar2) return date is
353: begin
354: if fnd_date.timezones_enabled then
355: return fnd_timezones_pvt.adjust_datetime(date_time,from_tz,to_tz);
356: else
357: return date_time;
358: end if;

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

365:
366: -- If the initialize routine is not called (for example on the concurrent
367: -- manager side in 11.5) the routines will use the hardcoded format of
368: -- DD-MON-RRRR.
369: FND_DATE.user_mask := 'DD-MON-RRRR';
370: FND_DATE.userDT_mask := FND_DATE.user_mask||' HH24:MI:SS';
371:
372: -- Assign the output masks - for now we'll derive them from the user mask.
373: -- Strip off any FX or FM in the mask. This wouldn't actually affect

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

366: -- If the initialize routine is not called (for example on the concurrent
367: -- manager side in 11.5) the routines will use the hardcoded format of
368: -- DD-MON-RRRR.
369: FND_DATE.user_mask := 'DD-MON-RRRR';
370: FND_DATE.userDT_mask := FND_DATE.user_mask||' HH24:MI:SS';
371:
372: -- Assign the output masks - for now we'll derive them from the user mask.
373: -- Strip off any FX or FM in the mask. This wouldn't actually affect
374: -- the output, but we use this mask as the error mask as well.

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

371:
372: -- Assign the output masks - for now we'll derive them from the user mask.
373: -- Strip off any FX or FM in the mask. This wouldn't actually affect
374: -- the output, but we use this mask as the error mask as well.
375: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
376: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
377:
378: -- TZ*
379: fnd_date.timezones_enabled := false;

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

372: -- Assign the output masks - for now we'll derive them from the user mask.
373: -- Strip off any FX or FM in the mask. This wouldn't actually affect
374: -- the output, but we use this mask as the error mask as well.
375: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
376: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
377:
378: -- TZ*
379: fnd_date.timezones_enabled := false;
380: -- *TZ

Line 379: fnd_date.timezones_enabled := false;

375: FND_DATE.output_mask := REPLACE(REPLACE(FND_DATE.user_mask,'FM'),'FX');
376: FND_DATE.outputDT_mask := REPLACE(REPLACE(FND_DATE.userDT_mask,'FM'),'FX');
377:
378: -- TZ*
379: fnd_date.timezones_enabled := false;
380: -- *TZ
381: end FND_DATE;

Line 381: end FND_DATE;

377:
378: -- TZ*
379: fnd_date.timezones_enabled := false;
380: -- *TZ
381: end FND_DATE;