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_OBJECTIVE_METADATA_SETUP dependencies on JTF_DIAGNOSTIC_COREAPI

Line 79: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

75: l_patch_number NUMBER;
76: BEGIN
77: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
78: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
79: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
80: l_kpi_Id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(get_message_name('BSC_OBJECTIVE'),inputs);
81: IF l_kpi_Id IS NULL OR l_kpi_Id = '' THEN
82: statusStr := 'FAILURE';
83: errStr := get_message_name('BSC_EMPTY_OBJ_ID');

Line 85: JTF_DIAGNOSTIC_COREAPI.BRPrint;

81: IF l_kpi_Id IS NULL OR l_kpi_Id = '' THEN
82: statusStr := 'FAILURE';
83: errStr := get_message_name('BSC_EMPTY_OBJ_ID');
84: fixInfo := get_message_name('BSC_SELECT_VALID_OBJECTIVE');
85: JTF_DIAGNOSTIC_COREAPI.BRPrint;
86: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
87: isFatal := 'FALSE';
88: ELSE
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 86: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

82: statusStr := 'FAILURE';
83: errStr := get_message_name('BSC_EMPTY_OBJ_ID');
84: fixInfo := get_message_name('BSC_SELECT_VALID_OBJECTIVE');
85: JTF_DIAGNOSTIC_COREAPI.BRPrint;
86: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
87: isFatal := 'FALSE';
88: ELSE
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;

Line 89: JTF_DIAGNOSTIC_COREAPI.BRPrint;

85: JTF_DIAGNOSTIC_COREAPI.BRPrint;
86: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
87: isFatal := 'FALSE';
88: ELSE
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;
91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);

Line 91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);

87: isFatal := 'FALSE';
88: ELSE
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;
91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);

Line 92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);

88: ELSE
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;
91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);

Line 93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);

89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;
91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);
97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);

Line 94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);

90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;
91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);
97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);
98: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_calculations','BSC_KPI_CALCULATIONS', l_Where_Clause);

Line 95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);

91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);
97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);
98: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_calculations','BSC_KPI_CALCULATIONS', l_Where_Clause);
99:

Line 96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);

92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);
97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);
98: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_calculations','BSC_KPI_CALCULATIONS', l_Where_Clause);
99:
100: SELECT

Line 97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);

93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);
97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);
98: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_calculations','BSC_KPI_CALCULATIONS', l_Where_Clause);
99:
100: SELECT
101: TO_NUMBER(REPLACE(property_value,'.','')) patch_number

Line 98: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_calculations','BSC_KPI_CALCULATIONS', l_Where_Clause);

94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);
96: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_level_properties','BSC_KPI_DIM_LEVEL_PROPERTIES', l_Where_Clause);
97: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_periodicities','BSC_KPI_PERIODICITIES', l_Where_Clause);
98: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_calculations','BSC_KPI_CALCULATIONS', l_Where_Clause);
99:
100: SELECT
101: TO_NUMBER(REPLACE(property_value,'.','')) patch_number
102: INTO

Line 110: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_measure_props','BSC_KPI_MEASURE_PROPS', l_Where_Clause);

106: WHERE
107: property_code = 'PATCH_NUMBER';
108:
109: IF l_patch_number >= 603 THEN
110: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_measure_props','BSC_KPI_MEASURE_PROPS', l_Where_Clause);
111: END IF;
112: statusStr := 'SUCCESS';
113: END IF;
114: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);