DBA Data[Home] [Help]

APPS.OKC_STD_ARTICLE_PUB SQL Statements

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

Line: 17

    l_saev_rec.last_updated_by       := p_saev_rec1.last_updated_by;
Line: 18

    l_saev_rec.last_update_date      := p_saev_rec1.last_update_date;
Line: 19

    l_saev_rec.last_update_login     := p_saev_rec1.last_update_login;
Line: 52

    l_sacv_rec.last_updated_by       := p_sacv_rec1.last_updated_by;
Line: 53

    l_sacv_rec.last_update_date      := p_sacv_rec1.last_update_date;
Line: 54

    l_sacv_rec.last_update_login     := p_sacv_rec1.last_update_login;
Line: 70

    l_saiv_rec.last_updated_by       := p_saiv_rec1.last_updated_by;
Line: 71

    l_saiv_rec.last_update_date      := p_saiv_rec1.last_update_date;
Line: 72

    l_saiv_rec.last_update_login     := p_saiv_rec1.last_update_login;
Line: 87

    l_savv_rec.last_updated_by       := p_savv_rec1.last_updated_by;
Line: 88

    l_savv_rec.last_update_date      := p_savv_rec1.last_update_date;
Line: 89

    l_savv_rec.last_update_login     := p_savv_rec1.last_update_login;
Line: 125

    l_samv_rec.last_updated_by       := p_samv_rec1.last_updated_by;
Line: 126

    l_samv_rec.last_update_date      := p_samv_rec1.last_update_date;
Line: 127

    l_samv_rec.last_update_login     := p_samv_rec1.last_update_login;
Line: 185

 PROCEDURE Update_std_article(
	p_api_version 		IN NUMBER,
	p_init_msg_list 	IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saev_rec		IN saev_rec_type,
	p_savv_tbl		IN savv_tbl_type,
	p_saiv_tbl		IN saiv_tbl_type,
	p_samv_tbl		IN samv_tbl_type,
	x_saev_rec		OUT NOCOPY saev_rec_type,
	x_savv_tbl		OUT NOCOPY savv_tbl_type,
	x_saiv_tbl		OUT NOCOPY saiv_tbl_type,
	x_samv_tbl		OUT NOCOPY samv_tbl_type) IS
 BEGIN
         x_return_status := OKC_API.G_RET_STS_SUCCESS;
Line: 201

   	 OKC_STD_ARTICLE_PVT.update_std_article(
            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_saev_rec	=>	 p_saev_rec,
	    p_savv_tbl	=>	 p_savv_tbl,
	    p_saiv_tbl	=>	 p_saiv_tbl,
	    p_samv_tbl	=>	 p_samv_tbl,
	    x_saev_rec	=>	 x_saev_rec,
	    x_savv_tbl	=>	 x_savv_tbl,
	    x_saiv_tbl	=>	 x_saiv_tbl,
	    x_samv_tbl	=>	 x_samv_tbl);
Line: 225

 END Update_std_article;
Line: 398

PROCEDURE update_std_article(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saev_rec		IN saev_rec_type,
	x_saev_rec		OUT NOCOPY saev_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 407

     l_api_name                     CONSTANT VARCHAR2(30) := 'UPDATE_STD_ARTICLE';
Line: 429

     OKC_STD_ARTICLE_PVT.update_std_article(
                         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_saev_rec            => l_saev_rec,
                         x_saev_rec            => x_saev_rec);
Line: 478

 END update_std_article;
Line: 481

PROCEDURE update_std_article(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saev_tbl		IN saev_tbl_type,
	x_saev_tbl		OUT NOCOPY saev_tbl_type) IS
     i				    NUMBER := 0;
Line: 497

       		update_std_article(
                         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_saev_rec            => p_saev_tbl(i),
                         x_saev_rec            => x_saev_tbl(i));
Line: 528

END update_std_article;
Line: 532

PROCEDURE delete_std_article(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saev_rec		IN saev_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 540

     l_api_name                     CONSTANT VARCHAR2(30) := 'DELETE_STD_ARTICLE';
Line: 560

     OKC_STD_ARTICLE_PVT.delete_std_article(
                         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_saev_rec            => l_saev_rec);
Line: 608

END delete_std_article;
Line: 610

PROCEDURE delete_std_article(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saev_tbl		IN saev_tbl_type) IS
     i				    NUMBER := 0;
Line: 625

       		delete_std_article(
                         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_saev_rec            => p_saev_tbl(i));
Line: 655

 END delete_std_article;
Line: 1044

PROCEDURE update_std_art_version(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_savv_rec		IN savv_rec_type,
	x_savv_rec		OUT NOCOPY savv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1053

     l_api_name                     CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_VERSION';
Line: 1075

     OKC_STD_ARTICLE_PVT.update_std_art_version(
                         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_savv_rec            => l_savv_rec,
                         x_savv_rec            => x_savv_rec);
Line: 1124

 END update_std_art_version;
Line: 1126

PROCEDURE update_std_art_version(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_savv_tbl		IN savv_tbl_type,
	x_savv_tbl		OUT NOCOPY savv_tbl_type) IS
     i				    NUMBER := 0;
Line: 1142

       		update_std_art_version(
                         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_savv_rec            => p_savv_tbl(i),
                         x_savv_rec            => x_savv_tbl(i));
Line: 1173

 END update_std_art_version;
Line: 1241

PROCEDURE delete_std_art_version(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_savv_rec		IN savv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1249

     l_api_name                     CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_VERSION';
Line: 1271

     OKC_STD_ARTICLE_PVT.delete_std_art_version(
                         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_savv_rec            => l_savv_rec);
Line: 1319

 END delete_std_art_version;
Line: 1321

PROCEDURE delete_std_art_version(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_savv_tbl		IN savv_tbl_type) IS
     i				    NUMBER := 0;
Line: 1336

       		delete_std_art_version(
                         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_savv_rec            => p_savv_tbl(i));
Line: 1366

 END delete_std_art_version;
Line: 1936

PROCEDURE update_std_art_incmpt(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saiv_rec		IN saiv_rec_type,
	x_saiv_rec		OUT NOCOPY saiv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1945

     l_api_name                     CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_INCMPT';
Line: 1967

     OKC_STD_ARTICLE_PVT.update_std_art_incmpt(
                         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_saiv_rec            => l_saiv_rec,
                         x_saiv_rec            => x_saiv_rec);
Line: 2016

 END update_std_art_incmpt;
Line: 2018

PROCEDURE update_std_art_incmpt(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saiv_tbl		IN saiv_tbl_type,
	x_saiv_tbl		OUT NOCOPY saiv_tbl_type) IS
     i				    NUMBER := 0;
Line: 2034

       		update_std_art_incmpt(
                         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_saiv_rec            => p_saiv_tbl(i),
                         x_saiv_rec            => x_saiv_tbl(i));
Line: 2065

 END update_std_art_incmpt;
Line: 2132

PROCEDURE delete_std_art_incmpt(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saiv_rec		IN saiv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 2140

     l_api_name                     CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_INCMPT';
Line: 2162

     OKC_STD_ARTICLE_PVT.delete_std_art_incmpt(
                         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_saiv_rec            => l_saiv_rec);
Line: 2210

 END delete_std_art_incmpt;
Line: 2212

PROCEDURE delete_std_art_incmpt(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_saiv_tbl		IN saiv_tbl_type) IS
      i				    NUMBER := 0;
Line: 2227

       		delete_std_art_incmpt(
                         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_saiv_rec            => p_saiv_tbl(i));
Line: 2257

 END delete_std_art_incmpt;
Line: 2524

PROCEDURE update_std_art_classing(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_sacv_rec		IN sacv_rec_type,
	x_sacv_rec		OUT NOCOPY sacv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 2533

     l_api_name                     CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_CLASSING';
Line: 2555

     OKC_STD_ARTICLE_PVT.update_std_art_classing(
                         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_sacv_rec            => l_sacv_rec,
                         x_sacv_rec            => x_sacv_rec);
Line: 2604

 END update_std_art_classing;
Line: 2608

PROCEDURE update_std_art_classing(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_sacv_tbl		IN sacv_tbl_type,
	x_sacv_tbl		OUT NOCOPY sacv_tbl_type) IS
     i				    NUMBER := 0;
Line: 2624

       		update_std_art_classing(
                         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_sacv_rec            => p_sacv_tbl(i),
                         x_sacv_rec            => x_sacv_tbl(i));
Line: 2655

 END update_std_art_classing;
Line: 2724

PROCEDURE delete_std_art_classing(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_sacv_rec		IN sacv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 2732

     l_api_name                     CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_CLASSING';
Line: 2754

     OKC_STD_ARTICLE_PVT.delete_std_art_classing(
                         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_sacv_rec            => l_sacv_rec);
Line: 2802

 END delete_std_art_classing;
Line: 2804

PROCEDURE delete_std_art_classing(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_sacv_tbl		IN sacv_tbl_type) IS
     i				    NUMBER := 0;
Line: 2819

       		delete_std_art_classing(
                         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_sacv_rec            => p_sacv_tbl(i));
Line: 2849

 END delete_std_art_classing;
Line: 3180

PROCEDURE update_std_art_set_mem(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_samv_rec		IN samv_rec_type,
	x_samv_rec		OUT NOCOPY samv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 3189

     l_api_name                     CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_SET_MEM';
Line: 3211

     OKC_STD_ARTICLE_PVT.update_std_art_set_mem(
                         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_samv_rec            => l_samv_rec,
                         x_samv_rec            => x_samv_rec);
Line: 3260

END update_std_art_set_mem;
Line: 3262

PROCEDURE update_std_art_set_mem(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_samv_tbl		IN samv_tbl_type,
	x_samv_tbl		OUT NOCOPY samv_tbl_type) IS
     i				    NUMBER := 0;
Line: 3278

       		update_std_art_set_mem(
                         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_samv_rec            => p_samv_tbl(i),
                         x_samv_rec            => x_samv_tbl(i));
Line: 3309

 END update_std_art_set_mem;
Line: 3377

PROCEDURE delete_std_art_set_mem(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_samv_rec		IN samv_rec_type) IS
     l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 3385

     l_api_name                     CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_SET_MEM';
Line: 3407

     OKC_STD_ARTICLE_PVT.delete_std_art_set_mem(
                         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_samv_rec            => l_samv_rec);
Line: 3455

 END delete_std_art_set_mem;
Line: 3457

PROCEDURE delete_std_art_set_mem(
	p_api_version 		IN NUMBER,
	p_init_msg_list 		IN VARCHAR2 ,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_samv_tbl		IN samv_tbl_type) IS
     i				    NUMBER := 0;
Line: 3472

       		delete_std_art_set_mem(
                         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_samv_rec            => p_samv_tbl(i));
Line: 3502

 END delete_std_art_set_mem;