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_OPTIONS_B

Line 302: FROM BSC_KPI_ANALYSIS_OPTIONS_B

298: IF (p_Analysis_Group_ID = 1) THEN
299: l_Count := 0;
300: WHILE (l_Count = 0) LOOP
301: SELECT COUNT(*) INTO l_Count
302: FROM BSC_KPI_ANALYSIS_OPTIONS_B
303: WHERE Indicator = p_Kpi_Id
304: AND Analysis_Group_Id = p_Analysis_Group_ID
305: AND Option_Id = p_Option_ID
306: AND Parent_Option_Id = x_Parent_Option_ID;

Line 320: FROM BSC_KPI_ANALYSIS_OPTIONS_B

316: ELSIF (p_Analysis_Group_ID = 2) THEN
317: l_Count := 0;
318: WHILE (l_Count = 0) LOOP
319: SELECT COUNT(*) INTO l_Count
320: FROM BSC_KPI_ANALYSIS_OPTIONS_B
321: WHERE Indicator = p_Kpi_Id
322: AND Analysis_Group_Id = p_Analysis_Group_ID
323: AND Option_Id = p_Option_ID
324: AND Parent_Option_Id = x_Parent_Option_ID

Line 3706: FROM BSC_KPI_ANALYSIS_OPTIONS_B

3702: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Option_Id <'||l_bsc_dimset_rec.Bsc_Option_Id||'>');
3703:
3704:
3705: SELECT COUNT(Indicator) INTO l_Count
3706: FROM BSC_KPI_ANALYSIS_OPTIONS_B
3707: WHERE Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
3708: AND Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3709: AND Analysis_Group_Id = l_bsc_dimset_rec.Bsc_Analysis_Id
3710: AND Option_Id = l_bsc_dimset_rec.Bsc_Option_Id;

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 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 5174: FROM BSC_KPI_ANALYSIS_OPTIONS_B

5170: AND dataset_id = -1;
5171: IF ((l_namecount =1) AND (l_index=1)AND (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id = 0)) THEN
5172: SELECT Option_Id
5173: INTO l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
5174: FROM BSC_KPI_ANALYSIS_OPTIONS_B
5175: WHERE Indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5176: AND Analysis_Group_Id = l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
5177: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0;
5178: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN

Line 5215: FROM BSC_KPI_ANALYSIS_OPTIONS_B

5211: END LOOP;
5212: ELSE
5213: SELECT COUNT(Option_Id) + 1
5214: INTO l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0
5215: FROM BSC_KPI_ANALYSIS_OPTIONS_B
5216: WHERE Indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5217: AND Analysis_Group_Id = l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
5218:
5219: -- START Granular Locking added by Aditya

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 5439: FROM BSC_KPI_ANALYSIS_OPTIONS_B

5435: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5436: END IF;
5437: -- obtain dimension set id this option is using.
5438: SELECT dim_set_id INTO l_dim_set_id
5439: FROM BSC_KPI_ANALYSIS_OPTIONS_B
5440: WHERE indicator = p_kpi_id
5441: AND analysis_group_id = 0
5442: AND option_id = p_option_id;
5443:

Line 5497: FROM BSC_KPI_ANALYSIS_OPTIONS_B

5493: END IF;
5494: -- Determine if the dimension set is being used by other options.
5495: IF (p_data_source = 'PMF') THEN
5496: SELECT COUNT(option_id) INTO l_count
5497: FROM BSC_KPI_ANALYSIS_OPTIONS_B
5498: WHERE indicator = p_kpi_id
5499: AND dim_set_id = l_dim_set_id;
5500: -- If there are no more options using this dim set delete it.
5501: IF (l_count = 0) THEN

Line 5633: FROM BSC_KPI_ANALYSIS_OPTIONS_B

5629: END IF;
5630: -- Determine if the dimension set is being used by other options.
5631: IF (p_data_source = 'PMF') THEN
5632: SELECT COUNT(option_id) INTO l_count
5633: FROM BSC_KPI_ANALYSIS_OPTIONS_B
5634: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5635: AND dim_set_id = p_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
5636:
5637: --Fetch the dim group id before deleting the objective.

Line 7544: FROM BSC_KPI_ANALYSIS_OPTIONS_B

7540: RAISE FND_API.G_EXC_ERROR;
7541: END IF;
7542: -- obtain dimension set id this option is using.
7543: SELECT dim_set_id INTO l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id
7544: FROM BSC_KPI_ANALYSIS_OPTIONS_B
7545: WHERE indicator = p_kpi_id
7546: AND analysis_group_id = 0
7547: AND option_id = p_Option_0;
7548: -- START Granular Locking - Lock the KPI Under consideration