APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_SYS_DATASETS_B

Line 876: FROM BSC_SYS_DATASETS_B

872:
873: -- If the KPI has been deleted, throw a valid message
874:
875: SELECT COUNT(1) INTO l_Count
876: FROM BSC_SYS_DATASETS_B
877: WHERE DATASET_ID = l_Dataset_Id;
878: IF l_count = 0 THEN
879: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
880: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','EDW_MEASURE'));

Line 1569: FROM bsc_sys_datasets_b b

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);
1571:
1572:
1573: END IF;

Line 1643: FROM BSC_SYS_DATASETS_B B

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);
1645:
1646: x_measure_short_name := l_measure_short_name;
1647:

Line 5574: FROM BSC_SYS_DATASETS_B B

5570: FROM BSC_SYS_MEASURES A
5571: WHERE A.MEASURE_ID =
5572: (
5573: SELECT B.MEASURE_ID1
5574: FROM BSC_SYS_DATASETS_B B
5575: WHERE B.DATASET_ID = l_Dataset_Id
5576: );
5577: EXCEPTION
5578: WHEN OTHERS THEN

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 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 8885: UPDATE BSC_SYS_DATASETS_B D

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;
8888:
8889: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_DATASETS_B -- ' || BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name));

Line 8889: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_DATASETS_B -- ' || BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name));

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;
8888:
8889: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_DATASETS_B -- ' || BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Measure_Short_Name));
8890:
8891: EXCEPTION
8892: WHEN OTHERS THEN
8893: --DBMS_OUTPUT.PUT_LINE('Error - ' || SQLERRM);