APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_SET_LEVELS

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),

Line 1230: s_sql := s_sql || ' from qpr_set_levels a';

1226: begin
1227: if g_copy_det_frm_tmpl = 'N' then
1228: s_sql := ' select a.CUBE_DIM_ID,a.MEASURE_ID, a.LEVEL_SHORT_NAME ,' ;
1229: s_sql := s_sql || ' a.DIM_EXPRESSION_TYPE,a.AGGMAP_NAME, null';
1230: s_sql := s_sql || ' from qpr_set_levels a';
1231: s_sql := s_sql || ' where a.PRICE_PLAN_ID = :1 ';
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,';

Line 1235: s_sql := s_sql || 'b.SET_LEVEL_FLAG from qpr_set_levels a, ' ;

1231: s_sql := s_sql || ' where a.PRICE_PLAN_ID = :1 ';
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;