PACKAGE: APPS.BSC_DEFAULT_KEY_ITEM_PUB

Source

1 PACKAGE BSC_DEFAULT_KEY_ITEM_PUB AS
2 /* $Header: BSCPDKIS.pls 120.2.12000000.1 2007/07/17 07:43:57 appldev noship $ */
3 
4 PROCEDURE Update_Key_Item(
5   p_kpi_id         IN             VARCHAR2
6 , p_params         IN             VARCHAR2
7 , p_commit         IN             VARCHAR2 := FND_API.G_FALSE
8 , x_return_status  OUT   NOCOPY   VARCHAR2
9 , x_msg_count      OUT   NOCOPY   NUMBER
10 , x_msg_data       OUT   NOCOPY   VARCHAR2
11 );
12 
13 PROCEDURE Cascade_Key_Item_Changes(
14   p_kpi_id         IN             VARCHAR2
15 , p_params         IN             VARCHAR2
16 , p_commit         IN             VARCHAR2 := FND_API.G_FALSE
17 , x_return_status  OUT   NOCOPY   VARCHAR2
18 , x_msg_count      OUT   NOCOPY   NUMBER
19 , x_msg_data       OUT   NOCOPY   VARCHAR2
20 );
21 
22 PROCEDURE Update_Default_Key_Items(
23   p_kpi_id         IN             VARCHAR2
24 , p_params         IN             VARCHAR2
25 , p_commit         IN             VARCHAR2 := FND_API.G_FALSE
26 , x_return_status  OUT   NOCOPY   VARCHAR2
27 , x_msg_count      OUT   NOCOPY   NUMBER
28 , x_msg_data       OUT   NOCOPY   VARCHAR2
29 );
30 
31 FUNCTION get_table_column_value(
32   p_table_name            IN    VARCHAR2
33  ,p_column_name           IN    VARCHAR2
34  ,p_where_cond            IN    VARCHAR2
35 ) RETURN VARCHAR2;
36 
37 PROCEDURE Set_Key_Item_Value
38 (
39     p_indicator        IN           BSC_KPIS_B.indicator%TYPE
40   , p_dim_id           IN           BSC_KPI_DIM_SETS_VL.dim_set_id%TYPE
41   , p_dim_obj_sht_name IN           BSC_SYS_DIM_LEVELS_VL.short_name%TYPE
42   , p_key_value        IN           BSC_KPI_DIM_LEVEL_PROPERTIES.default_key_value%TYPE
43   , x_return_status    OUT  NOCOPY  VARCHAR2
44   , x_msg_count        OUT  NOCOPY  NUMBER
45   , x_msg_data         OUT  NOCOPY  VARCHAR2
46 );
47 
48 END BSC_DEFAULT_KEY_ITEM_PUB;