APPS.QPR_MAINTAIN_AW dependencies on QPR_PLAN_MEASURES

Line 189: INSERT INTO qpr_plan_measures

185: fetch c_level_values bulk collect into
186: level_value_rec limit l_rows;
187: FORALL I IN
188: 1..level_value_rec.count
189: INSERT INTO qpr_plan_measures
190: (PRICE_PLAN_DATA_ID,
191: PRICE_PLAN_ID,
192: PRICE_PLAN_MEAS_GRP_ID,
193: PRICE_PLAN_MEAS_GRP_NAME,

Line 202: (qpr_plan_measures_s.nextval,

198: LAST_UPDATE_DATE,
199: LAST_UPDATED_BY,
200: LAST_UPDATE_LOGIN,
201: REQUEST_ID) values
202: (qpr_plan_measures_s.nextval,
203: g_price_plan_id,
204: decode(p_dim_code,
205: 'ORD', 1,
206: 'PRD', 2,

Line 447: delete qpr_plan_measures

443: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for AW Maintanance (sec):' ||
444: (l_end_time - l_start_time)/100);
445:
446: if p_clean_temp='Y' then
447: delete qpr_plan_measures
448: where run_number=g_run_number;
449: end if;
450: update qpr_price_plans_b
451: set aw_status_code = 'PROCESS'