APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_MEASURES

Line 526: insert into qpr_measures(MEASURE_ID, CUBE_ID, PRICE_PLAN_ID,

522: r_cub_meas_val.CAL_MEAS_EXPRESSION_TEXT(i) := s_calc_exp;
523: end loop;
524:
525: forall i in r_cub_meas_val.MEASURE_ID.first..r_cub_meas_val.MEASURE_ID.last
526: insert into qpr_measures(MEASURE_ID, CUBE_ID, PRICE_PLAN_ID,
527: MEASURE_PPA_CODE, MEAS_CREATION_SEQ_NUM,
528: MEAS_SHORT_NAME, MEAS_LONG_NAME,
529: MEAS_PLURAL_NAME, MEAS_TYPE, MEAS_DATA_TYPE,
530: MEAS_AUTO_SOLVE, CAL_MEAS_EXPRESSION_TEXT,

Line 541: values(qpr_measures_s.nextval, p_cube_id, g_new_pp_id,

537: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
538: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
539: PROGRAM_APPLICATION_ID, PROGRAM_ID,
540: REQUEST_ID)
541: values(qpr_measures_s.nextval, p_cube_id, g_new_pp_id,
542: r_cub_meas_val.MEASURE_PPA_CODE(i),
543: r_cub_meas_val.MEAS_CREATION_SEQ_NUM(i),
544: r_cub_meas_val.MEAS_SHORT_NAME(i),
545: r_cub_meas_val.MEAS_LONG_NAME(i),

Line 1318: from qpr_measures

1314: MAPPING_VIEW_NAME, MAP_COLUMN, USER_MAPPING_VIEW_NAME,
1315: USER_MAP_COLUMN, AGGMAP_NAME,MEAS_FOLD_SHORT_NAME,
1316: MEAS_FOLD_LONG_NAME, MEAS_FOLD_PLURAL_NAME
1317: bulk collect into r_cub_meas_val
1318: from qpr_measures
1319: where PRICE_PLAN_ID = g_src_pplan_id
1320: and CUBE_ID = l_ref_cub_id
1321: and nvl(INCLUDE_FLAG, 'Y') = 'Y';
1322: