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.ICX_ITEM_DIAG_PVT dependencies on DBMS_SQL

Line 209: /*g_file_tbl := DBMS_SQL.VARCHAR2_TABLE(null);

205: WHERE rownum = 1
206: ORDER BY filename;
207: BEGIN
208: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start init_file_versions');
209: /*g_file_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
210: g_file_versions_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
211: g_instance_versions_tbl := DBMS_SQL.VARCHAR2_TABLE (null);
212: */
213: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXGPPBB.pls'; g_file_versions_tbl(l_ctr) := '120.1.12010000.1';

Line 210: g_file_versions_tbl := DBMS_SQL.VARCHAR2_TABLE(null);

206: ORDER BY filename;
207: BEGIN
208: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start init_file_versions');
209: /*g_file_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
210: g_file_versions_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
211: g_instance_versions_tbl := DBMS_SQL.VARCHAR2_TABLE (null);
212: */
213: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXGPPBB.pls'; g_file_versions_tbl(l_ctr) := '120.1.12010000.1';
214: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXGPPBS.pls'; g_file_versions_tbl(l_ctr) := '120.0.12010000.1';

Line 211: g_instance_versions_tbl := DBMS_SQL.VARCHAR2_TABLE (null);

207: BEGIN
208: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start init_file_versions');
209: /*g_file_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
210: g_file_versions_tbl := DBMS_SQL.VARCHAR2_TABLE(null);
211: g_instance_versions_tbl := DBMS_SQL.VARCHAR2_TABLE (null);
212: */
213: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXGPPBB.pls'; g_file_versions_tbl(l_ctr) := '120.1.12010000.1';
214: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXGPPBS.pls'; g_file_versions_tbl(l_ctr) := '120.0.12010000.1';
215: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXGPPCB.pls'; g_file_versions_tbl(l_ctr) := '120.2.12010000.1';

Line 311: num1_tbl DBMS_SQL.NUMBER_TABLE;

307: status IN VARCHAR2
308: )
309: IS
310: l_ret VARCHAR2 (20) ;
311: num1_tbl DBMS_SQL.NUMBER_TABLE;
312: num2_tbl DBMS_SQL.NUMBER_TABLE;
313: num3_tbl DBMS_SQL.NUMBER_TABLE;
314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 312: num2_tbl DBMS_SQL.NUMBER_TABLE;

308: )
309: IS
310: l_ret VARCHAR2 (20) ;
311: num1_tbl DBMS_SQL.NUMBER_TABLE;
312: num2_tbl DBMS_SQL.NUMBER_TABLE;
313: num3_tbl DBMS_SQL.NUMBER_TABLE;
314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
316: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 313: num3_tbl DBMS_SQL.NUMBER_TABLE;

309: IS
310: l_ret VARCHAR2 (20) ;
311: num1_tbl DBMS_SQL.NUMBER_TABLE;
312: num2_tbl DBMS_SQL.NUMBER_TABLE;
313: num3_tbl DBMS_SQL.NUMBER_TABLE;
314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
316: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
317: l_api_name VARCHAR2 (20):='file_versions';

Line 314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;

310: l_ret VARCHAR2 (20) ;
311: num1_tbl DBMS_SQL.NUMBER_TABLE;
312: num2_tbl DBMS_SQL.NUMBER_TABLE;
313: num3_tbl DBMS_SQL.NUMBER_TABLE;
314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
316: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
317: l_api_name VARCHAR2 (20):='file_versions';
318: l_log VARCHAR2

Line 315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;

311: num1_tbl DBMS_SQL.NUMBER_TABLE;
312: num2_tbl DBMS_SQL.NUMBER_TABLE;
313: num3_tbl DBMS_SQL.NUMBER_TABLE;
314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
316: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
317: l_api_name VARCHAR2 (20):='file_versions';
318: l_log VARCHAR2
319: (

Line 316: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;

312: num2_tbl DBMS_SQL.NUMBER_TABLE;
313: num3_tbl DBMS_SQL.NUMBER_TABLE;
314: l_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
315: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
316: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
317: l_api_name VARCHAR2 (20):='file_versions';
318: l_log VARCHAR2
319: (
320: 4000

Line 362: p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE,

358: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception file_versions'||sqlerrm||SQLCODE );
359: END file_versions;
360:
361: procedure get_setup_values ( p_table_name in VARCHAR2 ,
362: p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE,
363: p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE)
364: is
365:
366: cursor OU_INV is

Line 420: , p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE

416:
417: procedure get_IDs_values ( p_table_name in VARCHAR2
418: , p_col_num out NOCOPY NUMBER
419: , p_row_num out NOCOPY NUMBER
420: , p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE
421: , p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE)
422: is
423: i number;
424: l_cat_num number;

Line 1085: , p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE

1081:
1082: procedure validate_values ( p_table_name in VARCHAR2
1083: , p_col_num out NOCOPY NUMBER
1084: , p_row_num out NOCOPY NUMBER
1085: , p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE
1086: , p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE) is
1087:
1088: l_row_val ICX_ITEM_DIAG_GRP.VARCHAR_TABLE;
1089: l_api_name VARCHAR2 (20):='validate_values';