APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_SYS_DATASETS_B

Line 1939: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;

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);
1943: x_meas_disp_name := l_display_name;

Line 1955: : x_source --> data source in bsc_sys_datasets_b

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
1959: /************************************************************/

Line 1967: ,x_source OUT NOCOPY BSC_SYS_DATASETS_B.SOURCE%TYPE

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;
1971:

Line 1978: BSC_SYS_DATASETS_B D,

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
1982: AND V.ATTRIBUTE_CATEGORY ='BIS PM Viewer'

Line 1996: BSC_SYS_DATASETS_B D

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;
2000: l_dataset_cur dataset_cur%ROWTYPE;