APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_UTILITY

Line 1034: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);

1030: FROM BIS_DIMENSIONS_VL
1031: WHERE UPPER(name) = UPPER(p_display_name);
1032:
1033: WHILE(l_count > 0) LOOP
1034: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
1035:
1036: SELECT COUNT(1) INTO l_count
1037: FROM BIS_DIMENSIONS_VL
1038: WHERE UPPER(name) = UPPER(l_pmf_disp_name);

Line 2323: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name||'+'||l_unassign);

2319: l_unassigns := p_unassign_dim_obj_names;
2320: WHILE (is_more( p_dim_obj_short_names => l_unassigns
2321: , p_dim_obj_name => l_unassign)
2322: ) LOOP
2323: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name||'+'||l_unassign);
2324: IF(l_regions IS NOT NULL) THEN
2325: SELECT DIM_NAME
2326: INTO l_dim_name
2327: FROM BSC_BIS_DIM_VL

Line 2352: BSC_UTILITY.Enable_Dimensions_Entity(

2348: ELSE
2349: l_dim_obj_sname := l_dim_obj_sname|| ',' || p_unassign_dim_obj_names;
2350: END IF;
2351: END IF;
2352: BSC_UTILITY.Enable_Dimensions_Entity(
2353: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
2354: , p_Entity_Short_Names => l_dim_obj_sname
2355: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
2356: , x_Return_Status => x_return_status

Line 2353: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT

2349: l_dim_obj_sname := l_dim_obj_sname|| ',' || p_unassign_dim_obj_names;
2350: END IF;
2351: END IF;
2352: BSC_UTILITY.Enable_Dimensions_Entity(
2353: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
2354: , p_Entity_Short_Names => l_dim_obj_sname
2355: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
2356: , x_Return_Status => x_return_status
2357: , x_Msg_Count => x_msg_count

Line 2355: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

2351: END IF;
2352: BSC_UTILITY.Enable_Dimensions_Entity(
2353: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
2354: , p_Entity_Short_Names => l_dim_obj_sname
2355: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
2356: , x_Return_Status => x_return_status
2357: , x_Msg_Count => x_msg_count
2358: , x_Msg_Data => x_msg_data
2359: );

Line 2634: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);

2630: FROM BIS_DIMENSIONS_VL
2631: WHERE UPPER(short_name) <> UPPER(l_dim_short_name)
2632: AND UPPER(name) = UPPER(p_display_name);
2633: WHILE(l_count > 0) LOOP
2634: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
2635: SELECT COUNT(1) INTO l_count
2636: FROM BIS_DIMENSIONS_VL
2637: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
2638: END LOOP;

Line 3211: IF( l_count > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

3207: OPEN cr_indicdimset_for_dimgrp;
3208: LOOP
3209: FETCH cr_indicdimset_for_dimgrp INTO l_kpi_id,l_dim_set_id,l_count;
3210: EXIT WHEN cr_indicdimset_for_dimgrp%NOTFOUND;
3211: IF( l_count > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
3212:
3213: l_indp_dimobj := 0;
3214: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj
3215: ( p_Kpi_Id => l_kpi_id

Line 3214: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj

3210: EXIT WHEN cr_indicdimset_for_dimgrp%NOTFOUND;
3211: IF( l_count > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
3212:
3213: l_indp_dimobj := 0;
3214: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj
3215: ( p_Kpi_Id => l_kpi_id
3216: , p_Dim_Set_Id => l_dim_set_id
3217: );
3218: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

Line 3218: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

3214: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj
3215: ( p_Kpi_Id => l_kpi_id
3216: , p_Dim_Set_Id => l_dim_set_id
3217: );
3218: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
3219: SELECT NAME INTO l_kpi_name
3220: FROM BSC_KPIS_VL
3221: WHERE INDICATOR = l_kpi_id;
3222:

Line 3441: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name, BSC_UTILITY.c_DIMENSION);

3437: --assign values to bsc records
3438:
3439: l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name := p_dim_short_name;
3440:
3441: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name, BSC_UTILITY.c_DIMENSION);
3442: IF(l_regions IS NOT NULL) THEN
3443: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_RPTASSOC_ERROR');
3444: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3445: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);

Line 4017: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN

4013: FND_MSG_PUB.Initialize;
4014: IF (p_Dim_Short_Name IS NULL) THEN
4015: RETURN NULL;
4016: END IF;
4017: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
4018: RETURN NULL;
4019: END IF;
4020:
4021: FOR cd IN c_Dim_Old_Objects LOOP