APPS.BIS_UTIL dependencies on BIS_INDICATORS

Line 2204: p_function_name : BIS_INDICATORS.function_name

2200: END is_Seeded;
2201:
2202: /*
2203: Called from PMFUtil.java to get the respId and secGrpId for a measure's report.
2204: p_function_name : BIS_INDICATORS.function_name
2205: p_region_code : region code from BIS_INDICATORS.actual_data_source
2206: p_owner : Target owner from wf_roles
2207: If the target owner is itself a responsibility, that will be used straightaway.
2208: If the owner is a user, we will use this user_id to get the responsibility for the form function.

Line 2205: p_region_code : region code from BIS_INDICATORS.actual_data_source

2201:
2202: /*
2203: Called from PMFUtil.java to get the respId and secGrpId for a measure's report.
2204: p_function_name : BIS_INDICATORS.function_name
2205: p_region_code : region code from BIS_INDICATORS.actual_data_source
2206: p_owner : Target owner from wf_roles
2207: If the target owner is itself a responsibility, that will be used straightaway.
2208: If the owner is a user, we will use this user_id to get the responsibility for the form function.
2209: If the owner is neither a responsibility nor a user, then return -1.

Line 2445: l_dim bis_indicators.short_name%TYPE;

2441: IS
2442:
2443: l_dim_plus_dimlevel VARCHAR2(100);
2444: l_pos NUMBER;
2445: l_dim bis_indicators.short_name%TYPE;
2446: l_dim_level bis_levels.short_name%TYPE;
2447: l_num NUMBER;
2448:
2449: CURSOR c_dim_plus_dimlevel_rel_cursor(l_dim VARCHAR2, l_dim_level VARCHAR2) IS

Line 2646: l_measure_name bis_indicators_vl.name%type;

2642: p_attribute1 IN VARCHAR2,
2643: p_attribute2 IN VARCHAR2)
2644: RETURN VARCHAR2
2645: IS
2646: l_measure_name bis_indicators_vl.name%type;
2647: BEGIN
2648: IF (p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE) THEN
2649: SELECT
2650: bis_measures.name INTO l_measure_name

Line 2652: bis_indicators_vl bis_measures

2648: IF (p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE) THEN
2649: SELECT
2650: bis_measures.name INTO l_measure_name
2651: FROM
2652: bis_indicators_vl bis_measures
2653: WHERE
2654: bis_measures.short_name = p_attribute2;
2655: ELSIF (p_attribute1 = BIS_AK_REGION_PUB.C_CHANGE_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_PERCENT_OF_TOTAL) THEN
2656: SELECT

Line 2659: bis_indicators_vl bis_measures,

2655: ELSIF (p_attribute1 = BIS_AK_REGION_PUB.C_CHANGE_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_PERCENT_OF_TOTAL) THEN
2656: SELECT
2657: bis_measures.name INTO l_measure_name
2658: FROM
2659: bis_indicators_vl bis_measures,
2660: ak_region_items_vl akRegionItems
2661: WHERE
2662: akRegionItems.region_code = p_region_code AND
2663: akRegionItems.attribute_code = p_attribute2 AND