DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_ANALYSIS_OPTIONS_TL

Line 3920: l_anal_name bsc_kpi_analysis_options_tl.name%TYPE := NULL;

3916: ) RETURN VARCHAR2 IS
3917: l_group_id NUMBER;
3918:
3919: h_ag_count NUMBER;
3920: l_anal_name bsc_kpi_analysis_options_tl.name%TYPE := NULL;
3921: h_ag1_depend NUMBER;
3922: h_ag2_depend NUMBER;
3923: h_ag_depend NUMBER;
3924: BEGIN

Line 5367: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := p_kpi_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.indicator

5363: FND_MSG_PUB.ADD;
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5367: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := p_kpi_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.indicator
5368: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_option_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.option_id
5369: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id := 0; -- BSC_KPI_ANALYSIS_OPTIONS_TL.analysis_group_id
5370:
5371: -- we also need to normalize the values for column ANALYSYS_OPTION0,

Line 5368: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_option_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.option_id

5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5367: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := p_kpi_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.indicator
5368: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_option_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.option_id
5369: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id := 0; -- BSC_KPI_ANALYSIS_OPTIONS_TL.analysis_group_id
5370:
5371: -- we also need to normalize the values for column ANALYSYS_OPTION0,
5372: -- ANALYSYS_OPTION1, ANALYSYS_OPTION2 based on group id.

Line 5369: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id := 0; -- BSC_KPI_ANALYSIS_OPTIONS_TL.analysis_group_id

5365: END IF;
5366: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5367: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := p_kpi_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.indicator
5368: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_option_id; -- BSC_KPI_ANALYSIS_OPTIONS_TL.option_id
5369: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id := 0; -- BSC_KPI_ANALYSIS_OPTIONS_TL.analysis_group_id
5370:
5371: -- we also need to normalize the values for column ANALYSYS_OPTION0,
5372: -- ANALYSYS_OPTION1, ANALYSYS_OPTION2 based on group id.
5373: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id = 0) THEN