PACKAGE: APPS.ICX_ITEM_DIAG_PVT

Source

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' ;
10   g_id_values_key   VARCHAR2(100) := 'ITEM_ID_SETUP_VALUES' ;
11 
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;
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;
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
32     (
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
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
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,
54 											 p_source_type in varchar2,
55 											x_return_status OUT NOCOPY varchar2	);
56 
57 PROCEDURE logStatement
58 (       p_pkg_name      IN      VARCHAR2        ,
59         p_proc_name     IN      VARCHAR2        ,
60         p_log_string    IN      VARCHAR2
61 );
62 
63 procedure PO_ATTRIBUTE_VALUES_DATA_FIX ;
64 
65 END ICX_ITEM_DIAG_PVT;