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_CONTRACT_TOP_LINE_PUB SQL Statements

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

Line: 100


  PROCEDURE update_contract_link_serv(
    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_chr_id			   IN  NUMBER,
    p_cle_id			   IN  NUMBER,
    p_contract_number              IN  VARCHAR2,
    p_item_name                    IN  VARCHAR2,
    p_supplier_name                IN  VARCHAR2,
    x_cle_id			   OUT NOCOPY NUMBER
) IS

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

Line: 137


    okl_contract_top_line_pvt.update_contract_link_serv (
            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_chr_id			=> p_chr_id,
            p_cle_id			=> p_cle_id,
	    p_contract_number           => p_contract_number,
	    p_item_name                 => p_item_name,
	    p_supplier_name             => p_supplier_name,
	    x_cle_id			=> x_cle_id);

Line: 185


  END update_contract_link_serv;

Line: 414


  PROCEDURE update_contract_top_line(
    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_clev_rec                     IN  clev_rec_type,
    p_klev_rec                     IN  klev_rec_type,
    p_cimv_rec                     IN  cimv_rec_type,
    p_cplv_rec                     IN  cplv_rec_type,
    x_clev_rec                     OUT NOCOPY clev_rec_type,
    x_klev_rec                     OUT NOCOPY klev_rec_type,
    x_cimv_rec                     OUT NOCOPY cimv_rec_type,
    x_cplv_rec                     OUT NOCOPY cplv_rec_type) IS

    l_clev_rec clev_rec_type := p_clev_rec;

Line: 434


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

Line: 458


    OKL_CONTRACT_TOP_LINE_pvt.update_contract_top_line(
      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_clev_rec	=> l_clev_rec,
      p_klev_rec	=> l_klev_rec,
      p_cimv_rec	=> l_cimv_rec,
      p_cplv_rec	=> l_cplv_rec,
      x_clev_rec	=> x_clev_rec,
      x_klev_rec	=> x_klev_rec,
      x_cimv_rec	=> x_cimv_rec,
      x_cplv_rec	=> x_cplv_rec
      );

Line: 510


  END update_contract_top_line;

Line: 521


  PROCEDURE update_contract_top_line(
    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_clev_tbl                     IN  clev_tbl_type,
    p_klev_tbl                     IN  klev_tbl_type,
    p_cimv_tbl                     IN  cimv_tbl_type,
    p_cplv_tbl                     IN  cplv_tbl_type,
    x_clev_tbl                     OUT NOCOPY clev_tbl_type,
    x_klev_tbl                     OUT NOCOPY klev_tbl_type,
    x_cimv_tbl                     OUT NOCOPY cimv_tbl_type,
    x_cplv_tbl                     OUT NOCOPY cplv_tbl_type) IS

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

Line: 569


		update_contract_top_line(
			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_clev_rec		=> p_clev_tbl(i),
      			p_klev_rec		=> l_klev_tbl(i),
      			p_cimv_rec		=> l_cimv_tbl(i),
      			p_cplv_rec		=> l_cplv_tbl(i),
			x_clev_rec		=> x_clev_tbl(i),
      			x_klev_rec		=> x_klev_tbl(i),
      			x_cimv_rec		=> x_cimv_tbl(i),
      			x_cplv_rec		=> x_cplv_tbl(i));

Line: 633


  END update_contract_top_line;

Line: 636


  PROCEDURE delete_contract_line(
            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_chr_id	     IN  number,
            p_cle_id         IN  number) IS

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

Line: 669


    OKL_CONTRACT_TOP_LINE_pvt.delete_contract_line(
      				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_chr_id        => p_chr_id,
    				p_cle_id        => p_cle_id);

Line: 713


  END delete_contract_line;

Line: 716


PROCEDURE delete_contract_top_line(
    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_clev_rec                     IN  clev_rec_type,
    p_klev_rec                     IN  klev_rec_type,
    p_cimv_rec                     IN  cimv_rec_type,
    p_cplv_rec                     IN  cplv_rec_type) IS

    l_clev_rec clev_rec_type := p_clev_rec;

Line: 732


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

Line: 756


    OKL_CONTRACT_TOP_LINE_pvt.delete_contract_top_line(
      				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_clev_rec      => l_clev_rec,
      				p_klev_rec      => l_klev_rec,
      				p_cimv_rec      => l_cimv_rec,
      				p_cplv_rec      => l_cplv_rec
      				);

Line: 804


  END delete_contract_top_line;

Line: 814


    PROCEDURE delete_contract_top_line(
      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_clev_tbl                     IN  clev_tbl_type,
      p_klev_tbl                     IN  klev_tbl_type,
      p_cimv_tbl                     IN  cimv_tbl_type,
      p_cplv_tbl                     IN  cplv_tbl_type
      ) IS

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

Line: 858


  		delete_contract_top_line(
  			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_clev_rec		=> p_clev_tbl(i),
        		p_klev_rec		=> l_klev_tbl(i),
        		p_cimv_rec		=> l_cimv_tbl(i),
        		p_cplv_rec		=> l_cplv_tbl(i));

Line: 918


    END delete_contract_top_line;