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.BSC_SETUP_DATA_RPT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 31: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

27: report OUT NOCOPY JTF_DIAG_REPORT,
28: reportClob OUT NOCOPY CLOB) IS
29: reportStr LONG;
30: counter NUMBER;
31: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
32: c_userid VARCHAR2(50);
33: statusStr VARCHAR2(50);
34: errStr VARCHAR2(4000);
35: fixInfo VARCHAR2(4000);

Line 56: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

52: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
53:
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55:
56: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));
58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));

53:
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55:
56: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));
58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);

Line 58: JTF_DIAGNOSTIC_COREAPI.BRPrint;

54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55:
56: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));
58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);
62: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);

55:
56: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));
58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);
62: JTF_DIAGNOSTIC_COREAPI.BRPrint;
63:

Line 60: JTF_DIAGNOSTIC_COREAPI.BRPrint;

56: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));
58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);
62: JTF_DIAGNOSTIC_COREAPI.BRPrint;
63:
64: sqltxt := 'SELECT a.SESSION_ID,b.serial#,b.status,c.object_name,a.ORACLE_USERNAME,'||

Line 61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);

57: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(g_patch_level_sql,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PRODUCT_LEVEL'));
58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);
62: JTF_DIAGNOSTIC_COREAPI.BRPrint;
63:
64: sqltxt := 'SELECT a.SESSION_ID,b.serial#,b.status,c.object_name,a.ORACLE_USERNAME,'||
65: ' a.OS_USER_NAME,a.PROCESS FROM v$locked_object a, v$session b, all_objects c '||

Line 62: JTF_DIAGNOSTIC_COREAPI.BRPrint;

58: JTF_DIAGNOSTIC_COREAPI.BRPrint;
59: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_APPS_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_versioN);
60: JTF_DIAGNOSTIC_COREAPI.BRPrint;
61: JTF_DIAGNOSTIC_COREAPI.LINE_OUT(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DB_VERSION')||JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header);
62: JTF_DIAGNOSTIC_COREAPI.BRPrint;
63:
64: sqltxt := 'SELECT a.SESSION_ID,b.serial#,b.status,c.object_name,a.ORACLE_USERNAME,'||
65: ' a.OS_USER_NAME,a.PROCESS FROM v$locked_object a, v$session b, all_objects c '||
66: ' WHERE c.OBJECT_NAME LIKE ''BSC%'' AND c.OBJECT_ID=a.OBJECT_ID AND b.sid=a.SESSION_ID'||

Line 69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_OBJECT_LOCKS');

65: ' a.OS_USER_NAME,a.PROCESS FROM v$locked_object a, v$session b, all_objects c '||
66: ' WHERE c.OBJECT_NAME LIKE ''BSC%'' AND c.OBJECT_ID=a.OBJECT_ID AND b.sid=a.SESSION_ID'||
67: ' AND c.OWNER = '''|| l_oracle_schema||'''';
68:
69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_OBJECT_LOCKS');
70:
71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: sqltxt := 'SELECT * FROM BSC_CURRENT_SESSIONS';

Line 71: JTF_DIAGNOSTIC_COREAPI.BRPrint;

67: ' AND c.OWNER = '''|| l_oracle_schema||'''';
68:
69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_OBJECT_LOCKS');
70:
71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: sqltxt := 'SELECT * FROM BSC_CURRENT_SESSIONS';
74:
75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_CURRENT_SESSIONS');

Line 75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_CURRENT_SESSIONS');

71: JTF_DIAGNOSTIC_COREAPI.BRPrint;
72:
73: sqltxt := 'SELECT * FROM BSC_CURRENT_SESSIONS';
74:
75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_CURRENT_SESSIONS');
76:
77: JTF_DIAGNOSTIC_COREAPI.BRPrint;
78: JTF_DIAGNOSTIC_COREAPI.display_profiles(271);
79: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 77: JTF_DIAGNOSTIC_COREAPI.BRPrint;

73: sqltxt := 'SELECT * FROM BSC_CURRENT_SESSIONS';
74:
75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_CURRENT_SESSIONS');
76:
77: JTF_DIAGNOSTIC_COREAPI.BRPrint;
78: JTF_DIAGNOSTIC_COREAPI.display_profiles(271);
79: JTF_DIAGNOSTIC_COREAPI.BRPrint;
80:
81: sqltxt := 'SELECT * FROM bsc_sys_init ';

Line 78: JTF_DIAGNOSTIC_COREAPI.display_profiles(271);

74:
75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_CURRENT_SESSIONS');
76:
77: JTF_DIAGNOSTIC_COREAPI.BRPrint;
78: JTF_DIAGNOSTIC_COREAPI.display_profiles(271);
79: JTF_DIAGNOSTIC_COREAPI.BRPrint;
80:
81: sqltxt := 'SELECT * FROM bsc_sys_init ';
82:

Line 79: JTF_DIAGNOSTIC_COREAPI.BRPrint;

75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_CURRENT_SESSIONS');
76:
77: JTF_DIAGNOSTIC_COREAPI.BRPrint;
78: JTF_DIAGNOSTIC_COREAPI.display_profiles(271);
79: JTF_DIAGNOSTIC_COREAPI.BRPrint;
80:
81: sqltxt := 'SELECT * FROM bsc_sys_init ';
82:
83: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_SYS_INIT');

Line 83: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_SYS_INIT');

79: JTF_DIAGNOSTIC_COREAPI.BRPrint;
80:
81: sqltxt := 'SELECT * FROM bsc_sys_init ';
82:
83: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_SYS_INIT');
84:
85: JTF_DIAGNOSTIC_COREAPI.BRPrint;
86:
87: sqltxt := 'SELECT * FROM BSC_MESSAGE_LOGS ';

Line 85: JTF_DIAGNOSTIC_COREAPI.BRPrint;

81: sqltxt := 'SELECT * FROM bsc_sys_init ';
82:
83: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_SYS_INIT');
84:
85: JTF_DIAGNOSTIC_COREAPI.BRPrint;
86:
87: sqltxt := 'SELECT * FROM BSC_MESSAGE_LOGS ';
88:
89: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_MESSAGE_LOGS');

Line 89: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_MESSAGE_LOGS');

85: JTF_DIAGNOSTIC_COREAPI.BRPrint;
86:
87: sqltxt := 'SELECT * FROM BSC_MESSAGE_LOGS ';
88:
89: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_MESSAGE_LOGS');
90:
91: JTF_DIAGNOSTIC_COREAPI.BRPrint;
92:
93: statusStr := 'SUCCESS';

Line 91: JTF_DIAGNOSTIC_COREAPI.BRPrint;

87: sqltxt := 'SELECT * FROM BSC_MESSAGE_LOGS ';
88:
89: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_MESSAGE_LOGS');
90:
91: JTF_DIAGNOSTIC_COREAPI.BRPrint;
92:
93: statusStr := 'SUCCESS';
94:
95: JTF_DIAGNOSTIC_COREAPI.WarningPrint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_REPORT_OUTPUT'));

Line 95: JTF_DIAGNOSTIC_COREAPI.WarningPrint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_REPORT_OUTPUT'));

91: JTF_DIAGNOSTIC_COREAPI.BRPrint;
92:
93: statusStr := 'SUCCESS';
94:
95: JTF_DIAGNOSTIC_COREAPI.WarningPrint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_REPORT_OUTPUT'));
96:
97: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
98: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
99: END runTest;