APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_HIERARCHIES

Line 273: insert into qpr_hierarchies(HIERARCHY_ID, PRICE_PLAN_DIM_ID,

269: rec_hier_out val_out_type;
270: begin
271: forall i in r_dim_hier_val.HIERARCHY_PPA_CODE.first..
272: r_dim_hier_val.HIERARCHY_PPA_CODE.last
273: insert into qpr_hierarchies(HIERARCHY_ID, PRICE_PLAN_DIM_ID,
274: HIERARCHY_PPA_CODE, PRICE_PLAN_ID,
275: HIER_SHORT_NAME, HIER_LONG_NAME,
276: HIER_PLURAL_NAME, HIER_TYPE_CODE,
277: HIER_DEFAULT_ORDER, DEFAULT_FLAG,

Line 284: values(qpr_hierarchies_s.nextval, p_ppdim_id,

280: CREATED_BY, LAST_UPDATE_DATE,
281: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
282: PROGRAM_APPLICATION_ID, PROGRAM_ID,
283: REQUEST_ID)
284: values(qpr_hierarchies_s.nextval, p_ppdim_id,
285: r_dim_hier_val.HIERARCHY_PPA_CODE(i),
286: g_new_pp_id, r_dim_hier_val.HIER_SHORT_NAME(i),
287: r_dim_hier_val.HIER_LONG_NAME(i),
288: r_dim_hier_val.HIER_PLURAL_NAME(i),

Line 1119: from qpr_hierarchies

1115: select HIERARCHY_ID,HIERARCHY_PPA_CODE,HIER_SHORT_NAME, HIER_LONG_NAME,
1116: HIER_PLURAL_NAME, HIER_TYPE_CODE, HIER_DEFAULT_ORDER,DEFAULT_FLAG,
1117: CALENDAR_CODE
1118: bulk collect into r_dim_hier_val
1119: from qpr_hierarchies
1120: where PRICE_PLAN_ID = g_src_pplan_id
1121: and PRICE_PLAN_DIM_ID = l_pplan_dim_id;
1122:
1123: if r_dim_hier_val.HIERARCHY_ID.count > 0 then