The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure fetch_and_delete(
p_tmp_id in number,
p_serials in out nocopy mtl_serial_numbers_temp_rec) is
i number := 0;
select
transaction_temp_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
vendor_serial_number,
vendor_lot_number,
fm_serial_number,
to_serial_number,
serial_prefix,
error_code error_code,
group_header_id
from mtl_serial_numbers_temp
where transaction_temp_id = c_tmp_id;
p_serials.last_update_date(i) := serial_rec.last_update_date;
p_serials.last_updated_by(i) := serial_rec.last_updated_by;
p_serials.last_update_login(i) := serial_rec.last_update_login;
p_serials.program_update_date(i) := serial_rec.program_update_date;
delete from mtl_serial_numbers_temp
where transaction_temp_id = p_tmp_id;
end fetch_and_delete;
procedure fetch_and_delete(
p_hdr_id in number,
p_serials in out nocopy mtl_serial_numbers_temp_rec) is
i number := 0;
select
transaction_temp_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
vendor_serial_number,
vendor_lot_number,
fm_serial_number,
to_serial_number,
serial_prefix,
error_code error_code,
group_header_id
from mtl_serial_numbers_temp
where group_header_id = c_hdr_id;
p_serials.last_update_date(i) := serial_rec.last_update_date;
p_serials.last_updated_by(i) := serial_rec.last_updated_by;
p_serials.last_update_login(i) := serial_rec.last_update_login;
p_serials.program_update_date(i) := serial_rec.program_update_date;
delete from mtl_serial_numbers_temp
where group_header_id = p_hdr_id;
end fetch_and_delete;
procedure insert_rows(
p_serials in mtl_serial_numbers_temp_rec) is
i number := 1;
insert into mtl_serial_numbers_temp (
transaction_temp_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
vendor_serial_number,
vendor_lot_number,
fm_serial_number,
to_serial_number,
serial_prefix,
error_code,
group_header_id
) values (
p_serials.transaction_temp_id(i),
p_serials.last_update_date(i),
p_serials.last_updated_by(i),
p_serials.creation_date(i),
p_serials.created_by(i),
p_serials.last_update_login(i),
p_serials.request_id(i),
p_serials.program_application_id(i),
p_serials.program_id(i),
p_serials.program_update_date(i),
p_serials.vendor_serial_number(i),
p_serials.vendor_lot_number(i),
p_serials.fm_serial_number(i),
p_serials.to_serial_number(i),
p_serials.serial_prefix(i),
p_serials.error_code(i),
p_serials.group_header_id(i)
);
end insert_rows;