APPS.ICX_ITEM_DIAG_GRP dependencies on DBMS_SQL

Line 138: , col_val IN DBMS_SQL.VARCHAR2_TABLE

134: END table_hdr;
135:
136: FUNCTION print_table(table_name IN VARCHAR2
137: , col_num IN NUMBER
138: , col_val IN DBMS_SQL.VARCHAR2_TABLE
139: , row_num IN NUMBER
140: , row_val IN VARCHAR_TABLE )
141: RETURN clob
142: IS

Line 329: l_col_val DBMS_SQL.VARCHAR2_TABLE;

325: SELECT char1, char2 , char3, char4
326: FROM po_session_gt
327: WHERE index_char1 =ICX_ITEM_DIAG_PVT.g_file_key;
328:
329: l_col_val DBMS_SQL.VARCHAR2_TABLE;
330: l_row_val VARCHAR_TABLE;
331: l_ret VARCHAR2(20);
332: BEGIN
333: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start print_file_versions');

Line 402: l_col_val DBMS_SQL.VARCHAR2_TABLE;

398: end need_patch;
399:
400: FUNCTION print_setup_values
401: RETURN VARCHAR2 IS
402: l_col_val DBMS_SQL.VARCHAR2_TABLE;
403: l_row_val VARCHAR_TABLE;
404: l_ret VARCHAR2(20);
405: l_api_name CONSTANT VARCHAR2(30) := 'print_setup_values';
406:

Line 426: l_col_val DBMS_SQL.VARCHAR2_TABLE;

422: END print_setup_values;
423:
424: FUNCTION print_id_values
425: RETURN VARCHAR2 IS
426: l_col_val DBMS_SQL.VARCHAR2_TABLE;
427: l_row_val VARCHAR_TABLE;
428: l_col_num number;
429: l_row_num number;
430: l_ret VARCHAR2(20);

Line 459: l_col_val DBMS_SQL.VARCHAR2_TABLE;

455: end print_id_values;
456:
457: FUNCTION validate_values
458: RETURN VARCHAR2 IS
459: l_col_val DBMS_SQL.VARCHAR2_TABLE;
460: l_row_val VARCHAR_TABLE;
461: l_col_num number;
462: l_row_num number;
463: l_ret varchar2(10);