[Home] [Help]
382: function insert_cube_data return val_out_type is
383: r_cub_val_out val_out_type;
384: begin
385: forall i in r_cub_val.CUBE_CODE.first..r_cub_val.CUBE_CODE.last
386: insert into qpr_cubes(CUBE_ID, CUBE_CODE, CUBE_PPA_CODE, PRICE_PLAN_ID,
387: CUBE_SHORT_NAME, CUBE_LONG_NAME,CUBE_PLURAL_NAME,
388: CUBE_AUTO_SOLVE_FLAG, DEFAULT_DATA_TYPE,
389: PARTITION_HIER,PARTITION_LEVEL, SPARSE_TYPE_CODE,
390: USE_GLOBAL_INDEX_FLAG, AGGMAP_NAME,
393: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
394: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
395: PROGRAM_APPLICATION_ID, PROGRAM_ID,
396: REQUEST_ID)
397: values(qpr_cubes_s.nextval,
398: -- 'QPR_'||r_cub_val.CUBE_PPA_CODE(i) || to_char(g_new_pp_id)
399: -- || '_CUBE',
400: r_cub_val.CUBE_CODE(i),
401: r_cub_val.CUBE_PPA_CODE(i), g_new_pp_id,
1270: tmpl.CUBE_AUTO_SOLVE_FLAG, tmpl.DEFAULT_DATA_TYPE, tmpl.PARTITION_HIER,
1271: tmpl.PARTITION_LEVEL,tmpl.SPARSE_TYPE_CODE, tmpl.USE_GLOBAL_INDEX_FLAG,
1272: tmpl.AGGMAP_NAME, tmpl.AGGMAP_CACHE_STORE, tmpl.AGGMAP_CACHE_NA
1273: bulk collect into r_cub_val
1274: from qpr_cubes src, qpr_cubes tmpl
1275: where src.PRICE_PLAN_ID = p_from_pp_id
1276: and tmpl.PRICE_PLAN_ID = g_src_pplan_id and
1277: src.CUBE_PPA_CODE = tmpl.CUBE_PPA_CODE
1278: order by tmpl.cube_id;
1282: CUBE_LONG_NAME, CUBE_PLURAL_NAME, CUBE_AUTO_SOLVE_FLAG,
1283: DEFAULT_DATA_TYPE, PARTITION_HIER,PARTITION_LEVEL,SPARSE_TYPE_CODE,
1284: USE_GLOBAL_INDEX_FLAG,AGGMAP_NAME,AGGMAP_CACHE_STORE,AGGMAP_CACHE_NA
1285: bulk collect into r_cub_val
1286: from qpr_cubes where PRICE_PLAN_ID = p_from_pp_id
1287: order by cube_id;
1288: end if;
1289: if r_cub_val.src_cube_id.count = 0 then
1290: fnd_file.put_line(fnd_file.log, 'No cube to copy ...');