APPS.BIS_BIA_STATS dependencies on FND_STATS

Line 5: * This is the wrapper around FND_STATS.gather_table_stats

1: package body BIS_BIA_STATS AS
2: /*$Header: BISGTSPB.pls 120.2 2006/09/07 14:34:46 aguwalan noship $*/
3:
4: /**
5: * This is the wrapper around FND_STATS.gather_table_stats
6: * Object name will be the table name or MV name seeded in RSG,
7: * while object type is either 'MV' or 'TABLE'
8: * We will derive the object schema name , then
9: * call FND_STATS.gather_table_stats to analyze the object

Line 9: * call FND_STATS.gather_table_stats to analyze the object

5: * This is the wrapper around FND_STATS.gather_table_stats
6: * Object name will be the table name or MV name seeded in RSG,
7: * while object type is either 'MV' or 'TABLE'
8: * We will derive the object schema name , then
9: * call FND_STATS.gather_table_stats to analyze the object
10: **/
11:
12: /**Changes for Enhancement 4378448. We have to review/rollback
13: the changes after ST fix the issue as mentioned in the enhancement.

Line 15: Call FND_STATS.SET_TABLE_STATS for the MV log if num_rows in all_tables

11:
12: /**Changes for Enhancement 4378448. We have to review/rollback
13: the changes after ST fix the issue as mentioned in the enhancement.
14: Changes made:
15: Call FND_STATS.SET_TABLE_STATS for the MV log if num_rows in all_tables
16: for this log <>0. Otherwise, not to call FND_STATS.SET_TABLE_STATS for the MV log.
17: **/
18:
19: procedure GATHER_TABLE_STATS(errbuf out NOCOPY varchar2,

Line 16: for this log <>0. Otherwise, not to call FND_STATS.SET_TABLE_STATS for the MV log.

12: /**Changes for Enhancement 4378448. We have to review/rollback
13: the changes after ST fix the issue as mentioned in the enhancement.
14: Changes made:
15: Call FND_STATS.SET_TABLE_STATS for the MV log if num_rows in all_tables
16: for this log <>0. Otherwise, not to call FND_STATS.SET_TABLE_STATS for the MV log.
17: **/
18:
19: procedure GATHER_TABLE_STATS(errbuf out NOCOPY varchar2,
20: retcode out NOCOPY varchar2,

Line 57: bis_collection_utilities.put_line('Calling FND_STATS.GATHER_TABLE_STATS for object '||l_object_owner||','||objectname);

53:
54:
55: if nvl(l_object_owner,'NOTFOUND')<>'NOTFOUND' then
56: begin
57: bis_collection_utilities.put_line('Calling FND_STATS.GATHER_TABLE_STATS for object '||l_object_owner||','||objectname);
58: FND_STATS.GATHER_TABLE_STATS(errbuf =>errbuf,
59: retcode =>retcode,
60: ownname =>l_object_owner,
61: tabname =>objectname,

Line 58: FND_STATS.GATHER_TABLE_STATS(errbuf =>errbuf,

54:
55: if nvl(l_object_owner,'NOTFOUND')<>'NOTFOUND' then
56: begin
57: bis_collection_utilities.put_line('Calling FND_STATS.GATHER_TABLE_STATS for object '||l_object_owner||','||objectname);
58: FND_STATS.GATHER_TABLE_STATS(errbuf =>errbuf,
59: retcode =>retcode,
60: ownname =>l_object_owner,
61: tabname =>objectname,
62: percent =>percent,

Line 73: bis_collection_utilities.put_line('Error happened inside FND_STATS.GATHER_TABLE_STATS '||sqlcode||sqlerrm);

69: );
70: bis_collection_utilities.put_line(l_object_owner||','||objectname||' has been analyzed successfully');
71: exception
72: when others then
73: bis_collection_utilities.put_line('Error happened inside FND_STATS.GATHER_TABLE_STATS '||sqlcode||sqlerrm);
74: raise;
75: end;
76: end if;
77:

Line 94: bis_collection_utilities.put_line('Not to call FND_STATS.SET_TABLE_STATS for '||l_object_owner||'.'||l_object_log||' because num_rows in all_tables for this MV log is already 0');

90: end;
91: end if;
92:
93: if l_object_log is not null and l_num_rows=0 then
94: bis_collection_utilities.put_line('Not to call FND_STATS.SET_TABLE_STATS for '||l_object_owner||'.'||l_object_log||' because num_rows in all_tables for this MV log is already 0');
95: end if;
96:
97: if l_object_log is not null and l_num_rows<>0 then
98: begin

Line 99: bis_collection_utilities.put_line('Calling FND_STATS.SET_TABLE_STATS for object log '||l_object_owner||','||l_object_log);

95: end if;
96:
97: if l_object_log is not null and l_num_rows<>0 then
98: begin
99: bis_collection_utilities.put_line('Calling FND_STATS.SET_TABLE_STATS for object log '||l_object_owner||','||l_object_log);
100: FND_STATS.SET_TABLE_STATS(OWNNAME=>l_object_owner,
101: TABNAME=>l_object_log,
102: NUMROWS=>0,
103: NUMBLKS=>0,

Line 100: FND_STATS.SET_TABLE_STATS(OWNNAME=>l_object_owner,

96:
97: if l_object_log is not null and l_num_rows<>0 then
98: begin
99: bis_collection_utilities.put_line('Calling FND_STATS.SET_TABLE_STATS for object log '||l_object_owner||','||l_object_log);
100: FND_STATS.SET_TABLE_STATS(OWNNAME=>l_object_owner,
101: TABNAME=>l_object_log,
102: NUMROWS=>0,
103: NUMBLKS=>0,
104: AVGRLEN=>0);

Line 108: bis_collection_utilities.put_line('Error happened inside FND_STATS.SET_TABLE_STATS '||sqlcode||sqlerrm);

104: AVGRLEN=>0);
105: bis_collection_utilities.put_line(l_object_owner||','||l_object_log||' statistics has been set successfully');
106: exception
107: when others then
108: bis_collection_utilities.put_line('Error happened inside FND_STATS.SET_TABLE_STATS '||sqlcode||sqlerrm);
109: raise;
110: end;
111: end if;
112: --Enh#4418520-aguwalan