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_CORRUPT_OBJECTS_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 46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

42: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
43:
44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
45:
46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47:
48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));

Line 48: JTF_DIAGNOSTIC_COREAPI.BRPrint;

44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
45:
46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47:
48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));
51:
52: h_count := 0;

Line 50: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));

46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47:
48: JTF_DIAGNOSTIC_COREAPI.BRPrint;
49:
50: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));
51:
52: h_count := 0;
53:
54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');

Line 54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');

50: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));
51:
52: h_count := 0;
53:
54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');
55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');
56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');

Line 55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');

51:
52: h_count := 0;
53:
54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');
55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');
56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');
59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');

Line 56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');

52: h_count := 0;
53:
54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');
55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');
56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');
59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');
60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');

Line 57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');

53:
54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');
55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');
56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');
59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');
60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');
61:

Line 58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');

54: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql1,'BIS_INDICATORS<>BSC_SYS_DATASETS_B');
55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');
56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');
59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');
60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');
61:
62:

Line 59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');

55: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql2,'BSC_SYS_DATASETS_B<>BIS_INDICATORS');
56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');
59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');
60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');
61:
62:
63: IF h_count >0 THEN

Line 60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');

56: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_measure_sql3,'BSC_DB_MEASURE_COLS_VL<>BSC_SYS_MEASURES');
57: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_per_sql,'BSC_SYS_PERIODICITIES_VL<>BSC_SYS_DIM_LEVELS_VL');
58: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_cal_sql,'BSC_SYS_CALENDARS_VL<>BSC_SYS_DIM_GROUPS_VL');
59: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_rpt_sql,'BSC_KPIS_B<>AK_REGIONS');
60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');
61:
62:
63: IF h_count >0 THEN
64: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 64: JTF_DIAGNOSTIC_COREAPI.BRPrint;

60: h_count:= h_count+JTF_DIAGNOSTIC_COREAPI.display_sql(g_dang_tab_sql,'BSC_TABS_VL<>AK_REGIONS');
61:
62:
63: IF h_count >0 THEN
64: JTF_DIAGNOSTIC_COREAPI.BRPrint;
65: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FOUND');
66: statusStr := 'WARNING';
67: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DANGLING_OBJ_FIX');
68: isFatal := 'FALSE';

Line 69: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

65: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FOUND');
66: statusStr := 'WARNING';
67: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DANGLING_OBJ_FIX');
68: isFatal := 'FALSE';
69: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
70: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
71: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
72: RETURN ;
73: END IF;

Line 76: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NO_DANG_RECS'));

72: RETURN ;
73: END IF;
74: statusStr := 'SUCCESS';
75: isFatal := 'FALSE';
76: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NO_DANG_RECS'));
77: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
79: END runTest;
80: