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 5: g_file_tbl DBMS_SQL.VARCHAR2_TABLE;

1: PACKAGE ICX_ITEM_DIAG_PVT AUTHID CURRENT_USER AS
2: /* $Header: ICX_ITEM_DIAG_PVT.pls 120.2.12020000.2 2013/02/11 13:26:50 vegajula noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):='ICX_ITEM_DIAG_PVT';
5: g_file_tbl DBMS_SQL.VARCHAR2_TABLE;
6: g_file_versions_tbl DBMS_SQL.VARCHAR2_TABLE;
7: g_instance_versions_tbl DBMS_SQL.VARCHAR2_TABLE;
8: g_file_key VARCHAR2(100) := 'ITEM_DIAG_FILE_VERSIONS' ;
9: g_error_key VARCHAR2(100) := 'ITEM_DIAG_ERRORS' ;

Line 6: g_file_versions_tbl DBMS_SQL.VARCHAR2_TABLE;

2: /* $Header: ICX_ITEM_DIAG_PVT.pls 120.2.12020000.2 2013/02/11 13:26:50 vegajula noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):='ICX_ITEM_DIAG_PVT';
5: g_file_tbl DBMS_SQL.VARCHAR2_TABLE;
6: g_file_versions_tbl DBMS_SQL.VARCHAR2_TABLE;
7: g_instance_versions_tbl DBMS_SQL.VARCHAR2_TABLE;
8: g_file_key VARCHAR2(100) := 'ITEM_DIAG_FILE_VERSIONS' ;
9: g_error_key VARCHAR2(100) := 'ITEM_DIAG_ERRORS' ;
10: g_id_values_key VARCHAR2(100) := 'ITEM_ID_SETUP_VALUES' ;

Line 7: g_instance_versions_tbl DBMS_SQL.VARCHAR2_TABLE;

3:
4: g_pkg_name CONSTANT VARCHAR2(30):='ICX_ITEM_DIAG_PVT';
5: g_file_tbl DBMS_SQL.VARCHAR2_TABLE;
6: g_file_versions_tbl DBMS_SQL.VARCHAR2_TABLE;
7: g_instance_versions_tbl DBMS_SQL.VARCHAR2_TABLE;
8: g_file_key VARCHAR2(100) := 'ITEM_DIAG_FILE_VERSIONS' ;
9: g_error_key VARCHAR2(100) := 'ITEM_DIAG_ERRORS' ;
10: g_id_values_key VARCHAR2(100) := 'ITEM_ID_SETUP_VALUES' ;
11:

Line 16: g_source_type_values DBMS_SQL.VARCHAR2_TABLE;

12:
13: g_file_count NUMBER := 30;
14: g_org_id number;
15: g_source_type varchar2(100);
16: g_source_type_values DBMS_SQL.VARCHAR2_TABLE;
17: g_auto_map_category VARCHAR2(1);
18:
19: g_category_key DBMS_SQL.VARCHAR2_TABLE;
20: g_source_ids DBMS_SQL.NUMBER_TABLE;

Line 19: g_category_key DBMS_SQL.VARCHAR2_TABLE;

15: g_source_type varchar2(100);
16: g_source_type_values DBMS_SQL.VARCHAR2_TABLE;
17: g_auto_map_category VARCHAR2(1);
18:
19: g_category_key DBMS_SQL.VARCHAR2_TABLE;
20: g_source_ids DBMS_SQL.NUMBER_TABLE;
21: g_organization_id number;
22: g_master_organization_id number;
23: g_category_set_id number;

Line 20: g_source_ids DBMS_SQL.NUMBER_TABLE;

16: g_source_type_values DBMS_SQL.VARCHAR2_TABLE;
17: g_auto_map_category VARCHAR2(1);
18:
19: g_category_key DBMS_SQL.VARCHAR2_TABLE;
20: g_source_ids DBMS_SQL.NUMBER_TABLE;
21: g_organization_id number;
22: g_master_organization_id number;
23: g_category_set_id number;
24: g_request_id NUMBER := fnd_global.conc_request_id;

Line 26: g_table_names DBMS_SQL.VARCHAR2_TABLE;

22: g_master_organization_id number;
23: g_category_set_id number;
24: g_request_id NUMBER := fnd_global.conc_request_id;
25:
26: g_table_names DBMS_SQL.VARCHAR2_TABLE;
27: g_error_code DBMS_SQL.VARCHAR2_TABLE;
28: PROCEDURE file_versions
29: (
30: status IN VARCHAR2);

Line 27: g_error_code DBMS_SQL.VARCHAR2_TABLE;

23: g_category_set_id number;
24: g_request_id NUMBER := fnd_global.conc_request_id;
25:
26: g_table_names DBMS_SQL.VARCHAR2_TABLE;
27: g_error_code DBMS_SQL.VARCHAR2_TABLE;
28: PROCEDURE file_versions
29: (
30: status IN VARCHAR2);
31: FUNCTION update_num

Line 37: p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE,

33: p_version IN VARCHAR2)
34: RETURN NUMBER;
35:
36: procedure get_setup_values ( p_table_name in VARCHAR2 ,
37: p_col_val out NOCOPY DBMS_SQL.VARCHAR2_TABLE,
38: p_row_val out NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE);
39:
40: procedure get_IDs_values ( p_table_name in VARCHAR2
41: , p_col_num OUT NOCOPY NUMBER

Line 43: , p_col_val OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

39:
40: procedure get_IDs_values ( p_table_name in VARCHAR2
41: , p_col_num OUT NOCOPY NUMBER
42: , p_row_num OUT NOCOPY NUMBER
43: , p_col_val OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
44: , p_row_val OUT NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE);
45:
46: procedure validate_values ( p_table_name in VARCHAR2
47: , p_col_num OUT NOCOPY NUMBER

Line 49: , p_col_val OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

45:
46: procedure validate_values ( p_table_name in VARCHAR2
47: , p_col_num OUT NOCOPY NUMBER
48: , p_row_num OUT NOCOPY NUMBER
49: , p_col_val OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
50: , p_row_val OUT NOCOPY ICX_ITEM_DIAG_GRP.VARCHAR_TABLE);
51:
52:
53: procedure sync_sources(p_org_id in number,