The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT name, display_name
FROM wf_users
WHERE orig_system_id = p_user_id
AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
SELECT user_name, description
FROM fnd_user
WHERE user_id = cp_user_id;
SELECT okl_wf_item_s.NEXTVAL item_key
FROM dual;
SELECT agreement.contract_number agreement_number
,subclass.meaning agreement_category
,vendors.vendor_name vendor_name
,agreement.id agreement_id
,agreement.description
,agreement.start_date
,agreement.end_date
FROM okc_k_headers_v agreement
,okc_subclasses_v subclass
,po_vendors vendors
,okc_k_party_roles_b party_roles
WHERE agreement.scs_code = subclass.code
AND party_roles.dnz_chr_id (+) = agreement.id
AND party_roles.rle_code (+) = 'OKL_VENDOR'
AND party_roles.object1_id1 = vendors.vendor_id(+)
AND agreement.id = cp_chr_id;
''|| Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_VP_PROGRAM_UPDATE'
,p_attribute_code => 'OKL_DESCRIPTION')
||' '||G_AMP_SIGN ||'nbsp;'|| cv_get_agrmnt_details.description
Line: 218
SELECT id
,contract_number
FROM okc_k_headers_b
WHERE id = cp_chr_id;
Line: 226
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
Line: 232
SELECT transaction_type_id,
fnd_application_id
FROM AME_CALLING_APPS
WHERE application_name = cp_trx_type;
Line: 357
l_parameter_list.DELETE;
Line: 439
SELECT USER_NAME
FROM FND_USER
WHERE user_id = p_user_id;
Line: 501
PROCEDURE update_agrmnt_status(itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,resultout OUT NOCOPY VARCHAR2) IS
x_return_status VARCHAR2(10);
Line: 509
l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_agrmnt_status';
Line: 510
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.UPDATE_AGRMNT_STATUS';
Line: 518
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');
Line: 534
okl_contract_status_pub.update_contract_status(p_api_version => '1.0'
,p_init_msg_list => OKL_API.G_TRUE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_khr_status => G_ACTIVE_STS_CODE
,p_chr_id => lv_agreement_id
);
Line: 546
'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
);
Line: 555
okl_contract_status_pub.update_contract_status(p_api_version => '1.0'
,p_init_msg_list => OKL_API.G_TRUE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_khr_status => G_DECLINED_STS_CODE
,p_chr_id => lv_agreement_id
);
Line: 567
'okl_contract_status_pub.update_contract_status G_DECLINED_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
);
Line: 589
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug update_agrmnt_status');
Line: 596
END update_agrmnt_status;