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.QLTDATE dependencies on FND_DATE

Line 6: Forms_canon_mask CONSTANT Varchar2(11) := fnd_date.name_in_mask;

2: /* $Header: qltdateb.plb 120.2.12020000.2 2013/01/04 15:06:40 hmakam ship $ */
3:
4: canon_mask CONSTANT Varchar2(25) := 'YYYY/MM/DD';
5: canon_DT_mask CONSTANT Varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
6: Forms_canon_mask CONSTANT Varchar2(11) := fnd_date.name_in_mask;
7: Forms_canon_DT_mask CONSTANT Varchar2(26) := fnd_date.name_in_dt_mask;
8:
9: --
10: -- See bug 2624112

Line 7: Forms_canon_DT_mask CONSTANT Varchar2(26) := fnd_date.name_in_dt_mask;

3:
4: canon_mask CONSTANT Varchar2(25) := 'YYYY/MM/DD';
5: canon_DT_mask CONSTANT Varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
6: Forms_canon_mask CONSTANT Varchar2(11) := fnd_date.name_in_mask;
7: Forms_canon_DT_mask CONSTANT Varchar2(26) := fnd_date.name_in_dt_mask;
8:
9: --
10: -- See bug 2624112
11: -- Quality now allows decimal precision upto 12

Line 20: -- Return the user mask as defined in the fnd_date package.

16: 'FM99999999999999999999999999999999999999999999999999D999999999999';
17:
18: FUNCTION user_mask RETURN Varchar2 IS
19: --
20: -- Return the user mask as defined in the fnd_date package.
21: --
22: BEGIN
23: IF fnd_date.user_mask IS NULL THEN
24: RETURN fnd_date.name_in_mask;

Line 23: IF fnd_date.user_mask IS NULL THEN

19: --
20: -- Return the user mask as defined in the fnd_date package.
21: --
22: BEGIN
23: IF fnd_date.user_mask IS NULL THEN
24: RETURN fnd_date.name_in_mask;
25: ELSE
26: RETURN fnd_date.user_mask;
27: END IF;

Line 24: RETURN fnd_date.name_in_mask;

20: -- Return the user mask as defined in the fnd_date package.
21: --
22: BEGIN
23: IF fnd_date.user_mask IS NULL THEN
24: RETURN fnd_date.name_in_mask;
25: ELSE
26: RETURN fnd_date.user_mask;
27: END IF;
28: END user_mask;

Line 26: RETURN fnd_date.user_mask;

22: BEGIN
23: IF fnd_date.user_mask IS NULL THEN
24: RETURN fnd_date.name_in_mask;
25: ELSE
26: RETURN fnd_date.user_mask;
27: END IF;
28: END user_mask;
29:
30:

Line 33: -- Return the output mask as defined in the fnd_date package.

29:
30:
31: FUNCTION output_mask RETURN Varchar2 IS
32: --
33: -- Return the output mask as defined in the fnd_date package.
34: --
35: BEGIN
36: IF fnd_date.output_mask IS NULL THEN
37: RETURN fnd_date.name_in_mask;

Line 36: IF fnd_date.output_mask IS NULL THEN

32: --
33: -- Return the output mask as defined in the fnd_date package.
34: --
35: BEGIN
36: IF fnd_date.output_mask IS NULL THEN
37: RETURN fnd_date.name_in_mask;
38: ELSE
39: RETURN fnd_date.output_mask;
40: END IF;

Line 37: RETURN fnd_date.name_in_mask;

33: -- Return the output mask as defined in the fnd_date package.
34: --
35: BEGIN
36: IF fnd_date.output_mask IS NULL THEN
37: RETURN fnd_date.name_in_mask;
38: ELSE
39: RETURN fnd_date.output_mask;
40: END IF;
41: END output_mask;

Line 39: RETURN fnd_date.output_mask;

35: BEGIN
36: IF fnd_date.output_mask IS NULL THEN
37: RETURN fnd_date.name_in_mask;
38: ELSE
39: RETURN fnd_date.output_mask;
40: END IF;
41: END output_mask;
42:
43:

Line 50: -- The following doesn't work if the fnd_date package is not

46: -- Convert a date (in Date type) to output format (Varchar2).
47: -- bso
48: --
49: BEGIN
50: -- The following doesn't work if the fnd_date package is not
51: -- properly initialized. Unfortunately, it is not initialized
52: -- when submitting a report. Therefore, use my own conversion.
53: -- RETURN fnd_date.date_to_displaydate(d);
54: RETURN to_char(d, output_mask);

Line 53: -- RETURN fnd_date.date_to_displaydate(d);

49: BEGIN
50: -- The following doesn't work if the fnd_date package is not
51: -- properly initialized. Unfortunately, it is not initialized
52: -- when submitting a report. Therefore, use my own conversion.
53: -- RETURN fnd_date.date_to_displaydate(d);
54: RETURN to_char(d, output_mask);
55: END date_to_user;
56:
57:

Line 110: RETURN fnd_date.date_to_displayDT(l_date, calendar_aware=> FND_DATE.calendar_aware_alt);

106:
107: l_date:= to_date(canon,canon_DT_mask);
108:
109: -- convert l_date to client tz then to user display format
110: RETURN fnd_date.date_to_displayDT(l_date, calendar_aware=> FND_DATE.calendar_aware_alt);
111: END;
112:
113: END canon_to_user;
114:

Line 154: -- Modifying to call fnd_date.string_to_date() before doing

150: -- established.
151: -- This is happening with elements which are mapped to
152: -- characterxxx columns where date is stored in canonical form.
153:
154: -- Modifying to call fnd_date.string_to_date() before doing
155: -- our regular Exception ladder.
156: -- rkunchal Mon Aug 19 02:40:07 PDT 2002
157:
158: tmp_date DATE;

Line 167: --tmp_date := FND_DATE.string_to_date(flex, canon_mask);

163: -- Passing the User format Mask instead of the
164: -- Canonical mask
165: -- ntungare Mon May 7 10:38:29 PDT 2007
166: --
167: --tmp_date := FND_DATE.string_to_date(flex, canon_mask);
168: tmp_date := FND_DATE.string_to_date(flex, user_mask);
169:
170: IF tmp_date IS NULL THEN
171: -- Bug 3179845. Timezone Project. rponnusa

Line 168: tmp_date := FND_DATE.string_to_date(flex, user_mask);

164: -- Canonical mask
165: -- ntungare Mon May 7 10:38:29 PDT 2007
166: --
167: --tmp_date := FND_DATE.string_to_date(flex, canon_mask);
168: tmp_date := FND_DATE.string_to_date(flex, user_mask);
169:
170: IF tmp_date IS NULL THEN
171: -- Bug 3179845. Timezone Project. rponnusa
172: -- Added mask to fix GSCC error

Line 237: -- already in canon_mask format.So FND_DATE.string_to_date() returns a date and earlier the function was

233: -- following ladder since we dont know the date mask of flex
234:
235: -- Bug 3935591. Data entered through mobile was showing wrong value in Forms VQR for softcoded DATE type
236: -- elements.For this particular flow QA_VALIDATION_API.VALIDATE_DATE calls this function with flex
237: -- already in canon_mask format.So FND_DATE.string_to_date() returns a date and earlier the function was
238: -- returning l_date. Modified the code to return date_to_canon(l_date)(VARCHAR2).
239: -- srhariha. Tue Nov 9 01:12:23 PST 2004.
240:
241: --

Line 247: --l_date := FND_DATE.string_to_date(flex, canon_mask);

243: -- Passing the User format Mask instead of the
244: -- Canonical mask
245: -- ntungare Mon May 7 10:38:29 PDT 2007
246: --
247: --l_date := FND_DATE.string_to_date(flex, canon_mask);
248: l_date := FND_DATE.string_to_date(flex, user_mask);
249: IF l_date IS NULL THEN
250: --
251: -- Bug 5921013

Line 248: l_date := FND_DATE.string_to_date(flex, user_mask);

244: -- Canonical mask
245: -- ntungare Mon May 7 10:38:29 PDT 2007
246: --
247: --l_date := FND_DATE.string_to_date(flex, canon_mask);
248: l_date := FND_DATE.string_to_date(flex, user_mask);
249: IF l_date IS NULL THEN
250: --
251: -- Bug 5921013
252: -- Passing the User format Mask instead of the

Line 437: d := fnd_date.string_to_date(flex, forms_canon_dt_mask);

433: d := to_date(flex, canon_mask);
434: return date_to_canon(d);
435:
436: EXCEPTION WHEN OTHERS THEN
437: d := fnd_date.string_to_date(flex, forms_canon_dt_mask);
438: IF d IS NULL THEN
439: --
440: -- Just to be safe, if it cannot be converted, then
441: -- return the original data.

Line 471: l_date := FND_DATE.string_to_date(flex, canon_DT_mask);

467: l_date DATE;
468:
469: BEGIN
470:
471: l_date := FND_DATE.string_to_date(flex, canon_DT_mask);
472: IF l_date IS NULL THEN
473: RETURN to_date(flex , canon_DT_mask);
474: ELSE
475: RETURN l_date;

Line 503: -- Return the output DT mask as defined in the fnd_date package.

499: END any_to_datetime;
500:
501: FUNCTION output_DT_mask RETURN Varchar2 IS
502: --
503: -- Return the output DT mask as defined in the fnd_date package.
504: --
505: BEGIN
506: IF fnd_date.outputDT_mask IS NULL THEN
507: RETURN fnd_date.name_in_DT_mask;

Line 506: IF fnd_date.outputDT_mask IS NULL THEN

502: --
503: -- Return the output DT mask as defined in the fnd_date package.
504: --
505: BEGIN
506: IF fnd_date.outputDT_mask IS NULL THEN
507: RETURN fnd_date.name_in_DT_mask;
508: ELSE
509: RETURN fnd_date.outputDT_mask;
510: END IF;

Line 507: RETURN fnd_date.name_in_DT_mask;

503: -- Return the output DT mask as defined in the fnd_date package.
504: --
505: BEGIN
506: IF fnd_date.outputDT_mask IS NULL THEN
507: RETURN fnd_date.name_in_DT_mask;
508: ELSE
509: RETURN fnd_date.outputDT_mask;
510: END IF;
511: END output_DT_mask;

Line 509: RETURN fnd_date.outputDT_mask;

505: BEGIN
506: IF fnd_date.outputDT_mask IS NULL THEN
507: RETURN fnd_date.name_in_DT_mask;
508: ELSE
509: RETURN fnd_date.outputDT_mask;
510: END IF;
511: END output_DT_mask;
512:
513: