DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_ANALYSIS_OPTION_PUB

Line 4924: l_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;

4920:
4921: -- added for AGRD
4922: l_Is_From_Report_Designer BOOLEAN;
4923: l_Key_Short_Name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
4924: l_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4925: x_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4926: l_Dimension_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;
4927: l_Is_XTD_Enabled VARCHAR2(1);
4928: l_Bsc_Measure_Id NUMBER;

Line 4925: x_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;

4921: -- added for AGRD
4922: l_Is_From_Report_Designer BOOLEAN;
4923: l_Key_Short_Name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
4924: l_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4925: x_Anal_Opt_Rec APPS.BSC_ANALYSIS_OPTION_PUB.BSC_OPTION_REC_TYPE;
4926: l_Dimension_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;
4927: l_Is_XTD_Enabled VARCHAR2(1);
4928: l_Bsc_Measure_Id NUMBER;
4929: l_Measure_Source BSC_SYS_MEASURES.SOURCE%TYPE;

Line 5431: BSC_ANALYSIS_OPTION_PUB.Create_Data_Series(

5427: --DBMS_OUTPUT.PUT_LINE('p_Commit -->'|| p_Commit);
5428:
5429:
5430:
5431: BSC_ANALYSIS_OPTION_PUB.Create_Data_Series(
5432: p_Commit => p_Commit
5433: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
5434: , x_Anal_Opt_Rec => x_Anal_Opt_Rec
5435: , x_Return_Status => x_Return_Status

Line 5457: BSC_ANALYSIS_OPTION_PUB.Update_Data_Series(

5453: l_Anal_Opt_Rec.Bsc_Measure_Help := p_Measure_Description;
5454:
5455: --DBMS_OUTPUT.PUT_LINE('STAGE 10 - Update_Data_Series');
5456:
5457: BSC_ANALYSIS_OPTION_PUB.Update_Data_Series(
5458: p_Commit => p_Commit
5459: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
5460: , x_Return_Status => x_Return_Status
5461: , x_Msg_Count => x_Msg_Count

Line 5528: -- added logic to call Pl/SQL API BSC_ANALYSIS_OPTION_PUB.Create_Data_Series to create Data Series

5524: -- Assign the above Measure (aka KPI) to the Analysis Option (aka Measure)
5525: -- of the KPI (aka Objective)
5526: --DBMS_OUTPUT.PUT_LINE('STAGE 9');
5527: -- added for Report Designer (AG Measures) AGRD
5528: -- added logic to call Pl/SQL API BSC_ANALYSIS_OPTION_PUB.Create_Data_Series to create Data Series
5529: IF (l_Is_From_Report_Designer) THEN
5530:
5531: l_Anal_Opt_Rec.Bsc_Kpi_Id := l_Kpi_Id;
5532: l_Anal_Opt_Rec.Bsc_Dataset_Id := l_Dataset_Id;

Line 5548: BSC_ANALYSIS_OPTION_PUB.Create_Data_Series(

5544:
5545:
5546:
5547:
5548: BSC_ANALYSIS_OPTION_PUB.Create_Data_Series(
5549: p_Commit => p_Commit
5550: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
5551: , x_Anal_Opt_Rec => x_Anal_Opt_Rec
5552: , x_Return_Status => x_Return_Status

Line 8117: BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series(

8113: -- reorder the Measure at the series level (Including delete/add)
8114: l_Measure_Short_Names := BSC_BIS_KPI_CRUD_PUB.Get_DS_Sequence_From_AK(p_Region_Code, p_Kpi_Id);
8115:
8116: IF (Has_Measure_Column_Changed(l_Measure_Short_Names, p_Kpi_Id) = FND_API.G_TRUE) THEN
8117: BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series(
8118: p_commit => FND_API.G_FALSE
8119: ,p_Kpi_Id => p_Kpi_Id
8120: ,p_option_group0 => 0
8121: ,p_option_group1 => 0

Line 11026: BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series(

11022: FND_MSG_PUB.ADD;
11023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11024: END IF;
11025:
11026: BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series(
11027: p_commit => FND_API.G_FALSE
11028: ,p_Kpi_Id => l_Kpi_Id
11029: ,p_option_group0 => 0
11030: ,p_option_group1 => 0