The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE
FROM DUAL;
SELECT '1'
FROM okl_lease_opportunities_b
WHERE reference_number = p_reference_number
AND id <> NVL(p_lease_opp_rec.id, -9999);
okl_lop_pvt.insert_row(
p_api_version => G_API_VERSION
,p_init_msg_list => G_TRUE
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lopv_rec => l_lease_opp_rec
,x_lopv_rec => x_lease_opp_rec
);
UPDATE okl_quick_quotes_b SET
lease_opportunity_id = x_lease_opp_rec.id
,currency_code = l_lease_opp_rec.currency_code
,program_agreement_id = l_lease_opp_rec.program_agreement_id
WHERE id = p_quick_quote_id;
PROCEDURE update_lease_opp (p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_transaction_control IN VARCHAR2,
p_lease_opp_rec IN lease_opp_rec_type,
x_lease_opp_rec OUT NOCOPY lease_opp_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_program_name CONSTANT VARCHAR2(30) := 'update_lease_opp';
okl_lop_pvt.update_row(
p_api_version => G_API_VERSION
,p_init_msg_list => G_TRUE
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lopv_rec => l_lease_opp_rec
,x_lopv_rec => x_lease_opp_rec);
END update_lease_opp;
SELECT lsq.id
FROM okl_lease_quotes_b lsq
WHERE lsq.parent_object_code = 'LEASEOPP'
AND lsq.parent_object_id = p_lease_opp_id;
SELECT qqh.id
FROM okl_quick_quotes_b qqh
WHERE lease_opportunity_id = p_lease_opp_id;
DELETE FROM okl_quick_quote_lines_tl WHERE id IN (SELECT id FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id);
DELETE FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id;
DELETE FROM okl_quick_quotes_b WHERE id = l_qqh.id;
DELETE FROM okl_quick_quotes_tl WHERE id = l_qqh.id;
Select object_version_number
into l_lopv_rec.object_version_number
from Okl_lease_opportunities_b
where id = p_lease_opp_id;
update_lease_opp (p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,p_transaction_control => p_transaction_control
,p_lease_opp_rec => l_lopv_rec
,x_lease_opp_rec => q_lopv_rec
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
SELECT property_tax_applicable,
bill_property_tax
FROM okl_property_tax_setups
WHERE org_id = mo_global.get_current_org_id();
SELECT okl_util.get_next_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER') FROM DUAL;--Bug 7022258-Modified by kkorrapo
SELECT rep.salesrep_id sales_rep_id
,rep.name sales_rep_name
FROM jtf_rs_salesreps rep
,jtf_rs_resource_extns res
WHERE rep.org_id = mo_global.get_current_org_id()
AND rep.resource_id = res.resource_id
AND res.user_id = G_USER_ID;
SELECT descriptive_flexfield_name
FROM fnd_descriptive_flexs
WHERE table_application_id = 540
AND application_table_name = 'OKL_LEASE_OPPORTUNITIES_B'
AND context_column_name = 'ATTRIBUTE_CATEGORY'
AND freeze_flex_definition_flag = 'Y';