The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rec IN PO_INTERFACE_ERRORS%ROWTYPE,
x_row_id OUT NOCOPY ROWID
) IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
SELECT po_interface_errors_s.NEXTVAL
INTO l_interface_transaction_id
FROM DUAL;
INSERT INTO po_interface_errors
( interface_type,
interface_transaction_id,
column_name,
error_message,
processing_date,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
error_message_name,
table_name,
batch_id,
interface_header_id,
interface_line_id,
interface_distribution_id
)
VALUES
( NVL(p_rec.interface_type, 'UNKNOWN'),
l_interface_transaction_id,
p_rec.column_name,
p_rec.error_message,
p_rec.processing_date,
SYSDATE,
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
FND_GLOBAL.CONC_REQUEST_ID,
FND_GLOBAL.PROG_APPL_ID,
FND_GLOBAL.CONC_PROGRAM_ID,
p_rec.program_update_date,
p_rec.error_message_name,
p_rec.table_name,
p_rec.batch_id,
p_rec.interface_header_id,
p_rec.interface_line_id,
p_rec.interface_distribution_id
)
RETURNING
ROWID
INTO
x_row_id;
END insert_row;