DBA Data[Home] [Help]

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: 334

  	lp_sifv_rec.sis_code := G_SIS_HDR_INSERTED;
Line: 476

      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: 484

	  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: 516

  	lp_sifv_rec.sis_code := G_SIS_HDR_INSERTED;
Line: 642

  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;
Line: 711

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

		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: 725

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

  END insert_asset_lines;
Line: 771

	  SELECT ID
	  FROM  OKL_SIF_LINES
	  WHERE kle_id = p_kle_id;
Line: 854

	   l_sfev_one_off_tbl.DELETE;
Line: 859

	   l_sfev_one_off_tbl.DELETE;
Line: 870

	   l_sfev_one_off_tbl.DELETE;
Line: 964

	   l_sfev_periodic_tbl.DELETE;
Line: 968

	   l_sfev_periodic_tbl.DELETE;
Line: 979

	   l_sfev_periodic_tbl.DELETE;
Line: 1059

	   l_sfev_periodic_tbl.DELETE;
Line: 1063

	   l_sfev_periodic_tbl.DELETE;
Line: 1075

	   l_sfev_periodic_tbl.DELETE;
Line: 1127

	   l_siyv_tbl.DELETE;
Line: 1131

	   l_siyv_tbl.DELETE;
Line: 1143

	   l_siyv_tbl.DELETE;
Line: 1159

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

	  SELECT id FROM OKL_SIF_FEES
	  WHERE sfe_type = 'SFO'

	  AND INCOME_OR_EXPENSE = 'EXPENSE'
	);
Line: 1179

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

	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: 1250

		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: 1293

	   l_sitv_tbl.DELETE;
Line: 1306

	   l_sitv_tbl.DELETE;
Line: 1328

	   l_sitv_tbl.DELETE;
Line: 1346

  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;
Line: 1386

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

      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: 1399

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

  END insert_loan_lines;
Line: 1557

	   l_sfev_periodic_tbl.DELETE;
Line: 1561

	   l_sfev_periodic_tbl.DELETE;
Line: 1573

	   l_sfev_periodic_tbl.DELETE;
Line: 1582

|   -- 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: 1673

        x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);
Line: 1685

     x_csm_one_off_fee_tbl.DELETE(i);
Line: 1698

 		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: 1726

	     	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: 1762

  END insert_rollover_fee_for_lease;
Line: 1769

|   -- 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;
Line: 1861

        x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);
Line: 1873

     x_csm_one_off_fee_tbl.DELETE(i);
Line: 1885

 		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: 1893

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

insert into err_msgs_log values ('assign_loan_levels x_return_status'||x_return_status);
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: 1933

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

  END insert_finance_fee_for_lease;
Line: 1965

|   -- 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: 2061

        x_csm_periodic_expenses_tbl.delete(l_periodic_expense_counter);
Line: 2073

     x_csm_one_off_fee_tbl.DELETE(i);
Line: 2101

  END insert_finance_fee_for_loan;
Line: 2103

  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: 2126

    OPEN update_sif_id_csr(p_trans_id);
Line: 2127

	FETCH update_sif_id_csr into l_sif_id, l_khr_id;
Line: 2128

    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: 2135

	CLOSE update_sif_id_csr;
Line: 2138

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

       IF update_sif_id_csr%ISOPEN THEN
	      CLOSE update_sif_id_csr;
Line: 2153

       IF update_sif_id_csr%ISOPEN THEN
	      CLOSE update_sif_id_csr;
Line: 2159

       IF update_sif_id_csr%ISOPEN THEN
	      CLOSE update_sif_id_csr;
Line: 2231

		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: 2241

		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: 2331

	   	-- 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: 2340

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

	 	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: 2354

                  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: 2360

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

	 		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: 2385

                          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: 2400

		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: 2413

                          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: 2441

		     	-- 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: 2451

	     	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: 2461

                          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: 2466

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

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

   	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: 2534

          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: 2541

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

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

	     	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: 2589

                          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: 2595

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

	     	-- 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: 2630

     	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: 2641

                  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: 2647

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

		  -- 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: 2685

			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: 2696

                        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: 2703

        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: 2717

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

  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: 2734

        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: 2739

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

	      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: 2881

		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: 2968

	   	-- 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: 2976

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

	 	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: 2989

                  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: 2994

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

		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: 3028

                  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: 3042

	 		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: 3051

                        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: 3077

		     	-- 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: 3086

	     	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: 3097

                          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: 3102

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

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

	     	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: 3146

                          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: 3152

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

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

	     	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: 3196

                          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: 3203

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

	     	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: 3259

	     	-- 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: 3267

	     	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: 3277

                          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: 3283

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

		  -- 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: 3317

			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: 3328

                          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: 3334

        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: 3349

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

  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: 3366

        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: 3371

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

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

	 	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: 3482

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

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

	 	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: 3546

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

	   l_siyv_tbl.DELETE;
Line: 3629

	   l_siyv_tbl.DELETE;
Line: 3640

	   l_siyv_tbl.DELETE;
Line: 3695

	      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: 3779

	   	-- 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: 3787

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

	 	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: 3801

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

	 		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: 3841

		     	-- 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: 3850

	     	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: 3860

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

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

	     	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: 3899

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

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

	     	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: 3939

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

	     	-- 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: 3969

	     	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: 3979

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

		  -- 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: 4009

			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: 4021

        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: 4035

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

  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: 4052

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

		    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: 4173

			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: 4264

	   	-- 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: 4272

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

	 	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: 4289

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

		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: 4331

	 		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: 4361

		     	-- 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: 4384

	     	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: 4396

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

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

	     	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: 4436

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

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

	     	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: 4476

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

	     	-- 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: 4505

	     	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: 4516

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

		  -- 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: 4547

			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: 4558

        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: 4571

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

  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: 4588

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

		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: 4754

	   	-- 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: 4764

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

	 	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: 4779

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

	 		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: 4813

		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: 4845

		     	-- 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: 4853

	     	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: 4863

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

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

	     	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: 4903

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

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

	     	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: 4944

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

	     	-- 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: 4973

	     	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: 4984

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

		  -- 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: 5013

			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: 5026

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