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

Line 900: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,

896:
897: --
898: -- Initialize the first one
899: if (m_formats(s_current_format_idx).default_date_format is not null) then
900: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,
901: m_formats(s_current_format_idx).default_date_time_format);
902: end if;
903: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
904: end populate_formats;

Line 903: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);

899: if (m_formats(s_current_format_idx).default_date_format is not null) then
900: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,
901: m_formats(s_current_format_idx).default_date_time_format);
902: end if;
903: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
904: end populate_formats;
905:
906: ---------------------------------------------------------
907: -- Procedure populate_parameters

Line 1057: dvalue := fnd_date.canonical_to_date(m_params(idx).value);

1053: m_params(idx).value), 1, 240);
1054:
1055: if m_params(idx).format_type in ('D', 'I', 'T', 'X', 'Y', 'Z', 't') then
1056: begin
1057: dvalue := fnd_date.canonical_to_date(m_params(idx).value);
1058: exception
1059: when others then
1060: Null;
1061: --* len := length(m_params(idx).value);

Line 1082: m_params(idx).value := fnd_date.date_to_displaydate(dvalue);

1078: --* end if;
1079: end;
1080:
1081: if m_params(idx).format_type in ('D', 'X') then
1082: m_params(idx).value := fnd_date.date_to_displaydate(dvalue);
1083: elsif m_params(idx).format_type in ('T', 'Y') then
1084: m_params(idx).value := fnd_date.date_to_displaydt(dvalue);
1085: elsif m_params(idx).format_type in ('I', 'Z', 't') then
1086: m_params(idx).value := to_char(dvalue, 'HH24:MI:SS');

Line 1084: m_params(idx).value := fnd_date.date_to_displaydt(dvalue);

1080:
1081: if m_params(idx).format_type in ('D', 'X') then
1082: m_params(idx).value := fnd_date.date_to_displaydate(dvalue);
1083: elsif m_params(idx).format_type in ('T', 'Y') then
1084: m_params(idx).value := fnd_date.date_to_displaydt(dvalue);
1085: elsif m_params(idx).format_type in ('I', 'Z', 't') then
1086: m_params(idx).value := to_char(dvalue, 'HH24:MI:SS');
1087: end if;
1088: end if;

Line 1387: 'fnd_date.date_to_displaydate('||m_columns(idx).column_name||')';

1383: l_select := l_select || sep ||
1384: 'to_char('||m_columns(idx).column_name||', '''||m_columns(idx).format_mask||''')';
1385: elsif m_columns(idx).display_format = 'DATE' then
1386: l_select := l_select || sep ||
1387: 'fnd_date.date_to_displaydate('||m_columns(idx).column_name||')';
1388: ELSIF m_report.output_format = 'CSV' AND m_columns(idx).display_format = 'VARCHAR2' THEN
1389: l_select := l_select || sep || '''"''||' || m_columns(idx).column_name || '||''"''';
1390: else
1391: l_select := l_select || sep || m_columns(idx).column_name;

Line 1451: m_arguments(idx).where_clause ||' fnd_date.canonical_to_date(:b'||To_char(m_bind_count)||')';

1447: m_arguments(idx).where_clause ||' fnd_number.canonical_to_number(:b'||To_char(m_bind_count)||')';
1448: -- 'fnd_number.canonical_to_number('''||m_arguments(idx).value||''')';
1449: else
1450: l_where := l_where||sep||
1451: m_arguments(idx).where_clause ||' fnd_date.canonical_to_date(:b'||To_char(m_bind_count)||')';
1452: --'fnd_date.canonical_to_date('''||m_arguments(idx).value||''')';
1453: end if;
1454: sep := NEWLINE||'AND ';
1455:

Line 1452: --'fnd_date.canonical_to_date('''||m_arguments(idx).value||''')';

1448: -- 'fnd_number.canonical_to_number('''||m_arguments(idx).value||''')';
1449: else
1450: l_where := l_where||sep||
1451: m_arguments(idx).where_clause ||' fnd_date.canonical_to_date(:b'||To_char(m_bind_count)||')';
1452: --'fnd_date.canonical_to_date('''||m_arguments(idx).value||''')';
1453: end if;
1454: sep := NEWLINE||'AND ';
1455:
1456: END IF; /* where clause is not null and value is not null */

Line 2158: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,

2154: --
2155: -- Initialize the date/time formats
2156: -- NOTE: The very first one was also initialized during populate_formats
2157: if (m_formats(s_current_format_idx).default_date_format is not null) then
2158: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,
2159: m_formats(s_current_format_idx).default_date_time_format);
2160: end if;
2161: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
2162:

Line 2161: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);

2157: if (m_formats(s_current_format_idx).default_date_format is not null) then
2158: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,
2159: m_formats(s_current_format_idx).default_date_time_format);
2160: end if;
2161: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
2162:
2163: IF (g_print_debug) THEN
2164: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');
2165: END IF;

Line 2409: sqlstmt := sqlstmt || sep || 'fnd_date.date_to_canonical('||crow.column_name||')';

2405: sqlstmt := sqlstmt || sep || crow.column_name;
2406: elsif crow.display_format = 'NUMBER' then
2407: sqlstmt := sqlstmt || sep || 'fnd_number.number_to_canonical('||crow.column_name||')';
2408: elsif crow.display_format = 'DATE' then
2409: sqlstmt := sqlstmt || sep || 'fnd_date.date_to_canonical('||crow.column_name||')';
2410: end if;
2411:
2412: sep := ', ';
2413: numcols := numcols + 1;

Line 2469: 'FND_DATE.DATE_TO_CANONICAL('||crow.column_name ||') = '||buf;

2465: where_clause := where_clause || sep ||
2466: 'FND_NUMBER.NUMBER_TO_CANONICAL('||crow.column_name ||') = '||buf;
2467: elsif crow.display_format = 'DATE' then
2468: where_clause := where_clause || sep ||
2469: 'FND_DATE.DATE_TO_CANONICAL('||crow.column_name ||') = '||buf;
2470: end if;
2471:
2472: sep := ' AND ';
2473: end loop;