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.description
,agreement.start_date
,agreement.end_date
,change.change_request_number
,lookups.meaning change_request_type
FROM okc_k_headers_v agreement
,okc_subclasses_v subclass
,po_vendors vendors
,okc_k_party_roles_b party_roles
,okl_vp_change_requests change
,fnd_lookups lookups
,okl_k_headers khr
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 khr.id = agreement.id
AND khr.crs_id = change.id
AND change.change_type_code = 'AGREEMENT'
AND change.change_type_code = lookups.lookup_code
and lookups.lookup_type = 'OKL_VP_CHANGE_REQUEST_TYPES'
AND change.id = p_change_request_id
UNION
-- this portion of select will work for ASSOCIATION type of change requests
SELECT agreement.contract_number agreement_number
,subclass.meaning agreement_category
,vendors.vendor_name vendor_name
,agreement.description
,agreement.start_date
,agreement.end_date
,change.change_request_number
,lookups.meaning change_request_type
FROM okc_k_headers_v agreement
,okc_subclasses_v subclass
,po_vendors vendors
,okc_k_party_roles_b party_roles
,okl_vp_change_requests change
,fnd_lookups lookups
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 = change.chr_id
AND change.change_type_code = 'ASSOCIATION'
AND change.change_type_code = lookups.lookup_code
and lookups.lookup_type = 'OKL_VP_CHANGE_REQUEST_TYPES'
AND change.id = p_change_request_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_creq_dtls.description
Line: 268
SELECT id
,change_request_number
FROM okl_vp_change_requests
WHERE id = cp_crq_id;
Line: 275
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
Line: 282
select description transaction_type_id,
fnd_application_id
from AME_TRANSACTION_TYPES_V
where transaction_type_id=cp_trx_type;
Line: 288
SELECT transaction_type_id,
fnd_application_id
FROM AME_CALLING_APPS
WHERE application_name = cp_trx_type; */
Line: 412
l_parameter_list.DELETE;
Line: 492
SELECT USER_NAME
FROM FND_USER
WHERE user_id = p_user_id;
Line: 554
PROCEDURE update_cr_status(itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,resultout OUT NOCOPY VARCHAR2) IS
-- cursor to get the agreement number that was created for the change request
CURSOR c_get_creq_chr_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS
SELECT CASE WHEN (cr.change_type_code = 'AGREEMENT') THEN
(SELECT id FROM okl_k_headers WHERE crs_id = cr.id)
ELSE cr.chr_id END creq_chr_id
,cr.change_type_code
FROM okl_vp_change_requests cr
WHERE cr.id = cp_change_request_id;
Line: 572
l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_cr_status';
Line: 573
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.UPDATE_CR_STATUS';
Line: 583
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_cr_status');
Line: 651
okl_vp_change_request_pvt.update_change_request_header(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_vcrv_rec => lv_vcrv_rec
,x_vcrv_rec => x_vcrv_rec
);
Line: 666
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_AGR_APP_REJECTED_STS_CODE
,p_chr_id => cv_get_creq_chr.creq_chr_id
);
Line: 693
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug update_cr_status');
Line: 699
END update_cr_status;