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.BIS_BIA_STATS dependencies on BIS_COLLECTION_UTILITIES

Line 41: bis_collection_utilities.put_line('request id: '||l_request_id);

37: begin
38: l_request_id:=fnd_global.CONC_REQUEST_ID ;
39: l_root_request_id:=FND_GLOBAL.CONC_PRIORITY_REQUEST;
40:
41: bis_collection_utilities.put_line('request id: '||l_request_id);
42:
43: begin
44: l_object_owner:=bis_create_requestset.get_object_owner(objectname,objecttype);
45: l_object_log:=bis_create_requestset.get_mv_log(objectname,l_object_owner);

Line 46: bis_collection_utilities.put_line('schema for '||objectname||':'||l_object_owner);

42:
43: begin
44: l_object_owner:=bis_create_requestset.get_object_owner(objectname,objecttype);
45: l_object_log:=bis_create_requestset.get_mv_log(objectname,l_object_owner);
46: bis_collection_utilities.put_line('schema for '||objectname||':'||l_object_owner);
47: bis_collection_utilities.put_line('MV log for '||objectname||':'||l_object_log );
48: exception
49: when others then
50: bis_collection_utilities.put_line('Error happened when get object schema and object mv log'||sqlcode||sqlerrm);

Line 47: bis_collection_utilities.put_line('MV log for '||objectname||':'||l_object_log );

43: begin
44: l_object_owner:=bis_create_requestset.get_object_owner(objectname,objecttype);
45: l_object_log:=bis_create_requestset.get_mv_log(objectname,l_object_owner);
46: bis_collection_utilities.put_line('schema for '||objectname||':'||l_object_owner);
47: bis_collection_utilities.put_line('MV log for '||objectname||':'||l_object_log );
48: exception
49: when others then
50: bis_collection_utilities.put_line('Error happened when get object schema and object mv log'||sqlcode||sqlerrm);
51: raise;

Line 50: bis_collection_utilities.put_line('Error happened when get object schema and object mv log'||sqlcode||sqlerrm);

46: bis_collection_utilities.put_line('schema for '||objectname||':'||l_object_owner);
47: bis_collection_utilities.put_line('MV log for '||objectname||':'||l_object_log );
48: exception
49: when others then
50: bis_collection_utilities.put_line('Error happened when get object schema and object mv log'||sqlcode||sqlerrm);
51: raise;
52: end;
53:
54:

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 70: bis_collection_utilities.put_line(l_object_owner||','||objectname||' has been analyzed successfully');

66: granularity =>granularity,
67: hmode =>hmode,
68: invalidate=>invalidate
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;

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 105: bis_collection_utilities.put_line(l_object_owner||','||l_object_log||' statistics has been set successfully');

101: TABNAME=>l_object_log,
102: NUMROWS=>0,
103: NUMBLKS=>0,
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;

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

Line 115: bis_collection_utilities.put_line('Calling BIS_COLL_RS_HISTORY.insert_program_object_data ');

111: end if;
112: --Enh#4418520-aguwalan
113: IF(BIS_CREATE_REQUESTSET.is_history_collect_on(l_root_request_id)) THEN
114: begin
115: bis_collection_utilities.put_line('Calling BIS_COLL_RS_HISTORY.insert_program_object_data ');
116: if nvl(l_object_owner,'NOTFOUND')<>'NOTFOUND' then
117: BIS_COLL_RS_HISTORY.insert_program_object_data
118: (x_request_id => l_request_id,
119: x_stage_req_id =>null,

Line 136: bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');

132: x_refresh_type =>'ANALYZED',
133: x_set_request_id =>l_root_request_id);
134: end if;
135:
136: bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');
137: exception
138: when others then
139: bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);
140: raise;

Line 139: bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);

135:
136: bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');
137: exception
138: when others then
139: bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);
140: raise;
141: end;
142: ELSE
143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

Line 143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

139: bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);
140: raise;
141: end;
142: ELSE
143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
144: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
145: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
146: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
147: END IF;

Line 144: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');

140: raise;
141: end;
142: ELSE
143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
144: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
145: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
146: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
147: END IF;
148:

Line 145: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');

141: end;
142: ELSE
143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
144: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
145: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
146: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
147: END IF;
148:
149: exception

Line 146: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

142: ELSE
143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
144: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
145: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
146: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
147: END IF;
148:
149: exception
150: when others then