eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACC_GEN_RULE_PVT SQL Statements

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

Line: 77


 PROCEDURE update_acc_gen_rule(
    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_agrv_rec                     IN agrv_rec_type
   ,p_aulv_tbl                     IN aulv_tbl_type
   ,x_agrv_rec                     OUT NOCOPY agrv_rec_type
   ,x_aulv_tbl                     OUT NOCOPY aulv_tbl_type
    )
	IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 91


	      -- Update the master
    update_acc_gen_rule(
       p_api_version
      ,p_init_msg_list
      ,x_return_status
      ,x_msg_count
      ,x_msg_data
      ,p_agrv_rec
      ,x_agrv_rec);

Line: 105


    update_acc_gen_rule_lns(
      p_api_version
      ,p_init_msg_list
      ,x_return_status
      ,x_msg_count
      ,x_msg_data
      ,p_aulv_tbl
      ,x_aulv_tbl);

Line: 128


	END update_acc_gen_rule;

Line: 206


    okl_agr_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_agrv_rec,
    x_agrv_rec);

Line: 322


PROCEDURE update_acc_gen_rule(
    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_agrv_rec		    IN agrv_rec_type,
    x_agrv_rec              OUT NOCOPY agrv_rec_type) IS
BEGIN
    okl_agr_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_agrv_rec,
    x_agrv_rec);

Line: 344


END update_acc_gen_rule;

Line: 346


PROCEDURE update_acc_gen_rule(
    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_agrv_tbl		    IN agrv_tbl_type,
    x_agrv_tbl              OUT NOCOPY agrv_tbl_type) IS

    l_overall_status        VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 364


        update_acc_gen_rule(
          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_agrv_rec                     => p_agrv_tbl(i),
          x_agrv_rec                     => x_agrv_tbl(i));

Line: 384


END update_acc_gen_rule;

Line: 386


	--Put custom code for cascade delete by developer
PROCEDURE delete_acc_gen_rule(
    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_agrv_rec		    IN agrv_rec_type) IS
    i	                    NUMBER :=0;

Line: 399


	SELECT id
	FROM OKL_ACC_GEN_RUL_LNS
	WHERE agr_id = p_agr_id;

Line: 415


	    -- delete Lines
    delete_acc_gen_rule_lns(p_api_version
                           ,p_init_msg_list
                           ,x_return_status
                           ,x_msg_count
                           ,x_msg_data
                           ,l_rule_line_tbl);

Line: 425


        okl_agr_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_agrv_rec);

Line: 448


END delete_acc_gen_rule;

Line: 451


PROCEDURE delete_acc_gen_rule(
    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_agrv_tbl		    IN agrv_tbl_type) IS
    i	                    NUMBER :=0;

Line: 469


	     delete_acc_gen_rule(
    	    p_api_version
    	   ,p_init_msg_list
    	   ,x_return_status
    	   ,x_msg_count
    	   ,x_msg_data
    	   ,p_agrv_tbl(i));

Line: 503


END delete_acc_gen_rule;

Line: 570


    okl_aul_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aulv_rec,
    x_aulv_rec);

Line: 683


PROCEDURE update_acc_gen_rule_lns(
    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_aulv_rec		    IN aulv_rec_type,
    x_aulv_rec              OUT NOCOPY aulv_rec_type) IS
BEGIN


    okl_aul_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_aulv_rec,
    x_aulv_rec);

Line: 709


END update_acc_gen_rule_lns;

Line: 711


PROCEDURE update_acc_gen_rule_lns(
    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_aulv_tbl		    IN aulv_tbl_type,
    x_aulv_tbl              OUT NOCOPY aulv_tbl_type) IS

   l_overall_status               VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 728


        update_acc_gen_rule_lns(
          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_aulv_rec                     => p_aulv_tbl(i),
          x_aulv_rec                     => x_aulv_tbl(i));

Line: 752


END update_acc_gen_rule_lns;

Line: 754


	--Put custom code for cascade delete by developer

PROCEDURE delete_acc_gen_rule_lns(
    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_aulv_rec		    IN aulv_rec_type) IS
    i	                    NUMBER :=0;

Line: 766


	--Delete the Master
        okl_aul_pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_aulv_rec);

Line: 788


END delete_acc_gen_rule_lns;

Line: 790


PROCEDURE delete_acc_gen_rule_lns(
    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_aulv_tbl		    IN aulv_tbl_type) IS
    i	                    NUMBER :=0;

Line: 808


          delete_acc_gen_rule_lns(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_aulv_tbl(i));

Line: 843


END delete_acc_gen_rule_lns;