APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_ITEM_DIAG_GRP

Line 363: p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE)

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
367: select ORG_ID, org.SHORT_CODE OU_CODE, org.NAME OU_NAME ,

Line 421: , p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE)

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;
425: l_old_organization_id varchar2(100);

Line 1086: , p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE) is

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';
1090:

Line 1088: l_row_val ICX_ITEM_DIAG_GRP.VARCHAR_TABLE;

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';
1090:
1091: cursor validate(j number) is
1092: SELECT /*+ LEADING(doc) */