1867:
1868: -- obtain dimension set id this option is using.
1869: select dim_set_id
1870: into l_dim_set_id
1871: from BSC_KPI_ANALYSIS_OPTIONS_B
1872: where indicator = p_kpi_id
1873: and analysis_group_id = p_option_group_id
1874: and option_id = p_option_id;
1875:
1896:
1897: -- Determine if the dimension set is being used by other options.
1898: select count(option_id)
1899: into l_count
1900: from BSC_KPI_ANALYSIS_OPTIONS_B
1901: where indicator = p_kpi_id
1902: and dim_set_id = l_dim_set_id;
1903:
1904: -- If there are no more options using this dim set delete it.
3556:
3557: -- Evaluate if the option exists
3558: select count(option_id)
3559: into l_count
3560: from BSC_KPI_ANALYSIS_OPTIONS_B
3561: where indicator = p_kpi_id
3562: and analysis_group_id = p_analysis_group_id
3563: and option_id = p_option_id
3564: and parent_option_id = p_parent_option_id
3610:
3611: -- Evaluate if the Analysis option Exist in the Metadata
3612: select count(option_id)
3613: into l_count
3614: from BSC_KPI_ANALYSIS_OPTIONS_B
3615: where indicator = p_kpi_id
3616: and analysis_group_id = p_analysis_group_id
3617: and option_id = p_option_id
3618: and parent_option_id = p_parent_option_id