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 1447: m_arguments(idx).where_clause ||' fnd_number.canonical_to_number(:b'||To_char(m_bind_count)||')';

1443: m_arguments(idx).where_clause ||' :b'||To_char(m_bind_count);
1444: --''''||m_arguments(idx).value||'''';
1445: elsif m_arguments(idx).datatype = 'NUMBER' then
1446: l_where := l_where||sep||
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)||')';

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

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

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

1455:
1456: END IF; /* where clause is not null and value is not null */
1457: end loop;
1458: else
1459: l_where := 'WHERE REQUEST_ID=fnd_number.canonical_to_number(:b1)'
1460: ||m_formats(s_current_format_idx).where_clause;
1461:
1462: m_binds(1) := fnd_number.number_to_canonical(m_formats(s_current_format_idx).request_id);
1463: m_bind_count := 1;

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

1458: else
1459: l_where := 'WHERE REQUEST_ID=fnd_number.canonical_to_number(:b1)'
1460: ||m_formats(s_current_format_idx).where_clause;
1461:
1462: m_binds(1) := fnd_number.number_to_canonical(m_formats(s_current_format_idx).request_id);
1463: m_bind_count := 1;
1464: end if;
1465:
1466: return l_where;

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

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

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

2462: where_clause := where_clause || sep ||
2463: crow.column_name ||' = '''||buf||'''';
2464: elsif crow.display_format = 'NUMBER' then
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;