DBA Data[Home] [Help]

APPS.BSC_DIMENSION_GROUPS_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 594: l_total_disp_name bsc_sys_dim_levels_vl.total_disp_name%TYPE;

590: l_default_value bsc_sys_dim_levels_by_group.default_value%TYPE;
591: l_default_type NUMBER;
592: l_parent_in_total NUMBER;
593: l_no_items NUMBER;
594: l_total_disp_name bsc_sys_dim_levels_vl.total_disp_name%TYPE;
595: l_comp_disp_name bsc_sys_dim_levels_vl.comp_disp_name%TYPE;
596: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
597: begin
598:

Line 595: l_comp_disp_name bsc_sys_dim_levels_vl.comp_disp_name%TYPE;

591: l_default_type NUMBER;
592: l_parent_in_total NUMBER;
593: l_no_items NUMBER;
594: l_total_disp_name bsc_sys_dim_levels_vl.total_disp_name%TYPE;
595: l_comp_disp_name bsc_sys_dim_levels_vl.comp_disp_name%TYPE;
596: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
597: begin
598:
599: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 909: FROM bsc_sys_dim_levels_vl

905: WHERE short_name = cp_dim_shortname;
906:
907: CURSOR c_dim_level (cp_dim_level_shortname VARCHAR2) IS
908: SELECT dim_level_id, total_disp_name, comp_disp_name
909: FROM bsc_sys_dim_levels_vl
910: WHERE short_name = cp_dim_level_shortname;
911:
912: BEGIN
913: