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 1125: FROM V$PARAMETER

1121: begin
1122: SELECT to_char(least(to_number(VALUE),8)),
1123: to_char(least(to_number(VALUE)*2,8))
1124: INTO v_freelist_groups, v_initrans
1125: FROM V$PARAMETER
1126: WHERE NAME = 'cpu_count';
1127: exception
1128: when NO_DATA_FOUND then
1129: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');

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

1126: WHERE NAME = 'cpu_count';
1127: exception
1128: when NO_DATA_FOUND then
1129: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1130: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1131: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1132: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1133: raise_application_error(-20001,'Missing view V$PARAMETER');
1134: when OTHERS then

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

1129: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1130: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1131: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1132: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1133: raise_application_error(-20001,'Missing view V$PARAMETER');
1134: when OTHERS then
1135: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1136: raise;
1137: end;

Line 1142: FROM V$PARAMETER

1138:
1139: begin
1140: SELECT to_char(min(to_number(VALUE)))
1141: INTO v_degree
1142: FROM V$PARAMETER
1143: WHERE NAME IN ('parallel_max_servers','cpu_count');
1144: exception
1145: when NO_DATA_FOUND then
1146: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');

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

1143: WHERE NAME IN ('parallel_max_servers','cpu_count');
1144: exception
1145: when NO_DATA_FOUND then
1146: utl_file.put_line(i_file_handle,'--Error while querying number parallel degree.');
1147: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1148: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1149:
1150: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1151: raise_application_error(-20001,'Missing view V$PARAMETER');

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

1147: utl_file.put_line(i_file_handle,'-- View V$PARAMETER does not exist.');
1148: utl_file.put_line(i_file_handle,'-- Please check if you login to the correct user, database,');
1149:
1150: utl_file.put_line(i_file_handle,'-- and that application installation has been completed successfully.');
1151: raise_application_error(-20001,'Missing view V$PARAMETER');
1152:
1153: when OTHERS then
1154: utl_file.put_line(i_file_handle,'--Error while querying number of CPUs.');
1155: raise;