DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_PUB

Line 5348: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

5344: l_tab_id NUMBER;
5345: l_dim_set_id NUMBER;
5346:
5347: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
5348: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5349: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
5350: BEGIN
5351: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Analysis_Options procedure');
5352: FND_MSG_PUB.Initialize;

Line 5483: BSC_KPI_PUB.Update_Kpi_Time_Stamp

5479: -- fixed bug#3136769
5480: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
5481: END IF;
5482: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
5483: BSC_KPI_PUB.Update_Kpi_Time_Stamp
5484: ( p_commit => FND_API.G_FALSE
5485: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5486: , x_return_status => x_return_status
5487: , x_msg_count => x_msg_count

Line 5491: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_KPI_PUB.Update_Kpi_Time_Stamp');

5487: , x_msg_count => x_msg_count
5488: , x_msg_data => x_msg_data
5489: );
5490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5491: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_KPI_PUB.Update_Kpi_Time_Stamp');
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493: END IF;
5494: -- Determine if the dimension set is being used by other options.
5495: IF (p_data_source = 'PMF') THEN

Line 5756: , p_BM_Property_Value IN NUMBER := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph -- 0 For Lines and 1 for Bars

5752: , p_kpi_name IN VARCHAR2
5753: , p_kpi_help IN VARCHAR2 := NULL
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

Line 5766: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

5762: , x_return_status OUT NOCOPY VARCHAR2
5763: , x_msg_count OUT NOCOPY NUMBER
5764: , x_msg_data OUT NOCOPY VARCHAR2
5765: ) IS
5766: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5767: l_commit VARCHAR2(10);
5768: l_tab_name BSC_TABS_TL.name%TYPE;
5769: l_count NUMBER;
5770: l_max_group_count NUMBER;

Line 5857: IF ((p_BM_Property_Value IS NOT NULL) AND (p_BM_Property_Value <> BSC_KPI_PUB.Benchmark_Kpi_Line_Graph)) THEN

5853: l_Bsc_Kpi_Entity_Rec.Bsc_Anal_Opt_Comb_Tbl := l_Anal_Num_Tbl;
5854:
5855:
5856:
5857: IF ((p_BM_Property_Value IS NOT NULL) AND (p_BM_Property_Value <> BSC_KPI_PUB.Benchmark_Kpi_Line_Graph)) THEN
5858: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5859: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Bar_Graph;
5860: ELSE
5861: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;

Line 5858: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;

5854:
5855:
5856:
5857: IF ((p_BM_Property_Value IS NOT NULL) AND (p_BM_Property_Value <> BSC_KPI_PUB.Benchmark_Kpi_Line_Graph)) THEN
5858: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5859: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Bar_Graph;
5860: ELSE
5861: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5862: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;

Line 5859: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Bar_Graph;

5855:
5856:
5857: IF ((p_BM_Property_Value IS NOT NULL) AND (p_BM_Property_Value <> BSC_KPI_PUB.Benchmark_Kpi_Line_Graph)) THEN
5858: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5859: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Bar_Graph;
5860: ELSE
5861: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5862: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;
5863: END IF;

Line 5861: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;

5857: IF ((p_BM_Property_Value IS NOT NULL) AND (p_BM_Property_Value <> BSC_KPI_PUB.Benchmark_Kpi_Line_Graph)) THEN
5858: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5859: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Bar_Graph;
5860: ELSE
5861: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5862: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;
5863: END IF;
5864: -- Set some default values.
5865: -- Added by ADRAO

Line 5862: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;

5858: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5859: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Bar_Graph;
5860: ELSE
5861: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code := BSC_KPI_PUB.Benchmark_Kpi_Property;
5862: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;
5863: END IF;
5864: -- Set some default values.
5865: -- Added by ADRAO
5866: BSC_BIS_LOCKS_PUB.LOCK_KPI

Line 5902: BSC_KPI_PUB.Update_Kpi

5898: RAISE FND_API.G_EXC_ERROR;
5899: END IF;
5900:
5901:
5902: BSC_KPI_PUB.Update_Kpi
5903: ( p_commit => FND_API.G_FALSE
5904: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5905: , x_return_status => x_return_status
5906: , x_msg_count => x_msg_count

Line 5910: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_Kpi Failed: at BSC_KPI_PUB.Update_Kpi');

5906: , x_msg_count => x_msg_count
5907: , x_msg_data => x_msg_data
5908: );
5909: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5910: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_Kpi Failed: at BSC_KPI_PUB.Update_Kpi');
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: END IF;
5913:
5914: -- Fixed Bug#3663301, Called ActionFlag_Change with a Color Flag

Line 6048: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

6044: , x_return_status OUT NOCOPY VARCHAR2
6045: , x_msg_count OUT NOCOPY NUMBER
6046: , x_msg_data OUT NOCOPY VARCHAR2
6047: ) IS
6048: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
6049: BEGIN
6050: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Kpi procedure');
6051: x_return_status := FND_API.G_RET_STS_SUCCESS;
6052: FND_MSG_PUB.Initialize;

Line 6101: BSC_KPI_PUB.Create_Kpi

6097: l_Bsc_Kpi_Entity_Rec.Created_By := 0;
6098: l_Bsc_Kpi_Entity_Rec.Last_Updated_By := 0;
6099: l_Bsc_Kpi_Entity_Rec.Last_Update_Login := 0;
6100: l_Bsc_Kpi_Entity_Rec.Last_Update_Login := 0;
6101: BSC_KPI_PUB.Create_Kpi
6102: ( p_commit => FND_API.G_FALSE
6103: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
6104: , x_return_status => x_return_status
6105: , x_msg_count => x_msg_count

Line 6109: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Kpi Failed: at BSC_KPI_PUB.Create_Kpi');

6105: , x_msg_count => x_msg_count
6106: , x_msg_data => x_msg_data
6107: );
6108: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6109: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Kpi Failed: at BSC_KPI_PUB.Create_Kpi');
6110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6111: END IF;
6112: IF (p_commit = FND_API.G_TRUE) THEN
6113: COMMIT;

Line 7445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7444: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
7445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
7446: l_count NUMBER;
7447: l_Default_Delete BOOLEAN := FALSE;
7448: l_ind_type BSC_KPIS_B.indicator_type%TYPE;
7449: l_max_group_count NUMBER;

Line 7642: BSC_KPI_PUB.Update_Kpi_Time_Stamp

7638: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Multi_Groups_Opts Failed: at BSC_KPI_PVT.Set_Default_Option');
7639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7640: END IF;
7641:
7642: BSC_KPI_PUB.Update_Kpi_Time_Stamp
7643: ( p_commit => FND_API.G_FALSE
7644: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
7645: , x_return_status => x_return_status
7646: , x_msg_count => x_msg_count

Line 7650: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Multi_Groups_Opts Failed: at BSC_KPI_PUB.Update_Kpi_Time_Stamp');

7646: , x_msg_count => x_msg_count
7647: , x_msg_data => x_msg_data
7648: );
7649: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7650: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Multi_Groups_Opts Failed: at BSC_KPI_PUB.Update_Kpi_Time_Stamp');
7651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7652: END IF;
7653:
7654: BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group