[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
p_id IN NUMBER,
p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
Okl_Populate_Prceng_Result_Pvt.update_sif_rets(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sirv_rec => l_sirv_rec,
x_sirv_rec => x_sirv_rec);
END update_sif_rets;
PROCEDURE update_sif_rets (x_return_status OUT NOCOPY VARCHAR2,
p_id IN NUMBER,
p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
Okl_Populate_Prceng_Result_Pvt.update_sif_rets(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sirv_rec => l_sirv_rec,
x_sirv_rec => x_sirv_rec);
END update_sif_rets;
PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
p_id IN NUMBER,
p_yield_name IN VARCHAR2,
p_amount IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
Okl_Populate_Prceng_Result_Pvt.update_sif_rets(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
p_sirv_rec => l_sirv_rec,
x_sirv_rec => lx_sirv_rec);
END update_sif_rets;
PROCEDURE update_sif_rets (p_id IN NUMBER,
p_yield_name IN VARCHAR2,
p_amount IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
Okl_Populate_Prceng_Result_Pvt.update_sif_rets(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
p_sirv_rec => l_sirv_rec,
x_sirv_rec => lx_sirv_rec);
END update_sif_rets;
okl_srs_pvt.insert_row_upg(p_srsv_tbl => l_srsv_tbl);
SELECT khr_id
FROM okl_stream_interfaces
WHERE transaction_number = trx_number;
SELECT start_date
FROM okc_k_headers_b
WHERE id = khr_id;
SELECT khr_id
FROM okl_stream_interfaces
WHERE transaction_number = trx_number;
SELECT start_date
FROM okc_k_headers_b
WHERE id = khr_id;
PROCEDURE update_status (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
p_transaction_number IN NUMBER,
p_sis_code IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
) IS
-- cursor to update transaction status in the OKL_STREAM_INTERFACES table
CURSOR sif_data_csr (trx_number IN NUMBER) IS
SELECT
ID,ORP_CODE
FROM Okl_Stream_Interfaces
WHERE okl_stream_interfaces.transaction_number = trx_number;
OKL_POPULATE_PRCENG_RESULT_PVT.update_status (p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sifv_rec => lp_sifv_rec,
x_sifv_rec => lx_sifv_rec,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
x_return_status => l_return_status);
END update_status;
PROCEDURE update_status (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
p_transaction_number IN NUMBER,
p_sis_code IN VARCHAR2, -- outbound status
p_srt_code IN VARCHAR2, -- inbound status
p_log_file_name IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
) IS
-- cursor to update transaction status in the OKL_STREAM_INTERFACES table
CURSOR sif_data_csr (trx_number IN NUMBER) IS
SELECT
ID,ORP_CODE
FROM Okl_Stream_Interfaces
WHERE okl_stream_interfaces.transaction_number = trx_number;
SELECT
ID
FROM Okl_Sif_Rets
WHERE okl_sif_rets.transaction_number = trx_number;
Okl_Populate_Prceng_Result_Pvt.update_outbound_status (p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sifv_rec => lp_sifv_rec,
x_sifv_rec => lx_sifv_rec,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
x_return_status => l_return_status);
Okl_Populate_Prceng_Result_Pvt.update_sif_rets (p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sirv_rec => lp_sirv_rec,
x_sirv_rec => lx_sirv_rec,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
x_return_status => l_return_status);
END update_status;
PROCEDURE update_status (
p_transaction_number IN NUMBER,
p_sis_code IN VARCHAR2, -- outbound status
p_srt_code IN VARCHAR2, -- inbound status
p_log_file_name IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
) IS
-- cursor to update transaction status in the OKL_STREAM_INTERFACES table
CURSOR sif_data_csr (trx_number IN NUMBER) IS
SELECT
ID,ORP_CODE
FROM Okl_Stream_Interfaces
WHERE okl_stream_interfaces.transaction_number = trx_number;
SELECT
ID
FROM Okl_Sif_Rets
WHERE okl_sif_rets.transaction_number = trx_number;
Okl_Populate_Prceng_Result_Pvt.update_outbound_status (p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
p_sifv_rec => lp_sifv_rec,
x_sifv_rec => lx_sifv_rec,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
x_return_status => l_return_status);
Okl_Populate_Prceng_Result_Pvt.update_sif_rets (p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
p_sirv_rec => lp_sirv_rec,
x_sirv_rec => lx_sirv_rec,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data,
x_return_status => l_return_status);
END update_status;
SELECT
SIS_CODE
FROM Okl_Stream_Interfaces
WHERE okl_stream_interfaces.transaction_number = trx_number;
update_status (p_transaction_number => p_transaction_number,
p_sis_code => l_failure_code, -- outbound status
p_srt_code => l_failure_code, -- inbound status
p_log_file_name => l_log_file_name_pre || p_transaction_number || l_log_file_name_ext,
x_return_status => l_return_status);
SELECT
ORP_CODE, KHR_ID
FROM okl_stream_interfaces
WHERE okl_stream_interfaces.transaction_number = p_trx_number;
SELECT chr.orig_system_source_code,
chr.start_date,
chr.end_date,
chr.template_yn,
chr.authoring_org_id,
chr.inv_organization_id,
khr.deal_type,
pdt.id pid,
NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
chr.currency_code currency_code,
khr.term_duration term
--srsreeni Bug6004114 start
-- FROM okc_k_headers_v chr,
FROM okc_k_headers_all_b chr,
--srsreeni Bug6004114 end
okl_k_headers khr,
okl_products_v pdt
WHERE khr.id = chr.id
AND chr.id = chrId
AND khr.pdt_id = pdt.id(+);
OKL_POPULATE_PRCENG_RST_PUB.UPDATE_STATUS(--p_api_version => l_api_version,
--p_init_msg_list => l_init_msg_list,
p_transaction_number => l_transaction_number,
p_sis_code => G_SIS_CODE,
p_srt_code => G_SRT_CODE,
p_log_file_name => 'OKLSTXMLG_' || l_transaction_number || '.log',
x_return_status => l_return_status
);
OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_khr_id => l_khr_id,
p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_khr_id => l_khr_id,
p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);