APPS.BSC_ANALYSIS_OPTION_PVT dependencies on BSC_SYS_DATASETS_B

Line 1924: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;

1920: , x_msg_data OUT NOCOPY VARCHAR2
1921: ) is
1922: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1923: l_count number;
1924: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;
1927: l_dataset_color_change BOOLEAN := FALSE;
1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;

Line 1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;

1924: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;
1927: l_dataset_color_change BOOLEAN := FALSE;
1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;
1929: l_new_color_method bsc_sys_datasets_b.color_method%TYPE;
1930: begin
1931: FND_MSG_PUB.Initialize;
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1929: l_new_color_method bsc_sys_datasets_b.color_method%TYPE;

1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;
1927: l_dataset_color_change BOOLEAN := FALSE;
1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;
1929: l_new_color_method bsc_sys_datasets_b.color_method%TYPE;
1930: begin
1931: FND_MSG_PUB.Initialize;
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933: SAVEPOINT UpdateBSCAnaMeasPVT;

Line 1984: FROM bsc_sys_datasets_b

1980: if l_Anal_Opt_Rec.Bsc_Dataset_Id <> p_Anal_Opt_Rec.Bsc_Dataset_Id then
1981:
1982: SELECT color_method
1983: INTO l_old_color_method
1984: FROM bsc_sys_datasets_b
1985: WHERE dataset_id = p_Anal_Opt_Rec.Bsc_Dataset_Id;
1986:
1987: SELECT color_method
1988: INTO l_new_color_method

Line 1989: FROM bsc_sys_datasets_b

1985: WHERE dataset_id = p_Anal_Opt_Rec.Bsc_Dataset_Id;
1986:
1987: SELECT color_method
1988: INTO l_new_color_method
1989: FROM bsc_sys_datasets_b
1990: WHERE dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id;
1991:
1992: -- ppandey - Even if dataset id is changed, reset the color method
1993: -- only if color method of two dataset are different.

Line 2004: FROM bsc_sys_datasets_b

2000: -- Set Objective Structural Change
2001:
2002: SELECT source
2003: INTO l_source
2004: FROM bsc_sys_datasets_b
2005: WHERE dataset_id = p_Anal_Opt_Rec.Bsc_Dataset_Id;
2006:
2007: SELECT SHORT_NAME
2008: INTO l_sname

Line 3328: bsc_sys_datasets_b b,

3324: SELECT c.actual_data_source actual_data_source , c.function_name function_name
3325: ,a.dataset_id dataset_id
3326: ,a.full_name name
3327: FROM bsc_oaf_analysys_opt_comb_v a,
3328: bsc_sys_datasets_b b,
3329: bis_indicators c
3330: WHERE a.dataset_id = b.dataset_id
3331: AND b.dataset_id = c.dataset_id
3332: AND a.Indicator = p_kpi_id