The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_stmt := 'SELECT
ID
,TRY_ID
,REV_CCID
,FREIGHT_CCID
,REC_CCID
,CLEARING_CCID
,TAX_CCID
,UNBILLED_CCID
,UNEARNED_CCID
,OBJECT_VERSION_NUMBER
,ORG_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,POST_TO_GL_YN
FROM OKL_TRX_ACCT_OPTS WHERE try_id = ' || p_taov_rec.try_id;
,l_taov_rec.LAST_UPDATED_BY
,l_taov_rec.LAST_UPDATE_DATE
,l_taov_rec.LAST_UPDATE_LOGIN
,l_taov_rec.POST_TO_GL_YN;
OKL_TRX_ACCT_OPTS_PUB.INSERT_TRX_ACCT_OPTS(p_api_version => 1.0,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_taov_rec => l_taov_rec_in,
x_taov_rec => l_taov_rec_out);
OKL_TRX_ACCT_OPTS_PUB.UPDATE_TRX_ACCT_OPTS(p_api_version => 1.0,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_taov_rec => l_taov_rec_in,
x_taov_rec => l_taov_rec_out);