APPS.BSC_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_KPI_SERIES_PUB

Line 514: BSC_KPI_SERIES_PUB.Check_Series_Default_Props(

510: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513:
514: BSC_KPI_SERIES_PUB.Check_Series_Default_Props(
515: p_commit => l_commit
516: ,p_Indicator => p_Anal_Opt_Rec.Bsc_Kpi_Id
517: ,x_return_status => x_return_status
518: ,x_msg_count => x_msg_count

Line 530: BSC_KPI_SERIES_PUB.Check_Color_Props(

526: FETCH c_Default_Series_Id INTO l_Series_Id, l_Budget_Flag;
527: CLOSE c_Default_Series_Id;
528:
529:
530: BSC_KPI_SERIES_PUB.Check_Color_Props(
531: p_commit => FND_API.G_FALSE
532: ,p_Indicator => p_Anal_Opt_Rec.Bsc_Kpi_Id
533: ,p_Analysis_Option0 => p_Anal_Opt_Rec.Bsc_Option_Group0
534: ,p_Analysis_Option1 => p_Anal_Opt_Rec.Bsc_Option_Group1

Line 583: BSC_KPI_SERIES_PUB.Check_Series_Default_Props(

579: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: BSC_KPI_SERIES_PUB.Check_Series_Default_Props(
584: p_commit => l_commit
585: ,p_Indicator => l_Anal_Opt_Rec.Bsc_Kpi_Id
586: ,x_return_status => x_return_status
587: ,x_msg_count => x_msg_count

Line 605: BSC_KPI_SERIES_PUB.Check_Color_Props(

601: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: BSC_KPI_SERIES_PUB.Check_Color_Props(
606: p_commit => FND_API.G_FALSE
607: ,p_Indicator => l_Anal_Opt_Rec.Bsc_Kpi_Id
608: ,p_Analysis_Option0 => l_Anal_Opt_Rec.Bsc_Option_Group0
609: ,p_Analysis_Option1 => l_Anal_Opt_Rec.Bsc_Option_Group1

Line 833: ,x_dim_Dataset_map OUT NOCOPY BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table

829: ************************************************************************************/
830:
831: PROCEDURE Get_Current_Dim_DataSet_Map (
832: p_Indicator IN NUMBER
833: ,x_dim_Dataset_map OUT NOCOPY BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table
834: ) IS
835: BEGIN
836: SELECT DISTINCT
837: dim.dim_set_id, dim.dataset_id,0

Line 861: ,p_olddim_Dataset_map IN BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table

857:
858: PROCEDURE Check_Strucural_Flag_Change(
859: p_commit IN VARCHAR2 := FND_API.G_FALSE
860: ,p_Indicator IN NUMBER
861: ,p_olddim_Dataset_map IN BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table
862: ,p_cascade_shared BOOLEAN := FALSE
863: ,x_return_status OUT NOCOPY VARCHAR2
864: ,x_msg_count OUT NOCOPY NUMBER
865: ,x_msg_data OUT NOCOPY VARCHAR2

Line 868: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

864: ,x_msg_count OUT NOCOPY NUMBER
865: ,x_msg_data OUT NOCOPY VARCHAR2
866: ) IS
867:
868: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
869: isStructureChange BOOLEAN;
870:
871: CURSOR c_shared_objs IS
872: SELECT

Line 959: ,p_olddim_Dataset_map IN BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table := NULL

955: ,p_Change_Dim_Set IN NUMBER := 0
956: ,p_default_calculation IN NUMBER := NULL
957: ,p_Create_Flow IN VARCHAR2 := FND_API.G_FALSE
958: ,p_time_stamp IN VARCHAR2 := NULL
959: ,p_olddim_Dataset_map IN BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table := NULL
960: ,x_return_status OUT NOCOPY VARCHAR2
961: ,x_msg_count OUT NOCOPY NUMBER
962: ,x_msg_data OUT NOCOPY VARCHAR2
963: ) IS

Line 986: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

982: l_temp_GrandParent_Id NUMBER := NULL;
983: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
984: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
985:
986: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
987: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
988: isStructureChange BOOLEAN := FALSE;
989: i NUMBER;
990:

Line 987: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

983: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
984: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
985:
986: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
987: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
988: isStructureChange BOOLEAN := FALSE;
989: i NUMBER;
990:
991:

Line 1113: BSC_KPI_SERIES_PUB.Save_Default_Calculation(

1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: END IF;
1111:
1112: IF l_indicator_type <> 10 AND p_DataSet_Id IS NOT NULL THEN
1113: BSC_KPI_SERIES_PUB.Save_Default_Calculation(
1114: p_commit => FND_API.G_FALSE
1115: ,p_Indicator => p_Indicator
1116: ,p_Analysis_Option0 => l_AO0
1117: ,p_Analysis_Option1 => l_AO1

Line 2328: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

2324: l_olddim_set_ids FND_TABLE_OF_NUMBER;
2325: l_newdim_set_ids FND_TABLE_OF_NUMBER;
2326: l_Removed_Dim_Set_Ids FND_TABLE_OF_NUMBER;
2327:
2328: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
2329:
2330: i NUMBER;
2331: CURSOR c_Shared_Objs IS
2332: SELECT

Line 2479: BSC_KPI_SERIES_PUB.Check_Series_Default_Props (

2475: END IF;
2476: END LOOP;
2477:
2478:
2479: BSC_KPI_SERIES_PUB.Check_Series_Default_Props (
2480: p_commit => l_commit
2481: ,p_Indicator => p_Indicator
2482: ,x_return_status => x_return_status
2483: ,x_msg_count => x_msg_count

Line 2582: BSC_KPI_SERIES_PUB.Check_Series_Default_Props(

2578: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: END IF;
2581: END LOOP;
2582: BSC_KPI_SERIES_PUB.Check_Series_Default_Props(
2583: p_commit => l_commit
2584: ,p_Indicator => cd.Indicator
2585: ,x_return_status => x_return_status
2586: ,x_msg_count => x_msg_count

Line 3153: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

3149: l_temp_Parent_Id NUMBER := NULL;
3150: l_temp_GrandParent_Id NUMBER := NULL;
3151: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3152: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3153: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
3154: CURSOR c_shared_objs IS
3155: SELECT
3156: indicator
3157: FROM