APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_LVL_ATTRIBUTES

Line 354: insert into qpr_lvl_attributes(LEVEL_ATTR_ID, HIERARCHY_LEVEL_ID,

350: procedure insert_lvl_attributes is
351: begin
352: forall i in r_lvl_attr_val.LEVEL_ATTR_ID.first..
353: r_lvl_attr_val.LEVEL_ATTR_ID.last
354: insert into qpr_lvl_attributes(LEVEL_ATTR_ID, HIERARCHY_LEVEL_ID,
355: DIM_ATTR_ID,
356: PRICE_PLAN_ID, MAPPING_VIEW_NAME,
357: MAP_COLUMN, USER_MAPPING_VIEW_NAME,
358: USER_MAP_COLUMN, TEMPLATE_FLAG,

Line 364: values(qpr_lvl_attributes_s.nextval,

360: CREATED_BY, LAST_UPDATE_DATE,
361: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
362: PROGRAM_APPLICATION_ID, PROGRAM_ID,
363: REQUEST_ID)
364: values(qpr_lvl_attributes_s.nextval,
365: r_lvl_attr_val.HIERARCHY_LEVEL_ID(i),
366: r_lvl_attr_val.DIM_ATTR_ID(i),
367: g_new_pp_id,
368: r_lvl_attr_val.MAPPING_VIEW_NAME(i),

Line 1079: s_lvl_sql := s_lvl_sql || 'from qpr_lvl_attributes where PRICE_PLAN_ID=:1';

1075:
1076: s_lvl_sql := 'select LEVEL_ATTR_ID, HIERARCHY_LEVEL_ID,DIM_ATTR_ID,';
1077: s_lvl_sql := s_lvl_sql || ' MAPPING_VIEW_NAME, MAP_COLUMN, ';
1078: s_lvl_sql := s_lvl_sql || ' USER_MAPPING_VIEW_NAME, USER_MAP_COLUMN ';
1079: s_lvl_sql := s_lvl_sql || 'from qpr_lvl_attributes where PRICE_PLAN_ID=:1';
1080: s_lvl_sql := s_lvl_sql || ' and nvl(INCLUDED_FLAG, ''Y'') = ''Y''' ;
1081: s_lvl_sql := s_lvl_sql || ' and HIERARCHY_LEVEL_ID IN (' ;
1082:
1083: for i in rec_dim_ids.ID.first..rec_dim_ids.ID.last loop