APPS.ZPB_BUSAREA_VAL dependencies on ZPB_DIMENSIONS_VL

Line 2289: SELECT name INTO l_dimName FROM zpb_dimensions_vl

2285: DISABLE_BP(p_business_area ,each.object_name,
2286: each_sum_sel.SUM_SELECTION_PATH, l_queryErrorType,
2287: each_sum_sel.ANALYSIS_CYCLE_ID, p_init_fix);
2288:
2289: SELECT name INTO l_dimName FROM zpb_dimensions_vl
2290: WHERE bus_area_id = p_business_area
2291: AND aw_name = each_sum_sel.DIMENSION;
2292:
2293: l_memberName := GET_LINE_MEMBER_DESC(each_sum_sel.MEMBER);

Line 2302: SELECT name INTO l_dimName FROM zpb_dimensions_vl

2298: END IF;
2299: END LOOP;
2300: ELSE
2301: FOR each_sum_sel in l_sum_sel1(each.object_name, p_business_area) LOOP
2302: SELECT name INTO l_dimName FROM zpb_dimensions_vl
2303: WHERE bus_area_id = p_business_area
2304: AND aw_name = each_sum_sel.DIMENSION_NAME;
2305:
2306: DISABLE_BP(p_business_area ,each.object_name,

Line 2526: SELECT AW_NAME INTO l_rem_def_hier_dim FROM ZPB_DIMENSIONS_VL

2522: WHEN no_data_found THEN
2523: null;
2524: END;
2525: --get the removed Default Hier's Dimension ID
2526: SELECT AW_NAME INTO l_rem_def_hier_dim FROM ZPB_DIMENSIONS_VL
2527: WHERE BUS_AREA_ID = p_business_area
2528: AND DEFAULT_HIER = SUBSTR(p_object_id, INSTR(p_object_id, '_', -1, 1) + 1);
2529:
2530: --get the ID for Line Dimension

Line 2531: SELECT AW_NAME INTO l_line_dimID FROM ZPB_DIMENSIONS_VL

2527: WHERE BUS_AREA_ID = p_business_area
2528: AND DEFAULT_HIER = SUBSTR(p_object_id, INSTR(p_object_id, '_', -1, 1) + 1);
2529:
2530: --get the ID for Line Dimension
2531: SELECT AW_NAME INTO l_line_dimID FROM ZPB_DIMENSIONS_VL
2532: WHERE BUS_AREA_ID = p_business_area
2533: AND DIM_TYPE = 'LINE';
2534:
2535: l_secFoldPath := G_BUS_AREA_PATH_PREFIX || p_business_area || G_SECURITY_ADMIN_FOLDER;

Line 2854: SELECT name INTO l_dimName FROM zpb_dimensions_vl

2850:
2851: ELSIF (instr (each.object_name, 'SUM') > 0) THEN
2852: IF (instr(each.object_name, 'SUM_') > 0) THEN
2853: FOR each_sum_sel in l_sum_sel2(each.object_name, p_business_area) LOOP
2854: SELECT name INTO l_dimName FROM zpb_dimensions_vl
2855: WHERE bus_area_id = p_business_area
2856: AND aw_name = each_sum_sel.DIMENSION;
2857:
2858: l_memberName := GET_LINE_MEMBER_DESC(each_sum_sel.MEMBER);

Line 2873: SELECT name INTO l_dimName FROM zpb_dimensions_vl

2869: each_sum_sel.ANALYSIS_CYCLE_ID, p_init_fix);
2870: END LOOP;
2871: ELSE
2872: FOR each_sum_sel in l_sum_sel1(each.object_name, p_business_area) LOOP
2873: SELECT name INTO l_dimName FROM zpb_dimensions_vl
2874: WHERE bus_area_id = p_business_area
2875: AND aw_name = each_sum_sel.DIMENSION_NAME;
2876: IF(l_rem_def_hier_dim = each_sum_sel.DIMENSION_NAME) then
2877: l_queryErrorType := 'F';