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.WF_INSTALL dependencies on V$PARAMETER

Line 296: FROM V$PARAMETER

292: begin
293: SELECT to_char(least(to_number(VALUE),8)),
294: to_char(least(to_number(VALUE),4))
295: INTO v_freelist_groups, v_initrans
296: FROM V$PARAMETER
297: WHERE NAME = 'cpu_count';
298: exception
299: when NO_DATA_FOUND then
300: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');

Line 301: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');

297: WHERE NAME = 'cpu_count';
298: exception
299: when NO_DATA_FOUND then
300: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
301: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
302: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
303: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
304: raise_application_error(-20001,'Missing view V$PARAMETER');
305: when OTHERS then

Line 304: raise_application_error(-20001,'Missing view V$PARAMETER');

300: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
301: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
302: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
303: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
304: raise_application_error(-20001,'Missing view V$PARAMETER');
305: when OTHERS then
306: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
307: raise;
308: end;

Line 312: FROM V$PARAMETER

308: end;
309: begin
310: SELECT to_char(min(to_number(VALUE)))
311: INTO v_degree
312: FROM V$PARAMETER
313: WHERE NAME IN ('parallel_max_servers','cpu_count');
314: exception
315: when NO_DATA_FOUND then
316: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');

Line 317: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');

313: WHERE NAME IN ('parallel_max_servers','cpu_count');
314: exception
315: when NO_DATA_FOUND then
316: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');
317: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
318: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
319: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
320: raise_application_error(-20001,'Missing view V$PARAMETER');
321: when OTHERS then

Line 320: raise_application_error(-20001,'Missing view V$PARAMETER');

316: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');
317: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
318: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
319: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
320: raise_application_error(-20001,'Missing view V$PARAMETER');
321: when OTHERS then
322: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
323: raise;
324: end;

Line 1114: FROM V$PARAMETER

1110: begin
1111: SELECT to_char(least(to_number(VALUE),8)),
1112: to_char(least(to_number(VALUE)*2,8))
1113: INTO v_freelist_groups, v_initrans
1114: FROM V$PARAMETER
1115: WHERE NAME = 'cpu_count';
1116: exception
1117: when NO_DATA_FOUND then
1118: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');

Line 1119: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');

1115: WHERE NAME = 'cpu_count';
1116: exception
1117: when NO_DATA_FOUND then
1118: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1119: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1120: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1121: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1122: raise_application_error(-20001,'Missing view V$PARAMETER');
1123: when OTHERS then

Line 1122: raise_application_error(-20001,'Missing view V$PARAMETER');

1118: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1119: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1120: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1121: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1122: raise_application_error(-20001,'Missing view V$PARAMETER');
1123: when OTHERS then
1124: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1125: raise;
1126: end;

Line 1131: FROM V$PARAMETER

1127:
1128: begin
1129: SELECT to_char(min(to_number(VALUE)))
1130: INTO v_degree
1131: FROM V$PARAMETER
1132: WHERE NAME IN ('parallel_max_servers','cpu_count');
1133: exception
1134: when NO_DATA_FOUND then
1135: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');

Line 1136: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');

1132: WHERE NAME IN ('parallel_max_servers','cpu_count');
1133: exception
1134: when NO_DATA_FOUND then
1135: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');
1136: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1137: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1138:
1139: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1140: raise_application_error(-20001,'Missing view V$PARAMETER');

Line 1140: raise_application_error(-20001,'Missing view V$PARAMETER');

1136: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1137: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1138:
1139: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1140: raise_application_error(-20001,'Missing view V$PARAMETER');
1141:
1142: when OTHERS then
1143: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1144: raise;