APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 626: l_Kpi_Measure_Id bsc_kpi_analysis_measures_b.Kpi_Measure_Id%TYPE;

622: ,x_msg_data OUT NOCOPY varchar2
623: ) is
624:
625: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
626: l_Kpi_Measure_Id bsc_kpi_analysis_measures_b.Kpi_Measure_Id%TYPE;
627: l_Default_Value NUMBER;
628: l_commit VARCHAR2(2) := FND_API.G_FALSE;
629: begin
630: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 915: bsc_kpi_analysis_measures_b

911: MINUS
912: SELECT
913: kpi_measure_id
914: FROM
915: bsc_kpi_analysis_measures_b
916: WHERE
917: indicator = p_Anal_Opt_Rec.Bsc_Kpi_id;
918: BEGIN
919:

Line 1397: FROM BSC_KPI_ANALYSIS_MEASURES_B

1393: -- Get the Data Series Ids using Default mesures
1394: CURSOR c_Default_Data_Series IS
1395: SELECT SERIES_ID
1396: INTO l_count
1397: FROM BSC_KPI_ANALYSIS_MEASURES_B
1398: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1399: AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
1400: AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
1401: AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2

Line 1486: FROM BSC_KPI_ANALYSIS_MEASURES_B

1482: -- set the Series Id
1483: if l_Anal_Opt_Rec.Bsc_Dataset_Series_Id is null then
1484: SELECT COUNT (SERIES_ID)
1485: INTO l_count
1486: FROM BSC_KPI_ANALYSIS_MEASURES_B
1487: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1488: AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
1489: AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
1490: AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;

Line 1494: from BSC_KPI_ANALYSIS_MEASURES_B

1490: AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;
1491: IF l_count <> 0 then
1492: SELECT MAX(SERIES_ID) + 1
1493: into l_Anal_Opt_Rec.Bsc_Dataset_Series_Id
1494: from BSC_KPI_ANALYSIS_MEASURES_B
1495: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1496: AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
1497: AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
1498: AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;

Line 1860: FROM BSC_KPI_ANALYSIS_MEASURES_B

1856:
1857: ---Check if the number of Series before delete
1858: SELECT COUNT(SERIES_ID)
1859: INTO l_Num_Series
1860: FROM BSC_KPI_ANALYSIS_MEASURES_B
1861: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1862: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
1863: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
1864: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;

Line 1925: FROM BSC_KPI_ANALYSIS_MEASURES_B

1921: IF l_Num_Series = 1 and l_Anal_Opt_Rec.Bsc_New_Kpi <> 'Y' then
1922:
1923: SELECT COUNT(SERIES_ID)
1924: INTO l_Num_Series
1925: FROM BSC_KPI_ANALYSIS_MEASURES_B
1926: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1927: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
1928: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
1929: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;

Line 2166: FROM BSC_KPI_ANALYSIS_MEASURES_B

2162:
2163: -- Cursor to get the Data Series Id correspondig each Data Set
2164: Cursor c_Data_Series is
2165: SELECT SERIES_ID, DATASET_ID
2166: FROM BSC_KPI_ANALYSIS_MEASURES_B
2167: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
2168: AND ANALYSIS_OPTION0 = l_Anal_Opt_Rec.Bsc_Option_Group0
2169: AND ANALYSIS_OPTION1 = l_Anal_Opt_Rec.Bsc_Option_Group1
2170: AND ANALYSIS_OPTION2 = l_Anal_Opt_Rec.Bsc_Option_Group2

Line 2176: FROM BSC_KPI_ANALYSIS_MEASURES_B

2172:
2173: -- Cursor to get the Data Series not applied any more
2174: Cursor c_Data_Series_Remove is
2175: SELECT SERIES_ID, DATASET_ID
2176: FROM BSC_KPI_ANALYSIS_MEASURES_B
2177: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
2178: AND ANALYSIS_OPTION0 = l_Anal_Opt_Rec.Bsc_Option_Group0
2179: AND ANALYSIS_OPTION1 = l_Anal_Opt_Rec.Bsc_Option_Group1
2180: AND ANALYSIS_OPTION2 = l_Anal_Opt_Rec.Bsc_Option_Group2