The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM okc_k_headers_b CHR
where chr.ID = p_chr_id
AND nvl(chr.orig_system_source_code,'XXXX') = 'OKL_RELEASE';
SELECT 'Y'
FROM okc_k_headers_b CHR
WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
and chr.ID = p_chr_id
AND exists (SELECT '1'
FROM OKC_RULES_B rul
WHERE rul.dnz_chr_id = chr.id
AND rul.rule_information_category = 'LARLES'
AND nvl(rule_information1,'N') = 'Y');
select mo_global.get_current_org_id() l_fnd_profile
from dual;
select cust_trx_type_id l_cust_trx_type_id
from ra_cust_trx_types
where name = 'Invoice-OKL';
select ct.object1_id1 id
from okc_contacts ct,
okc_contact_sources csrc,
okc_k_party_roles_b pty,
okc_k_headers_b chr
where ct.cpl_id = pty.id
and ct.cro_code = csrc.cro_code
and ct.jtot_object1_code = csrc.jtot_object_code
and ct.dnz_chr_id = chr.id
and pty.rle_code = csrc.rle_code
and csrc.cro_code = 'SALESPERSON'
and csrc.rle_code = 'LESSOR'
and csrc.buy_or_sell = chr.buy_or_sell
and pty.dnz_chr_id = chr.id
and pty.chr_id = chr.id
and chr.id = chrId;
select bill_to_site_use_id cust_acct_site_id
from okc_k_headers_b
where id = chrId;
select object1_id1 cust_acct_site_id
from okc_rules_b rul
where rul.rule_information_category = 'BTO'
and exists (select '1'
from okc_rule_groups_b rgp
where rgp.id = rul.rgp_id
and rgp.rgd_code = 'LABILL'
and rgp.chr_id = rul.dnz_chr_id
and rgp.chr_id = chrId );
SELECT khr.pdt_id product_id
,NULL product_name
,khr.sts_code contract_status
,khr.start_date start_date
,khr.currency_code currency_code
,khr.authoring_org_id authoring_org_id
,khr.currency_conversion_rate currency_conversion_rate
,khr.currency_conversion_type currency_conversion_type
,khr.currency_conversion_date currency_conversion_date
--Bug# 4622198
,khr.scs_code
--Bug# 5964482: Accounting Engine CR
--Bug# 6073872: DFF attributes are being taken from okc_k_headers instead of okl_k_headers
,khr.khr_attribute_category
,khr.khr_attribute1
,khr.khr_attribute2
,khr.khr_attribute3
,khr.khr_attribute4
,khr.khr_attribute5
,khr.khr_attribute6
,khr.khr_attribute7
,khr.khr_attribute8
,khr.khr_attribute9
,khr.khr_attribute10
,khr.khr_attribute11
,khr.khr_attribute12
,khr.khr_attribute13
,khr.khr_attribute14
,khr.khr_attribute15
FROM okl_k_headers_full_v khr
WHERE khr.id = p_contract_id;
SELECT id trx_try_id
FROM okl_trx_types_tl
WHERE name = p_transaction_type
AND language = 'US';
select description,
lookup_code
from fnd_lookup_values
where language = 'US'
AND lookup_type = lkp_type
AND meaning = mng;
Select txh.ID HeaderTransID,
txh.date_transaction_occurred date_transaction_occurred,
txh.tsu_code
From okl_trx_contracts txh
Where txh.tcn_type = tcntype
and txh.khr_id = khrId
--rkuttiya added for 12.1.1 Multi GAAP
and txh.representation_type = 'PRIMARY';
SELECT contract_number
FROM OKC_K_HEADERS_B
WHERE id = p_ctr_id1;
SELECT COUNT (*)
FROM (SELECT COUNT(*)
FROM okc_k_lines_b cleb,
okl_k_lines kle
WHERE kle.id = cleb.id
AND cleb.chr_id = chrId
--ndani - 27-Mar-2013 - Bug# 16558722 - Start
AND cleb.dnz_chr_id = chrid
AND cleb.lse_id = 33
AND cleb.sts_code <> 'ABANDONED'
--ndani - 27-Mar-2013 - Bug# 16558722 - End
GROUP BY NVL(kle.re_lease_yn,'N')
);
Okl_Trx_Contracts_Pub.update_trx_contracts(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => x_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_tcnv_rec => l_upd_trxH_rec
,x_tcnv_rec => lx_upd_trxH_rec);
/*l_trxl_del_tbl.delete;
okl_trx_contracts_pub.delete_trx_cntrct_lines(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tclv_tbl => l_trxl_del_tbl);
l_amount_tbl.delete;
Okl_Trx_Contracts_Pub.update_trx_contracts
(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_tcnv_rec => l_tcnv_rec
,p_tclv_tbl => l_tclv_tbl
,x_tcnv_rec => x_tcnv_rec
,x_tclv_tbl => x_tclv_tbl );
/*-------Bug# 5964482 : Commented code to update header and Lines with Amount--------------------
--as new code has been incorporated above-----------------------------------------------------
-- Check Status
IF(x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
l_trxH_in_rec.amount := 0;
Okl_Trx_Contracts_Pub.update_trx_contracts(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => x_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_tcnv_rec => l_trxH_in_rec
,x_tcnv_rec => l_trxH_out_rec);
Okl_Trx_Contracts_Pub.update_trx_cntrct_lines(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => x_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_tclv_rec => l_trxL_in_rec
,x_tclv_rec => l_trxL_out_rec);
okl_contract_status_pub.update_contract_status(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_passStatus,
p_chr_id );
okl_contract_status_pub.update_contract_status(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_failStatus,
p_chr_id );