APPS.QPR_SPECIAL_ETL dependencies on QPR_MEASURE_DATA_S

Line 910: values (QPR_MEASURE_DATA_S.nextval,

906: LAST_UPDATE_DATE ,
907: LAST_UPDATED_BY ,
908: LAST_UPDATE_LOGIN ,
909: REQUEST_ID)
910: values (QPR_MEASURE_DATA_S.nextval,
911: -999,
912: 'OFFADJDATA',
913: c_offadj_data.level1_value(I),
914: c_offadj_data.date_value(I),

Line 1074: (QPR_MEASURE_DATA_S.nextval,

1070: LAST_UPDATE_DATE ,
1071: LAST_UPDATED_BY ,
1072: LAST_UPDATE_LOGIN ,
1073: REQUEST_ID) values
1074: (QPR_MEASURE_DATA_S.nextval,
1075: 'OFFADJDATA',
1076: p_instance_id,
1077: c_offadj_data.level2_value(I),
1078: c_offadj_data.level3_value(I),

Line 1404: update qpr_measure_data set psg_level_value = t_psg_val(i),

1400:
1401: fnd_file.put_line(fnd_file.log,
1402: 'updating pricing segments for measuretype:salesdata');
1403: forall i in t_meas_val_id.first..t_meas_val_id.last
1404: update qpr_measure_data set psg_level_value = t_psg_val(i),
1405: last_update_date = sysdate,
1406: last_updated_by = fnd_global.user_id,
1407: last_update_login = fnd_global.login_id,
1408: request_id = fnd_global.conc_request_id

Line 1413: update qpr_measure_data set psg_level_value = t_psg_val(i),

1409: where measure_value_id = t_meas_val_id(i);
1410:
1411: fnd_file.put_line(fnd_file.log,'Updating measuretypes:ADJUSTMENT,OFFADJDATA');
1412: forall i in t_meas_val_id.first..t_meas_val_id.last
1413: update qpr_measure_data set psg_level_value = t_psg_val(i),
1414: last_update_date = sysdate,
1415: last_updated_by = fnd_global.user_id,
1416: last_update_login = fnd_global.login_id,
1417: request_id = fnd_global.conc_request_id