APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_HIER_LEVELS

Line 311: insert into qpr_hier_levels(HIERARCHY_LEVEL_ID, HIERARCHY_ID,

307: t_old_new_lvl num_type;
308: begin
309: forall i in r_hier_lvl_val.HIERARCHY_LEVEL_ID.first..
310: r_hier_lvl_val.HIERARCHY_LEVEL_ID.last
311: insert into qpr_hier_levels(HIERARCHY_LEVEL_ID, HIERARCHY_ID,
312: LEVEL_PPA_CODE, LEVEL_SEQ_NUM,
313: PRICE_PLAN_ID, LVL_SHORT_NAME,
314: LVL_LONG_NAME, LVL_PLURAL_NAME,
315: MAPPING_VIEW_NAME, MAP_COLUMN,

Line 323: values(qpr_hier_levels_s.nextval, p_hier_id,

319: CREATED_BY, LAST_UPDATE_DATE,
320: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
321: PROGRAM_APPLICATION_ID, PROGRAM_ID,
322: REQUEST_ID)
323: values(qpr_hier_levels_s.nextval, p_hier_id,
324: r_hier_lvl_val.LEVEL_PPA_CODE(i),
325: r_hier_lvl_val.LEVEL_SEQ_NUM(i),
326: g_new_pp_id, r_hier_lvl_val.LVL_SHORT_NAME(i),
327: r_hier_lvl_val.LVL_LONG_NAME(i),

Line 1134: from qpr_hier_levels

1130: LVL_SHORT_NAME, LVL_LONG_NAME, LVL_PLURAL_NAME,
1131: MAPPING_VIEW_NAME, MAP_COLUMN , USER_MAPPING_VIEW_NAME,
1132: USER_MAP_COLUMN
1133: bulk collect into r_hier_lvl_val
1134: from qpr_hier_levels
1135: where PRICE_PLAN_ID = g_src_pplan_id
1136: and HIERARCHY_ID = r_dim_hier_val.HIERARCHY_ID(j)
1137: and nvl(INCLUDE_FLAG, 'Y') = 'Y';
1138: