APPS.BSC_COMMON_DIMENSIONS_PVT dependencies on BSC_KPI_DIM_LEVELS_B

Line 7: ,p_level_index IN BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE

3:
4: PROCEDURE Get_Parent_level_properties
5: (
6: p_tab_id IN BSC_TABS_B.tab_id%TYPE
7: ,p_level_index IN BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE
8: ,x_parent_level_id OUT NOCOPY BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
9: ,x_parent_level_index OUT NOCOPY BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE
10: );
11:

Line 9: ,x_parent_level_index OUT NOCOPY BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE

5: (
6: p_tab_id IN BSC_TABS_B.tab_id%TYPE
7: ,p_level_index IN BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE
8: ,x_parent_level_id OUT NOCOPY BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
9: ,x_parent_level_index OUT NOCOPY BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE
10: );
11:
12: -- The following API saves LIST BUTTON (Common Dimension) configuration
13: -- for a particular SCORECARD.

Line 80: -- before creating records we will update default_value in bsc_kpi_dim_levels_b.the same way as it was

76: AND dim_level_id = l_dim_level_id
77: AND dim_level_index = l_dim_level_index;
78:
79: IF (l_row_cnt = 0) THEN
80: -- before creating records we will update default_value in bsc_kpi_dim_levels_b.the same way as it was
81: -- happening in VB
82: BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value
83: (
84: p_dim_level_id => l_dim_level_id

Line 453: UPDATE bsc_kpi_dim_levels_b

449:
450: BEGIN
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453: UPDATE bsc_kpi_dim_levels_b
454: SET DEFAULT_VALUE = BSC_COMMON_DIMENSIONS_PVT.C_ALL
455: WHERE indicator IN (
456: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )
457: AND default_value like BSC_COMMON_DIMENSIONS_PVT.C_COM_DIM_DEFAULT_VALUE;

Line 509: ,p_default_value IN BSC_KPI_DIM_LEVELS_B.default_value%TYPE

505: /********************************************************/
506: PROCEDURE set_dim_default_value
507: (
508: p_dim_level_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
509: ,p_default_value IN BSC_KPI_DIM_LEVELS_B.default_value%TYPE
510: ,p_Tab_Id IN BSC_TABS_B.tab_id%TYPE
511: ,x_return_status OUT NOCOPY VARCHAR2
512: ,x_msg_count OUT NOCOPY NUMBER
513: ,x_msg_data OUT NOCOPY VARCHAR2

Line 515: l_level_table_name BSC_KPI_DIM_LEVELS_B.level_table_name%TYPE;

511: ,x_return_status OUT NOCOPY VARCHAR2
512: ,x_msg_count OUT NOCOPY NUMBER
513: ,x_msg_data OUT NOCOPY VARCHAR2
514: ) IS
515: l_level_table_name BSC_KPI_DIM_LEVELS_B.level_table_name%TYPE;
516: l_sql VARCHAR2(1000);
517: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_varchar2;
518:
519: BEGIN

Line 529: UPDATE bsc_kpi_dim_levels_b

525: FROM bsc_sys_dim_levels_b
526: WHERE dim_level_id = p_dim_level_id;
527:
528:
529: UPDATE bsc_kpi_dim_levels_b
530: SET DEFAULT_VALUE = p_default_value
531: WHERE indicator IN (
532: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )
533: AND level_table_name = l_level_table_name;

Line 580: ,p_level_index IN BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE

576:
577: PROCEDURE Get_Parent_level_properties
578: (
579: p_tab_id IN BSC_TABS_B.tab_id%TYPE
580: ,p_level_index IN BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE
581: ,x_parent_level_id OUT NOCOPY BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
582: ,x_parent_level_index OUT NOCOPY BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE
583: ) IS
584: BEGIN

Line 582: ,x_parent_level_index OUT NOCOPY BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE

578: (
579: p_tab_id IN BSC_TABS_B.tab_id%TYPE
580: ,p_level_index IN BSC_KPI_DIM_LEVELS_B.dim_level_index%TYPE
581: ,x_parent_level_id OUT NOCOPY BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
582: ,x_parent_level_index OUT NOCOPY BSC_KPI_DIM_LEVELS_B.parent_level_index%TYPE
583: ) IS
584: BEGIN
585: x_parent_level_id :=NULL;
586: x_parent_level_index :=NULL;