The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT name
FROM okl_products
WHERE id = pdt_id;
SELECT quality_val, quality_name
FROM okl_prod_qlty_val_uv
WHERE pdt_id = p_id
AND QUALITY_NAME IN ('LEASE', 'INVESTOR');
SELECT quality_val
FROM okl_prod_qlty_val_uv
WHERE pdt_id = p_id
AND QUALITY_NAME = 'TAXOWNER';
SELECT name,
short_name
FROM gl_ledgers
WHERE ledger_id = set_of_books_id;
SELECT pdt_id
FROM okl_k_headers
WHERE id = p_khr_id;
okl_tcn_pvt.insert_row(
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
);
PROCEDURE update_trx_contracts(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tcnv_rec IN tcnv_rec_type,
p_tclv_tbl IN tclv_tbl_type,
x_tcnv_rec OUT NOCOPY tcnv_rec_type,
x_tclv_tbl OUT NOCOPY tclv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
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 => p_tcnv_rec
,x_tcnv_rec => x_tcnv_rec
);
update_trx_cntrct_lines(
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_tclv_tbl => p_tclv_tbl
,x_tclv_tbl => x_tclv_tbl
);
END update_trx_contracts;
PROCEDURE update_trx_contracts(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tcnv_rec IN tcnv_rec_type
,x_tcnv_rec OUT NOCOPY tcnv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
okl_tcn_pvt.update_row(
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 -- Bug#5707866
,x_tcnv_rec => x_tcnv_rec
);
END update_trx_contracts;
PROCEDURE update_trx_contracts(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tcnv_tbl IN tcnv_tbl_type
,x_tcnv_tbl OUT NOCOPY tcnv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_trx_contracts(
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => p_tcnv_tbl(i),
x_tcnv_rec => x_tcnv_tbl(i));
END update_trx_contracts;
PROCEDURE delete_trx_contracts(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tcnv_rec IN tcnv_rec_type) IS
i NUMBER :=0;
SELECT tcl.id
FROM OKL_TXL_CNTRCT_LNS tcl
WHERE tcl.tcn_id = p_tcnv_rec.id;
delete_trx_cntrct_lines( 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_tclv_tbl => l_tclv_tbl);
okl_tcn_pvt.delete_row(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 => p_tcnv_rec);
END delete_trx_contracts;
PROCEDURE delete_trx_contracts(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tcnv_tbl IN tcnv_tbl_type) IS
i NUMBER :=0;
delete_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 => p_tcnv_tbl(i)
);
END delete_trx_contracts;
SELECT
code,
stream_type_purpose
FROM
OKL_STRM_TYPE_B
WHERE
id = sty_id;
okl_tcl_pvt.insert_row(
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_tclv_rec => l_tclv_rec
,x_tclv_rec => x_tclv_rec
);
PROCEDURE update_trx_cntrct_lines(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tclv_rec IN tclv_rec_type
,x_tclv_rec OUT NOCOPY tclv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
okl_tcl_pvt.update_row(
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_tclv_rec => p_tclv_rec
,x_tclv_rec => x_tclv_rec
);
END update_trx_cntrct_lines;
PROCEDURE update_trx_cntrct_lines(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tclv_tbl IN tclv_tbl_type
,x_tclv_tbl OUT NOCOPY tclv_tbl_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
update_trx_cntrct_lines(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tclv_rec => p_tclv_tbl(i),
x_tclv_rec => x_tclv_tbl(i));
END update_trx_cntrct_lines;
PROCEDURE delete_trx_cntrct_lines(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tclv_rec IN tclv_rec_type) IS
i NUMBER :=0;
okl_tcl_pvt.delete_row(
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_tclv_rec => p_tclv_rec);
END delete_trx_cntrct_lines;
PROCEDURE delete_trx_cntrct_lines(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_tclv_tbl IN tclv_tbl_type) IS
i NUMBER :=0;
delete_trx_cntrct_lines(
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_tclv_rec => p_tclv_tbl(i));
END delete_trx_cntrct_lines;