[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT h.id, h.tas_type, date_trans_occurred, depreciate_yn, dnz_asset_id, corporate_book, in_service_date,
deprn_method,life_in_months, nvl(depreciation_cost,0) depreciation_cost , asset_number, old_residual_value,
new_residual_value, kle_id, dnz_khr_id, contract_number, sts_code
FROM OKL_TRX_ASSETS h, okl_txl_assets_v l, okc_k_headers_b khr
WHERE h.id = l.tas_id
AND h.tsu_code NOT IN ('PROCESSED')
AND h.tas_type = 'ARC'
AND khr.id = l.dnz_khr_id
AND h.date_trans_occurred <= p_sysdate
AND (
-- all 2 parameter values are provided
( p_khr_id IS NOT NULL AND p_kle_id IS NOT NULL AND
l.dnz_khr_id = p_khr_id AND l.kle_id = p_kle_id)
OR
-- none of the parameter values are provided
( p_khr_id IS NULL AND p_kle_id IS NULL)
OR
-- contract Id is provided, kle_id not provided
(p_khr_id IS NOT NULL AND l.dnz_khr_id = p_khr_id AND p_kle_id IS NULL)
OR
-- contract Id is not provided, kle_id is provided
(p_khr_id IS NULL AND p_kle_id IS NOT NULL AND l.kle_id = p_kle_id)
)
ORDER BY h.last_update_date;
SELECT count(*)
FROM okl_trx_quotes_b
WHERE qst_code = 'ACCEPTED'
AND khr_id = p_khr_id;
SELECT SYSDATE INTO l_sysdate FROM DUAL;
OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thpv_rec => lp_thpv_rec,
x_thpv_rec => lx_thpv_rec);
OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thpv_rec => lp_thpv_rec,
x_thpv_rec => lx_thpv_rec);
fnd_msg_pub.delete_msg;