DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 2326: , p_anal_grp_Id IN BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE

2322:
2323: FUNCTION Get_Num_Analysis_options
2324: (
2325: p_obj_id IN BSC_KPIS_B.indicator%TYPE
2326: , p_anal_grp_Id IN BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
2327: )RETURN NUMBER IS
2328: l_count NUMBER;
2329: BEGIN
2330: SELECT num_of_options

Line 2332: FROM BSC_KPI_ANALYSIS_GROUPS

2328: l_count NUMBER;
2329: BEGIN
2330: SELECT num_of_options
2331: INTO l_count
2332: FROM BSC_KPI_ANALYSIS_GROUPS
2333: WHERE indicator =p_obj_id
2334: AND analysis_group_id = p_anal_grp_Id;
2335:
2336: RETURN l_count;

Line 2367: FROM bsc_kpi_analysis_groups

2363:
2364: BEGIN
2365: SELECT COUNT(0)
2366: INTO l_max_group_count
2367: FROM bsc_kpi_analysis_groups
2368: WHERE indicator = p_obj_id;
2369:
2370: IF(l_max_group_count>1) THEN
2371: BSC_BIS_KPI_MEAS_PUB.store_kpi_anal_group(p_obj_id, l_Anal_Opt_Tbl);