The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 03-jan-2006 rpenneru bug#4899020 comparison source is not updated properly |
| while Rearrange_Data_Series |
| 05-jan-2006 rpenneru bug#4683354 Modified to reset datasource both for BSC |
| and PMF type measures |
| 22-may-2006 akoduri bug#5104402 data source is getting updated wrongly for |
| PMF type measures |
| 12-Sep-2006 akoduri Bug#5526265 Issues iwth actual_data_source and |
| function name updation |
| 11-OCT-2006 akoduri Bug #5554168 Issue with Measures having different short |
| names in bis_indicators & bsc_sys_measures |
| 31-Jan-2007 akoduri Enh #5679096 Migration of multibar functionality from |
| VB to Html |
+======================================================================================+
*/
G_PKG_NAME CONSTANT varchar2(30) := 'BSC_ANALYSIS_OPTION_PVT';
SELECT indicator
FROM BSC_KPIS_B
WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND Prototype_Flag <> 2;
select share_flag
into l_share_flag
from BSC_KPIS_B
where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
select max(option_id) + 1
into l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
from BSC_KPI_ANALYSIS_OPTIONS_B
where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
and analysis_group_id = l_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
select name
into l_Anal_Opt_Rec.Bsc_Measure_Long_Name
from BSC_SYS_DATASETS_TL
where dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id
and language = USERENV('LANG');
procedure Update_Analysis_Options
( p_commit IN varchar2 -- := FND_API.G_FALSE
, p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
, p_data_Source IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
SELECT indicator
FROM BSC_KPIS_B
WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
AND Prototype_Flag <> 2;
BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit
,p_Anal_Opt_Rec
,p_data_source
,x_return_status
,x_msg_count
,x_msg_data);
Update_Analysis_Measures( p_commit
,p_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit
,l_Anal_Opt_Rec
,p_data_source
,x_return_status
,x_msg_count
,x_msg_data);
Update_Analysis_Measures( p_commit
,l_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
end Update_Analysis_Options;
procedure Update_Analysis_Options(
p_commit IN varchar2 -- := FND_API.G_FALSE
,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
) is
begin
x_return_status := FND_API.G_RET_STS_SUCCESS;
Update_Analysis_Options(
p_commit => p_commit
,p_Anal_Opt_Rec => p_Anal_Opt_Rec
,p_data_Source => NULL
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
end Update_Analysis_Options;
procedure Delete_Analysis_Options(
p_commit IN varchar2 -- := FND_API.G_FALSE
,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
) is
begin
x_return_status := FND_API.G_RET_STS_SUCCESS;
BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options( p_commit
,p_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
end Delete_Analysis_Options;
SELECT BSC_KPI_MEASURE_S.nextval
INTO l_Kpi_Measure_Id
FROM SYS.DUAL;
procedure Update_Analysis_Measures(
p_commit IN varchar2 -- := FND_API.G_FALSE
,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
) is
l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
, p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_UPDATE
, p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
, p_Option0 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group0, 0)
, p_Option1 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group1, 0)
, p_Option2 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group2, 0)
, p_Series_Id => NVL(l_Anal_Opt_Rec.Bsc_Dataset_Series_Id, 0)
, p_Default_Value => NVL(l_Anal_Opt_Rec.Bsc_Dataset_Default_Value, 0)
, x_Default_Value => l_Default_Value
, x_Return_Status => x_Return_Status
, x_Msg_Count => x_Msg_Count
, x_Msg_Data => x_Msg_Data
);
BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures( p_commit
,l_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
end Update_Analysis_Measures;
SELECT
kpi_measure_id
FROM
bsc_kpi_measure_props
WHERE
indicator = p_Anal_Opt_Rec.Bsc_Kpi_id
MINUS
SELECT
kpi_measure_id
FROM
bsc_kpi_analysis_measures_b
WHERE
indicator = p_Anal_Opt_Rec.Bsc_Kpi_id;
BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props (
p_commit => FND_API.G_FALSE
,p_objective_id => p_Anal_Opt_Rec.Bsc_Kpi_Id
,p_kpi_measure_id => cd.kpi_measure_id
,p_cascade_shared => FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_Msg_Data
);
BSC_COLOR_RANGES_PUB.Delete_Color_Prop_Ranges (
p_commit => FND_API.G_FALSE
,p_objective_id => p_Anal_Opt_Rec.Bsc_Kpi_Id
,p_kpi_measure_id => cd.kpi_measure_id
,p_cascade_shared => FALSE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_Msg_Data
);
DELETE FROM bsc_sys_kpi_colors
WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
kpi_measure_id = cd.kpi_measure_id;
procedure Delete_Analysis_Measures(
p_commit IN varchar2 -- := FND_API.G_FALSE
,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
) is
begin
x_return_status := FND_API.G_RET_STS_SUCCESS;
BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures( p_commit
,p_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
end Delete_Analysis_Measures;
PROCEDURE Delete_Ana_Opt_Mult_Groups
( p_commit IN VARCHAR2:=FND_API.G_FALSE
, p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
, p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
, p_max_group_count IN NUMBER
, p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
, p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups
( p_commit => FND_API.G_FALSE
, p_Kpi_id => p_Kpi_id
, p_Anal_Opt_Tbl => p_Anal_Opt_Tbl
, p_max_group_count => p_max_group_count
, p_Anal_Opt_Comb_Tbl => p_Anal_Opt_Comb_Tbl
, p_Anal_Opt_Rec => p_Anal_Opt_Rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
END Delete_Ana_Opt_Mult_Groups;
SELECT OBJ.NAME OBJ_NAME,
OBJ.SHORT_NAME SHORT_NAME,
DS.NAME KPI_NAME
FROM BSC_KPIS_VL OBJ,
BSC_KPI_ANALYSIS_MEASURES_VL DS
WHERE DS.INDICATOR = p_kpi_id
AND DS.ANALYSIS_OPTION0 = p_option0
AND DS.ANALYSIS_OPTION1 = p_option1
AND DS.ANALYSIS_OPTION2 = p_option2
AND DS.SERIES_ID = p_series_id
AND OBJ.INDICATOR = DS.INDICATOR;
FND_MESSAGE.SET_NAME('BSC','BSC_D_DELETE_RPT_KPI_OBJ');
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
PROCEDURE delete_extra_series(
p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
BSC_ANALYSIS_OPTION_PVT.delete_extra_series(
p_Bsc_Anal_Opt_Rec => p_Bsc_Anal_Opt_Rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
END delete_extra_series;
SELECT indicator
FROM BSC_KPIS_B
WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND Prototype_Flag <> 2;
SELECT SERIES_COLOR, BM_COLOR
FROM BSC_SYS_SERIES_COLORS
WHERE SERIES_ID = l_series_id;
SELECT SERIES_ID
INTO l_count
FROM BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2
AND dataset_id = -1
ORDER BY SERIES_ID DESC;
SELECT COUNT(0)
INTO l_count
FROM BSC_KPIS_B
WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
select share_flag
into l_share_flag
from BSC_KPIS_B
where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
Delete_Data_Series(
p_commit => p_commit
,p_Anal_Opt_Rec => l_Anal_Opt_Rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
SELECT COUNT (SERIES_ID)
INTO l_count
FROM BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;
SELECT MAX(SERIES_ID) + 1
into l_Anal_Opt_Rec.Bsc_Dataset_Series_Id
from BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
AND analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
AND analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;
SELECT MAX(SERIES_ID)
INTO l_max_series_id
FROM BSC_SYS_SERIES_COLORS;
select name
into l_Anal_Opt_Rec.Bsc_Measure_Long_Name
from BSC_SYS_DATASETS_VL
where dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id;
procedure Update_Data_Series
( p_commit IN VARCHAR2 -- FND_API.G_FALSE
, p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
SELECT indicator
FROM BSC_KPIS_B
WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
AND Prototype_Flag <> 2;
SELECT COUNT(0)
INTO l_count
FROM BSC_KPIS_B
WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
select share_flag
into l_share_flag
from BSC_KPIS_B
where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE
,l_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE
,l_Anal_Opt_Rec
,x_return_status
,x_msg_count
,x_msg_data);
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
end Update_Data_Series;
procedure Delete_Data_Series(
p_commit IN varchar2 -- := FND_API.G_FALSE
,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
) is
l_Num_Series NUMBER;
SELECT indicator
FROM BSC_KPIS_B
WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND Prototype_Flag <> 2;
SAVEPOINT DeleteBSCDataSeriesPUB;
SELECT COUNT(0)
INTO l_count
FROM BSC_KPIS_B
WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
select share_flag
into l_share_flag
from BSC_KPIS_B
where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
SELECT COUNT(SERIES_ID)
INTO l_Num_Series
FROM BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;
BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(
p_commit => FND_API.G_FALSE
,p_Anal_Opt_Rec => l_Anal_Opt_Rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(
p_commit => FND_API.G_FALSE
,p_Anal_Opt_Rec => l_Anal_Opt_Rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
SELECT COUNT(SERIES_ID)
INTO l_Num_Series
FROM BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;
ROLLBACK TO DeleteBSCDataSeriesPUB;
ROLLBACK TO DeleteBSCDataSeriesPUB;
ROLLBACK TO DeleteBSCDataSeriesPUB;
x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
End Delete_Data_Series;
SELECT indicator
FROM BSC_KPIS_B
WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND Prototype_Flag <> 2;
SELECT
i.dataset_id
FROM
bis_indicators i
WHERE
i.short_name = l_short_name;
SELECT SERIES_ID, DATASET_ID
FROM BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND ANALYSIS_OPTION0 = l_Anal_Opt_Rec.Bsc_Option_Group0
AND ANALYSIS_OPTION1 = l_Anal_Opt_Rec.Bsc_Option_Group1
AND ANALYSIS_OPTION2 = l_Anal_Opt_Rec.Bsc_Option_Group2
AND DATASET_ID = l_Anal_Opt_Rec.Bsc_Dataset_Id;
SELECT SERIES_ID, DATASET_ID
FROM BSC_KPI_ANALYSIS_MEASURES_B
WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
AND ANALYSIS_OPTION0 = l_Anal_Opt_Rec.Bsc_Option_Group0
AND ANALYSIS_OPTION1 = l_Anal_Opt_Rec.Bsc_Option_Group1
AND ANALYSIS_OPTION2 = l_Anal_Opt_Rec.Bsc_Option_Group2
AND SERIES_ID >= l_count
ORDER BY SERIES_ID DESC;
Delete_Data_Series(
p_commit => p_commit
,p_Anal_Opt_Rec => l_Anal_Opt_Rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
SELECT num_of_options
INTO l_count
FROM BSC_KPI_ANALYSIS_GROUPS
WHERE indicator =p_obj_id
AND analysis_group_id = p_anal_grp_Id;
SELECT COUNT(0)
INTO l_max_group_count
FROM bsc_kpi_analysis_groups
WHERE indicator = p_obj_id;
with the one selected by the user.If it has changed then it return
True otherwise it returns false.
Input : p_Anal_Num_Tbl --> New analysis option combination table.
p_Old_Anal_Num_Tbl --> Old Analysis option combination table.
Output : True --> means changed.
False --> means not changed.
Created BY : ashankar For bug 4220400
/**********************************************************/
FUNCTION Default_Anal_Option_Changed
(
p_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
, p_Old_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
)RETURN BOOLEAN IS
l_return BOOLEAN;