DBA Data[Home] [Help]

APPS.OKL_TMPT_SET_PVT SQL Statements

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

Line: 112

 PROCEDURE update_tmpt_set(
    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_aesv_rec                     IN aesv_rec_type
   ,p_avlv_tbl                     IN avlv_tbl_type
   ,p_atlv_tbl                     IN atlv_tbl_type
   ,x_aesv_rec                     OUT NOCOPY aesv_rec_type
   ,x_avlv_tbl                     OUT NOCOPY avlv_tbl_type
   ,x_atlv_tbl                     OUT NOCOPY atlv_tbl_type
    )
	AS
   l_return_status         VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Line: 132

    update_tmpt_set(p_api_version,
    	            p_init_msg_list,
               	    x_return_status,
                    x_msg_count,
                    x_msg_data,
                    p_aesv_rec,
                    x_aesv_rec);
Line: 143

        update_template(p_api_version,
                        p_init_msg_list,
                        x_return_status,
                        x_msg_count,
                        x_msg_data,
                        p_avlv_tbl,
                        x_avlv_tbl);
Line: 154

           update_tmpt_lines(p_api_version,
                             p_init_msg_list,
                             x_return_status,
                             x_msg_count,
                             x_msg_data,
                             p_atlv_tbl,
                             x_atlv_tbl);
Line: 165

END UPDATE_TMPT_SET;
Line: 256

    okl_aes_pvt.insert_row(p_api_version,
                           p_init_msg_list,
                           x_return_status,
                           x_msg_count,
                           x_msg_data,
                           p_aesv_rec,
                           x_aesv_rec);
Line: 364

PROCEDURE update_tmpt_set(
    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_aesv_rec		    IN aesv_rec_type,
    x_aesv_rec              OUT NOCOPY aesv_rec_type) IS
BEGIN
    okl_aes_pvt.update_row(p_api_version,
                           p_init_msg_list,
                           x_return_status,
                           x_msg_count,
                           x_msg_data,
                           p_aesv_rec,
                           x_aesv_rec);
Line: 381

END update_tmpt_set;
Line: 383

PROCEDURE update_tmpt_set(
    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_aesv_tbl		    IN aesv_tbl_type,
    x_aesv_tbl              OUT NOCOPY aesv_tbl_type) IS

    l_overall_status        VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Line: 402

        update_tmpt_set(
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_aesv_rec                     => p_aesv_tbl(i),
          x_aesv_rec                     => x_aesv_tbl(i));
Line: 424

END update_tmpt_set;
Line: 427

PROCEDURE delete_tmpt_set(
    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_aesv_rec		    IN aesv_rec_type) IS

i	                    NUMBER :=0;
Line: 441

SELECT id
FROM okl_ae_templates
WHERE aes_id = p_aes_id;
Line: 462

  delete_template(p_api_version
                 ,p_init_msg_list
                 ,x_return_status
                 ,x_msg_count
                 ,x_msg_data
                 ,l_ae_template_tbl);
Line: 471

        delete_tmpt_set(p_api_version,
    		        p_init_msg_list,
    		        x_return_status,
    		        x_msg_count,
    		        x_msg_data,
    		        p_aesv_rec);
Line: 490

END delete_tmpt_set;
Line: 493

PROCEDURE delete_tmpt_set(
    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_aesv_tbl		    IN aesv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 509

	   delete_tmpt_set(
    	    p_api_version
    	   ,p_init_msg_list
    	   ,x_return_status
    	   ,x_msg_count
    	   ,x_msg_data
    	   ,p_aesv_tbl(i));
Line: 531

END delete_tmpt_set;
Line: 604

    okl_avl_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_avlv_rec,
    x_avlv_rec);
Line: 720

PROCEDURE update_template(
    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_avlv_rec		    IN avlv_rec_type,
    x_avlv_rec              OUT NOCOPY avlv_rec_type) IS
BEGIN

    OKL_AVL_PVT.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_avlv_rec,
    x_avlv_rec);
Line: 743

END update_template;
Line: 745

PROCEDURE update_template(
    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_avlv_tbl		    IN avlv_tbl_type,
    x_avlv_tbl              OUT NOCOPY avlv_tbl_type) IS
   l_overall_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 762

        update_template(
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_avlv_rec                     => p_avlv_tbl(i),
          x_avlv_rec                     => x_avlv_tbl(i));
Line: 784

END update_template;
Line: 787

PROCEDURE delete_template(
    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_avlv_rec		    IN avlv_rec_type) IS

i	                    NUMBER :=0;
Line: 800

SELECT ID
FROM OKL_AE_TMPT_LNES
WHERE avl_id = p_avlv_rec.ID;
Line: 816

   delete_tmpt_lines(p_api_version,
                     p_init_msg_list,
                     x_return_Status,
                     x_msg_count,
                     x_msg_data,
                     l_atlv_tbl);
Line: 825

        okl_avl_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_avlv_rec);
Line: 834

END delete_template;
Line: 838

PROCEDURE delete_template(
    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_avlv_tbl		    IN avlv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 855

          delete_template(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_avlv_tbl(i));
Line: 876

END delete_template;
Line: 944

    okl_atl_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_atlv_rec,
    x_atlv_rec);
Line: 1054

PROCEDURE update_tmpt_lines(
    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_atlv_rec		    IN atlv_rec_type,
    x_atlv_rec              OUT NOCOPY atlv_rec_type) IS
BEGIN
    okl_atl_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_atlv_rec,
    x_atlv_rec);
Line: 1076

END update_tmpt_lines;
Line: 1078

PROCEDURE update_tmpt_lines(
    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_atlv_tbl		    IN atlv_tbl_type,
    x_atlv_tbl              OUT NOCOPY atlv_tbl_type) IS
   l_overall_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1095

        update_tmpt_lines(
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_atlv_rec                     => p_atlv_tbl(i),
          x_atlv_rec                     => x_atlv_tbl(i));
Line: 1118

END update_tmpt_lines;
Line: 1121

	--Put custom code for cascade delete by developer
PROCEDURE delete_tmpt_lines(
    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_atlv_rec		    IN atlv_rec_type) IS
    i	                    NUMBER :=0;
Line: 1132

	--Delete the Master
        okl_atl_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_atlv_rec);
Line: 1141

END delete_tmpt_lines;
Line: 1143

PROCEDURE delete_tmpt_lines(
    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_atlv_tbl		    IN atlv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 1160

          delete_tmpt_lines(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_atlv_tbl(i));
Line: 1181

END delete_tmpt_lines;