APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_DIMENSIONS

Line 180: insert into qpr_dimensions(PRICE_PLAN_DIM_ID, PRICE_PLAN_ID,

176: rec_dim_out val_out_type;
177: begin
178: forall i in r_dim_val.SRC_PRICE_PLAN_DIM_ID.first..
179: r_dim_val.SRC_PRICE_PLAN_DIM_ID.last
180: insert into qpr_dimensions(PRICE_PLAN_DIM_ID, PRICE_PLAN_ID,
181: DIM_CODE, DIM_PPA_CODE,
182: DIM_SEQ_NUM, MAND_DIM_FLAG,
183: TIME_DIM_FLAG , LOB_ENABLED_FLAG ,
184: DIM_SHORT_NAME , DIM_LONG_NAME ,

Line 193: values(qpr_dimensions_s.nextval, g_new_pp_id,

189: CREATION_DATE, CREATED_BY,
190: LAST_UPDATE_DATE, LAST_UPDATED_BY,
191: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
192: PROGRAM_ID, REQUEST_ID)
193: values(qpr_dimensions_s.nextval, g_new_pp_id,
194: r_dim_val.DIM_PPA_CODE(i) ||
195: to_char(g_new_pp_id)|| '_D',
196: r_dim_val.DIM_PPA_CODE(i),
197: r_dim_val.DIM_SEQ_NUM(i),

Line 1051: from qpr_dimensions src, qpr_dimensions tmpl

1047: tmpl.NATIVE_KEY_FLAG,
1048: tmpl.MEASURE_DIM_FLAG, tmpl.SPARSE_FLAG , tmpl.LOWEST_LVL,
1049: tmpl.LIST_PRICE_PLAN_FLAG
1050: bulk collect into r_dim_val
1051: from qpr_dimensions src, qpr_dimensions tmpl
1052: where src.PRICE_PLAN_ID = p_from_pp_id
1053: and tmpl.PRICE_PLAN_ID = g_src_pplan_id
1054: and src.DIM_PPA_CODE = tmpl.DIM_PPA_CODE
1055: and nvl(tmpl.INCLUDE_FLAG, 'Y') = 'Y';

Line 1062: from qpr_dimensions

1058: MAND_DIM_FLAG, TIME_DIM_FLAG, LOB_ENABLED_FLAG, DIM_SHORT_NAME,
1059: DIM_LONG_NAME, DIM_PLURAL_NAME, NATIVE_KEY_FLAG,
1060: MEASURE_DIM_FLAG, SPARSE_FLAG , LOWEST_LVL, LIST_PRICE_PLAN_FLAG
1061: bulk collect into r_dim_val
1062: from qpr_dimensions
1063: where PRICE_PLAN_ID = g_src_pplan_id
1064: and nvl(INCLUDE_FLAG, 'Y') = 'Y';
1065: end if;
1066: