APPS.BIS_UTIL dependencies on AK_REGION_ITEMS

Line 1687: Values in ATTRIBUTE2 of AK_REGION_ITEMS */

1683: END IF;
1684: END get_parent_objects;
1685:
1686: /*This function uses PMV Function BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby to retrieve Dimension Short Name
1687: Values in ATTRIBUTE2 of AK_REGION_ITEMS */
1688:
1689: FUNCTION get_dims_for_region(
1690: x_RegionCode IN VARCHAR2
1691: )

Line 2660: ak_region_items_vl akRegionItems

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
2664: akRegionItems.attribute2 = bis_measures.short_name;

Line 2690: FROM ak_region_items

2686: --////////Filtering out the Simulation reports from the next available report ////////////////
2687:
2688: CURSOR c_next_ds IS
2689: SELECT region_code, region_application_id, attribute_code, attribute_application_id
2690: FROM ak_region_items
2691: WHERE attribute2 = p_measure_short_name
2692: AND attribute1 IN ('MEASURE_NOTARGET', 'MEASURE')
2693: AND NOT(region_code = p_current_region_code AND region_application_id = p_current_region_appid)
2694: AND NVL(BIS_REPORT_PUB.getRegionDataSourceType(p_current_region_code),' ') <> 'MULTIPLE_DATA_SOURCE'

Line 2700: FROM ak_region_items

2696: AND rownum < 2 ;
2697:
2698: CURSOR c_compare_to_col(p_region_code VARCHAR2, p_region_appid NUMBER, p_measure_attrcode VARCHAR2) IS
2699: SELECT attribute_code, attribute_application_id
2700: FROM ak_region_items
2701: WHERE region_code = p_region_code
2702: AND region_application_id = p_region_appid
2703: AND attribute1 IN ('COMPARE_TO_MEASURE', 'COMPARE_TO_MEASURE_NO_TARGET')
2704: AND attribute2 = p_measure_attrcode ;

Line 2787: , p_attribute2 IN AK_REGION_ITEMS_VL.attribute2%TYPE

2783:
2784: FUNCTION Get_Default_Value_From_Params
2785: (
2786: p_parameters IN FND_FORM_FUNCTIONS_VL.parameters%TYPE
2787: , p_attribute2 IN AK_REGION_ITEMS_VL.attribute2%TYPE
2788: )RETURN VARCHAR2 IS
2789:
2790: l_default_value VARCHAR2(1000);
2791: l_posPParamsStart NUMBER;