APPS.OKL_POPULATE_PRCENG_RESULT_PVT SQL Statements

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

Line: 9

    SELECT
            ID,
            TRANSACTION_NUMBER,
            SRT_CODE,
            EFFECTIVE_PRE_TAX_YIELD,
            YIELD_NAME,
            INDEX_NUMBER,
            EFFECTIVE_AFTER_TAX_YIELD,
            NOMINAL_PRE_TAX_YIELD,
            NOMINAL_AFTER_TAX_YIELD,
			STREAM_INTERFACE_ATTRIBUTE01,
			STREAM_INTERFACE_ATTRIBUTE02,
			STREAM_INTERFACE_ATTRIBUTE03,
			STREAM_INTERFACE_ATTRIBUTE04,
			STREAM_INTERFACE_ATTRIBUTE05,
			STREAM_INTERFACE_ATTRIBUTE06,
			STREAM_INTERFACE_ATTRIBUTE07,
			STREAM_INTERFACE_ATTRIBUTE08,
			STREAM_INTERFACE_ATTRIBUTE09,
			STREAM_INTERFACE_ATTRIBUTE10,
			STREAM_INTERFACE_ATTRIBUTE11,
			STREAM_INTERFACE_ATTRIBUTE12,
			STREAM_INTERFACE_ATTRIBUTE13,
			STREAM_INTERFACE_ATTRIBUTE14,
   			STREAM_INTERFACE_ATTRIBUTE15,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            IMPLICIT_INTEREST_RATE,
            DATE_PROCESSED,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE
            -- end,mvasudev -- 02/21/2002
      FROM Okl_Sif_Rets_V
     WHERE okl_sif_rets_v.id    = p_id;

Line: 84

              l_sirv_rec.LAST_UPDATED_BY,
              l_sirv_rec.CREATION_DATE,
              l_sirv_rec.LAST_UPDATE_DATE,
              l_sirv_rec.LAST_UPDATE_LOGIN,
              l_sirv_rec.IMPLICIT_INTEREST_RATE,
              l_sirv_rec.DATE_PROCESSED,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            l_sirv_rec.REQUEST_ID,
            l_sirv_rec.PROGRAM_APPLICATION_ID,
            l_sirv_rec.PROGRAM_ID,
            l_sirv_rec.PROGRAM_UPDATE_DATE;

Line: 118

    OKL_SIF_RETS_PUB.insert_sif_rets(p_api_version   => p_api_version,
                                     p_init_msg_list => p_init_msg_list,
                                     x_return_status => l_return_status,
                                     x_msg_count     => x_msg_count,
                                     x_msg_data      => x_msg_data,
                                     p_sirv_rec      => p_sirv_rec,
                                     x_sirv_rec      => x_sirv_rec);

Line: 154

  PROCEDURE update_sif_rets(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_sirv_rec                     IN  sirv_rec_type,
                              x_sirv_rec                     OUT NOCOPY sirv_rec_type
  ) IS
    l_api_name  CONSTANT VARCHAR2(30) := 'update_sif_rets';

Line: 282

	IF(p_sirv_rec.program_update_date <> G_MISS_DATE)
	THEN
	  l_sirv_rec.program_update_date := p_sirv_rec.program_update_date;

Line: 287

    OKL_SIF_RETS_PUB.update_sif_rets(p_api_version   => p_api_version,
                                     p_init_msg_list => p_init_msg_list,
                                     x_return_status => l_return_status,
                                     x_msg_count     => x_msg_count,
                                     x_msg_data      => x_msg_data,
                                     p_sirv_rec      => l_sirv_rec,
                                     x_sirv_rec      => x_sirv_rec);

Line: 319

  END update_sif_rets;

Line: 339

    OKL_SIF_RET_STRMS_PUB.insert_sif_ret_strms_per(
                          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_srsv_rec      => p_srsv_rec,
                          x_srsv_rec      => x_srsv_rec);

Line: 393

    OKL_SIF_RET_ERRORS_PUB.insert_sif_ret_errors(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_srmv_rec      => p_srmv_rec,
                                                 x_srmv_rec      => x_srmv_rec);

Line: 443

    OKL_SIF_RET_LEVELS_PUB.insert_sif_ret_levels(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_srlv_rec      => p_srlv_rec,
                                                 x_srlv_rec      => x_srlv_rec);

Line: 481

  PROCEDURE update_outbound_status (
    p_api_version    IN NUMBER,
    p_init_msg_list  IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    p_sifv_rec       IN sifv_rec_type,
    x_sifv_rec       OUT NOCOPY sifv_rec_type,
    x_msg_count      OUT NOCOPY NUMBER,
    x_msg_data       OUT NOCOPY VARCHAR2,
    x_return_status  OUT NOCOPY VARCHAR2) IS
    l_return_status  VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line: 490

    l_api_name  CONSTANT VARCHAR2(30) := 'update_outbound_status';

Line: 496

    OKL_SIF_RET_STRMS_PUB.MASS_INSERT_SIF_RET(p_srsv_tbl=>  G_SRSV_TBL);

Line: 503

    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 => p_sifv_rec
	 	       ,x_sifv_rec => x_sifv_rec);

Line: 527

  END update_outbound_status;