APPS.QPR_POLICY_EVAL dependencies on QPR_MEASURE_DATA

Line 295: l_policy_value qpr_measure_data.measure1_number%TYPE;

291: date_from date := FND_DATE.canonical_to_date(p_from_date);
292: date_to date := FND_DATE.canonical_to_date(p_to_date);
293: l_rows natural :=1000;
294: l_policy_counter number:=1;
295: l_policy_value qpr_measure_data.measure1_number%TYPE;
296: I number;
297: l_pric_at_pol_limit number;
298: l_med_sev_thre number;
299: l_high_sev_thre number;

Line 310: FROM qpr_measure_data

306: org_level_value, rep_level_value, chn_level_value, vlb_level_value,
307: dsb_level_value, time_level_value,
308: (measure1_number*measure3_number - measure2_number),
309: measure13_number, measure3_number, measure1_number, measure2_number
310: FROM qpr_measure_data
311: WHERE instance_id = p_instance_id
312: and measure_type_code = 'SALESDATA'
313: and time_level_value between date_from and date_to;
314:

Line 332: delete qpr_measure_data

328: if c_policy_data_rec.ord_sr_level_value_pk.count>0 then
329: begin
330: log_debug('Policy eval deleting');
331: forall I in 1..c_policy_data_rec.ord_sr_level_value_pk.count
332: delete qpr_measure_data
333: where instance_id=p_instance_id
334: and measure_type_code = decode(c_policy_data_rec.policy_type_code(I),
335: 'CEILING', 'QPR_CEILING_POLICY_MEASURES',
336: 'CORPORATE', 'QPR_CORPORATE_POLICY_MEASURES',

Line 351: insert into QPR_MEASURE_DATA(

347: end;
348: begin
349: log_debug('Policy eval inserting');
350: forall I in 1..c_policy_data_rec.ord_sr_level_value_pk.count
351: insert into QPR_MEASURE_DATA(
352: MEASURE_VALUE_ID,
353: MEASURE_TYPE_CODE,
354: INSTANCE_ID,
355: ORD_LEVEL_VALUE,

Line 384: (QPR_MEASURE_DATA_S.nextval,

380: LAST_UPDATE_DATE ,
381: LAST_UPDATED_BY ,
382: LAST_UPDATE_LOGIN ,
383: REQUEST_ID) values
384: (QPR_MEASURE_DATA_S.nextval,
385: decode(c_policy_data_rec.policy_type_code(I),
386: 'CEILING', 'QPR_CEILING_POLICY_MEASURES',
387: 'CORPORATE', 'QPR_CORPORATE_POLICY_MEASURES',
388: 'FIELD', 'QPR_FIELD_USER_POLICY_MEASURES',