APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_MEAS_AGGRS

Line 711: insert into qpr_meas_aggrs(MEAS_AGG_ID, MEASURE_ID, PRICE_PLAN_ID,

707: end loop;
708: end if;
709:
710: forall i in r_cub_meas_aggr.MEASURE_ID.first..r_cub_meas_aggr.MEASURE_ID.last
711: insert into qpr_meas_aggrs(MEAS_AGG_ID, MEASURE_ID, PRICE_PLAN_ID,
712: CUBE_DIM_ID, AGGMAP_NAME, AGGMAP_CACHE_STORE,
713: AGGMAP_CACHE_NA, DIM_OPCODE,
714: SET_LEVEL_FLAG, OVERRIDE_FLAG,
715: DIM_EXPRESSION, DIM_EXPRESSION_TYPE,

Line 723: values(qpr_meas_aggrs_s.nextval,

719: TEMPLATE_FLAG,CREATION_DATE,CREATED_BY,
720: LAST_UPDATE_DATE,LAST_UPDATED_BY,
721: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
722: PROGRAM_ID, REQUEST_ID)
723: values(qpr_meas_aggrs_s.nextval,
724: r_cub_meas_aggr.MEASURE_ID(i), g_new_pp_id,
725: r_cub_meas_aggr.CUBE_DIM_ID(i),
726: r_cub_meas_aggr.AGGMAP_NAME(i),
727: r_cub_meas_aggr.AGGMAP_CACHE_STORE(i),

Line 1219: s_sql := s_sql || ' from qpr_meas_aggrs where PRICE_PLAN_ID = :1 ';

1215: s_sql := s_sql || ' SET_LEVEL_FLAG, OVERRIDE_FLAG, DIM_EXPRESSION, ';
1216: s_sql := s_sql || 'DIM_EXPRESSION_TYPE,WEIGHTED_MEASURE_FLAG, ';
1217: s_sql := s_sql || 'WEIGHT_MEASURE_NAME, WNAFILL,DIVIDE_BY_ZERO_FLAG, ';
1218: s_sql := s_sql || ' DECIMAL_OVERFLOW_FLAG, NASKIP_FLAG ';
1219: s_sql := s_sql || ' from qpr_meas_aggrs where PRICE_PLAN_ID = :1 ';
1220:
1221: return(s_sql);
1222: end get_cube_meas_aggrs_sql;
1223: