The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT contract_number
FROM OKC_K_HEADERS_B
WHERE id = p_ctr_id1;
SELECT 'X'
FROM FND_LOOKUPS
WHERE lookup_type = 'OKL_REBOOK_REASON'
AND lookup_code = p_rebook_reason_code;
SELECT currency_code,
authoring_org_id
FROM okl_k_headers_full_v
WHERE id = p_chr_id;
SELECT id
FROM okl_trx_types_tl
WHERE LANGUAGE = 'US'
AND name = DECODE(p_trx_type,'REBOOK','Rebook',
'SPLIT', 'Split Contract',
'Error');
SELECT okl_txn_number_s.nextval
INTO l_id
FROM dual;
PROCEDURE update_trx_status(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
p_status IN VARCHAR2,
x_tcnv_rec OUT NOCOPY tcnv_rec_type
) IS
l_api_name VARCHAR2(35) := 'update_trx_status';
l_proc_name VARCHAR2(35) := 'UPDATE_TRX_STATUS';
SELECT id
FROM OKL_TRX_CONTRACTS
WHERE khr_id_new = p_chr_id_new
--rkuttiya added for 12.1.1 Multi GAAP
AND representation_type = 'PRIMARY';
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,
x_tcnv_rec => x_tcnv_rec
);
END update_trx_status;
SELECT start_date,
end_date
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT 'Y'
FROM DUAL
WHERE p_trx_date BETWEEN p_start_date AND p_end_date;
SELECT 'N'
FROM okc_k_lines_b okc ,
okc_line_styles_b ols,
okl_trx_assets trx ,
okl_txl_itm_insts itm
WHERE okc.dnz_chr_id = p_chr_id
AND okc.id = itm.kle_id
AND okc.lse_id = ols.id
AND ols.lty_code = 'INST_ITEM'
AND trx.tsu_code = 'ENTERED'
AND trx.tas_type = 'ALG'
AND trx.id = itm.tas_id ;
update_trx_status(
p_api_version => l_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_chr_id => l_rev_tbl(i).chr_id,
p_status => p_tsu_code,
x_tcnv_rec => x_tcnv_rec
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Trx UPDATE status: '|| x_return_status);
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_prbk_tcnv_rec,
x_tcnv_rec => x_prbk_tcnv_rec
);
okl_okc_migration_pvt.update_contract_header(
p_api_version => l_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_restricted_update => 'F',
p_chrv_rec => l_chrv_rec,
x_chrv_rec => x_chrv_rec
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Header UPDATE status: '|| x_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Line UPDATE status: '|| x_return_status);
SELECT id
FROM okl_trx_types_tl
WHERE LANGUAGE = 'US'
AND name = 'Service Integration';
SELECT currency_code,
authoring_org_id
FROM okl_k_headers_full_v
WHERE id = p_chr_id;
SELECT id
FROM okl_trx_types_tl
WHERE LANGUAGE = 'US'
AND name = 'Principal Paydown';
SELECT currency_code,
authoring_org_id
FROM okl_k_headers_full_v
WHERE id = p_chr_id;