DBA Data[Home] [Help]

APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_SET_LEVELS_S

Line 805: insert into qpr_set_levels(SET_DIM_LEVEL_ID, CUBE_DIM_ID, MEASURE_ID,

801: end loop;
802: end if;
803: end if;
804: forall i in r_cub_set_lvl.MEASURE_ID.first..r_cub_set_lvl.MEASURE_ID.last
805: insert into qpr_set_levels(SET_DIM_LEVEL_ID, CUBE_DIM_ID, MEASURE_ID,
806: PRICE_PLAN_ID,
807: LEVEL_SHORT_NAME, DIM_EXPRESSION_TYPE,
808: AGGMAP_NAME,TEMPLATE_FLAG,CREATION_DATE,
809: CREATED_BY, LAST_UPDATE_DATE,

Line 813: values(qpr_set_levels_s.nextval,

809: CREATED_BY, LAST_UPDATE_DATE,
810: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
811: PROGRAM_APPLICATION_ID, PROGRAM_ID,
812: REQUEST_ID)
813: values(qpr_set_levels_s.nextval,
814: r_cub_set_lvl.CUBE_DIM_ID(i),
815: r_cub_set_lvl.MEASURE_ID(i), g_new_pp_id,
816: r_cub_set_lvl.LEVEL_SHORT_NAME(i),
817: r_cub_set_lvl.DIM_EXPRESSION_TYPE(i),