PACKAGE BODY: APPS.EDW_ANALYZE_UTIL

Source

1 PACKAGE BODY EDW_ANALYZE_UTIL AS
2 /* $Header: EDWARSTB.pls 115.6 2003/11/19 09:19:34 smulye noship $  */
3 VERSION	CONSTANT CHAR(80) := '$Header: EDWARSTB.pls 115.6 2003/11/19 09:19:34 smulye noship $';
4 
5 -- ------------------------
6 -- Global Variables
7 -- ------------------------
8 
9 -- ------------------------
10 -- Public Procedures
11 -- ------------------------
12 
13 
14 Procedure analyze_table( p_table_name  in Varchar2) IS
15   l_bis_schema          VARCHAR2(30);
16   l_stmt  		VARCHAR2(200);
17   l_status		VARCHAR2(30);
18   l_industry		VARCHAR2(30);
19   errbuf                varchar2(2000):=null;
20   retcode               varchar2(200):=null;
21  BEGIN
22 
23       IF (FND_INSTALLATION.GET_APP_INFO('BIS', l_status, l_industry, l_bis_schema)) THEN
24          FND_STATS.GATHER_TABLE_STATS(errbuf,retcode, l_bis_schema, p_table_name ) ;
25       END IF;
26 
27  END;
28 
29 
30 Procedure analyze_wh_tables(Errbuf      	in out nocopy  Varchar2,
31                 Retcode     	in out nocopy Varchar2) IS
32  BEGIN
33     analyze_table('EDW_PUSH_DETAIL_LOG');
34     analyze_table('EDW_COLLECTION_DETAIL_LOG');
35     analyze_table('EDW_LOAD_PROGRESS_LOG');
36  END;
37 
38 END;
39