APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_DIM_ATTRIBUTES

Line 231: insert into qpr_dim_attributes(DIM_ATTR_ID, PRICE_PLAN_DIM_ID,

227: rec_dim_attr_val val_out_type;
228: begin
229: forall i in r_dim_attr_val.ATTR_PPA_CODE.first..
230: r_dim_attr_val.ATTR_PPA_CODE.last
231: insert into qpr_dim_attributes(DIM_ATTR_ID, PRICE_PLAN_DIM_ID,
232: PRICE_PLAN_ID,
233: ATTR_PPA_CODE, ATTR_SHORT_NAME,
234: ATTR_LONG_NAME, ATTR_PLURAL_NAME,
235: ATTR_CLASSIFICATION, ATTR_DATA_TYPE,

Line 242: values(qpr_dim_attributes_s.nextval, p_ppdim_id,

238: LAST_UPDATE_DATE, LAST_UPDATED_BY,
239: LAST_UPDATE_LOGIN,
240: PROGRAM_APPLICATION_ID, PROGRAM_ID,
241: REQUEST_ID)
242: values(qpr_dim_attributes_s.nextval, p_ppdim_id,
243: g_new_pp_id, r_dim_attr_val.ATTR_PPA_CODE(i),
244: r_dim_attr_val.ATTR_SHORT_NAME(i),
245: r_dim_attr_val.ATTR_LONG_NAME(i),
246: r_dim_attr_val.ATTR_PLURAL_NAME(i),

Line 1100: from qpr_dim_attributes

1096: select DIM_ATTR_ID, ATTR_PPA_CODE, ATTR_SHORT_NAME, ATTR_LONG_NAME,
1097: ATTR_PLURAL_NAME, ATTR_CLASSIFICATION, ATTR_DATA_TYPE,
1098: DEFAULT_ORDER_FLAG
1099: bulk collect into r_dim_attr_val
1100: from qpr_dim_attributes
1101: where PRICE_PLAN_ID = g_src_pplan_id
1102: and PRICE_PLAN_DIM_ID = l_pplan_dim_id;
1103:
1104: if r_dim_attr_val.DIM_ATTR_ID.count > 0 then