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;
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);