DBA Data[Home] [Help]

APPS.OKL_STREAMS_PVT SQL Statements

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

Line: 176

    Okl_Stm_Pvt.insert_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_stmv_rec      => p_stmv_rec
                          ,x_stmv_rec      => x_stmv_rec
                          );
Line: 222

    Okl_Stm_Pvt.insert_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_stmv_tbl      => p_stmv_tbl
                          ,x_stmv_tbl      => x_stmv_tbl
                          );
Line: 279

    okl_stm_pvt.insert_row_perf(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_stmv_tbl,
    x_stmv_tbl);
Line: 344

  PROCEDURE update_streams(
    p_api_version           IN  NUMBER,
    p_init_msg_list         IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_stmv_rec              IN  stmv_rec_type,
    p_selv_tbl              IN  selv_tbl_type,
    x_stmv_rec              OUT NOCOPY stmv_rec_type,
    x_selv_tbl              OUT NOCOPY selv_tbl_type) IS
    l_return_status         VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Line: 357

    update_streams(
                         p_api_version   => p_api_version
                        ,p_init_msg_list => p_init_msg_list
                        ,x_return_status => x_return_status
                        ,x_msg_count     => x_msg_count
                        ,x_msg_data      => x_msg_data
                        ,p_stmv_rec      => p_stmv_rec
                        ,x_stmv_rec      => x_stmv_rec
                        );
Line: 373

    update_stream_elements(
                              p_api_version   => p_api_version
                             ,p_init_msg_list => p_init_msg_list
                             ,x_return_status => x_return_status
                             ,x_msg_count     => x_msg_count
                             ,x_msg_data      => x_msg_data
                             ,p_selv_tbl      => p_selv_tbl
                             ,x_selv_tbl      => x_selv_tbl
                             );
Line: 404

  END update_streams;
Line: 543

  PROCEDURE update_streams(
     p_api_version                IN  NUMBER
    ,p_init_msg_list              IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status              OUT NOCOPY VARCHAR2
    ,x_msg_count                  OUT NOCOPY NUMBER
    ,x_msg_data                   OUT NOCOPY VARCHAR2
    ,p_stmv_rec                   IN  stmv_rec_type
    ,x_stmv_rec                   OUT NOCOPY stmv_rec_type) IS
    l_return_status               VARCHAR2(1)   := Okc_Api.G_RET_STS_SUCCESS;
Line: 554

    Okl_Stm_Pvt.update_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_stmv_rec      => p_stmv_rec
                          ,x_stmv_rec      => x_stmv_rec
                          );
Line: 581

  END update_streams;
Line: 583

  PROCEDURE update_streams(
     p_api_version                IN  NUMBER
    ,p_init_msg_list              IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status              OUT NOCOPY VARCHAR2
    ,x_msg_count                  OUT NOCOPY NUMBER
    ,x_msg_data                   OUT NOCOPY VARCHAR2
    ,p_stmv_tbl                   IN  stmv_tbl_type
    ,x_stmv_tbl                   OUT NOCOPY stmv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := Okc_Api.G_RET_STS_SUCCESS;
Line: 593

    Okl_Stm_Pvt.update_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_stmv_tbl      => p_stmv_tbl
                          ,x_stmv_tbl      => x_stmv_tbl
                          );
Line: 620

  END update_streams;
Line: 623

  PROCEDURE delete_streams(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status         OUT NOCOPY VARCHAR2
    ,x_msg_count             OUT NOCOPY NUMBER
    ,x_msg_data              OUT NOCOPY VARCHAR2
    ,p_stmv_rec              IN  stmv_rec_type) IS
    i                        NUMBER :=0;
Line: 635

      SELECT sel.id
        FROM OKL_STRM_ELEMENTS sel
       WHERE sel.stm_id = p_stmv_rec.id;
Line: 645

      delete_stream_elements(
                                p_api_version   => p_api_version
                               ,p_init_msg_list => p_init_msg_list
                               ,x_return_status => x_return_status
                               ,x_msg_count     => x_msg_count
                               ,x_msg_data      => x_msg_data
                               ,p_selv_tbl      => l_selv_tbl
                               );
Line: 661

    Okl_Stm_Pvt.delete_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_stmv_rec      => p_stmv_rec
                          );
Line: 689

  END delete_streams;
Line: 691

  PROCEDURE delete_streams(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status         OUT NOCOPY VARCHAR2
    ,x_msg_count             OUT NOCOPY NUMBER
    ,x_msg_data              OUT NOCOPY VARCHAR2
    ,p_stmv_tbl              IN  stmv_tbl_type) IS
    i                        NUMBER :=0;
Line: 706

        delete_streams(
                             p_api_version   => p_api_version
                            ,p_init_msg_list => p_init_msg_list
                            ,x_return_status => x_return_status
                            ,x_msg_count     => x_msg_count
                            ,x_msg_data      => x_msg_data
                            ,p_stmv_rec      => p_stmv_tbl(i)
                            );
Line: 737

  END delete_streams;
Line: 825

    Okl_Sel_Pvt.insert_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_selv_rec      => p_selv_rec
                          ,x_selv_rec      => x_selv_rec
                          );
Line: 865

    Okl_Sel_Pvt.insert_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_selv_tbl      => p_selv_tbl
                          ,x_selv_tbl      => x_selv_tbl
                          );
Line: 970

  PROCEDURE update_stream_elements(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_selv_rec                       IN  selv_rec_type
    ,x_selv_rec                       OUT NOCOPY selv_rec_type) IS
    l_return_status                   VARCHAR2(1)   := Okc_Api.G_RET_STS_SUCCESS;
Line: 981

    Okl_Sel_Pvt.update_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_selv_rec      => p_selv_rec
                          ,x_selv_rec      => x_selv_rec
                          );
Line: 1008

  END update_stream_elements;
Line: 1010

  PROCEDURE update_stream_elements(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_selv_tbl                       IN  selv_tbl_type
    ,x_selv_tbl                       OUT NOCOPY selv_tbl_type) IS
    l_return_status                   VARCHAR2(1)   := Okc_Api.G_RET_STS_SUCCESS;
Line: 1021

    Okl_Sel_Pvt.update_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_selv_tbl      => p_selv_tbl
                          ,x_selv_tbl      => x_selv_tbl
                          );
Line: 1048

  END update_stream_elements;
Line: 1051

  PROCEDURE delete_stream_elements(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_selv_rec                       IN  selv_rec_type) IS
    i                                 NUMBER :=0;
Line: 1061

    Okl_Sel_Pvt.delete_row(
                           p_api_version   => p_api_version
                          ,p_init_msg_list => p_init_msg_list
                          ,x_return_status => x_return_status
                          ,x_msg_count     => x_msg_count
                          ,x_msg_data      => x_msg_data
                          ,p_selv_rec      => p_selv_rec);
Line: 1086

  END delete_stream_elements;
Line: 1088

  PROCEDURE delete_stream_elements(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_selv_tbl                       IN  selv_tbl_type) IS

    i                                 NUMBER :=0;
Line: 1104

        delete_stream_elements(
                                  p_api_version   => p_api_version
                                 ,p_init_msg_list => p_init_msg_list
                                 ,x_return_status => x_return_status
                                 ,x_msg_count     => x_msg_count
                                 ,x_msg_data      => x_msg_data
                                 ,p_selv_rec      => p_selv_tbl(i));
Line: 1133

  END delete_stream_elements;
Line: 1224

      	   INSERT INTO OKL_STREAMS_H
        	   (
                major_version,
      	  	  ID,
      	  	  TRANSACTION_NUMBER,
      	  	  OBJECT_VERSION_NUMBER,
      	  	  SGN_CODE,
      	  	  SAY_CODE,
      	  	  STY_ID,
      	  	  KLE_ID,
      	  	  KHR_ID,
      	  	  ACTIVE_YN,
      	  	  PURPOSE_CODE,
      	  	  DATE_CURRENT,
      	  	  DATE_WORKING,
      	  	  DATE_HISTORY,
      	  	  COMMENTS,
      	  	  CREATED_BY,
      	  	  CREATION_DATE,
      	  	  LAST_UPDATED_BY,
      	  	  LAST_UPDATE_DATE,
      	  	  PROGRAM_ID,
      	  	  REQUEST_ID,
      	  	  PROGRAM_APPLICATION_ID,
      	  	  PROGRAM_UPDATE_DATE,
      	  	  LAST_UPDATE_LOGIN ,
      	  	  STM_ID,
      	  	  SOURCE_ID,
        	  SOURCE_TABLE,
--HKPATEL changed for bug 4212626
			  TRX_ID,
			  LINK_HIST_STREAM_ID

      		  )
        	   SELECT
            	  p_major_version,
      		  ID,
      		  TRANSACTION_NUMBER,
      		  OBJECT_VERSION_NUMBER,
      		  SGN_CODE,
      		  SAY_CODE,
      		  STY_ID,
      		  KLE_ID,
      		  KHR_ID,
      		  ACTIVE_YN,
      		  PURPOSE_CODE,
      		  DATE_CURRENT,
      		  DATE_WORKING,
      		  DATE_HISTORY,
      		  COMMENTS,
      		  CREATED_BY,
      		  CREATION_DATE,
      		  LAST_UPDATED_BY,
      		  LAST_UPDATE_DATE,
      		  PROGRAM_ID,
      		  REQUEST_ID,
      		  PROGRAM_APPLICATION_ID,
      		  PROGRAM_UPDATE_DATE,
      		  LAST_UPDATE_LOGIN ,
      		  STM_ID,
      		  SOURCE_ID,
        	  SOURCE_TABLE,
--HKPATEL changed for bug 4212626
			  TRX_ID,
			  LINK_HIST_STREAM_ID

        	   FROM OKL_STREAMS
        	   WHERE
        	   say_code = 'CURR' and
        	   khr_id = p_khr_id;
Line: 1329

      	INSERT INTO OKL_STRM_ELEMENTS_H
        	(
                MAJOR_VERSION,
      	 	  ID ,
      	  	  SE_LINE_NUMBER ,
      	  	  DATE_BILLED ,
      	  	  STM_ID ,
      	  	  OBJECT_VERSION_NUMBER ,
      	  	  STREAM_ELEMENT_DATE ,
      	  	  AMOUNT ,
      	  	  COMMENTS ,
      	  	  ACCRUED_YN ,
      	  	  PROGRAM_ID ,
      	  	  REQUEST_ID,
      	  	  PROGRAM_APPLICATION_ID,
      	  	  PROGRAM_UPDATE_DATE ,
      	  	  CREATED_BY ,
      	  	  CREATION_DATE ,
      	  	  LAST_UPDATED_BY ,
      	  	  LAST_UPDATE_DATE ,
      	  	  LAST_UPDATE_LOGIN ,
      	  	  SEL_ID ,
      	  	  SOURCE_ID ,
      		  SOURCE_TABLE,
--HKPATEL changed for bug 4212626
			  BILL_ADJ_FLAG,
			  ACCRUAL_ADJ_FLAG

         )
         SELECT
            	  p_major_version,
      		  ID ,
      		  SE_LINE_NUMBER ,
                DATE_BILLED ,
                STM_ID ,
                OBJECT_VERSION_NUMBER ,
                STREAM_ELEMENT_DATE ,
                AMOUNT ,
                COMMENTS ,
                ACCRUED_YN ,
                PROGRAM_ID ,
                REQUEST_ID,
                PROGRAM_APPLICATION_ID,
                PROGRAM_UPDATE_DATE ,
                CREATED_BY ,
                CREATION_DATE ,
                LAST_UPDATED_BY ,
                LAST_UPDATE_DATE ,
                LAST_UPDATE_LOGIN ,
                SEL_ID ,
                SOURCE_ID,
      		  SOURCE_TABLE,
--HKPATEL changed for bug 4212626
			  BILL_ADJ_FLAG,
			  ACCRUAL_ADJ_FLAG

        	FROM OKL_STRM_ELEMENTS
        	WHERE stm_id in (Select id from OKL_STREAMS where khr_id = p_khr_id and say_code ='CURR');
Line: 1416

          	select 'x'
          	from OKL_K_HEADERS
          	where id = l_khr_id;
Line: 1421

          	select 'x'
          	from OKL_STREAMS_H
          	where khr_id = l_khr_id and major_version = l_major_version ;