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 BSC_SYS_MEASURES

Line 199: REM | bsc_sys_measures |

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 +=======================================================================+
203: */

Line 596: bsc_sys_measures m,

592: m.measure_id
593: INTO
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

Line 1566: FROM bsc_sys_measures a

1562:
1563: IF (p_measure_short_name IS NULL) THEN
1564: SELECT a.short_name
1565: INTO l_measure_short_name
1566: FROM bsc_sys_measures a
1567: WHERE a.measure_id =
1568: (SELECT b.measure_id1
1569: FROM bsc_sys_datasets_b b
1570: WHERE b.dataset_id = x_dataset_id);

Line 1640: FROM BSC_SYS_MEASURES A

1636: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1637:
1638: SELECT A.SHORT_NAME
1639: INTO l_Measure_Short_Name
1640: FROM BSC_SYS_MEASURES A
1641: WHERE A.MEASURE_ID =
1642: (SELECT B.MEASURE_ID1
1643: FROM BSC_SYS_DATASETS_B B
1644: WHERE B.DATASET_ID = p_Dataset_Id);

Line 4891: l_Dataset_Source BSC_SYS_MEASURES.SOURCE%TYPE;

4887: x_Time_Dim_Obj_Short_Names VARCHAR2(2056);
4888: x_All_Dim_Group_Ids BSC_NUMBER_TBL_TYPE;
4889: x_Non_Time_Counter NUMBER;
4890: x_Time_Counter NUMBER;
4891: l_Dataset_Source BSC_SYS_MEASURES.SOURCE%TYPE;
4892: l_Dataset_Id NUMBER;
4893: l_Does_Dim_Group_Exist BOOLEAN;
4894: l_Does_Kpi_Exist BOOLEAN;
4895: l_Indicator NUMBER;

Line 4915: l_Measure_Short_Name BSC_SYS_MEASURES.SHORT_NAME%TYPE;

4911: l_Count NUMBER;
4912: l_Function_Name FND_FORM_FUNCTIONS_VL.USER_FUNCTION_NAME%TYPE;
4913: l_Measure_Group_Id NUMBER;
4914:
4915: l_Measure_Short_Name BSC_SYS_MEASURES.SHORT_NAME%TYPE;
4916:
4917: --added for bug#4057761
4918: l_tab_name BSC_TABS_TL.NAME%TYPE;
4919: l_group_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;

Line 4929: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;

4925: x_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4926: l_Dimension_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%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;

Line 4961: bsc_sys_measures m,

4957: M.SOURCE
4958: INTO
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

Line 5311: bsc_sys_measures m,

5307: m.measure_id
5308: INTO
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

Line 5570: FROM BSC_SYS_MEASURES A

5566:
5567: BEGIN
5568: SELECT A.SHORT_NAME
5569: INTO x_Measure_Short_Name
5570: FROM BSC_SYS_MEASURES A
5571: WHERE A.MEASURE_ID =
5572: (
5573: SELECT B.MEASURE_ID1
5574: FROM BSC_SYS_DATASETS_B B

Line 6490: bsc_sys_measures m,

6486: COUNT(1)
6487: INTO
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

Line 8364: bsc_sys_measures m,

8360: COUNT(1)
8361: INTO
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

Line 8410: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;

8406: l_Measure_Id NUMBER;
8407: l_Measure_Group_Id NUMBER;
8408: l_Count NUMBER;
8409: l_Measure_List BSC_VARCHAR2_TBL_TYPE;
8410: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
8411: l_Delete_Measure VARCHAR2(1);
8412: l_Delete_Dimensions VARCHAR2(1);
8413:
8414: l_report_region_rec BIS_AK_REGION_PUB.Bis_Region_Rec_Type;

Line 8463: + Update BSC_SYS_DATASETS_B.SOURCE and BSC_SYS_MEASURES.SOURCE to "PMF"

8459:
8460: /*
8461:
8462: o PHASE 2 - Delete/Convert Measure to PMF type
8463: + Update BSC_SYS_DATASETS_B.SOURCE and BSC_SYS_MEASURES.SOURCE to "PMF"
8464: For each l_Measure_List, update BSC_SYS_MEASURES.SOURCE and BSC_SYS_DATASETS_B.SOURCE
8465: to PMF.
8466: + Delete entries in BSC_DB_MEASURE_COLS_TL and BSC_DB_MEASURE_GROUPS_TL
8467: for the Measure Column (Identified by BSC_SYS_MEASURES.MEASURE_COL)

Line 8464: For each l_Measure_List, update BSC_SYS_MEASURES.SOURCE and BSC_SYS_DATASETS_B.SOURCE

8460: /*
8461:
8462: o PHASE 2 - Delete/Convert Measure to PMF type
8463: + Update BSC_SYS_DATASETS_B.SOURCE and BSC_SYS_MEASURES.SOURCE to "PMF"
8464: For each l_Measure_List, update BSC_SYS_MEASURES.SOURCE and BSC_SYS_DATASETS_B.SOURCE
8465: to PMF.
8466: + Delete entries in BSC_DB_MEASURE_COLS_TL and BSC_DB_MEASURE_GROUPS_TL
8467: for the Measure Column (Identified by BSC_SYS_MEASURES.MEASURE_COL)
8468: For each l_Measure_List, with its BSC_SYS_DATASETS_B.MEASURE_ID1 maps to BSC_SYS_MEASURES.MEASURE_ID.

Line 8467: for the Measure Column (Identified by BSC_SYS_MEASURES.MEASURE_COL)

8463: + Update BSC_SYS_DATASETS_B.SOURCE and BSC_SYS_MEASURES.SOURCE to "PMF"
8464: For each l_Measure_List, update BSC_SYS_MEASURES.SOURCE and BSC_SYS_DATASETS_B.SOURCE
8465: to PMF.
8466: + Delete entries in BSC_DB_MEASURE_COLS_TL and BSC_DB_MEASURE_GROUPS_TL
8467: for the Measure Column (Identified by BSC_SYS_MEASURES.MEASURE_COL)
8468: For each l_Measure_List, with its BSC_SYS_DATASETS_B.MEASURE_ID1 maps to BSC_SYS_MEASURES.MEASURE_ID.
8469: We need to call the following APIs ..
8470:
8471: Measure_Group_Id can be found out by querying BSC_DB_MEASURE_GROUPS_TL.SHORT_NAME

Line 8468: For each l_Measure_List, with its BSC_SYS_DATASETS_B.MEASURE_ID1 maps to BSC_SYS_MEASURES.MEASURE_ID.

8464: For each l_Measure_List, update BSC_SYS_MEASURES.SOURCE and BSC_SYS_DATASETS_B.SOURCE
8465: to PMF.
8466: + Delete entries in BSC_DB_MEASURE_COLS_TL and BSC_DB_MEASURE_GROUPS_TL
8467: for the Measure Column (Identified by BSC_SYS_MEASURES.MEASURE_COL)
8468: For each l_Measure_List, with its BSC_SYS_DATASETS_B.MEASURE_ID1 maps to BSC_SYS_MEASURES.MEASURE_ID.
8469: We need to call the following APIs ..
8470:
8471: Measure_Group_Id can be found out by querying BSC_DB_MEASURE_GROUPS_TL.SHORT_NAME
8472: with the passed REGION_CODE

Line 8610: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;

8606: l_Measure_Id NUMBER;
8607: l_Measure_Group_Id NUMBER;
8608: l_Count NUMBER;
8609: l_Measure_List BSC_VARCHAR2_TBL_TYPE;
8610: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
8611: l_Dataset_Id NUMBER;
8612: iCount NUMBER;
8613: l_Delete_Dimension VARCHAR2(1);
8614:

Line 8861: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;

8857: , x_Msg_Count OUT NOCOPY NUMBER
8858: , x_Msg_Data OUT NOCOPY VARCHAR
8859: ) IS
8860:
8861: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;
8862: l_Measure_Column BSC_SYS_MEASURES.MEASURE_COL%TYPE;
8863: l_Dataset_Id NUMBER;
8864:
8865: BEGIN

Line 8862: l_Measure_Column BSC_SYS_MEASURES.MEASURE_COL%TYPE;

8858: , x_Msg_Data OUT NOCOPY VARCHAR
8859: ) IS
8860:
8861: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;
8862: l_Measure_Column BSC_SYS_MEASURES.MEASURE_COL%TYPE;
8863: l_Dataset_Id NUMBER;
8864:
8865: BEGIN
8866: SAVEPOINT SwitchMeasureType;

Line 8878: UPDATE BSC_SYS_MEASURES M

8874:
8875: IF (p_Target_Source = BSC_BIS_MEASURE_PUB.c_PMF) THEN
8876: -- begin the UPDATE process
8877: BEGIN
8878: UPDATE BSC_SYS_MEASURES M
8879: SET M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF
8880: WHERE M.SHORT_NAME = p_Measure_Short_Name;
8881:
8882: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);

Line 8883: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_MEASURES - ' || l_Dataset_Id);

8879: SET M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF
8880: WHERE M.SHORT_NAME = p_Measure_Short_Name;
8881:
8882: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name);
8883: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_MEASURES - ' || l_Dataset_Id);
8884:
8885: UPDATE BSC_SYS_DATASETS_B D
8886: SET D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF
8887: WHERE D.DATASET_ID = l_Dataset_Id;

Line 8960: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;

8956: FUNCTION Get_Measure_Source (
8957: p_Measure_Short_Name IN VARCHAR2
8958: ) RETURN VARCHAR2
8959: IS
8960: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;
8961: BEGIN
8962: l_Measure_Source := BSC_BIS_MEASURE_PUB.c_BSC;
8963:
8964: SELECT

Line 8969: bsc_sys_measures m,

8965: m.source
8966: INTO
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

Line 8990: l_meas_source BSC_SYS_MEASURES.SOURCE%TYPE;

8986: p_Measures_Short_Name IN VARCHAR2 ,
8987: p_Actual_Data_Source IN VARCHAR2
8988: ) RETURN VARCHAR2
8989: IS
8990: l_meas_source BSC_SYS_MEASURES.SOURCE%TYPE;
8991: l_count NUMBER := 0;
8992: l_region_code AK_REGIONS.REGION_CODE%TYPE;
8993: BEGIN
8994:

Line 10771: bsc_sys_measures m,

10767: CURSOR c_GetFormula IS
10768: SELECT
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

Line 10779: l_Formula BSC_SYS_MEASURES.MEASURE_COL%TYPE;

10775: i.dataset_id = d.dataset_id AND
10776: d.measure_id1 = m.measure_id AND
10777: i.short_name = p_Measure_Short_Name;
10778:
10779: l_Formula BSC_SYS_MEASURES.MEASURE_COL%TYPE;
10780: l_Measure_Id BSC_SYS_MEASURES.MEASURE_ID%TYPE;
10781: l_char VARCHAR2(1);
10782: l_Formula_Temp VARCHAR2(2000);
10783: l_Comma_Old_Attribute_Codes VARCHAR2(2000);

Line 10780: l_Measure_Id BSC_SYS_MEASURES.MEASURE_ID%TYPE;

10776: d.measure_id1 = m.measure_id AND
10777: i.short_name = p_Measure_Short_Name;
10778:
10779: l_Formula BSC_SYS_MEASURES.MEASURE_COL%TYPE;
10780: l_Measure_Id BSC_SYS_MEASURES.MEASURE_ID%TYPE;
10781: l_char VARCHAR2(1);
10782: l_Formula_Temp VARCHAR2(2000);
10783: l_Comma_Old_Attribute_Codes VARCHAR2(2000);
10784: l_Comma_New_Attribute_Codes VARCHAR2(2000);

Line 10851: -- the private method - which exclusively updates BSC_SYS_MEASURES

10847: --DBMS_OUTPUT.PUT_LINE (' l_Formula_Temp - ' || l_Formula_Temp);
10848:
10849:
10850: -- after fixing the the Measure formula, update the measure using
10851: -- the private method - which exclusively updates BSC_SYS_MEASURES
10852:
10853: l_Dataset_Rec.Bsc_Measure_Id := l_Measure_Id;
10854: l_Dataset_Rec.Bsc_Measure_Col := l_Formula_Temp;
10855: