APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_MEASURE_DATA

Line 365: insert into QPR_MEASURE_DATA(MEASURE_VALUE_ID,

361:
362: procedure insert_measdata is
363: begin
364: forall i in r_insrecs.ORD_LEVEL_VALUE.FIRST..r_insrecs.ORD_LEVEL_VALUE.LAST
365: insert into QPR_MEASURE_DATA(MEASURE_VALUE_ID,
366: INSTANCE_ID,
367: MEASURE_TYPE_CODE,
368: ORD_LEVEL_VALUE,
369: ADJ_LEVEL_VALUE,

Line 431: values(QPR_MEASURE_DATA_S.nextval,

427: LAST_UPDATE_LOGIN ,
428: PROGRAM_APPLICATION_ID,
429: PROGRAM_ID,
430: REQUEST_ID)
431: values(QPR_MEASURE_DATA_S.nextval,
432: g_instance_id,
433: g_meas_type,
434: r_insrecs.ORD_LEVEL_VALUE(i),
435: r_insrecs.ADJ_LEVEL_VALUE(i),

Line 507: update QPR_MEASURE_DATA set

503:
504: procedure update_measdata is
505: begin
506: forall i in r_updrecs.MEASURE_VALUE_ID.FIRST..r_updrecs.MEASURE_VALUE_ID.LAST
507: update QPR_MEASURE_DATA set
508: MEASURE1_NUMBER = r_updrecs.MEASURE1_NUMBER(i),
509: MEASURE2_NUMBER = r_updrecs.MEASURE2_NUMBER(i),
510: MEASURE3_NUMBER = r_updrecs.MEASURE3_NUMBER(i),
511: MEASURE4_NUMBER = r_updrecs.MEASURE4_NUMBER(i),

Line 587: from QPR_MEASURE_DATA

583: PRD_LEVEL_VALUE, ADJ_LEVEL_VALUE,
584: USR1_LEVEL_VALUE, USR2_LEVEL_VALUE,
585: USR3_LEVEL_VALUE, USR4_LEVEL_VALUE,
586: USR5_LEVEL_VALUE, MEASURE_VALUE_ID
587: from QPR_MEASURE_DATA
588: where TIME_LEVEL_VALUE between d1 and d2
589: and INSTANCE_ID = ins_id
590: and MEASURE_TYPE_CODE = meas_tname
591: order by ORD_LEVEL_VALUE, ADJ_LEVEL_VALUE,