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 899: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,

895:
896: --
897: -- Initialize the first one
898: if (m_formats(s_current_format_idx).default_date_format is not null) then
899: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,
900: m_formats(s_current_format_idx).default_date_time_format);
901: end if;
902: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
903: if (g_release_name >= '12.2') then

Line 904: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date,calendar_aware=>FND_DATE.calendar_aware);

900: m_formats(s_current_format_idx).default_date_time_format);
901: end if;
902: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
903: if (g_release_name >= '12.2') then
904: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date,calendar_aware=>FND_DATE.calendar_aware);
905: else
906: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
907: end if;
908:

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

902: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
903: if (g_release_name >= '12.2') then
904: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date,calendar_aware=>FND_DATE.calendar_aware);
905: else
906: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
907: end if;
908:
909: end populate_formats;
910:

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

1059: m_params_with_actual_value(idx).value), 1, 240);
1060:
1061: if m_params(idx).format_type in ('D', 'I', 'T', 'X', 'Y', 'Z', 't') then
1062: begin
1063: dvalue := fnd_date.canonical_to_date(m_params(idx).value);
1064: exception
1065: when others then
1066: Null;
1067: --* len := length(m_params(idx).value);

Line 1090: m_params(idx).value := fnd_date.date_to_displaydate(dvalue,calendar_aware=>FND_DATE.calendar_aware);

1086:
1087: if m_params(idx).format_type in ('D', 'X') then
1088: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
1089: if (g_release_name >= '12.2') then
1090: m_params(idx).value := fnd_date.date_to_displaydate(dvalue,calendar_aware=>FND_DATE.calendar_aware);
1091: else
1092: m_params(idx).value := fnd_date.date_to_displaydate(dvalue);
1093: end if;
1094: elsif m_params(idx).format_type in ('T', 'Y') then

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

1088: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
1089: if (g_release_name >= '12.2') then
1090: m_params(idx).value := fnd_date.date_to_displaydate(dvalue,calendar_aware=>FND_DATE.calendar_aware);
1091: else
1092: m_params(idx).value := fnd_date.date_to_displaydate(dvalue);
1093: end if;
1094: elsif m_params(idx).format_type in ('T', 'Y') then
1095: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
1096: if (g_release_name >= '12.2') then

Line 1097: m_params(idx).value := fnd_date.date_to_displaydt(dvalue,calendar_aware=>FND_DATE.calendar_aware);

1093: end if;
1094: elsif m_params(idx).format_type in ('T', 'Y') then
1095: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
1096: if (g_release_name >= '12.2') then
1097: m_params(idx).value := fnd_date.date_to_displaydt(dvalue,calendar_aware=>FND_DATE.calendar_aware);
1098: else
1099: m_params(idx).value := fnd_date.date_to_displaydt(dvalue);
1100: end if;
1101: elsif m_params(idx).format_type in ('I', 'Z', 't') then

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

1095: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
1096: if (g_release_name >= '12.2') then
1097: m_params(idx).value := fnd_date.date_to_displaydt(dvalue,calendar_aware=>FND_DATE.calendar_aware);
1098: else
1099: m_params(idx).value := fnd_date.date_to_displaydt(dvalue);
1100: end if;
1101: elsif m_params(idx).format_type in ('I', 'Z', 't') then
1102: m_params(idx).value := to_char(dvalue, 'HH24:MI:SS');
1103: end if;

Line 1403: 'fnd_date.date_to_displaydate('||m_columns(idx).column_name||',calendar_aware=>'||FND_DATE.calendar_aware||')';

1399: l_select := l_select || sep ||
1400: 'to_char('||m_columns(idx).column_name||', '''||m_columns(idx).format_mask||''')';
1401: elsif m_columns(idx).display_format = 'DATE' then
1402: l_select := l_select || sep ||
1403: 'fnd_date.date_to_displaydate('||m_columns(idx).column_name||',calendar_aware=>'||FND_DATE.calendar_aware||')';
1404: ELSIF m_report.output_format = 'CSV' AND m_columns(idx).display_format = 'VARCHAR2' THEN
1405: l_select := l_select || sep || '''"''||' || m_columns(idx).column_name || '||''"''';
1406: else
1407: l_select := l_select || sep || m_columns(idx).column_name;

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

1463: m_arguments(idx).where_clause ||' fnd_number.canonical_to_number(:b'||To_char(m_bind_count)||')';
1464: -- 'fnd_number.canonical_to_number('''||m_arguments(idx).value||''')';
1465: else
1466: l_where := l_where||sep||
1467: m_arguments(idx).where_clause ||' fnd_date.canonical_to_date(:b'||To_char(m_bind_count)||')';
1468: --'fnd_date.canonical_to_date('''||m_arguments(idx).value||''')';
1469: end if;
1470: sep := NEWLINE||'AND ';
1471:

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

1464: -- 'fnd_number.canonical_to_number('''||m_arguments(idx).value||''')';
1465: else
1466: l_where := l_where||sep||
1467: m_arguments(idx).where_clause ||' fnd_date.canonical_to_date(:b'||To_char(m_bind_count)||')';
1468: --'fnd_date.canonical_to_date('''||m_arguments(idx).value||''')';
1469: end if;
1470: sep := NEWLINE||'AND ';
1471:
1472: END IF; /* where clause is not null and value is not null */

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

2218: --
2219: -- Initialize the date/time formats
2220: -- NOTE: The very first one was also initialized during populate_formats
2221: if (m_formats(s_current_format_idx).default_date_format is not null) then
2222: fnd_date.initialize(m_formats(s_current_format_idx).default_date_format,
2223: m_formats(s_current_format_idx).default_date_time_format);
2224: end if;
2225: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
2226: if (g_release_name >= '12.2') then

Line 2227: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date,calendar_aware=>FND_DATE.calendar_aware);

2223: m_formats(s_current_format_idx).default_date_time_format);
2224: end if;
2225: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
2226: if (g_release_name >= '12.2') then
2227: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date,calendar_aware=>FND_DATE.calendar_aware);
2228: else
2229: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
2230: end if;
2231: IF (g_print_debug) THEN

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

2225: g_release_name := fa_cache_pkg.fazarel_release_name; -- Bug 10636707 - Character date international calendar support
2226: if (g_release_name >= '12.2') then
2227: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date,calendar_aware=>FND_DATE.calendar_aware);
2228: else
2229: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
2230: end if;
2231: IF (g_print_debug) THEN
2232: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');
2233: END IF;

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

2473: sqlstmt := sqlstmt || sep || crow.column_name;
2474: elsif crow.display_format = 'NUMBER' then
2475: sqlstmt := sqlstmt || sep || 'fnd_number.number_to_canonical('||crow.column_name||')';
2476: elsif crow.display_format = 'DATE' then
2477: sqlstmt := sqlstmt || sep || 'fnd_date.date_to_canonical('||crow.column_name||')';
2478: end if;
2479:
2480: sep := ', ';
2481: numcols := numcols + 1;

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

2533: where_clause := where_clause || sep ||
2534: 'FND_NUMBER.NUMBER_TO_CANONICAL('||crow.column_name ||') = '||buf;
2535: elsif crow.display_format = 'DATE' then
2536: where_clause := where_clause || sep ||
2537: 'FND_DATE.DATE_TO_CANONICAL('||crow.column_name ||') = '||buf;
2538: end if;
2539:
2540: sep := ' AND ';
2541: end loop;