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_BIS_MEASURE_PUB

Line 248: ,p_Measure_Operation IN VARCHAR2 := BSC_BIS_MEASURE_PUB.c_SUM

244: ,p_Measure_Name IN VARCHAR2
245: ,p_Measure_Short_Name IN VARCHAR2 := NULL
246: ,p_Measure_Description IN VARCHAR2 := NULL
247: ,p_Measure_Type IN NUMBER := NULL
248: ,p_Measure_Operation IN VARCHAR2 := BSC_BIS_MEASURE_PUB.c_SUM
249: ,p_Dataset_Format_Id IN NUMBER := NULL
250: ,p_Dataset_Autoscale_Flag IN NUMBER := NULL
251: ,p_Measure_Increase_In_Measure IN VARCHAR2 := NULL
252: ,p_Measure_Random_Style IN NUMBER := NULL

Line 472: ,p_Measure_Operation IN VARCHAR2 := BSC_BIS_MEASURE_PUB.c_SUM

468: ,p_Measure_Name IN VARCHAR2
469: ,p_Measure_Short_Name IN VARCHAR2 := NULL
470: ,p_Measure_Description IN VARCHAR2 := NULL
471: ,p_Measure_Type IN NUMBER := NULL
472: ,p_Measure_Operation IN VARCHAR2 := BSC_BIS_MEASURE_PUB.c_SUM
473: ,p_Dataset_Format_Id IN NUMBER := NULL
474: ,p_Dataset_Autoscale_Flag IN NUMBER := NULL
475: ,p_Measure_Increase_In_Measure IN VARCHAR2 := NULL
476: ,p_Measure_Random_Style IN NUMBER := NULL

Line 588: --DBMS_OUTPUT.PUT_LINE('Outside BSC_BIS_MEASURE_PUB.Update_Measure' );

584:
585:
586: -- Upade the Measure Prototype Data.
587:
588: --DBMS_OUTPUT.PUT_LINE('Outside BSC_BIS_MEASURE_PUB.Update_Measure' );
589:
590: -- Push the query to a function (mod)
591: SELECT
592: m.measure_id

Line 605: BSC_BIS_MEASURE_PUB.Update_Measure(

601: d.measure_id1 = m.measure_id AND
602: i.short_name = p_measure_short_name;
603:
604: -- Passed AK type and AK source (pl/sql), since they were getting updated to null
605: BSC_BIS_MEASURE_PUB.Update_Measure(
606: p_Commit => p_commit
607: ,p_Dataset_Id => l_dataset_id
608: ,p_Dataset_Source => BSC_BIS_MEASURE_PUB.c_BSC
609: ,p_Dataset_Name => p_measure_name

Line 608: ,p_Dataset_Source => BSC_BIS_MEASURE_PUB.c_BSC

604: -- Passed AK type and AK source (pl/sql), since they were getting updated to null
605: BSC_BIS_MEASURE_PUB.Update_Measure(
606: p_Commit => p_commit
607: ,p_Dataset_Id => l_dataset_id
608: ,p_Dataset_Source => BSC_BIS_MEASURE_PUB.c_BSC
609: ,p_Dataset_Name => p_measure_name
610: ,p_Dataset_Help => p_measure_description
611: ,p_Dataset_Measure_Id1 => l_Bsc_Measure_Id
612: ,p_Dataset_Operation => NULL

Line 964: BSC_BIS_MEASURE_PUB.Delete_Measure(

960:
961:
962: -- Delete the Measure from the DB (BSC and BIS).
963:
964: BSC_BIS_MEASURE_PUB.Delete_Measure(
965: p_Commit => p_commit
966: ,p_Dataset_Id => l_Dataset_Id
967: ,x_return_status => x_return_status
968: ,x_msg_count => x_msg_count

Line 1037: --DBMS_OUTPUT.PUT_LINE('Outside BSC_BIS_MEASURE_PUB.Delete_Measure ' );

1033: END IF;
1034: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );
1035:
1036: -- Delete the Actual Measure from BSC and BIS Datamodel.
1037: --DBMS_OUTPUT.PUT_LINE('Outside BSC_BIS_MEASURE_PUB.Delete_Measure ' );
1038: BSC_BIS_MEASURE_PUB.Delete_Measure(
1039: p_Commit => p_Commit
1040: ,p_Dataset_Id => l_Dataset_Id
1041: ,x_return_status => x_return_status

Line 1038: BSC_BIS_MEASURE_PUB.Delete_Measure(

1034: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );
1035:
1036: -- Delete the Actual Measure from BSC and BIS Datamodel.
1037: --DBMS_OUTPUT.PUT_LINE('Outside BSC_BIS_MEASURE_PUB.Delete_Measure ' );
1038: BSC_BIS_MEASURE_PUB.Delete_Measure(
1039: p_Commit => p_Commit
1040: ,p_Dataset_Id => l_Dataset_Id
1041: ,x_return_status => x_return_status
1042: ,x_msg_count => x_msg_count

Line 1506: BSC_BIS_MEASURE_PUB.Create_Measure(

1502:
1503: --DBMS_OUTPUT.PUT_LINE('STAGE 8B1');
1504:
1505: -- added exception handling for Bug#3755656
1506: BSC_BIS_MEASURE_PUB.Create_Measure(
1507: p_commit => p_commit
1508: ,x_dataset_id => x_dataset_id
1509: ,p_dataset_source => p_dataset_source --'BSC' data source
1510: ,p_dataset_name => p_measure_name

Line 2619: , p_data_source => BSC_BIS_MEASURE_PUB.c_BSC

2615: IF (l_counter = 1) THEN
2616: BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Multi_Groups_Opts
2617: ( p_commit => p_Commit
2618: , p_kpi_id => p_Kpi_Id
2619: , p_data_source => BSC_BIS_MEASURE_PUB.c_BSC
2620: , p_Option_0 => l_Option0
2621: , p_Option_1 => l_Option1
2622: , p_Option_2 => l_Option2
2623: , p_Sid => l_Series_Id

Line 4973: /*IF (NVL(l_Measure_Source, 'PMF') <> BSC_BIS_MEASURE_PUB.c_BSC) THEN

4969:
4970: --DBMS_OUTPUT.PUT_LINE('STAGE 1A - l_Measure_Source - ' || l_Measure_Source);
4971: --DBMS_OUTPUT.PUT_LINE('STAGE 1A - p_Measure_Short_Name - ' || p_Measure_Short_Name);
4972:
4973: /*IF (NVL(l_Measure_Source, 'PMF') <> BSC_BIS_MEASURE_PUB.c_BSC) THEN
4974: ROLLBACK TO CreateBscBisMetadata;
4975: RETURN;
4976: END IF;*/
4977:

Line 5014: l_Dataset_Source := BSC_BIS_MEASURE_PUB.c_BSC;

5010: x_Non_Time_Dim_Obj_Short_Names := NULL;
5011: x_Time_Dim_Obj_Short_Names := NULL;
5012: l_Dataset_Source := NULL;
5013: l_Sequence := 10;
5014: l_Dataset_Source := BSC_BIS_MEASURE_PUB.c_BSC;
5015: l_Measure_Short_Name := NULL;
5016: x_All_Dim_Group_Ids(1) := NULL;
5017: x_All_Dim_Group_Ids(2) := NULL;
5018: x_All_Dim_Group_Ids(3) := NULL;

Line 5319: --DBMS_OUTPUT.PUT_LINE('STAGE 7D - ' || BSC_BIS_MEASURE_PUB.c_BSC);

5315: i.dataset_id = d.dataset_id AND
5316: d.measure_id1 = m.measure_id AND
5317: i.short_name = p_measure_short_name;
5318: --DBMS_OUTPUT.PUT_LINE('STAGE 7C - ' || l_Dataset_Id);
5319: --DBMS_OUTPUT.PUT_LINE('STAGE 7D - ' || BSC_BIS_MEASURE_PUB.c_BSC);
5320: --DBMS_OUTPUT.PUT_LINE('STAGE 7E - ' || l_Bsc_Measure_Id);
5321: --DBMS_OUTPUT.PUT_LINE('STAGE 7F - ' || p_Region_Function_Name || '.' || p_Measure_Short_Name);
5322:
5323: l_Actual_Data_Source := BSC_BIS_KPI_CRUD_PUB.Get_Actual_Source_Data(p_Measure_Short_Name);

Line 5356: BSC_BIS_MEASURE_PUB.Update_Measure(

5352:
5353:
5354: IF (BSC_UTILITY.Is_Measure_Seeded(p_Measure_Short_Name) = FND_API.G_FALSE AND BSC_UTILITY.is_Calculated_kpi(p_Measure_Short_Name)= FND_API.G_FALSE) THEN
5355:
5356: BSC_BIS_MEASURE_PUB.Update_Measure(
5357: p_Commit => p_Commit
5358: ,p_Dataset_Id => l_Dataset_Id
5359: ,p_Dataset_Source => l_Measure_Source
5360: ,p_Dataset_Name => p_Measure_Name

Line 5419: IF((l_Returned_Kpi_Id =BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND l_Measure_Source =BSC_BIS_MEASURE_PUB.c_BSC) OR l_Count1 = 0) THEN

5415: FROM BSC_KPI_ANALYSIS_MEASURES_B B
5416: WHERE B.DATASET_ID = l_Dataset_Id
5417: AND B.INDICATOR = l_Kpi_id;
5418:
5419: IF((l_Returned_Kpi_Id =BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND l_Measure_Source =BSC_BIS_MEASURE_PUB.c_BSC) OR l_Count1 = 0) THEN
5420: l_Anal_Opt_Rec.Bsc_Kpi_Id := l_Kpi_Id;
5421: l_Anal_Opt_Rec.Bsc_Dataset_Id := l_Dataset_Id;
5422: l_Anal_Opt_Rec.Bsc_Dataset_Default_Value := 1;
5423: l_Anal_Opt_Rec.Bsc_Measure_Long_Name := p_Measure_Name;

Line 6042: BSC_BIS_MEASURE_PUB.Apply_Dataset_Calc(

6038: , BSC_BIS_KPI_CRUD_PUB.C_CALC_DV
6039: );
6040:
6041: -- Apply the disabled Calculations.
6042: BSC_BIS_MEASURE_PUB.Apply_Dataset_Calc(
6043: p_commit => p_Commit
6044: ,p_dataset_id => p_Dataset_Id
6045: ,p_disabled_calc_table => l_Disable_Calc_List
6046: ,x_return_status => x_Return_Status

Line 6497: m.source = BSC_BIS_MEASURE_PUB.c_BSC;

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
6497: m.source = BSC_BIS_MEASURE_PUB.c_BSC;
6498:
6499: -- Measure Does not exist or not a BSC Measure
6500: IF l_Count = 0 THEN
6501: RETURN NULL;

Line 8371: m.source = BSC_BIS_MEASURE_PUB.c_BSC;

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
8371: m.source = BSC_BIS_MEASURE_PUB.c_BSC;
8372:
8373: -- Measure Does not exist or not a BSC Measure
8374: IF l_Count = 0 THEN
8375: RETURN BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY;

Line 8489: , p_Target_Source => BSC_BIS_MEASURE_PUB.c_PMF

8485: --DBMS_OUTPUT.PUT_LINE('loop ... BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type ... ' || l_Measure_List(iCount));
8486: BSC_BIS_KPI_CRUD_PUB.Switch_Measure_Type (
8487: p_Commit => p_Commit
8488: , p_Measure_Short_Name => l_Measure_List(iCount)
8489: , p_Target_Source => BSC_BIS_MEASURE_PUB.c_PMF
8490: , p_Delete_Columns => FND_API.G_FALSE
8491: , p_Clean_Measure_Date_Source => FND_API.G_TRUE
8492: , x_Return_Status => x_Return_Status
8493: , x_Msg_Count => x_Msg_Count

Line 8788: BSC_BIS_MEASURE_PUB.Delete_Measure(

8784: --DBMS_OUTPUT.PUT_LINE(' l_Measure_List(iCount) - ' || l_Measure_List(iCount));
8785:
8786:
8787:
8788: BSC_BIS_MEASURE_PUB.Delete_Measure(
8789: p_Commit => p_commit
8790: ,p_Dataset_Id => l_Dataset_Id
8791: ,x_return_status => x_return_status
8792: ,x_msg_count => x_msg_count

Line 8870: IF((p_Target_Source = BSC_BIS_MEASURE_PUB.c_BSC) OR (p_Target_Source = l_Measure_Source)) THEN

8866: SAVEPOINT SwitchMeasureType;
8867: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
8868: l_Measure_Source := Get_Measure_Source(p_Measure_Short_Name);
8869:
8870: IF((p_Target_Source = BSC_BIS_MEASURE_PUB.c_BSC) OR (p_Target_Source = l_Measure_Source)) THEN
8871: --- Conversion from PMF to BSC is currently not supported,
8872: RETURN;
8873: END IF;
8874:

Line 8875: IF (p_Target_Source = BSC_BIS_MEASURE_PUB.c_PMF) THEN

8871: --- Conversion from PMF to BSC is currently not supported,
8872: RETURN;
8873: END IF;
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

Line 8879: SET M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF

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);
8883: --DBMS_OUTPUT.PUT_LINE('Suceess - Update - BSC_SYS_MEASURES - ' || l_Dataset_Id);

Line 8886: SET D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF

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));
8890:

Line 8962: l_Measure_Source := BSC_BIS_MEASURE_PUB.c_BSC;

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

Line 8981: RETURN BSC_BIS_MEASURE_PUB.c_BSC;

8977: RETURN l_Measure_Source;
8978:
8979: EXCEPTION
8980: WHEN OTHERS THEN
8981: RETURN BSC_BIS_MEASURE_PUB.c_BSC;
8982: END Get_Measure_Source;
8983:
8984:
8985: FUNCTION Is_Measure_Data_Source_Valid(

Line 9006: (l_meas_source = BSC_BIS_MEASURE_PUB.c_PMF OR l_meas_source = BSC_BIS_MEASURE_PUB.c_BSC)) THEN

9002: -- When AG Report is deleted the actual_data_source of measures having this report as primary
9003: -- data source was not getting updated .This condition will check for such measures.
9004: l_meas_source := Get_Measure_Source(p_Measures_Short_Name);
9005: IF (l_count = 0 AND (BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measures_Short_Name) = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) AND
9006: (l_meas_source = BSC_BIS_MEASURE_PUB.c_PMF OR l_meas_source = BSC_BIS_MEASURE_PUB.c_BSC)) THEN
9007: RETURN FND_API.G_FALSE;
9008: END IF;
9009:
9010: RETURN FND_API.G_TRUE;

Line 9074: Get_Measure_Source(p_Measures_Short_Name) = BSC_BIS_MEASURE_PUB.c_BSC) THEN

9070:
9071: -- For BSC Type of measure an invalid function name should be overwritten.
9072: --This happens only if the report with this function name is deleted
9073: IF (l_Count = 0 AND (BSC_BIS_KPI_CRUD_PUB.Get_Objective_By_AGKpi(p_Measures_Short_Name) = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) AND
9074: Get_Measure_Source(p_Measures_Short_Name) = BSC_BIS_MEASURE_PUB.c_BSC) THEN
9075: RETURN NULL;
9076: ELSE
9077: RETURN l_Measure_Function_Name;
9078: END IF;

Line 10336: AND Get_Measure_Source(p_Measures_Short_Name) <> BSC_BIS_MEASURE_PUB.c_PMF) THEN

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)
10336: AND Get_Measure_Source(p_Measures_Short_Name) <> BSC_BIS_MEASURE_PUB.c_PMF) THEN
10337: RETURN NULL;
10338: ELSE
10339: RETURN l_Comparison_Source;
10340: END IF;

Line 10693: IF (Get_Measure_Source(l_Measure_Short_Name) = BSC_BIS_MEASURE_PUB.c_CDS) THEN

10689: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10691: END IF;
10692:
10693: IF (Get_Measure_Source(l_Measure_Short_Name) = BSC_BIS_MEASURE_PUB.c_CDS) THEN
10694: IF ((p_Old_Attribute_Codes IS NOT NULL) AND (p_New_Attribute_Codes IS NOT NULL)) THEN
10695: BSC_BIS_KPI_CRUD_PUB.Cascade_Changes_Into_Forumla (
10696: p_Commit => p_Commit
10697: , p_Measure_Short_Name => l_Measure_Short_Name