APPS.BSC_SIMULATION_VIEW_PUB dependencies on BSC_KPIS_B

Line 6: p_indicator IN BSC_KPIS_B.indicator%TYPE

2: /* $Header: BSCSIMPB.pls 120.3.12000000.1 2007/07/17 07:44:26 appldev noship $ */
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

Line 62: p_indicator IN bsc_kpis_b.indicator%TYPE

58:
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:

Line 68: l_short_name bsc_kpis_b.short_name%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;
68: l_short_name bsc_kpis_b.short_name%TYPE;
69: l_kpi_short_name bis_indicators.short_name%TYPE;
70: l_formula VARCHAR2(32000);
71: l_count NUMBER;
72:

Line 107: FROM bsc_kpis_b

103: BEGIN
104:
105: SELECT short_name
106: INTO l_short_name
107: FROM bsc_kpis_b
108: WHERE indicator =p_indicator;
109:
110: IF(l_short_name IS NOT NULL)THEN
111: l_count :=0;

Line 496: FROM bsc_kpis_b

492: IF(p_Region_Code IS NOT NULL)THEN
493:
494: SELECT COUNT(0)
495: INTO l_count
496: FROM bsc_kpis_b
497: WHERE SHORT_NAME = p_Region_Code;
498:
499:
500: --DBMS_OUTPUT.PUT_LINE('l_count -->'||l_count);

Line 1672: p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE

1668: /***************************************************/
1669:
1670: PROCEDURE Set_Sim_Key_Values
1671: (
1672: p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE
1673: ,p_indicator IN BSC_KPIS_B.indicator%TYPE
1674: ,x_return_status OUT NOCOPY VARCHAR2
1675: ,x_msg_count OUT NOCOPY NUMBER
1676: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1673: ,p_indicator IN BSC_KPIS_B.indicator%TYPE

1669:
1670: PROCEDURE Set_Sim_Key_Values
1671: (
1672: p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE
1673: ,p_indicator IN BSC_KPIS_B.indicator%TYPE
1674: ,x_return_status OUT NOCOPY VARCHAR2
1675: ,x_msg_count OUT NOCOPY NUMBER
1676: ,x_msg_data OUT NOCOPY VARCHAR2
1677: ) IS

Line 1682: FROM bsc_kpis_b

1678:
1679: CURSOR c_shared_obj IS
1680: SELECT indicator
1681: ,short_name
1682: FROM bsc_kpis_b
1683: WHERE prototype_flag<>2
1684: AND share_flag =2
1685: AND config_type =7
1686: AND source_indicator = p_indicator;

Line 1773: p_indicator IN BSC_KPIS_B.indicator%TYPE

1769: END Set_Sim_Key_Values;
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