APPS.BSC_COMMON_DIMENSIONS_PVT dependencies on BSC_SYS_DIM_LEVELS_B

Line 8: ,x_parent_level_id OUT NOCOPY BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

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:
12: -- The following API saves LIST BUTTON (Common Dimension) configuration

Line 508: p_dim_level_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

504: Created By : ashankar
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

Line 525: FROM bsc_sys_dim_levels_b

521:
522: IF(p_dim_level_id IS NOT NULL AND p_default_value IS NOT NULL) THEN
523: SELECT level_table_name
524: INTO l_level_table_name
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

Line 581: ,x_parent_level_id OUT NOCOPY BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

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
585: x_parent_level_id :=NULL;