The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT application_id
FROM fnd_application_vl
WHERE application_short_name = x_short_name;
SELECT msg.message_number
FROM fnd_new_messages msg, fnd_languages_vl lng
WHERE msg.message_name = x_msg
and msg.application_id = x_id
and lng.LANGUAGE_CODE = msg.language_code
and lng.language_id = x_lang_id;
SELECT okl_wf_item_s.nextval
FROM dual;
l_parameter_list.DELETE;
SELECT count(*)
FROM OKL_TRX_ASSETS
WHERE ID=c_tas_id;
SELECT contract_number
FROM OKC_K_HEADERS_V
WHERE id=c_contract_id;
SELECT okl_wf_item_s.nextval
FROM dual;
l_parameter_list.DELETE;
SELECT count(*)
FROM OKL_TRX_CONTRACTS
WHERE ID=p_trx_id;
SELECT *
FROM OKL_TRX_CONTRACTS
WHERE ID = p_id;
SELECT contract_number
FROM OKC_K_HEADERS_V
WHERE id=p_ctr_id;
SELECT object1_id1,
object1_id2
FROM okc_k_party_roles_b
WHERE dnz_chr_id = p_contract_id
AND rle_code = 'LESSEE';
SELECT name
FROM okx_parties_v
WHERE ID1 = p_id1
AND ID2 = p_id2;
SELECT nvl(ppf.email_address , fu.email_address) email
FROM fnd_user fu,
per_people_f ppf
WHERE fu.employee_id = ppf.person_id (+)
AND fu.user_id = c_agent_id;
OPEN c_agent_csr(l_req_rec.last_updated_by);
SELECT jtf_amv_item_id,email_subject_line
FROM okl_cs_process_tmplts_uv
WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
AND start_date <= TRUNC(sysdate)
AND NVL(end_date, sysdate) >= TRUNC(sysdate)
AND ptm_code = p_ptm_code;
SELECT jtf_amv_item_id,email_subject_line
FROM okl_cs_process_tmplts_uv
WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
AND start_date <= TRUNC(sysdate)
AND NVL(end_date, sysdate) >= TRUNC(sysdate)
AND ptm_code = p_ptm_code;
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
PROCEDURE Update_Request_Internal( itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2)
AS
l_trx_id NUMBER;
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
END Update_Request_Internal;
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
SELECT khr_id
FROM okl_k_headers_v
where id = p_ctr_id ;
SELECT co.object1_id1,
co.jtot_object1_code
FROM okc_contacts_v co,
okc_k_party_roles_b pr
WHERE co.dnz_chr_id = p_contract_id
AND co.cpl_id = pr.id
AND co.dnz_chr_id = pr.dnz_chr_id
AND pr.rle_code = 'OKL_VENDOR';
SELECT name,
email_address
FROM okx_salesreps_v
WHERE id1 = p_object_id;
SELECT COUNT(*) FROM
IEX_DELINQUENCIES_ALL
WHERE PARTY_CUST_ID = p_party_id
AND STATUS NOT IN ('CURRENT','PREDELINQUENT');
SELECT fnd.meaning svf_name,
fnd.description svf_desc,
svf.amount svf_amount
FROM fnd_lookups fnd,
okl_service_fees_b svf
WHERE svf.srv_code= 'CSTSFRFEE'
AND svf.srv_code = fnd.lookup_code
AND lookup_type = 'OKL_SERVICE_FEES';
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
select consolidated_invoice_number,id
from okl_cnsld_ar_hdrs_b
where id in
(select distinct(cnr_id)
from okl_cnsld_ar_lines_b
where id in
(select
distinct b.lln_id
from ar_payment_schedules_all a,
okl_cnsld_ar_strms_b b
where b.receivables_invoice_id=a.customer_trx_id
and b.khr_id = c_khr_id
and a.amount_due_remaining > 0
and a.due_date < sysdate));
select trunc(sysdate) - trunc(d.due_date) days,
sum(amount_due_remaining) total_amount,
c.khr_id
from
okl_cnsld_ar_hdrs_b a,
okl_cnsld_ar_lines_b b,
okl_cnsld_ar_strms_b c,
ar_payment_schedules_all d
where
a.id=b.cnr_id and
b.id=c.lln_id and
c.receivables_invoice_id = d.customer_trx_id and
a.id=c_ar_hdr_id
group by (trunc(sysdate) - trunc(d.due_date)),c.khr_id
order by days desc;
SELECT NVL(SUM(amount_due_remaining),0)
FROM okl_bpd_leasing_payment_trx_v
WHERE contract_id = p_contract_id;
SELECT chrb.id khr_id , CHRB.contract_number,
hca.cust_account_id
FROM OKC_K_HEADERS_B CHRB,
HZ_CUST_ACCOUNTS HCA
WHERE CHRB.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID
AND hca.cust_account_id = c_cust_account_id;
SELECT b.id,b.name,b.description
FROM okl_k_headers a,okl_products b
WHERE a.pdt_id=b.id
AND a.pdt_id is not null
AND a.id=c_contract_id;
SELECT c.address1,
c.address2,
c.address3,
c.address4,
c.city,
c.postal_code,
c.state,
c.province,
c.county,
c.country,
c.description
FROM okc_k_headers_b chr,
okx_cust_site_uses_v c
WHERE c.id1 = chr.bill_to_site_use_id
and chr.id = c_contract_id ;
SELECT okl_wf_item_s.nextval
FROM dual;
l_parameter_list.DELETE;
SELECT *
FROM OKL_TRX_REQUESTS
WHERE ID = p_id;
SELECT contract_number
FROM OKC_K_HEADERS_V
WHERE id=p_ctr_id;
SELECT okl_wf_item_s.nextval
FROM dual;
l_parameter_list.DELETE;
SELECT *
FROM OKL_TRX_REQUESTS
WHERE ID = p_id;
SELECT contract_number
FROM OKC_K_HEADERS_V
WHERE id=p_ctr_id;
PROCEDURE update_ppd_processed_status(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2)
AS
l_request_id NUMBER ;
SELECT object_Version_number
FROM okl_trx_requests
WHERE id=a_id;
okl_trx_requests_pub.update_trx_requests(
p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trqv_rec => l_trqv_rec,
x_trqv_rec => x_trqv_rec);
'update_ppd_processed_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
'update_ppd_processed_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_ppd_processed_status;
SELECT okl_wf_item_s.nextval
FROM dual;
l_parameter_list.DELETE;
SELECT *
FROM OKL_TRX_REQUESTS
WHERE ID = p_id;
SELECT contract_number
FROM OKC_K_HEADERS_V
WHERE id=p_ctr_id;
SELECT sty_id
FROM OKL_CNSLD_AR_STRMS_B
WHERE id=c_lsm_id;
okl_credit_memo_pub.insert_request(p_api_version => l_api_version,
p_init_msg_list => fnd_api.g_false,
-- p_lsm_id => l_lsm_id,
p_tld_id => l_lsm_id,
p_credit_amount => l_credit_amount,
p_credit_sty_id => l_sty_id,
p_transaction_source => l_transaction_source, -- vpanwar for bug no 6334774
x_tai_id => lx_tai_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
PROCEDURE update_crm_approved_status(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2)
AS
l_request_id NUMBER ;
SELECT object_Version_number
FROM okl_trx_requests
WHERE id=a_id;
okl_trx_requests_pub.update_trx_requests(
p_api_version => l_api_version,
p_init_msg_list =>fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trqv_rec => l_trqv_rec,
x_trqv_rec => x_trqv_rec);
'update_crm_approved_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_crm_approved_status;
PROCEDURE update_crm_rejected_status(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2)
AS
l_request_id NUMBER ;
SELECT object_Version_number
FROM okl_trx_requests
WHERE id=a_id;
okl_trx_requests_pub.update_trx_requests(
p_api_version => l_api_version,
p_init_msg_list =>fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trqv_rec => l_trqv_rec,
x_trqv_rec => x_trqv_rec);
'update_crm_rejected_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_crm_rejected_status;
PROCEDURE update_crm_success_status(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2)
AS
l_tai_id NUMBER ;
SELECT object_Version_number
FROM okl_trx_requests
WHERE id=a_id;
okl_trx_requests_pub.update_trx_requests(
p_api_version => l_api_version,
p_init_msg_list =>fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trqv_rec => l_trqv_rec,
x_trqv_rec => x_trqv_rec);
'update_crm_success_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_crm_success_status;
PROCEDURE update_crm_error_status(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2)
AS
l_request_id NUMBER ;
SELECT object_Version_number
FROM okl_trx_requests
WHERE id=a_id;
okl_trx_requests_pub.update_trx_requests(
p_api_version => l_api_version,
p_init_msg_list =>fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trqv_rec => l_trqv_rec,
x_trqv_rec => x_trqv_rec);
'update_crm_error_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_crm_error_status;