[Home] [Help]
584: r_cub_dims_val.PRICE_PLAN_DIM_ID(i) := p_old_new_dimid(l_old_dim_id);
585: end loop;
586:
587: forall i in r_cub_dims_val.CUBE_DIM_ID.first..r_cub_dims_val.CUBE_DIM_ID.last
588: insert into qpr_cube_dims(CUBE_DIM_ID, CUBE_ID,
589: PRICE_PLAN_ID, PRICE_PLAN_DIM_ID,
590: AGGMAP_NAME, DIM_OPCODE,
591: DIM_SEQ_NUM,
592: MAPPING_VIEW_NAME, MAP_COLUMN,
599: CREATED_BY, LAST_UPDATE_DATE,
600: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
601: PROGRAM_APPLICATION_ID, PROGRAM_ID,
602: REQUEST_ID)
603: values(qpr_cube_dims_s.nextval, p_cube_id, g_new_pp_id,
604: r_cub_dims_val.PRICE_PLAN_DIM_ID(i),
605: nvl(r_cub_dims_val.AGGMAP_NAME(i), p_cube_def_agg),
606: r_cub_dims_val.DIM_OPCODE(i),
607: r_cub_dims_val.DIM_SEQ_NUM(i),
1232: else
1233: s_sql := ' select b.CUBE_DIM_ID, a.MEASURE_ID, ' ;
1234: s_sql := s_sql || 'a.LEVEL_SHORT_NAME,a.DIM_EXPRESSION_TYPE,a.AGGMAP_NAME,';
1235: s_sql := s_sql || 'b.SET_LEVEL_FLAG from qpr_set_levels a, ' ;
1236: s_sql := s_sql || ' qpr_cube_dims b where a.PRICE_PLAN_ID = :1 ';
1237: s_sql := s_sql || ' and b.PRICE_PLAN_ID = a.PRICE_PLAN_ID ' ;
1238: s_sql := s_sql || ' and b.CUBE_DIM_ID = a.CUBE_DIM_ID ';
1239: end if;
1240:
1351: DIM_EXPRESSION,DIM_EXPRESSION_TYPE,WEIGHTED_MEASURE_FLAG,
1352: WEIGHT_MEASURE_NAME, WNAFILL,DIVIDE_BY_ZERO_FLAG,
1353: DECIMAL_OVERFLOW_FLAG,NASKIP_FLAG
1354: bulk collect into r_cub_dims_val
1355: from qpr_cube_dims
1356: where PRICE_PLAN_ID = g_src_pplan_id
1357: and CUBE_ID = l_ref_cub_id;
1358:
1359: if r_cub_dims_val.CUBE_DIM_ID.count = 0 then