[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_uom_data(p_instance_id in number) is
request_id number;
insert into QPR_UOM_CONVERSIONS(UOM_CONV_ID, FROM_UOM_CLASS, TO_UOM_CLASS,
FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG,
CONVERSION_RATE, ITEM_KEY, FROM_UOM_DESC,
INSTANCE_ID,
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID, PROGRAM_ID,
REQUEST_ID)
values(QPR_UOM_CONVERSIONS_S.nextval,
r_uom_data.FROM_UOM_CLASS(i), r_uom_data.TO_UOM_CLASS(i),
r_uom_data.FROM_UOM_CODE(i), r_uom_data.TO_UOM_CODE(i),
r_uom_data.BASE_UOM_FLAG(i), r_uom_data.CONVERSION_RATE(i),
r_uom_data.SR_ITEM_PK(i), r_uom_data.FROM_UOM_DESC(i),
p_instance_id,
sys_date, user_id, sys_date, user_id,
login_id, prg_appl_id, prg_id, request_id) ;
fnd_file.put_line(fnd_file.log, 'ERROR INSERTING UOM_DATA...');
end insert_uom_data;
delete QPR_UOM_CONVERSIONS where INSTANCE_ID = p_instance_id;
s_sql := 'select FROM_UOM_CLASS, TO_UOM_CLASS,FROM_UOM_CODE, TO_UOM_CODE, ';
insert_uom_data(p_instance_id);