[Home] [Help]
795: l_intercompany ZPB_BUSAREA_VERSIONS.INTERCOMPANY_ENABLED%type;
796:
797: l_vs_combo_id FEM_GLOBAL_VS_COMBO_DEFS.GLOBAL_VS_COMBO_ID%type;
798:
799: l_owner_dim ZPB_DIMENSIONS.IS_OWNER_DIM%type;
800: l_def_hier ZPB_DIMENSIONS.DEFAULT_HIER%type;
801:
802: l_dim_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;
803: l_attr_name FEM_DIM_ATTRIBUTES_VL.ATTRIBUTE_NAME%type;
796:
797: l_vs_combo_id FEM_GLOBAL_VS_COMBO_DEFS.GLOBAL_VS_COMBO_ID%type;
798:
799: l_owner_dim ZPB_DIMENSIONS.IS_OWNER_DIM%type;
800: l_def_hier ZPB_DIMENSIONS.DEFAULT_HIER%type;
801:
802: l_dim_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;
803: l_attr_name FEM_DIM_ATTRIBUTES_VL.ATTRIBUTE_NAME%type;
804:
1268: ---------------------------------------------------------------------
1269: begin
1270: select IS_OWNER_DIM
1271: into l_owner_dim
1272: from ZPB_DIMENSIONS
1273: where BUS_AREA_ID = l_ba_id
1274: and EPB_ID = each.AW_DIM_PREFIX;
1275: if (l_owner_dim = 'YES') then
1276: REGISTER_ERROR('S', 'E', 'ZPB_BUSAREA_VAL_OWNER_NO_HIER',
1535: -------------------------------------------------------------------
1536: begin
1537: select DEFAULT_HIER, IS_OWNER_DIM
1538: into l_def_hier, l_owner_dim
1539: from ZPB_DIMENSIONS
1540: where BUS_AREA_ID = l_ba_id
1541: and EPB_ID = each.AW_DIM_PREFIX;
1542:
1543: if (l_owner_dim = 'YES' and
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);
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,
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
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;
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);
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';
3078: l_codeAW := zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(FND_GLOBAL.USER_ID);
3079: l_sharedAW := 'ZPB.ZPBDATA'||l_ba_id;
3080: ATTACH_AWS(l_codeAW, l_sharedAW);
3081:
3082: SELECT SHAR_TABLE_ID INTO l_tableID FROM zpb_dimensions
3083: WHERE BUS_AREA_ID = l_ba_id
3084: AND dim_type = 'LINE';
3085:
3086: SELECT table_name INTO G_LINE_DIM_TABLE_NAME FROM zpb_tables