APPS.BSC_SIMULATION_VIEW_PUB dependencies on BSC_SYS_DATASETS_B

Line 7: ,p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE

3:
4: PROCEDURE Set_Obj_Kpi_Prototype
5: (
6: p_indicator IN BSC_KPIS_B.indicator%TYPE
7: ,p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
8: ,x_return_status OUT NOCOPY VARCHAR2
9: ,x_msg_count OUT NOCOPY NUMBER
10: ,x_msg_data OUT NOCOPY VARCHAR2
11: );

Line 41: p_DatasetId IN bsc_sys_datasets_b.dataset_id%TYPE

37:
38:
39: FUNCTION Get_Kpi_MeasureCol
40: (
41: p_DatasetId IN bsc_sys_datasets_b.dataset_id%TYPE
42: ) RETURN VARCHAR2 IS
43:
44: l_measure_col bsc_sys_measures.measure_col%TYPE;
45: BEGIN

Line 50: FROM bsc_sys_datasets_b b

46:
47: IF(p_DatasetId IS NOT NULL) THEN
48: SELECT measure_col
49: INTO l_measure_col
50: FROM bsc_sys_datasets_b b
51: , bsc_sys_measures a
52: WHERE b.measure_id1 =a.measure_id
53: AND b.dataset_id =p_DatasetId;
54: END IF;

Line 63: ,p_Dataset_Id IN bsc_sys_datasets_b.dataset_id%TYPE

59:
60: FUNCTION Get_Formula_Base_Columns
61: (
62: p_indicator IN bsc_kpis_b.indicator%TYPE
63: ,p_Dataset_Id IN bsc_sys_datasets_b.dataset_id%TYPE
64: ,p_Meas_Col IN bsc_sys_measures.measure_col%TYPE
65: ) RETURN VARCHAR2 IS
66:
67: l_measure_col bsc_sys_measures.measure_col%TYPE;

Line 632: l_dataset_id BSC_SYS_DATASETS_B.dataset_id%TYPE;

628: ,x_msg_count OUT NOCOPY NUMBER
629: ,x_msg_data OUT NOCOPY VARCHAR2
630: ) IS
631: l_count NUMBER;
632: l_dataset_id BSC_SYS_DATASETS_B.dataset_id%TYPE;
633: BEGIN
634: FND_MSG_PUB.INITIALIZE;
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:

Line 1774: ,p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE

1770:
1771: PROCEDURE Set_Obj_Kpi_Prototype
1772: (
1773: p_indicator IN BSC_KPIS_B.indicator%TYPE
1774: ,p_dataset_id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
1775: ,x_return_status OUT NOCOPY VARCHAR2
1776: ,x_msg_count OUT NOCOPY NUMBER
1777: ,x_msg_data OUT NOCOPY VARCHAR2
1778: