APPS.OKL_CREATE_STREAMS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

	 g_asset_ids.DELETE;

Line: 21

	 g_periodic_expenses_indexes.DELETE;

Line: 22

         g_periodic_incomes_indexes.DELETE;

Line: 23

         g_rents_indexes.DELETE;

Line: 24

	 g_sfe_ids.DELETE;

Line: 25

	 g_sil_ids.DELETE;

Line: 26

	 g_siy_names.DELETE;

Line: 57

       p_array_table.DELETE(l_nxt_row);

Line: 243

       p_array_table.DELETE(l_nxt_row);

Line: 272

       p_array_table.DELETE(l_nxt_row);

Line: 289

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

Line: 297

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

Line: 306

     SELECT pdt.reporting_pdt_id
       FROM okl_k_headers khr,
            okl_products_v pdt
      WHERE khr.id = p_khr_id
        AND khr.pdt_id = pdt.id(+);

Line: 346

  	lp_sifv_rec.sis_code := G_SIS_HDR_INSERTED;

Line: 503

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

Line: 511

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

Line: 543

  	lp_sifv_rec.sis_code := G_SIS_HDR_INSERTED;

Line: 669

  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

    -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
    cursor get_rebook_type is
    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from okl_sys_acct_opts;

Line: 760

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

Line: 763

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

Line: 774

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

Line: 804

  END insert_asset_lines;

Line: 820

	  SELECT ID
	  FROM  OKL_SIF_LINES
	  WHERE kle_id = p_kle_id;

Line: 827

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from okl_sys_acct_opts;

Line: 832

    select orig_contract_line_id
    from   okl_k_lines
    where  id = cp_subsidy_line_id;

Line: 940

	   l_sfev_one_off_tbl.DELETE;

Line: 945

	   l_sfev_one_off_tbl.DELETE;

Line: 956

	   l_sfev_one_off_tbl.DELETE;

Line: 980

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 1073

	   l_sfev_periodic_tbl.DELETE;

Line: 1077

	   l_sfev_periodic_tbl.DELETE;

Line: 1088

	   l_sfev_periodic_tbl.DELETE;

Line: 1111

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 1188

	   l_sfev_periodic_tbl.DELETE;

Line: 1192

	   l_sfev_periodic_tbl.DELETE;

Line: 1204

	   l_sfev_periodic_tbl.DELETE;

Line: 1256

	   l_siyv_tbl.DELETE;

Line: 1260

	   l_siyv_tbl.DELETE;

Line: 1272

	   l_siyv_tbl.DELETE;

Line: 1288

  	SELECT DISTINCT
  	KLE_ID, ID
  	FROM OKL_SIF_FEES
  	WHERE SIF_ID = p_sif_id
	AND kle_id IS NOT NULL;

Line: 1298

	  SELECT id FROM OKL_SIF_FEES
	  WHERE sfe_type = 'SFO'

	  AND INCOME_OR_EXPENSE = 'EXPENSE'
	);

Line: 1308

	SELECT NAME
	FROM OKL_STRM_TYPE_TL
	WHERE ID = p_sty_id
        AND LANGUAGE = USERENV('LANG'); -- smahapat fixed bug# 3323146

Line: 1317

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

Line: 1379

		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;

Line: 1422

	   l_sitv_tbl.DELETE;

Line: 1435

	   l_sitv_tbl.DELETE;

Line: 1457

	   l_sitv_tbl.DELETE;

Line: 1475

  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

    -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
    cursor get_rebook_type is
    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 1536

          OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

Line: 1539

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

Line: 1549

          OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

Line: 1587

  END insert_loan_lines;

Line: 1610

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 1724

	   l_sfev_periodic_tbl.DELETE;

Line: 1728

	   l_sfev_periodic_tbl.DELETE;

Line: 1740

	   l_sfev_periodic_tbl.DELETE;

Line: 1749

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

Line: 1788

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 1867

        x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);

Line: 1879

     x_csm_one_off_fee_tbl.DELETE(i);

Line: 1892

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

Line: 1920

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

Line: 1956

  END insert_rollover_fee_for_lease;

Line: 1963

|   -- 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  --this should have orig_contract_line_id populated
   ,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;

Line: 2000

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 2085

        x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);

Line: 2097

     x_csm_one_off_fee_tbl.DELETE(i);

Line: 2109

 		insert_loan_lines(p_api_version		=> p_api_version, --come back here
 	   		    	  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);

Line: 2117

/*insert into err_msgs_log values ('insert_loan_lines x_return_status'||x_return_status);

Line: 2136

insert into err_msgs_log values ('assign_loan_levels x_return_status'||x_return_status);

Line: 2144

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

Line: 2157

/*insert into err_msgs_log values ('Okl_Sif_Fees_Pub.insert_sif_fees x_return_status'||x_return_status);

Line: 2185

  END insert_finance_fee_for_lease;

Line: 2189

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

Line: 2230

    select nvl(amort_inc_adj_rev_dt_yn, 'N')
    from   okl_sys_acct_opts;

Line: 2319

        x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);

Line: 2331

     x_csm_one_off_fee_tbl.DELETE(i);

Line: 2359

  END insert_finance_fee_for_loan;

Line: 2361

  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;

Line: 2384

    OPEN update_sif_id_csr(p_trans_id);

Line: 2385

	FETCH update_sif_id_csr into l_sif_id, l_khr_id;

Line: 2386

    IF update_sif_id_csr%NOTFOUND THEN
      okl_api.set_message(p_app_name      => G_APP_NAME,
                          p_msg_name      => 'Transaction Number Not Found');

Line: 2393

	CLOSE update_sif_id_csr;

Line: 2396

	  UPDATE OKL_SIF_PRICING_PARAMS
	  SET SIF_ID = l_sif_id
	  WHERE SIF_ID IS NULL AND KHR_ID = l_khr_id;

Line: 2405

       IF update_sif_id_csr%ISOPEN THEN
	      CLOSE update_sif_id_csr;

Line: 2411

       IF update_sif_id_csr%ISOPEN THEN
	      CLOSE update_sif_id_csr;

Line: 2417

       IF update_sif_id_csr%ISOPEN THEN
	      CLOSE update_sif_id_csr;

Line: 2489

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

Line: 2499

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

Line: 2589

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

Line: 2598

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 2602

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

Line: 2612

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

Line: 2618

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 2634

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

Line: 2643

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

Line: 2660

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

Line: 2673

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

Line: 2703

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

Line: 2713

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

Line: 2723

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

Line: 2728

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 2781

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 2785

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

Line: 2796

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

Line: 2803

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 2836

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 2840

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

Line: 2851

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

Line: 2857

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 2885

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

Line: 2892

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

Line: 2903

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

Line: 2909

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

Line: 2938

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

Line: 2947

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

Line: 2958

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

Line: 2965

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

Line: 2979

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 2984

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

Line: 2996

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

Line: 3001

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 3132

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

Line: 3143

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

Line: 3230

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

Line: 3238

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 3241

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

Line: 3251

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

Line: 3256

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 3273

		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, --input param

					   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, --output param
					   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);

Line: 3290

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

Line: 3304

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

Line: 3313

                        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_loan_lines,return status is :'||l_return_status);

Line: 3339

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

Line: 3348

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

Line: 3359

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

Line: 3364

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 3394

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 3398

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

Line: 3408

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

Line: 3414

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 3445

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 3448

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

Line: 3458

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

Line: 3465

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 3488

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

Line: 3521

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

Line: 3529

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

Line: 3539

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

Line: 3545

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

Line: 3572

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

Line: 3579

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

Line: 3590

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

Line: 3596

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

Line: 3611

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 3616

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

Line: 3628

        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param,return status is :'||l_return_status);

Line: 3633

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 3728

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

Line: 3732

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

Line: 3744

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

Line: 3792

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

Line: 3796

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

Line: 3808

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

Line: 3887

	   l_siyv_tbl.DELETE;

Line: 3891

	   l_siyv_tbl.DELETE;

Line: 3902

	   l_siyv_tbl.DELETE;

Line: 3957

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

Line: 4041

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

Line: 4049

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 4052

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

Line: 4063

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 4077

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

Line: 4103

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

Line: 4112

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

Line: 4122

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4148

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4151

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

Line: 4161

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4187

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4190

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

Line: 4201

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4224

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

Line: 4231

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

Line: 4241

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

Line: 4264

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

Line: 4271

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

Line: 4283

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

Line: 4297

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 4302

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

Line: 4314

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 4426

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

Line: 4435

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

Line: 4526

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

Line: 4534

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 4538

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

Line: 4551

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 4566

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

Line: 4593

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

Line: 4623

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

Line: 4646

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

Line: 4658

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4683

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4686

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

Line: 4698

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4724

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4727

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

Line: 4738

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 4760

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

Line: 4767

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

Line: 4778

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

Line: 4800

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

Line: 4809

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

Line: 4820

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

Line: 4833

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 4838

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

Line: 4850

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

Line: 4957

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

Line: 5016

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

Line: 5026

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 5030

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

Line: 5041

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line: 5056

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

Line: 5077

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

Line: 5110

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

Line: 5118

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

Line: 5128

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 5155

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 5158

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

Line: 5168

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 5195

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 5198

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

Line: 5209

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

Line: 5230

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

Line: 5238

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

Line: 5249

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

Line: 5271

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

Line: 5278

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

Line: 5291

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');