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_MEAS_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 4109: FROM BSC_KPI_ANALYSIS_MEASURES_B

4105: l_config_type NUMBER;
4106: l_def_calc_id bsc_kpi_measure_props.default_calculation%TYPE;
4107: CURSOR c_old_data_set_id IS
4108: SELECT dataset_id
4109: FROM BSC_KPI_ANALYSIS_MEASURES_B
4110: WHERE indicator = p_kpi_id
4111: AND analysis_option0 = NVL(p_analysis_option_id0, 0)
4112: AND analysis_option1 = NVL(p_analysis_option_id1, 0)
4113: AND analysis_option2 = NVL(p_analysis_option_id2, 0)

Line 4135: BSC_KPI_ANALYSIS_MEASURES_B K

4131:
4132: CURSOR C_OPTIONZERO_SOURCE IS
4133: SELECT D.SOURCE,D.DATASET_ID
4134: FROM BSC_SYS_DATASETS_B D,
4135: BSC_KPI_ANALYSIS_MEASURES_B K
4136: WHERE D.DATASET_ID = K.DATASET_ID
4137: AND k.indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4138: AND analysis_option0 = 0
4139: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1

Line 4147: bsc_kpi_analysis_measures_b

4143: CURSOR c_stack_series_id IS
4144: SELECT
4145: stack_series_id
4146: FROM
4147: bsc_kpi_analysis_measures_b
4148: WHERE
4149: indicator = p_kpi_id AND
4150: analysis_option0 = p_analysis_option_id0 AND
4151: analysis_option1 = p_analysis_option_id1 AND

Line 4160: bsc_kpi_analysis_measures_b km

4156: SELECT
4157: default_calculation
4158: FROM
4159: bsc_kpi_measure_props kp,
4160: bsc_kpi_analysis_measures_b km
4161: WHERE
4162: km.indicator = p_kpi_id AND
4163: km.indicator = kp.indicator AND
4164: km.kpi_measure_id = kp.kpi_measure_id AND

Line 4175: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL

4171: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options procedure');
4172: FND_MSG_PUB.Initialize;
4173: x_return_status := FND_API.G_RET_STS_SUCCESS;
4174: SAVEPOINT UpdateBSCKPIAnaOpts;
4175: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
4176: l_dim_set_id := p_dim_set_id;
4177: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := p_option0_Name;
4178: l_Bsc_Anal_Opt_Rec.Bsc_Option_Help := p_measure_help;
4179: l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2 := p_analysis_option_id2;

Line 4622: FROM BSC_KPI_ANALYSIS_MEASURES_B

4618: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
4619: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4620:
4621: SELECT COUNT(1) INTO l_index
4622: FROM BSC_KPI_ANALYSIS_MEASURES_B
4623: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4624: AND analysis_option0 = 0
4625: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
4626: AND analysis_option2 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2

Line 4856: --logic for setting BSC_KPI_ANALYSIS_MEASURES_B.Default_Value for multi series indicators

4852: END IF;
4853: END IF;
4854: END IF;
4855: IF ((p_default_value IS NOT NULL) AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Series_Id IS NOT NULL)) THEN
4856: --logic for setting BSC_KPI_ANALYSIS_MEASURES_B.Default_Value for multi series indicators
4857: SELECT COUNT(*) INTO l_count FROM BSC_KPI_ANALYSIS_MEASURES_B
4858: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4859: AND analysis_option0 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
4860: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1

Line 4857: SELECT COUNT(*) INTO l_count FROM BSC_KPI_ANALYSIS_MEASURES_B

4853: END IF;
4854: END IF;
4855: IF ((p_default_value IS NOT NULL) AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Series_Id IS NOT NULL)) THEN
4856: --logic for setting BSC_KPI_ANALYSIS_MEASURES_B.Default_Value for multi series indicators
4857: SELECT COUNT(*) INTO l_count FROM BSC_KPI_ANALYSIS_MEASURES_B
4858: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4859: AND analysis_option0 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
4860: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
4861: AND analysis_option2 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2;

Line 4863: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

4859: AND analysis_option0 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
4860: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
4861: AND analysis_option2 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2;
4862: IF (l_count > 1 ) THEN -- this condition ensure that it have many series.
4863: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
4864: SET default_value = 1
4865: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4866: AND analysis_option0 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
4867: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1

Line 4871: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

4867: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
4868: AND analysis_option2 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2
4869: AND series_id = p_default_value;
4870:
4871: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
4872: SET default_value = 0
4873: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4874: AND analysis_option0 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
4875: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1

Line 5038: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL

5034: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
5035: FND_MSG_PUB.ADD;
5036: RAISE FND_API.G_EXC_ERROR;
5037: END IF;
5038: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5039: l_measure_short_name := p_measure_short_name;
5040: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := p_measure_name;
5041: l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2 := 0;
5042: l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1 := 0;

Line 5164: FROM BSC_KPI_ANALYSIS_MEASURES_B

5160: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5161:
5162: SELECT COUNT(*)
5163: INTO l_index
5164: FROM BSC_KPI_ANALYSIS_MEASURES_B
5165: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5166: AND analysis_option0 = 0
5167: AND analysis_option1 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
5168: AND analysis_option2 = l_Bsc_Anal_Opt_Rec.Bsc_Option_Group2

Line 5366: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL

5362: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
5363: FND_MSG_PUB.ADD;
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5367: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := p_kpi_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.indicator
5368: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_option_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.option_id
5369: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id := 0; -- BSC_KPI_ANALYSIS_OPTIONS_TL.analysis_group_id
5370:

Line 5459: FROM BSC_KPI_ANALYSIS_MEASURES_B

5455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5456: END IF;
5457: --Determine number of distinct dataset_id before delete.
5458: SELECT COUNT (DISTINCT dataset_id) INTO l_count
5459: FROM BSC_KPI_ANALYSIS_MEASURES_B
5460: WHERE INDICATOR = p_kpi_id;
5461:
5462: -- END Granular Locking - Lock the KPI Under consideration
5463: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options

Line 5476: FROM BSC_KPI_ANALYSIS_MEASURES_B

5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5473: END IF;
5474: --Determine number of distinct dataset_id after delete.
5475: SELECT COUNT (DISTINCT dataset_id) INTO l_new_count
5476: FROM BSC_KPI_ANALYSIS_MEASURES_B
5477: WHERE INDICATOR=p_kpi_id;
5478: IF (l_count <> l_new_count) THEN
5479: -- fixed bug#3136769
5480: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

Line 5758: , p_Anal_opt0 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option0%TYPE

5754: , p_responsibility_id IN NUMBER := NULL
5755: , p_default_value IN NUMBER
5756: , p_BM_Property_Value IN NUMBER := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph -- 0 For Lines and 1 for Bars
5757: , p_time_stamp IN VARCHAR2 := NULL
5758: , p_Anal_opt0 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option0%TYPE
5759: , p_Anal_opt1 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option1%TYPE
5760: , p_Anal_opt2 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option2%TYPE
5761: , p_Anal_Series IN BSC_KPI_ANALYSIS_MEASURES_B.series_id%TYPE
5762: , x_return_status OUT NOCOPY VARCHAR2

Line 5759: , p_Anal_opt1 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option1%TYPE

5755: , p_default_value IN NUMBER
5756: , p_BM_Property_Value IN NUMBER := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph -- 0 For Lines and 1 for Bars
5757: , p_time_stamp IN VARCHAR2 := NULL
5758: , p_Anal_opt0 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option0%TYPE
5759: , p_Anal_opt1 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option1%TYPE
5760: , p_Anal_opt2 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option2%TYPE
5761: , p_Anal_Series IN BSC_KPI_ANALYSIS_MEASURES_B.series_id%TYPE
5762: , x_return_status OUT NOCOPY VARCHAR2
5763: , x_msg_count OUT NOCOPY NUMBER

Line 5760: , p_Anal_opt2 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option2%TYPE

5756: , p_BM_Property_Value IN NUMBER := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph -- 0 For Lines and 1 for Bars
5757: , p_time_stamp IN VARCHAR2 := NULL
5758: , p_Anal_opt0 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option0%TYPE
5759: , p_Anal_opt1 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option1%TYPE
5760: , p_Anal_opt2 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option2%TYPE
5761: , p_Anal_Series IN BSC_KPI_ANALYSIS_MEASURES_B.series_id%TYPE
5762: , x_return_status OUT NOCOPY VARCHAR2
5763: , x_msg_count OUT NOCOPY NUMBER
5764: , x_msg_data OUT NOCOPY VARCHAR2

Line 5761: , p_Anal_Series IN BSC_KPI_ANALYSIS_MEASURES_B.series_id%TYPE

5757: , p_time_stamp IN VARCHAR2 := NULL
5758: , p_Anal_opt0 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option0%TYPE
5759: , p_Anal_opt1 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option1%TYPE
5760: , p_Anal_opt2 IN BSC_KPI_ANALYSIS_MEASURES_B.analysis_option2%TYPE
5761: , p_Anal_Series IN BSC_KPI_ANALYSIS_MEASURES_B.series_id%TYPE
5762: , x_return_status OUT NOCOPY VARCHAR2
5763: , x_msg_count OUT NOCOPY NUMBER
5764: , x_msg_data OUT NOCOPY VARCHAR2
5765: ) IS

Line 7403: FROM BSC_KPI_ANALYSIS_MEASURES_B

7399:
7400: IF (l_sname IS NOT NULL) THEN
7401:
7402: SELECT COUNT (DISTINCT dataset_id) INTO l_count
7403: FROM BSC_KPI_ANALYSIS_MEASURES_B
7404: WHERE INDICATOR = p_kpi_id;
7405:
7406: ELSE
7407:

Line 7409: FROM BSC_KPI_ANALYSIS_MEASURES_B A, BSC_SYS_DATASETS_B B

7405:
7406: ELSE
7407:
7408: SELECT COUNT (DISTINCT A.dataset_id) INTO l_count
7409: FROM BSC_KPI_ANALYSIS_MEASURES_B A, BSC_SYS_DATASETS_B B
7410: WHERE INDICATOR = p_kpi_id
7411: AND A.DATASET_ID = B.DATASET_ID
7412: AND B.SOURCE = 'BSC';
7413:

Line 7564: FROM BSC_KPI_ANALYSIS_MEASURES_B

7560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7561: END IF;
7562: --Determine number of distinct dataset_id before delete.
7563: /*SELECT COUNT (DISTINCT dataset_id) INTO l_count
7564: FROM BSC_KPI_ANALYSIS_MEASURES_B
7565: WHERE INDICATOR = p_kpi_id;*/
7566:
7567: l_count := get_Struct_Meas_Count(p_kpi_id);
7568:

Line 7668: FROM BSC_KPI_ANALYSIS_MEASURES_B

7664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7665: END IF;
7666:
7667: /* SELECT COUNT (DISTINCT dataset_id) INTO l_new_count
7668: FROM BSC_KPI_ANALYSIS_MEASURES_B
7669: WHERE INDICATOR = p_kpi_id;*/
7670:
7671: l_new_count := get_Struct_Meas_Count(p_kpi_id);
7672:

Line 7694: FROM BSC_KPI_ANALYSIS_MEASURES_B

7690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7691: END IF;
7692:
7693: SELECT COUNT (DISTINCT dataset_id) INTO l_new_count
7694: FROM BSC_KPI_ANALYSIS_MEASURES_B
7695: WHERE INDICATOR = l_kpi_id;
7696: IF (l_count <> l_new_count) THEN
7697: BSC_DESIGNER_PVT.ActionFlag_Change(l_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
7698: END IF;