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_BIS_KPI_CRUD_PUB dependencies on BIS_INDICATORS

Line 198: REM | different short names in bis_indicators & |

194: REM | 19-MAY-2006 ankgoel Bug #5201116 Get correct Comparison Source |
195: REM | 22-MAY-2006 akoduri Bug #5104426 Data Source getting updated |
196: REM | BSC Type measures |
197: REM | 11-OCT-2006 akoduri Bug #5554168 Issue with Measures having |
198: REM | different short names in bis_indicators & |
199: REM | bsc_sys_measures |
200: REM | 09-feb-2007 ashankar Simulation Tree Enhacement 5386112 |
201: REM | 22-Mar-2007 ashankar Fixed the Bug#5930808 |
202: REM +=======================================================================+

Line 598: bis_indicators i

594: l_Bsc_Measure_Id
595: FROM
596: bsc_sys_measures m,
597: bsc_sys_datasets_vl d,
598: bis_indicators i
599: WHERE
600: i.dataset_id = d.dataset_id AND
601: d.measure_id1 = m.measure_id AND
602: i.short_name = p_measure_short_name;

Line 2285: UPDATE BIS_INDICATORS

2281:
2282: l_Value := l_Region_Code || '.' || p_Measure_Short_Name;
2283:
2284:
2285: UPDATE BIS_INDICATORS
2286: SET ACTUAL_DATA_SOURCE = l_Value
2287: , ACTUAL_DATA_SOURCE_TYPE = 'AK'
2288: , FUNCTION_NAME = l_Region_Code
2289: , ENABLE_LINK = 'Y'

Line 2866: bis_indicators i

2862: SELECT
2863: i.dataset_id
2864: INTO l_dataset_id
2865: FROM
2866: bis_indicators i
2867: WHERE
2868: i.short_name = p_Measure_Short_Name;
2869:
2870: RETURN l_dataset_id;

Line 4747: -- bis_indicators as the api validate the akregion

4743: END IF;
4744: --DBMS_OUTPUT.PUT_LINE('Outside Create_Measure_Region_Item ' );
4745:
4746: -- udpate the actual data source column in
4747: -- bis_indicators as the api validate the akregion
4748:
4749: Update_Actual_Data_Source(
4750: p_kpi_id => p_Kpi_Id
4751: , p_dataset_id => Get_Dataset_Id(p_Measure_Short_Name)

Line 4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;

4905: l_Report_Region_Rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;
4906: l_User_Page_Report_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4907: l_User_Portlet_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4908: l_Analysis_Option NUMBER;
4909: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
4910: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
4911: l_Count NUMBER;
4912: l_Function_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4913: l_Measure_Group_Id NUMBER;

Line 4931: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

4927: l_Is_XTD_Enabled VARCHAR2(1);
4928: l_Bsc_Measure_Id NUMBER;
4929: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;
4930: l_Returned_Kpi_Id NUMBER;
4931: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4932: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4933: l_Count1 NUMBER;
4934: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4935: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

Line 4932: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;

4928: l_Bsc_Measure_Id NUMBER;
4929: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;
4930: l_Returned_Kpi_Id NUMBER;
4931: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4932: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4933: l_Count1 NUMBER;
4934: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4935: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4936: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

Line 4935: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

4931: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
4932: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
4933: l_Count1 NUMBER;
4934: l_attribute_code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4935: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4936: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
4937: l_as_of_date VARCHAR2(1);
4938:
4939: l_obj_type NUMBER;

Line 4963: bis_indicators i

4959: l_Measure_Source
4960: FROM
4961: bsc_sys_measures m,
4962: bsc_sys_datasets_vl d,
4963: bis_indicators i
4964: WHERE
4965: i.dataset_id = d.dataset_id AND
4966: d.measure_id1 = m.measure_id AND
4967: i.short_name = p_Measure_Short_Name;

Line 5293: FROM BIS_INDICATORS

5289: -- ) Update Measure Properties
5290: -- ) Update Objective Analysis Measures metadata.
5291: -- Create normal measure.
5292: SELECT COUNT(1) INTO l_Count
5293: FROM BIS_INDICATORS
5294: WHERE SHORT_NAME = p_measure_short_name;
5295:
5296: l_Region_Code := BIS_PMV_UTIL.GetReportRegion(p_Region_Function_Name);
5297: l_attribute_code := BSC_BIS_KPI_CRUD_PUB.Get_Attribute_Code_For_Measure(l_Region_Code,p_Measure_Short_Name);

Line 5313: bis_indicators i

5309: l_Bsc_Measure_Id
5310: FROM
5311: bsc_sys_measures m,
5312: bsc_sys_datasets_vl d,
5313: bis_indicators i
5314: WHERE
5315: i.dataset_id = d.dataset_id AND
5316: d.measure_id1 = m.measure_id AND
5317: i.short_name = p_measure_short_name;

Line 5589: UPDATE BIS_INDICATORS

5585: IF (l_Compare_Attribute_Code IS NOT NULL) THEN
5586: l_Comparison_Source := p_Region_Function_Name || '.' || l_Compare_Attribute_Code;
5587: END IF;
5588:
5589: UPDATE BIS_INDICATORS
5590: SET ACTUAL_DATA_SOURCE = p_Region_Function_Name || '.' || l_attribute_code
5591: , ACTUAL_DATA_SOURCE_TYPE = 'AK'
5592: , FUNCTION_NAME = p_Region_Function_Name
5593: , COMPARISON_SOURCE = l_Comparison_Source

Line 5915: BIS_INDICATORS M,

5911: D.HELP,
5912: M.SHORT_NAME,
5913: D.FORMAT_ID
5914: FROM BSC_KPI_ANALYSIS_MEASURES_VL A,
5915: BIS_INDICATORS M,
5916: BSC_SYS_DATASETS_VL D
5917: WHERE A.ANALYSIS_OPTION0 >= p_Deleted_AO_Index
5918: AND A.ANALYSIS_OPTION1 = 0
5919: AND A.ANALYSIS_OPTION2 = 0

Line 6473: -- Gets BSC_KPIS_VL.INDICATOR using BIS_INDICATORS.SHORT_NAME

6469: WHEN OTHERS THEN
6470: RETURN NULL;
6471: END Get_Next_Region_Code_By_AO;
6472:
6473: -- Gets BSC_KPIS_VL.INDICATOR using BIS_INDICATORS.SHORT_NAME
6474: -- Used in UI
6475:
6476: FUNCTION Get_Objective_By_Kpi(
6477: p_Short_Name IN VARCHAR2

Line 6492: bis_indicators i

6488: l_Count
6489: FROM
6490: bsc_sys_measures m,
6491: bsc_sys_datasets_vl d,
6492: bis_indicators i
6493: WHERE
6494: i.dataset_id = d.dataset_id AND
6495: d.measure_id1 = m.measure_id AND
6496: i.short_name = p_Short_Name AND

Line 6508: FROM BIS_INDICATORS

6504: SELECT DISTINCT INDICATOR
6505: INTO l_Kpi_Id
6506: FROM BSC_KPI_ANALYSIS_OPTIONS_B
6507: WHERE SHORT_NAME = (SELECT SUBSTR(ACTUAL_DATA_SOURCE, 1, INSTR(ACTUAL_DATA_SOURCE, '.') - 1) REGION_CODE
6508: FROM BIS_INDICATORS
6509: WHERE SHORT_NAME = p_Short_Name);
6510:
6511: RETURN l_Kpi_Id;
6512:

Line 6711: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

6707: l_Return_Msg VARCHAR2(32000);
6708: l_Message VARCHAR2(32000);
6709: l_Temp_Message VARCHAR2(32000);
6710: l_Dep_Message VARCHAR2(32000);
6711: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
6712: l_Report_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
6713: l_Parent_Obj_Table BIS_RSG_PUB_API_PKG.t_BIA_RSG_Obj_Table;
6714: l_Index_Count NUMBER;
6715: l_Trigger_Exception BOOLEAN;

Line 6712: l_Report_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;

6708: l_Message VARCHAR2(32000);
6709: l_Temp_Message VARCHAR2(32000);
6710: l_Dep_Message VARCHAR2(32000);
6711: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
6712: l_Report_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
6713: l_Parent_Obj_Table BIS_RSG_PUB_API_PKG.t_BIA_RSG_Obj_Table;
6714: l_Index_Count NUMBER;
6715: l_Trigger_Exception BOOLEAN;
6716: l_Trigger_Warning BOOLEAN;

Line 6719: l_Kpi_Name BIS_INDICATORS_TL.NAME%TYPE;

6715: l_Trigger_Exception BOOLEAN;
6716: l_Trigger_Warning BOOLEAN;
6717: l_Loop NUMBER;
6718: l_Parent_Object_Type VARCHAR2(10);
6719: l_Kpi_Name BIS_INDICATORS_TL.NAME%TYPE;
6720:
6721: l_Msg_Count_Size NUMBER;
6722: l_Msg_Max_Count_Size NUMBER;
6723: l_Msg_Exceeds_Size BOOLEAN;

Line 6731: , BIS_INDICATORS BI

6727: SELECT T.NAME
6728: FROM BSC_TABS_VL T
6729: , BSC_TAB_INDICATORS TI
6730: , BSC_KPI_ANALYSIS_MEASURES_B AM
6731: , BIS_INDICATORS BI
6732: WHERE BI.SHORT_NAME = l_Measure_Short_Name
6733: AND AM.DATASET_ID = BI.DATASET_ID
6734: AND TI.INDICATOR = AM.INDICATOR
6735: AND T.TAB_ID = TI.TAB_ID;

Line 6739: FROM BIS_INDICATORS B

6735: AND T.TAB_ID = TI.TAB_ID;
6736:
6737: CURSOR c_Report_List IS
6738: SELECT B.FUNCTION_NAME
6739: FROM BIS_INDICATORS B
6740: WHERE B.SHORT_NAME = l_Measure_Short_Name;
6741:
6742: CURSOR c_Kpi_Report_List IS
6743: SELECT K.NAME || ' [' || K.INDICATOR || ']' NAME

Line 6746: , BIS_INDICATORS B

6742: CURSOR c_Kpi_Report_List IS
6743: SELECT K.NAME || ' [' || K.INDICATOR || ']' NAME
6744: FROM BSC_KPIS_VL K
6745: , BSC_KPI_ANALYSIS_MEASURES_B A
6746: , BIS_INDICATORS B
6747: WHERE K.INDICATOR = A.INDICATOR
6748: AND A.DATASET_ID = B.DATASET_ID
6749: AND B.SHORT_NAME = l_Measure_Short_Name;
6750:

Line 6933: FROM BIS_INDICATORS_VL

6929:
6930: BEGIN
6931: SELECT NAME
6932: INTO l_Kpi_Name
6933: FROM BIS_INDICATORS_VL
6934: WHERE SHORT_NAME = l_Measure_Short_Name;
6935: EXCEPTION WHEN OTHERS THEN
6936: l_Kpi_Name := l_Measure_Short_Name;
6937: END;

Line 7182: FROM BIS_INDICATORS

7178:
7179: BEGIN
7180: SELECT SUBSTR(ACTUAL_DATA_SOURCE, 1, INSTR(ACTUAL_DATA_SOURCE, '.') - 1)
7181: INTO x_Report_Code
7182: FROM BIS_INDICATORS
7183: WHERE SHORT_NAME = p_Measure_Short_Name;
7184: EXCEPTION
7185: WHEN OTHERS THEN
7186: x_Report_Code := NULL;

Line 7257: l_measure_shortname BIS_INDICATORS.SHORT_NAME%TYPE;

7253: ,x_msg_count OUT NOCOPY NUMBER
7254: ,x_msg_data OUT NOCOPY VARCHAR2
7255: ) IS
7256:
7257: l_measure_shortname BIS_INDICATORS.SHORT_NAME%TYPE;
7258: l_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE;
7259: l_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE;
7260: l_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE;
7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;

Line 7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b

7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE
7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE
7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS
7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b
7273: WHERE a.dataset_id = b.dataset_id
7274: AND B.INDICATOR = p_indicator
7275: AND B.ANALYSIS_OPTION0 = p_ana_option0
7276: AND B.ANALYSIS_OPTION1 = p_ana_option1

Line 7280: TYPE shortnames_array IS TABLE OF BIS_INDICATORS.SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;

7276: AND B.ANALYSIS_OPTION1 = p_ana_option1
7277: AND B.ANALYSIS_OPTION2 = p_ana_option2
7278: AND B.SERIES_ID = p_series_id;
7279:
7280: TYPE shortnames_array IS TABLE OF BIS_INDICATORS.SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;
7281: l_measure_names shortnames_array;
7282: l_index pls_integer;
7283:
7284: BEGIN

Line 8234: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

8230: AND ATTRIBUTE1 IN ('BUCKET_MEASURE', 'MEASURE', 'MEASURE_NOTARGET', 'SUB MEASURE')
8231: ORDER BY DISPLAY_SEQUENCE;
8232:
8233: l_Measure_Short_Names VARCHAR2(4096);
8234: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
8235: l_Kpi_Id NUMBER;
8236: l_Dataset_Id NUMBER;
8237: l_Count NUMBER;
8238: BEGIN

Line 8347: -- Gets BSC_KPIS_VL.INDICATOR using BIS_INDICATORS.SHORT_NAME

8343:
8344: END Get_Dep_Obj_Func_Name;
8345:
8346:
8347: -- Gets BSC_KPIS_VL.INDICATOR using BIS_INDICATORS.SHORT_NAME
8348: -- Used in UI
8349:
8350: FUNCTION Get_Objective_By_AGKpi(
8351: p_Short_Name IN VARCHAR2

Line 8366: bis_indicators i

8362: l_Count
8363: FROM
8364: bsc_sys_measures m,
8365: bsc_sys_datasets_vl d,
8366: bis_indicators i
8367: WHERE
8368: i.dataset_id = d.dataset_id AND
8369: d.measure_id1 = m.measure_id AND
8370: i.short_name = p_Short_Name AND

Line 8382: FROM BIS_INDICATORS

8378: SELECT DISTINCT INDICATOR
8379: INTO l_Kpi_Id
8380: FROM BSC_KPIS_B
8381: WHERE SHORT_NAME = (SELECT SUBSTR(ACTUAL_DATA_SOURCE, 1, INSTR(ACTUAL_DATA_SOURCE, '.') - 1) REGION_CODE
8382: FROM BIS_INDICATORS
8383: WHERE SHORT_NAME = p_Short_Name);
8384:
8385: RETURN l_Kpi_Id;
8386:

Line 8419: FROM BIS_INDICATORS I,

8415:
8416:
8417: CURSOR c_Measure_Short_Names IS
8418: SELECT I.SHORT_NAME
8419: FROM BIS_INDICATORS I,
8420: BSC_KPI_ANALYSIS_MEASURES_VL A
8421: WHERE A.INDICATOR = l_Kpi_Id
8422: AND I.DATASET_ID = A.DATASET_ID;
8423:

Line 8476: + Retain BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE to "AK"

8472: with the passed REGION_CODE
8473:
8474: BSC_DB_MEASURE_GROUPS_PKG.DELETE_ROW(L_Measure_Group_Id)
8475:
8476: + Retain BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE to "AK"
8477: + Retain BIS_INDICATORS.FUNCTION_NAME to the current function - no changes
8478: + Manipulate BIS_INDICATORS.ACTUAL_DATA_SOURCE - Open Issue
8479:
8480: */

Line 8477: + Retain BIS_INDICATORS.FUNCTION_NAME to the current function - no changes

8473:
8474: BSC_DB_MEASURE_GROUPS_PKG.DELETE_ROW(L_Measure_Group_Id)
8475:
8476: + Retain BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE to "AK"
8477: + Retain BIS_INDICATORS.FUNCTION_NAME to the current function - no changes
8478: + Manipulate BIS_INDICATORS.ACTUAL_DATA_SOURCE - Open Issue
8479:
8480: */
8481: --DBMS_OUTPUT.PUT_LINE('Coming to ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type');

Line 8478: + Manipulate BIS_INDICATORS.ACTUAL_DATA_SOURCE - Open Issue

8474: BSC_DB_MEASURE_GROUPS_PKG.DELETE_ROW(L_Measure_Group_Id)
8475:
8476: + Retain BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE to "AK"
8477: + Retain BIS_INDICATORS.FUNCTION_NAME to the current function - no changes
8478: + Manipulate BIS_INDICATORS.ACTUAL_DATA_SOURCE - Open Issue
8479:
8480: */
8481: --DBMS_OUTPUT.PUT_LINE('Coming to ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type');
8482:

Line 8617: FROM BIS_INDICATORS I,

8613: l_Delete_Dimension VARCHAR2(1);
8614:
8615: CURSOR c_Measure_Short_Names IS
8616: SELECT I.SHORT_NAME
8617: FROM BIS_INDICATORS I,
8618: BSC_KPI_ANALYSIS_MEASURES_VL A
8619: WHERE A.INDICATOR = l_Kpi_Id
8620: AND I.DATASET_ID = A.DATASET_ID;
8621:

Line 8849: -- Empties the BIS_INDICATORS source and type.

8845:
8846:
8847: -- Converts a measure from AG to Existing Source with the following option
8848: -- Deletes the source groups
8849: -- Empties the BIS_INDICATORS source and type.
8850: PROCEDURE Switch_Measure_Type (
8851: p_Commit IN VARCHAR2 := FND_API.G_FALSE
8852: , p_Measure_Short_Name IN VARCHAR2
8853: , p_Target_Source IN VARCHAR2

Line 8905: UPDATE BIS_INDICATORS B

8901:
8902: IF (p_Clean_Measure_Date_Source = FND_API.G_TRUE) THEN
8903: BEGIN
8904:
8905: UPDATE BIS_INDICATORS B
8906: SET B.ACTUAL_DATA_SOURCE = NULL
8907: WHERE B.SHORT_NAME = p_Measure_Short_Name;
8908:
8909: EXCEPTION

Line 8971: bis_indicators i

8967: l_Measure_Source
8968: FROM
8969: bsc_sys_measures m,
8970: bsc_sys_datasets_vl d,
8971: bis_indicators i
8972: WHERE
8973: i.dataset_id = d.dataset_id AND
8974: d.measure_id1 = m.measure_id AND
8975: i.short_name = p_Measure_Short_Name;

Line 9023: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

9019: FUNCTION Get_Actual_Source_Data (
9020: p_Measures_Short_Name IN VARCHAR2
9021: ) RETURN VARCHAR2
9022: IS
9023: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
9024: BEGIN
9025:
9026: l_Actual_Data_Source := NULL;
9027:

Line 9030: FROM BIS_INDICATORS B

9026: l_Actual_Data_Source := NULL;
9027:
9028: SELECT B.ACTUAL_DATA_SOURCE
9029: INTO l_Actual_Data_Source
9030: FROM BIS_INDICATORS B
9031: WHERE B.SHORT_NAME = p_Measures_Short_Name;
9032:
9033:
9034: -- Invalid Data sources should be returned as NULL (so that they are updatable)

Line 9051: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;

9047: FUNCTION Get_Measure_Function_Name (
9048: p_Measures_Short_Name IN VARCHAR2
9049: ) RETURN VARCHAR2
9050: IS
9051: l_Measure_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
9052: l_Count NUMBER := 0;
9053: BEGIN
9054:
9055: l_Measure_Function_Name := NULL;

Line 9059: FROM BIS_INDICATORS B

9055: l_Measure_Function_Name := NULL;
9056:
9057: SELECT B.FUNCTION_NAME
9058: INTO l_Measure_Function_Name
9059: FROM BIS_INDICATORS B
9060: WHERE B.SHORT_NAME = p_Measures_Short_Name;
9061:
9062: IF(l_Measure_Function_Name IS NULL) THEN
9063: RETURN NULL;

Line 9091: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;

9087: FUNCTION Get_Actual_Source_Data_Type (
9088: p_Measures_Short_Name IN VARCHAR2
9089: ) RETURN VARCHAR2
9090: IS
9091: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
9092: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
9093: BEGIN
9094:
9095: l_Actual_Data_Source_Type := NULL;

Line 9092: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

9088: p_Measures_Short_Name IN VARCHAR2
9089: ) RETURN VARCHAR2
9090: IS
9091: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
9092: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
9093: BEGIN
9094:
9095: l_Actual_Data_Source_Type := NULL;
9096:

Line 9099: FROM BIS_INDICATORS B

9095: l_Actual_Data_Source_Type := NULL;
9096:
9097: SELECT B.ACTUAL_DATA_SOURCE_TYPE, B.ACTUAL_DATA_SOURCE
9098: INTO l_Actual_Data_Source_Type, l_Actual_Data_Source
9099: FROM BIS_INDICATORS B
9100: WHERE B.SHORT_NAME = p_Measures_Short_Name;
9101:
9102: -- Invalid Data sources should be returned as NULL (so that they are updatable)
9103: IF (Is_Measure_Data_Source_Valid(p_Measures_Short_Name,l_Actual_Data_Source) = FND_API.G_FALSE) THEN

Line 9303: , BIS_INDICATORS I

9299: ) RETURN VARCHAR2 IS
9300: CURSOR c_Meas_Short_Names IS
9301: SELECT I.SHORT_NAME
9302: FROM BSC_KPI_ANALYSIS_MEASURES_B K
9303: , BIS_INDICATORS I
9304: WHERE K.INDICATOR = p_Kpi_Id
9305: AND K.ANALYSIS_OPTION0 = 0
9306: AND K.ANALYSIS_OPTION1 = 0
9307: AND K.ANALYSIS_OPTION2 = 0

Line 9344: , BIS_INDICATORS I

9340:
9341: CURSOR c_Meas_Short_Names IS
9342: SELECT I.SHORT_NAME
9343: FROM BSC_KPI_ANALYSIS_MEASURES_B K
9344: , BIS_INDICATORS I
9345: WHERE K.INDICATOR = p_Kpi_Id
9346: AND K.ANALYSIS_OPTION0 = 0
9347: AND K.ANALYSIS_OPTION1 = 0
9348: AND K.ANALYSIS_OPTION2 = 0

Line 9354: l_Cur_Meas_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

9350: AND K.DATASET_ID <>-1
9351: ORDER BY K.SERIES_ID;
9352:
9353: l_Measure_Short_Names VARCHAR2(1000);
9354: l_Cur_Meas_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
9355: l_PreviousMeasCnt NUMBER := 0;
9356: l_CurrentMeasCnt NUMBER := 0;
9357: BEGIN
9358:

Line 9366: , BIS_INDICATORS I

9362: END IF;
9363:
9364: SELECT COUNT(1) INTO l_PreviousMeasCnt
9365: FROM BSC_KPI_ANALYSIS_MEASURES_B K
9366: , BIS_INDICATORS I
9367: WHERE K.INDICATOR = p_Kpi_Id
9368: AND K.ANALYSIS_OPTION0 = 0
9369: AND K.ANALYSIS_OPTION1 = 0
9370: AND K.ANALYSIS_OPTION2 = 0

Line 9522: FROM BIS_INDICATORS B

9518:
9519:
9520: CURSOR c_meas_sht IS
9521: SELECT B.short_name
9522: FROM BIS_INDICATORS B
9523: ,BSC_TAB_VIEW_LABELS_B C
9524: ,BSC_TABS_B A
9525: WHERE A.tab_id = C.tab_id
9526: AND C.link_id = B.dataset_id

Line 10324: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

10320: FUNCTION Get_Comparison_Source (
10321: p_Measures_Short_Name IN VARCHAR2
10322: ) RETURN VARCHAR2
10323: IS
10324: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
10325: BEGIN
10326:
10327: l_Comparison_Source := NULL;
10328:

Line 10331: FROM BIS_INDICATORS B

10327: l_Comparison_Source := NULL;
10328:
10329: SELECT B.COMPARISON_SOURCE
10330: INTO l_Comparison_Source
10331: FROM BIS_INDICATORS B
10332: WHERE B.SHORT_NAME = p_Measures_Short_Name;
10333:
10334: -- Invalid Data sources should be returned as NULL (so that they are updatable)
10335: IF ((BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measures_Short_Name) = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY)

Line 10583: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

10579: p_Measure_Short_Name IN VARCHAR2
10580: , p_Region_Code IN VARCHAR2
10581: ) RETURN VARCHAR2 IS
10582: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
10583: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10584: l_Return VARCHAR2(1);
10585: BEGIN
10586: l_Return := FND_API.G_FALSE;
10587:

Line 10621: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

10617: , x_Msg_Count OUT NOCOPY NUMBER
10618: , x_Msg_Data OUT NOCOPY VARCHAR
10619: ) IS
10620:
10621: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
10622: l_Measure_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;

Line 10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;

10621: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
10622: l_Measure_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
10628: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
10629: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

Line 10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

10622: l_Measure_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
10628: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
10629: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
10630:

Line 10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;

10623: l_Compare_Attr_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
10628: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
10629: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
10630:
10631:

Line 10628: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;

10624:
10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
10628: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
10629: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
10630:
10631:
10632: CURSOR cMeasureShortNames IS

Line 10629: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

10625: l_Actual_Data_Source_Type BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE%TYPE;
10626: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
10627: l_Function_Name BIS_INDICATORS.FUNCTION_NAME%TYPE;
10628: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
10629: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
10630:
10631:
10632: CURSOR cMeasureShortNames IS
10633: SELECT AK.ATTRIBUTE_CODE

Line 10647: FROM BIS_INDICATORS BIS

10643: , BIS.ACTUAL_DATA_SOURCE
10644: , BIS.FUNCTION_NAME
10645: , BIS.COMPARISON_SOURCE
10646: , BIS.ENABLE_LINK
10647: FROM BIS_INDICATORS BIS
10648: WHERE BIS.SHORT_NAME = l_Measure_Short_Name;
10649: BEGIN
10650:
10651: SAVEPOINT CascdAttrCode;

Line 10773: bis_indicators i

10769: m.measure_col, m.measure_id
10770: FROM
10771: bsc_sys_measures m,
10772: bsc_sys_datasets_vl d,
10773: bis_indicators i
10774: WHERE
10775: i.dataset_id = d.dataset_id AND
10776: d.measure_id1 = m.measure_id AND
10777: i.short_name = p_Measure_Short_Name;