DBA Data[Home] [Help]

APPS.OKL_ACCT_EVENT_PVT SQL Statements

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

Line: 108

 PROCEDURE update_acct_event(
    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_aetv_rec                     IN aetv_rec_type
   ,p_aehv_tbl                     IN aehv_tbl_type
	,p_aelv_tbl                     IN aelv_tbl_type
   ,x_aetv_rec                     OUT NOCOPY aetv_rec_type
   ,x_aehv_tbl                     OUT NOCOPY aehv_tbl_type
   ,x_aelv_tbl                     OUT NOCOPY aelv_tbl_type
    )
	AS
   l_return_status         VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
Line: 125

	     --Update the Master
    update_acct_event(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_aetv_rec,
    	x_aetv_rec);
Line: 138

        update_acct_header(
        p_api_version,
        p_init_msg_list,
        x_return_status,
        x_msg_count,
        x_msg_data,
        p_aehv_tbl,
        x_aehv_tbl);
Line: 150

               update_acct_lines(
               p_api_version,
               p_init_msg_list,
               x_return_status,
               x_msg_count,
               x_msg_data,
               p_aelv_tbl,
               x_aelv_tbl);
Line: 162

END update_acct_event;
Line: 257

    okl_aet_pvt.insert_row(p_api_version,
                           p_init_msg_list,
                           x_return_status,
                           x_msg_count,
                           x_msg_data,
                           p_aetv_rec,
                           x_aetv_rec);
Line: 375

PROCEDURE update_acct_event(
    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_aetv_rec		    IN aetv_rec_type,
    x_aetv_rec              OUT NOCOPY aetv_rec_type) IS
BEGIN
    okl_aet_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aetv_rec,
    x_aetv_rec);
Line: 393

END update_acct_event;
Line: 395

PROCEDURE update_acct_event(
    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_aetv_tbl		    IN aetv_tbl_type,
    x_aetv_tbl              OUT NOCOPY aetv_tbl_type) IS
    i                       NUMBER := 0;
Line: 413

        update_acct_event(
          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_aetv_rec                     => p_aetv_tbl(i),
          x_aetv_rec                     => x_aetv_tbl(i));
Line: 438

PROCEDURE delete_acct_event(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_aetv_rec		    IN aetv_rec_type)

IS

  l_return_status 	    VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 451

  SELECT ae_header_id
  FROM okl_ae_headers
  WHERE accounting_event_id = v_aet_id;
Line: 464

      delete_Acct_header(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_aehv_rec          => l_aehv_rec);
Line: 476

      OKL_AET_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_aetv_rec        => p_aetv_rec);
Line: 498

END delete_acct_event;
Line: 501

PROCEDURE delete_acct_event(
    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_aetv_tbl		    IN aetv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 520

	     delete_acct_event(
    	    p_api_version
    	   ,p_init_msg_list
    	   ,x_return_status
    	   ,x_msg_count
    	   ,x_msg_data
    	   ,p_aetv_tbl(i));
Line: 554

END delete_acct_event;
Line: 625

    okl_aeh_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aehv_rec,
    x_aehv_rec);
Line: 743

PROCEDURE update_acct_header(
    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_aehv_rec		    IN aehv_rec_type,
    x_aehv_rec              OUT NOCOPY aehv_rec_type) IS
BEGIN
    okl_aeh_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aehv_rec,
    x_aehv_rec);
Line: 765

END update_acct_header;
Line: 768

PROCEDURE update_acct_header(
    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_aehv_tbl		    IN aehv_tbl_type,
    x_aehv_tbl              OUT NOCOPY aehv_tbl_type) IS

    i                       NUMBER := 0;
Line: 787

        update_Acct_header(
          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_aehv_rec                     => p_aehv_tbl(i),
          x_aehv_rec                     => x_aehv_tbl(i));
Line: 811

END update_acct_header;
Line: 814

PROCEDURE delete_acct_header(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_aehv_rec		   IN aehv_rec_type) IS

  i	                    NUMBER :=0;
Line: 826

  SELECT ae_line_id
  FROM OKL_AE_LINES
  WHERE ae_header_id = v_aeh_id;
Line: 846

       delete_acct_lines(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_aelv_tbl        => l_aelv_tbl);
Line: 857

	--Delete the Header

        okl_aeh_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_aehv_rec          => p_aehv_rec);
Line: 880

END delete_acct_header;
Line: 882

PROCEDURE delete_acct_header(
    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_aehv_tbl		    IN aehv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 898

        delete_acct_header(
          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_aehv_rec                     => p_aehv_tbl(i));
Line: 933

END delete_acct_header;
Line: 1005

    okl_ael_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aelv_rec,
    x_aelv_rec);
Line: 1126

PROCEDURE update_acct_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_aelv_rec		    IN aelv_rec_type,
    x_aelv_rec              OUT NOCOPY aelv_rec_type) IS
BEGIN
    okl_ael_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aelv_rec,
    x_aelv_rec);
Line: 1148

END update_acct_lines;
Line: 1150

PROCEDURE update_acct_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_aelv_tbl		    IN aelv_tbl_type,
    x_aelv_tbl              OUT NOCOPY aelv_tbl_type) IS

 i                              NUMBER := 0;
Line: 1168

        update_Acct_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_aelv_rec                     => p_aelv_tbl(i),
          x_aelv_rec                     => x_aelv_tbl(i));
Line: 1192

END update_acct_lines;
Line: 1194

	--Put custom code for cascade delete by developer
PROCEDURE delete_acct_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_aelv_rec		    IN aelv_rec_type) IS
    i	                    NUMBER :=0;
Line: 1205

	--Delete the Master
        okl_ael_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_aelv_rec);
Line: 1226

END delete_acct_lines;
Line: 1228

PROCEDURE delete_acct_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_aelv_tbl		    IN aelv_tbl_type) IS

i                              NUMBER := 0;
Line: 1245

        delete_Acct_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_aelv_rec                     => p_aelv_tbl(i));
Line: 1281

END delete_acct_lines;