The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID
,OBJECT_VERSION_NUMBER
,SFWT_FLAG
,CHR_ID_RESPONSE
,CHR_ID_AWARD
-- ,CHR_ID_RENEWED obsolete
,INV_ORGANIZATION_ID
,STS_CODE
,QCL_ID
,SCS_CODE
,CONTRACT_NUMBER
,CURRENCY_CODE
,CONTRACT_NUMBER_MODIFIER
,ARCHIVED_YN
,DELETED_YN
,CUST_PO_NUMBER_REQ_YN
,PRE_PAY_REQ_YN
,CUST_PO_NUMBER
,SHORT_DESCRIPTION
,COMMENTS
,DESCRIPTION
,DPAS_RATING
,COGNOMEN
,TEMPLATE_YN
,TEMPLATE_USED
,DATE_APPROVED
,DATETIME_CANCELLED
,AUTO_RENEW_DAYS
,DATE_ISSUED
,DATETIME_RESPONDED
,NON_RESPONSE_REASON
,NON_RESPONSE_EXPLAIN
,RFP_TYPE
,CHR_TYPE
,KEEP_ON_MAIL_LIST
,SET_ASIDE_REASON
,SET_ASIDE_PERCENT
,RESPONSE_COPIES_REQ
,DATE_CLOSE_PROJECTED
,DATETIME_PROPOSED
,DATE_SIGNED
,DATE_TERMINATED
,DATE_RENEWED
,TRN_CODE
,START_DATE
,END_DATE
,AUTHORING_ORG_ID
,BUY_OR_SELL
,ISSUE_OR_RECEIVE
,ESTIMATED_AMOUNT
-- ,CHR_ID_RENEWED_TO -- obsolete
,ESTIMATED_AMOUNT_RENEWED
,CURRENCY_CODE_RENEWED
,UPG_ORIG_SYSTEM_REF
,UPG_ORIG_SYSTEM_REF_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
FROM okc_k_headers_v
WHERE id = p_old_kid;
l_chrv_rec.DELETED_YN := v_chrv_rec.DELETED_YN;
l_chrv_rec.LAST_UPDATED_BY := v_chrv_rec.LAST_UPDATED_BY;
l_chrv_rec.LAST_UPDATE_DATE := v_chrv_rec.LAST_UPDATE_DATE;
l_chrv_rec.LAST_UPDATE_LOGIN := v_chrv_rec.LAST_UPDATE_LOGIN;
OKC_CONTRACT_PUB.update_contract_header(
p_api_version => 1
,p_init_msg_list => OKC_API.G_FALSE
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_restricted_update => OKC_API.G_FALSE
,p_chrv_rec => l_chrv_rec
,x_chrv_rec => x_chrv_rec);
select 'X'
from okc_k_party_roles_v role,
okx_parties_v party
where role.object1_id1 = party.id1
and role.object1_id2 = party.id2
and role.jtot_object1_code in ('OKX_PARTY','OKX_OPERUNIT')
and upper(role.rle_code) = upper(p_role)
and role.chr_id = p_kid
and party.name = p_party_name;