APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_KPIS_B

Line 6: p_kpi_id IN BSC_KPIS_B.indicator%TYPE

2: /* $Header: BSCPDKIB.pls 120.4.12000000.2 2007/10/15 06:41:06 psomesul noship $ */
3:
4: PROCEDURE Validate_key_shared_obj
5: (
6: p_kpi_id IN BSC_KPIS_B.indicator%TYPE
7: , p_params IN VARCHAR2
8: , x_return_status OUT NOCOPY VARCHAR2
9: , x_msg_count OUT NOCOPY NUMBER
10: , x_msg_data OUT NOCOPY VARCHAR2

Line 181: FROM bsc_kpis_b

177:
178: SAVEPOINT bsc_key_item_pub_upd_key_item;
179:
180: SELECT count(0) INTO l_count
181: FROM bsc_kpis_b
182: WHERE indicator = p_kpi_id
183: AND source_indicator IS NULL
184: AND (share_flag =1 OR share_flag = 0) -- OBJECTIVE should be a master or new objective
185: AND prototype_flag <> 2;

Line 290: p_indicator IN BSC_KPIS_B.indicator%TYPE

286:
287:
288: PROCEDURE Set_Key_Item_Value
289: (
290: p_indicator IN BSC_KPIS_B.indicator%TYPE
291: , p_dim_id IN BSC_KPI_DIM_SETS_VL.dim_set_id%TYPE
292: , p_dim_obj_sht_name IN BSC_SYS_DIM_LEVELS_VL.short_name%TYPE
293: , p_key_value IN BSC_KPI_DIM_LEVEL_PROPERTIES.default_key_value%TYPE
294: , x_return_status OUT NOCOPY VARCHAR2

Line 298: l_indicator BSC_KPIS_B.indicator%TYPE;

294: , x_return_status OUT NOCOPY VARCHAR2
295: , x_msg_count OUT NOCOPY NUMBER
296: , x_msg_data OUT NOCOPY VARCHAR2
297: )IS
298: l_indicator BSC_KPIS_B.indicator%TYPE;
299:
300: CURSOR c_dim_obj IS
301: SELECT a.dim_set_id,
302: a.dim_level_index,

Line 586: UPDATE bsc_kpis_b

582: SELECT tab_id
583: FROM bsc_tab_indicators
584: WHERE indicator = p_kpi_id);
585:
586: UPDATE bsc_kpis_b
587: SET last_updated_by = l_user_id,
588: last_update_date = SYSDATE,
589: last_update_login = l_login_id
590: WHERE indicator = p_kpi_id;

Line 678: FROM bsc_kpis_b

674: ) IS
675:
676: CURSOR c_shared_objectives IS
677: SELECT indicator
678: FROM bsc_kpis_b
679: WHERE source_indicator = p_kpi_id
680: AND share_flag = 2
681: AND prototype_flag <> 2;
682: