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_NUMBER

Line 1463: m_arguments(idx).where_clause ||' fnd_number.canonical_to_number(:b'||To_char(m_bind_count)||')';

1459: m_arguments(idx).where_clause ||' :b'||To_char(m_bind_count);
1460: --''''||m_arguments(idx).value||'''';
1461: elsif m_arguments(idx).datatype = 'NUMBER' then
1462: l_where := l_where||sep||
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)||')';

Line 1464: -- 'fnd_number.canonical_to_number('''||m_arguments(idx).value||''')';

1460: --''''||m_arguments(idx).value||'''';
1461: elsif m_arguments(idx).datatype = 'NUMBER' then
1462: l_where := l_where||sep||
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||''')';

Line 1476: -- l_where := 'WHERE REQUEST_ID=fnd_number.canonical_to_number(:b1)'

1472: END IF; /* where clause is not null and value is not null */
1473: end loop;
1474: else
1475: -- bug 7316487/ bug 8263761
1476: -- l_where := 'WHERE REQUEST_ID=fnd_number.canonical_to_number(:b1)'
1477: -- ||m_formats(s_current_format_idx).where_clause;
1478: l_where := 'WHERE REQUEST_ID=:b1'
1479: ||m_formats(s_current_format_idx).where_clause;
1480:

Line 1481: m_binds(1) := fnd_number.number_to_canonical(m_formats(s_current_format_idx).request_id);

1477: -- ||m_formats(s_current_format_idx).where_clause;
1478: l_where := 'WHERE REQUEST_ID=:b1'
1479: ||m_formats(s_current_format_idx).where_clause;
1480:
1481: m_binds(1) := fnd_number.number_to_canonical(m_formats(s_current_format_idx).request_id);
1482: m_bind_count := 1;
1483: end if;
1484:
1485: return l_where;

Line 2475: sqlstmt := sqlstmt || sep || 'fnd_number.number_to_canonical('||crow.column_name||')';

2471: for crow in cols(p_formats(idx).report_id, p_formats(idx).attribute_set) loop
2472: if crow.display_format = 'VARCHAR2' then
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:

Line 2534: 'FND_NUMBER.NUMBER_TO_CANONICAL('||crow.column_name ||') = '||buf;

2530: where_clause := where_clause || sep ||
2531: crow.column_name ||' = '''||buf||'''';
2532: elsif crow.display_format = 'NUMBER' then
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;