[Home] [Help]
701: ,x_msg_count OUT NOCOPY NUMBER
702: ,x_msg_data OUT NOCOPY VARCHAR2
703: ) is
704:
705: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
706: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
707: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
708: l_Measure_Col_Help VARCHAR2(150);
709: l_count NUMBER;
841: if (l_Dataset_Rec.Bsc_Measure_id is null) then
842:
843: -- Insert into BSC tables
844:
845: BSC_DATASETS_PUB.Create_Measures(
846: p_commit => p_commit
847: ,p_Dataset_Rec => l_Dataset_Rec
848: ,x_Dataset_Id => x_Dataset_Id
849: ,x_return_status => x_return_status
849: ,x_return_status => x_return_status
850: ,x_msg_count => x_msg_count
851: ,x_msg_data => x_msg_data);
852: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
853: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Measures');
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: END IF;
856:
857: else
891: -- END Granular Locking
892:
893:
894: -- Now, create the dataset.
895: BSC_DATASETS_PUB.Create_Dataset(
896: p_commit => FND_API.G_FALSE
897: ,p_Dataset_Rec => l_Dataset_Rec
898: ,x_Dataset_Id => x_Dataset_Id
899: ,x_return_status => x_return_status
899: ,x_return_status => x_return_status
900: ,x_msg_count => x_msg_count
901: ,x_msg_data => x_msg_data);
902: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
903: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Dataset');
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907: -- POSCO Bug#3817894
1314: END Is_Src_Col_In_Formulas;
1315:
1316: PROCEDURE Update_Single_To_Formula(
1317: p_commit IN VARCHAR2 := FND_API.G_FALSE
1318: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1319: ,p_Dataset_Rec_db IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1320: ,x_return_status OUT NOCOPY VARCHAR2
1321: ,x_msg_count OUT NOCOPY NUMBER
1322: ,x_msg_data OUT NOCOPY VARCHAR2
1315:
1316: PROCEDURE Update_Single_To_Formula(
1317: p_commit IN VARCHAR2 := FND_API.G_FALSE
1318: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1319: ,p_Dataset_Rec_db IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1320: ,x_return_status OUT NOCOPY VARCHAR2
1321: ,x_msg_count OUT NOCOPY NUMBER
1322: ,x_msg_data OUT NOCOPY VARCHAR2
1323:
1323:
1324: ) IS
1325: l_kpi_flag number := -1;
1326: l_indicator_table BSC_NUM_LIST;
1327: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1328:
1329: CURSOR indicators_cursor is
1330: SELECT distinct indicator
1331: FROM bsc_kpi_analysis_measures_b
1401: ,x_msg_data);
1402:
1403:
1404: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1405: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Measures');
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:
1409: --Need to update Dataset Info with the new Measure Id generated
1407: END IF;
1408:
1409: --Need to update Dataset Info with the new Measure Id generated
1410:
1411: BSC_DATASETS_PUB.Update_Dataset(
1412: p_commit => p_commit
1413: ,p_Dataset_Rec => l_Dataset_Rec
1414: ,p_update_dset_calc => false
1415: ,x_return_status => x_return_status
1416: ,x_msg_count => x_msg_count
1417: ,x_msg_data => x_msg_data);
1418:
1419: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1420: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Update_Measures');
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:
1424: /*Checking for Structural changes in indicators*/
1525: ,x_msg_count OUT NOCOPY NUMBER
1526: ,x_msg_data OUT NOCOPY VARCHAR2
1527: ) is
1528:
1529: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1530: l_Dataset_Rec_db BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1531: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
1532: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1533: l_measure_col_help VARCHAR2(150);
1526: ,x_msg_data OUT NOCOPY VARCHAR2
1527: ) is
1528:
1529: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1530: l_Dataset_Rec_db BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1531: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
1532: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1533: l_measure_col_help VARCHAR2(150);
1534: l_old_measure_id NUMBER;
1537: l_measure_group_id BSC_DB_MEASURE_COLS_TL.Measure_Group_Id%TYPE;
1538: l_projection_id BSC_DB_MEASURE_COLS_TL.Projection_Id%TYPE;
1539: l_measure_type BSC_DB_MEASURE_COLS_TL.Measure_Type%TYPE;
1540:
1541: l_Del_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1542: l_Delete_Source BOOLEAN;
1543: l_Dataset_Name BSC_SYS_DATASETS_VL.Name%TYPE;
1544: l_Same_Name BOOLEAN := FALSE;
1545:
1792: a new Measure Record should be inserted in bsc_sys_measures
1793: */
1794:
1795:
1796: BSC_DATASETS_PUB.Retrieve_Measures(
1797: p_commit => p_commit
1798: ,p_Dataset_Rec => l_Dataset_Rec
1799: ,x_Dataset_Rec => l_Dataset_Rec_db
1800: ,x_return_status => x_return_status
1827:
1828: ELSE
1829:
1830: -- Update the Dataset and Measure Record
1831: --DBMS_OUTPUT.PUT_LINE('calling BSC_DATASETS_PUB.Update_Measures <'||x_msg_data||'>');
1832: BSC_DATASETS_PUB.Update_Measures(
1833: p_commit => p_commit
1834: ,p_Dataset_Rec => l_Dataset_Rec
1835: ,p_update_dset_calc => false
1828: ELSE
1829:
1830: -- Update the Dataset and Measure Record
1831: --DBMS_OUTPUT.PUT_LINE('calling BSC_DATASETS_PUB.Update_Measures <'||x_msg_data||'>');
1832: BSC_DATASETS_PUB.Update_Measures(
1833: p_commit => p_commit
1834: ,p_Dataset_Rec => l_Dataset_Rec
1835: ,p_update_dset_calc => false
1836: ,x_return_status => x_return_status
1837: ,x_msg_count => x_msg_count
1838: ,x_msg_data => x_msg_data);
1839:
1840: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1841: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Update_Measures');
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END IF;
1844: END IF;
1845:
2157: ,x_msg_count OUT NOCOPY NUMBER
2158: ,x_msg_data OUT NOCOPY VARCHAR2
2159: ) is
2160:
2161: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2162: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2164: l_count number;
2165: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
2197: END IF;
2198:
2199: -- END : Granular Locking
2200:
2201: BSC_DATASETS_PUB.Delete_Measures(
2202: p_commit => p_commit
2203: ,p_Dataset_Rec => l_Dataset_Rec
2204: ,x_return_status => x_return_status
2205: ,x_msg_count => x_msg_count
2370: ,x_msg_count OUT NOCOPY NUMBER
2371: ,x_msg_data OUT NOCOPY VARCHAR2
2372: ) is
2373:
2374: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2375: begin
2376:
2377: fnd_msg_pub.initialize;
2378:
2378:
2379: l_Dataset_Rec.Bsc_Dataset_Id:= p_dataset_id;
2380:
2381: -- Disabled Calculations
2382: BSC_DATASETS_PUB.Delete_Dataset_Calc(
2383: p_commit => p_commit
2384: ,p_Dataset_Rec => l_Dataset_Rec
2385: ,x_return_status => x_return_status
2386: ,x_msg_count => x_msg_count
2652:
2653:
2654:
2655: function getColorFormula(
2656: p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
2657: ,p_Measure_Apply_Rollup IN VARCHAR2) return varchar2
2658: is
2659: l_column_name varchar2(30);
2660: l_color_formula varchar2(4000) := NULL;
2848: --=============================================================================
2849: Procedure Load_Measure
2850: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
2851: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2852: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
2853: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2854: , p_custom_mode IN VARCHAR2 := NULL
2855: , p_application_short_name IN VARCHAR2
2856: , p_Org_Dimension_Short_Name IN VARCHAR2
2865: --l_msg VARCHAR2(3000);
2866: l_measure_group_id NUMBER;
2867: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
2868: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
2869: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2870: l_Application_rec_p BIS_Application_PVT.Application_Rec_Type;
2871: l_Application_rec BIS_Application_PVT.Application_Rec_Type;
2872: l_dataset_id NUMBER;
2873: l_measure_id1 NUMBER;
2878: l_org_dimension_id NUMBER;
2879: l_time_dimension_id NUMBER;
2880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2881: l_measure_rec_new BIS_MEASURE_PUB.Measure_Rec_Type;
2882: l_dataset_rec_db BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2883: l_dataset_rec_db1 BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2884: l_measure_rec_db BIS_MEASURE_PUB.Measure_Rec_Type;
2885: l_time_stamp VARCHAR2(200);
2886:
2879: l_time_dimension_id NUMBER;
2880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2881: l_measure_rec_new BIS_MEASURE_PUB.Measure_Rec_Type;
2882: l_dataset_rec_db BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2883: l_dataset_rec_db1 BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2884: l_measure_rec_db BIS_MEASURE_PUB.Measure_Rec_Type;
2885: l_time_stamp VARCHAR2(200);
2886:
2887: l_upload_test BOOLEAN := FALSE;
2910: ,x_error_Tbl => l_error_Tbl
2911: );
2912: IF (l_measure_rec_db.dataset_id IS NOT NULL) THEN
2913: l_dataset_rec.Bsc_Dataset_Id := l_measure_rec_db.dataset_id;
2914: BSC_DATASETS_PUB.Retrieve_Dataset(
2915: p_commit => p_commit
2916: ,p_Dataset_Rec => l_dataset_rec
2917: ,x_Dataset_Rec => l_dataset_rec_db
2918: ,x_return_status => x_return_status
3084: -- Use the db record that is retrieved before for this.
3085:
3086: l_time_stamp := BSC_BIS_LOCKS_PUB.GET_TIME_STAMP_DATASET(
3087: p_dataset_id => l_dataset_rec.bsc_dataset_id);
3088: -- Use BSC_DATASETS_PUB.Retrieve_Measures to get the measure details
3089: -- Previously l_dataset_rec has got all properties related to datasets
3090: -- Now measures properties are populated.
3091:
3092: BSC_DATASETS_PUB.Retrieve_Measures(
3088: -- Use BSC_DATASETS_PUB.Retrieve_Measures to get the measure details
3089: -- Previously l_dataset_rec has got all properties related to datasets
3090: -- Now measures properties are populated.
3091:
3092: BSC_DATASETS_PUB.Retrieve_Measures(
3093: p_commit => p_commit
3094: ,p_Dataset_Rec => l_Dataset_Rec_db
3095: ,x_Dataset_Rec => l_Dataset_Rec_db1
3096: ,x_return_status => x_return_status
3204: (p_commit IN VARCHAR2 := FND_API.G_FALSE
3205: ,p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3206: , p_custom_mode IN VARCHAR2 := NULL
3207: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3208: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
3209: , x_return_status OUT NOCOPY VARCHAR2
3210: , x_msg_count OUT NOCOPY NUMBER
3211: , x_msg_data OUT NOCOPY VARCHAR2
3212: )
3211: , x_msg_data OUT NOCOPY VARCHAR2
3212: )
3213: IS
3214:
3215: l_dataset_rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
3216: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
3217: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3218: l_Dataset_Id NUMBER;
3219: l_upload_test BOOLEAN := FALSE;
3262: l_measure_rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3263: l_measure_rec.Last_Updated_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3264: l_measure_rec.Last_Update_Login := fnd_global.LOGIN_ID;
3265:
3266: BSC_DATASETS_PUB.Translate_Measure(
3267: p_commit => FND_API.G_FALSE
3268: ,p_measure_rec => l_measure_rec
3269: ,p_Dataset_Rec => l_Dataset_Rec
3270: ,x_return_status => x_return_status