APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BIS_INDICATORS

Line 1938: l_measure_type BIS_INDICATORS_VL.MEASURE_TYPE%TYPE;

1934: ,p_dataset_id IN NUMBER
1935: ,x_meas_disp_name OUT NOCOPY VARCHAR
1936: ) IS
1937: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;
1938: l_measure_type BIS_INDICATORS_VL.MEASURE_TYPE%TYPE;
1939: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1940: l_item_type AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE;
1941: BEGIN
1942: Get_Measure_Prop(p_region_code, p_dataset_id, l_display_name, l_measure_type, l_source, l_item_type);

Line 1954: : x_measure_type --> measure type in bis_indicators_vl

1950: If p_region_code is null, it retrieves information from bis_display_measures_v.
1951: Input : p_region_code --> Region code
1952: p_dataset_id --> dataset id
1953: Output : x_meas_disp_name --> measure display name
1954: : x_measure_type --> measure type in bis_indicators_vl
1955: : x_source --> data source in bsc_sys_datasets_b
1956: : x_item_type --> attribute1 in ak_region_items
1957: Created By : sawu 30-JUN-2005
1958: Modified By : ashankar 07-JUL-05 Filtering Weighted KPIs

Line 1966: ,x_measure_type OUT NOCOPY BIS_INDICATORS_VL.MEASURE_TYPE%TYPE

1962: (
1963: p_region_code IN VARCHAR
1964: ,p_dataset_id IN NUMBER
1965: ,x_meas_disp_name OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE
1966: ,x_measure_type OUT NOCOPY BIS_INDICATORS_VL.MEASURE_TYPE%TYPE
1967: ,x_source OUT NOCOPY BSC_SYS_DATASETS_B.SOURCE%TYPE
1968: ,x_item_type OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE
1969: ) IS
1970: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;

Line 1977: FROM BIS_INDICATORS_VL B,

1973: SELECT DISTINCT NVL(V.ATTRIBUTE_LABEL_LONG,B.NAME) NAME,
1974: B.MEASURE_TYPE,
1975: D.SOURCE,
1976: v.attribute1 ITEM_TYPE
1977: FROM BIS_INDICATORS_VL B,
1978: BSC_SYS_DATASETS_B D,
1979: AK_REGION_ITEMS_VL V,
1980: AK_REGIONS C
1981: WHERE C.REGION_CODE = V.REGION_CODE

Line 1995: BIS_INDICATORS B,

1991:
1992: CURSOR dataset_cur IS
1993: SELECT V.NAME, V.MEASURE_TYPE, D.SOURCE
1994: FROM BIS_DISPLAY_MEASURES_V V,
1995: BIS_INDICATORS B,
1996: BSC_SYS_DATASETS_B D
1997: WHERE D.DATASET_ID = p_dataset_id
1998: AND D.DATASET_ID = B.DATASET_ID
1999: AND B.SHORT_NAME = V.SHORT_NAME;