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.JTF_GRIDDB dependencies on JTF_DBSTRING_UTILS

Line 17: lineFeed varchar2(10) := jtf_dbstring_utils.getLineFeed;

13: -- Incoming persistance versions
14: clientTabVersion varchar2(5) := '1';
15: clientColDefVersion varchar2(5) := '1';
16:
17: lineFeed varchar2(10) := jtf_dbstring_utils.getLineFeed;
18: nullValue varchar2(10) := jtf_dbstring_utils.getNullString;
19:
20: tableDefs tabDefTabType;
21: columnDefs colDefTabType;

Line 18: nullValue varchar2(10) := jtf_dbstring_utils.getNullString;

14: clientTabVersion varchar2(5) := '1';
15: clientColDefVersion varchar2(5) := '1';
16:
17: lineFeed varchar2(10) := jtf_dbstring_utils.getLineFeed;
18: nullValue varchar2(10) := jtf_dbstring_utils.getNullString;
19:
20: tableDefs tabDefTabType;
21: columnDefs colDefTabType;
22: temp_columnDefs colDefTabType;

Line 165: ||lineFeed||lineFeed||'exceeds the current maxlength ('||to_char(jtf_dbstring_utils.getMaxStringLength)||' bytes / record). Reduce the number of columns defined in the datasource (metadata definition) or display partial column values.');

161: fnd_message.set_name('JTF','JTF_GRID_EXCEED_MAXLENGTH');
162: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports: A record of data for:'
163: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
164: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_dataSource_name||'>'
165: ||lineFeed||lineFeed||'exceeds the current maxlength ('||to_char(jtf_dbstring_utils.getMaxStringLength)||' bytes / record). Reduce the number of columns defined in the datasource (metadata definition) or display partial column values.');
166: elsif errorType = MISSING_SORT_COL_ERROR then
167: fnd_message.set_name('JTF','JTF_GRID_MISSING_SORT_COLUMN');
168: fnd_message.set_token('SOURCE','jtf_griddb.'||method);
169: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);

Line 517: return 'to_char('|| columnDefs(columnDefIndex).db_col_name || ',fnd_currency.get_format_mask('||columnDefs(columnDefIndex).db_currency_code_col||',jtf_dbstring_utils.getCurrencyFormatLength))';

513: if columnDefs(columnDefIndex).display_format_mask is not null then
514: return 'to_char('|| columnDefs(columnDefIndex).db_col_name || ','''||columnDefs(columnDefIndex).display_format_mask||''')';
515: elsif columnDefs(columnDefIndex).display_format_type_code = 'CUR'
516: and columnDefs(columnDefIndex).db_currency_code_col is not null then
517: return 'to_char('|| columnDefs(columnDefIndex).db_col_name || ',fnd_currency.get_format_mask('||columnDefs(columnDefIndex).db_currency_code_col||',jtf_dbstring_utils.getCurrencyFormatLength))';
518: else
519: return 'to_char('|| columnDefs(columnDefIndex).db_col_name || ')' ;
520: end if;
521: elsif columnDefs(columnDefIndex).data_type_code = 'D' then

Line 570: dynSQL jtf_dbstring_utils.maxString%TYPE := null;

566: end buildOrderByClause;
567:
568: function prepareSQL(gridName in varchar2, tableIndex in binary_integer) return boolean is
569:
570: dynSQL jtf_dbstring_utils.maxString%TYPE := null;
571: fromClause varchar2(200) := null;
572: whereClause varchar2(4000):= null;
573: orderClause varchar2(600) := null;
574: i pls_integer;

Line 850: tempRec jtf_dbstring_utils.maxString%TYPE;

846:
847: function fetchDataSet(gridName in varchar2
848: ,p_serverInitDate in date) return dataSet%TYPE is
849: j binary_integer;
850: tempRec jtf_dbstring_utils.maxString%TYPE;
851: NOT_INITIALIZED Exception;
852: rowCount pls_integer;
853: colCount varchar2(6);
854: i pls_integer;

Line 1656: l_public_flag varchar2(1) := jtf_dbstring_utils.getBooleanString(publicFlag);

1652: l_where_clause varchar2(2000);
1653: l_grid_sort_col_alias1 varchar2(30);
1654: l_grid_sort_col_alias2 varchar2(30);
1655: l_grid_sort_col_alias3 varchar2(30);
1656: l_public_flag varchar2(1) := jtf_dbstring_utils.getBooleanString(publicFlag);
1657: l_grid_col_alias varchar2(30);
1658: l_sort_asc_by_default varchar2(1);
1659: l_visible_flag varchar2(1);
1660: l_display_seq number(3);

Line 1904: -- ' default_flag = <'||nvl(jtf_dbstring_utils.getBooleanString(defaultFlag),nullValue)||'>'||lineFeed||

1900: -- handleErrors(INTERNAL_ERROR,'saveSerializedTableDef',gridName,
1901: -- ' dataSource = <'||nvl(dataSource,nullValue)||'>'||lineFeed||
1902: -- ' custom_grid_id = <'||nvl(to_char(l_custom_grid_id),nullValue)||'>'||lineFeed||
1903: -- ' custom_grid_name = <'||nvl(l_custom_grid_name,nullValue)||'>'||lineFeed||
1904: -- ' default_flag = <'||nvl(jtf_dbstring_utils.getBooleanString(defaultFlag),nullValue)||'>'||lineFeed||
1905: -- ' public_flag = <'||nvl(l_public_flag,nullValue)||'>'||lineFeed
1906: -- null,SQLERRM);
1907: -- return false;
1908: end saveSerializedTableDef;

Line 2505: sql_statement jtf_dbstring_utils.maxString%TYPE;

2501: i number;
2502: bind_count number;
2503: l_len_sql number;
2504: len number := 1;
2505: sql_statement jtf_dbstring_utils.maxString%TYPE;
2506: whereClause varchar2(4000);
2507: k binary_integer;
2508: bind_var binary_integer;
2509:

Line 2718: l_debug_tbl(i).debug_message := JTF_DBSTRING_UTILS.getVersion;

2714: l_debug_tbl(i).debug_message := 'SOURCE CODE INFORMATION';
2715: i := i + 1;
2716: l_debug_tbl(i).debug_message := JTF_GRIDDB.getVersion;
2717: i := i + 1;
2718: l_debug_tbl(i).debug_message := JTF_DBSTRING_UTILS.getVersion;
2719: i := i + 1;
2720: l_debug_tbl(i).debug_message := JTF_DBSTREAM_UTILS.getVersion;
2721: i := i + 1;
2722: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.getVersion;