The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_asset_ids.DELETE;
g_periodic_expenses_indexes.DELETE;
g_periodic_incomes_indexes.DELETE;
g_rents_indexes.DELETE;
g_sfe_ids.DELETE;
g_sil_ids.DELETE;
g_siy_names.DELETE;
p_array_table.DELETE(l_nxt_row);
p_array_table.DELETE(l_nxt_row);
p_array_table.DELETE(l_nxt_row);
SELECT template_name,template_path
FROM OKL_PRD_PRICE_TMPLS
WHERE pdt_id = p_pdt_id
AND l_date BETWEEN start_date AND NVL(end_date,l_date);
SELECT id
FROM okl_stream_interfaces
WHERE khr_id = l_contract_id AND transaction_number = l_trx_number
AND sis_code IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED,G_SIS_PROCESS_COMPLETE);
lp_sifv_rec.sis_code := G_SIS_HDR_INSERTED;
SELECT template_name,template_path
FROM OKL_PRD_PRICE_TMPLS
WHERE pdt_id = p_pdt_id
AND l_date BETWEEN start_date AND NVL(end_date,l_date);
SELECT id
FROM okl_stream_interfaces
WHERE khr_id = l_contract_id AND transaction_number = l_trx_number
AND sis_code IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED,G_SIS_PROCESS_COMPLETE);
lp_sifv_rec.sis_code := G_SIS_HDR_INSERTED;
PROCEDURE insert_asset_lines(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_sif_id IN NUMBER
,p_csm_line_details_tbl IN csm_line_details_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
lp_silv_rec silv_rec_type;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
Okl_Sif_Lines_Pub.insert_sif_lines(
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_silv_rec => lp_silv_rec
,x_silv_rec => lx_silv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
END insert_asset_lines;
SELECT ID
FROM OKL_SIF_LINES
WHERE kle_id = p_kle_id;
l_sfev_one_off_tbl.DELETE;
l_sfev_one_off_tbl.DELETE;
l_sfev_one_off_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_siyv_tbl.DELETE;
l_siyv_tbl.DELETE;
l_siyv_tbl.DELETE;
SELECT DISTINCT
KLE_ID, ID
FROM OKL_SIF_FEES
WHERE SIF_ID = p_sif_id
AND kle_id IS NOT NULL;
SELECT id FROM OKL_SIF_FEES
WHERE sfe_type = 'SFO'
AND INCOME_OR_EXPENSE = 'EXPENSE'
);
SELECT NAME
FROM OKL_STRM_TYPE_TL
WHERE ID = p_sty_id
AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146
SELECT
ID
FROM OKL_SIF_FEES
WHERE SIF_ID = p_sif_id
AND SIL_ID = p_sil_id
AND (level_index_number = 0 OR level_index_number IS NULL)
AND DESCRIPTION = p_description
-- bug 3548593 smahapat added to filter out one time expenses
-- since streams are not generated
AND id NOT IN (
SELECT id FROM OKL_SIF_FEES
WHERE sfe_type = 'SFO'
AND INCOME_OR_EXPENSE = 'EXPENSE'
);
SELECT
ID
INTO l_sitv_tbl(i).sfe_id
FROM OKL_SIF_FEES
WHERE SIF_ID = p_sif_id
AND SIL_ID = l_sitv_tbl(i).sil_id
--AND SFE_TYPE = 'SFR' -- 04/10/2002
-- 04/23/2002,mvasudev
AND (level_index_number = 0 OR level_index_number IS NULL)
-- 05/03/2002,mvasudev
AND DESCRIPTION = l_sty_name;
l_sitv_tbl.DELETE;
l_sitv_tbl.DELETE;
l_sitv_tbl.DELETE;
PROCEDURE insert_loan_lines(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_sif_id IN NUMBER
,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
lp_silv_rec silv_rec_type;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
Okl_Sif_Lines_Pub.insert_sif_lines(
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_silv_rec => lp_silv_rec
,x_silv_rec => lx_silv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
END insert_loan_lines;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
l_sfev_periodic_tbl.DELETE;
| -- PROCEDURE insert_rollover_fee_for_lease |
| -- This procedure takes care of inserting rollover fee loan lines with in |
| -- a lease. It checks for the fee type 'FINACED' to identify rollover fee. |
| -- Assigns and Inserts Loan Line AND LOAN LEVEL details for this Contract |
+==========================================================================================*/
PROCEDURE insert_rollover_fee_for_lease(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_sif_id IN NUMBER
,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
,x_csm_one_off_fee_tbl OUT NOCOPY csm_one_off_fee_tbl_type
,x_csm_periodic_expenses_tbl OUT NOCOPY csm_periodic_expenses_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
lp_silv_rec silv_rec_type;
x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);
x_csm_one_off_fee_tbl.DELETE(i);
insert_loan_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => p_sif_id,
p_csm_loan_lines_tbl => l_csm_loan_lines_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_loan_levels_tbl
,x_sfev_tbl => lx_sfev_loan_levels_tbl);
END insert_rollover_fee_for_lease;
| -- PROCEDURE insert_finance_fee_for_lease |
| -- This procedure takes care of inserting finance fee loan lines with in |
| -- a lease. It checks for the fee type 'FINACED' to identify finance fee. |
| -- Assigns and Inserts Loan Line AND LOAN LEVEL details for this Contract |
+==========================================================================================*/
PROCEDURE insert_finance_fee_for_lease(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_sif_id IN NUMBER
,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
,x_csm_one_off_fee_tbl OUT NOCOPY csm_one_off_fee_tbl_type
,x_csm_periodic_expenses_tbl OUT NOCOPY csm_periodic_expenses_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
lp_silv_rec silv_rec_type;
x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);
x_csm_one_off_fee_tbl.DELETE(i);
insert_loan_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => p_sif_id,
p_csm_loan_lines_tbl => l_csm_loan_lines_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
/*insert into err_msgs_log values ('insert_loan_lines x_return_status'||x_return_status);
insert into err_msgs_log values ('assign_loan_levels x_return_status'||x_return_status);
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_loan_levels_tbl
,x_sfev_tbl => lx_sfev_loan_levels_tbl);
/*insert into err_msgs_log values ('Okl_Sif_Fees_Pub.insert_sif_fees x_return_status'||x_return_status);
END insert_finance_fee_for_lease;
| -- PROCEDURE insert_finance_fee_for_loan |
| -- This procedure takes care of inserting finance fee loan lines with in |
| -- a loan. It checks for the fee type 'FINACED' to identify finance fee. |
| -- Assigns and Inserts Loan Line AND LOAN LEVEL details for this Contract |
+=========================================================================================*/
PROCEDURE insert_finance_fee_for_loan(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_sif_id IN NUMBER
,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
,x_csm_one_off_fee_tbl OUT NOCOPY csm_one_off_fee_tbl_type
,x_csm_periodic_expenses_tbl OUT NOCOPY csm_periodic_expenses_tbl_type
,x_csm_loan_lines_tbl OUT NOCOPY csm_loan_line_tbl_type
,x_csm_loan_levels_tbl OUT NOCOPY csm_loan_level_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
lp_silv_rec silv_rec_type;
x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);
x_csm_one_off_fee_tbl.DELETE(i);
END insert_finance_fee_for_loan;
PROCEDURE Update_Pricing_Param (
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
,p_trans_id IN NUMBER
,x_sif_id OUT NOCOPY NUMBER
,x_khr_id OUT NOCOPY NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
CURSOR update_sif_id_csr(p_trans_id NUMBER)
IS
SELECT id, khr_id
FROM okl_stream_interfaces
WHERE transaction_number = p_trans_id;
OPEN update_sif_id_csr(p_trans_id);
FETCH update_sif_id_csr into l_sif_id, l_khr_id;
IF update_sif_id_csr%NOTFOUND THEN
okl_api.set_message(p_app_name => G_APP_NAME,
p_msg_name => 'Transaction Number Not Found');
CLOSE update_sif_id_csr;
UPDATE OKL_SIF_PRICING_PARAMS
SET SIF_ID = l_sif_id
WHERE SIF_ID IS NULL AND KHR_ID = l_khr_id;
IF update_sif_id_csr%ISOPEN THEN
CLOSE update_sif_id_csr;
IF update_sif_id_csr%ISOPEN THEN
CLOSE update_sif_id_csr;
IF update_sif_id_csr%ISOPEN THEN
CLOSE update_sif_id_csr;
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE khr_id = p_khr_id
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
);
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
);
-- Insert Transaction Header Data
-- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces, return status is:'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
insert_asset_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_line_details_tbl => p_csm_line_details_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_asset_lines, the return status is :'||l_return_status);
insert_finance_fee_for_lease(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_one_off_fee_tbl => p_csm_one_off_fee_tbl,
p_csm_periodic_expenses_tbl => p_csm_periodic_expenses_tbl,
x_csm_one_off_fee_tbl => x_csm_one_off_fee_tbl,
x_csm_periodic_expenses_tbl => x_csm_periodic_expenses_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_finance_fee_for_lease, the return status is :'||l_return_status);
-- Insert Rent Details
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_rent_tbl
,x_sfev_tbl => lx_sfev_rent_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_one_off_tbl
,x_sfev_tbl => lx_sfev_one_off_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_periodic_tbl
,x_sfev_tbl => lx_sfev_periodic_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
-- Insert Yield Data corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
Okl_Sif_Yields_Pub.insert_sif_yields(
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_siyv_tbl => lp_siyv_tbl
,x_siyv_tbl => lx_siyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields, the return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
-- Insert StreamTypes corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
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_sitv_tbl => lp_sitv_tbl
,x_sitv_tbl => lx_sitv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Stream_Types_Pub.insert_sif_stream_types, the return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
Update_Pricing_Param (
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,p_trans_id => lx_sifv_rec.transaction_number
,x_sif_id => l_sif_id
,x_khr_id => l_khr_id
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param, the return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE khr_id = p_khr_id
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
);
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
);
-- Insert Transaction Header Data
-- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
insert_finance_fee_for_loan(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_one_off_fee_tbl => p_csm_one_off_fee_tbl,
p_csm_periodic_expenses_tbl => p_csm_periodic_expenses_tbl,
p_csm_loan_lines_tbl => p_csm_loan_lines_tbl,
p_csm_loan_levels_tbl => p_csm_loan_levels_tbl,
x_csm_one_off_fee_tbl => x_csm_one_off_fee_tbl,
x_csm_periodic_expenses_tbl => x_csm_periodic_expenses_tbl,
x_csm_loan_lines_tbl => x_csm_loan_lines_tbl,
x_csm_loan_levels_tbl => x_csm_loan_levels_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_finance_fee_for_loan,return status is :'||l_return_status);
insert_loan_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_loan_lines_tbl => x_csm_loan_lines_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_loan_lines,return status is :'||l_return_status);
-- Insert Loan Levels
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_loan_levels_tbl
,x_sfev_tbl => lx_sfev_loan_levels_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_one_off_tbl
,x_sfev_tbl => lx_sfev_one_off_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_periodic_expenses_tbl
,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_SIF_FEES_PUB.insert_sif_fees(
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_sfev_tbl => lp_sfev_periodic_incomes_tbl
,x_sfev_tbl => lx_sfev_periodic_incomes_tbl);
-- Insert Yield Data corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
Okl_Sif_Yields_Pub.insert_sif_yields(
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_siyv_tbl => lp_siyv_tbl
,x_siyv_tbl => lx_siyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
-- Insert StreamTypes corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
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_sitv_tbl => lp_sitv_tbl
,x_sitv_tbl => lx_sitv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Stream_Types_Pub.insert_sif_stream_types,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
Update_Pricing_Param (
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,p_trans_id => lx_sifv_rec.transaction_number
,x_sif_id => l_sif_id
,x_khr_id => l_khr_id
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param,return status is :'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
Okl_Stream_Interfaces_Pub.update_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
Okl_Stream_Interfaces_Pub.update_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
l_siyv_tbl.DELETE;
l_siyv_tbl.DELETE;
l_siyv_tbl.DELETE;
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE jtot_object1_code = p_csm_lease_header.jtot_object1_code
AND object1_id1 = p_csm_lease_header.object1_id1
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST)
);
-- Insert Transaction Header Data
-- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
insert_asset_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_line_details_tbl => p_csm_line_details_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
-- Insert Rent Details
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_rent_tbl
,x_sfev_tbl => lx_sfev_rent_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_one_off_tbl
,x_sfev_tbl => lx_sfev_one_off_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_periodic_tbl
,x_sfev_tbl => lx_sfev_periodic_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
-- Insert Yield Data corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
Okl_Sif_Yields_Pub.insert_sif_yields(
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_siyv_tbl => lp_siyv_tbl
,x_siyv_tbl => lx_siyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
-- Insert StreamTypes corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
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_sitv_tbl => lp_sitv_tbl
,x_sitv_tbl => lx_sitv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
Update_Pricing_Param (
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,p_trans_id => lx_sifv_rec.transaction_number
,x_sif_id => l_sif_id
,x_khr_id => l_khr_id
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE jtot_object1_code = p_csm_loan_header.jtot_object1_code
AND object1_id1 = p_csm_loan_header.object1_id1
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST)
);
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE khr_id = p_csm_loan_header.khr_id
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
);
-- Insert Transaction Header Data
-- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
insert_finance_fee_for_loan(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_one_off_fee_tbl => p_csm_one_off_fee_tbl,
p_csm_periodic_expenses_tbl => p_csm_periodic_expenses_tbl,
p_csm_loan_lines_tbl => p_csm_loan_lines_tbl,
p_csm_loan_levels_tbl => p_csm_loan_levels_tbl,
x_csm_one_off_fee_tbl => x_csm_one_off_fee_tbl,
x_csm_periodic_expenses_tbl => x_csm_periodic_expenses_tbl,
x_csm_loan_lines_tbl => x_csm_loan_lines_tbl,
x_csm_loan_levels_tbl => x_csm_loan_levels_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
insert_loan_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_loan_lines_tbl => x_csm_loan_lines_tbl,
--smahapat changed for bug 4131347
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
-- Insert Loan Levels
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_loan_levels_tbl
,x_sfev_tbl => lx_sfev_loan_levels_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_one_off_tbl
,x_sfev_tbl => lx_sfev_one_off_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_periodic_expenses_tbl
,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
-- Insert Yield Data corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
Okl_Sif_Yields_Pub.insert_sif_yields(
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_siyv_tbl => lp_siyv_tbl
,x_siyv_tbl => lx_siyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
-- Insert StreamTypes corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
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_sitv_tbl => lp_sitv_tbl
,x_sitv_tbl => lx_sitv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
Update_Pricing_Param (
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,p_trans_id => lx_sifv_rec.transaction_number
,x_sif_id => l_sif_id
,x_khr_id => l_khr_id
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
SELECT '1' FROM dual
WHERE EXISTS
(SELECT '1'
FROM OKL_STREAM_INTERFACES
WHERE khr_id = p_khr_id
AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
);
-- Insert Transaction Header Data
-- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
IF(L_DEBUG_ENABLED='Y') THEN
L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
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_sifv_rec => lp_sifv_rec
,x_sifv_rec => lx_sifv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
insert_asset_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_line_details_tbl => p_csm_line_details_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
insert_finance_fee_for_lease(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_sif_id => l_sif_id,
p_csm_one_off_fee_tbl => p_csm_one_off_fee_tbl,
p_csm_periodic_expenses_tbl => p_csm_periodic_expenses_tbl,
x_csm_one_off_fee_tbl => x_csm_one_off_fee_tbl,
x_csm_periodic_expenses_tbl => x_csm_periodic_expenses_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
-- Insert Rent Details
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_rent_tbl
,x_sfev_tbl => lx_sfev_rent_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_one_off_tbl
,x_sfev_tbl => lx_sfev_one_off_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
Okl_Sif_Fees_Pub.insert_sif_fees(
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_sfev_tbl => lp_sfev_periodic_tbl
,x_sfev_tbl => lx_sfev_periodic_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
-- Insert Yield Data corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
Okl_Sif_Yields_Pub.insert_sif_yields(
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_siyv_tbl => lp_siyv_tbl
,x_siyv_tbl => lx_siyv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
-- Insert StreamTypes corresponding to this Transaction
-- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
IF(IS_DEBUG_PROCEDURE_ON) THEN
BEGIN
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
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_sitv_tbl => lp_sitv_tbl
,x_sitv_tbl => lx_sitv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');