APPS.OKL_CONTRACT_LINE_ITEM_PUB SQL Statements

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

Line: 186

  PROCEDURE update_contract_line_item(
      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_line_item_tbl                IN  line_item_tbl_type,
      x_line_item_tbl                OUT NOCOPY line_item_tbl_type
      )  IS

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

Line: 221

    okl_contract_line_item_pvt.update_contract_line_item(
      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_line_item_tbl      => p_line_item_tbl,
      x_line_item_tbl      => x_line_item_tbl);

Line: 265

  END update_contract_line_item;

Line: 268

  PROCEDURE delete_contract_line_item(
      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_line_item_tbl                IN  line_item_tbl_type
      ) IS

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

Line: 303

    okl_contract_line_item_pvt.delete_contract_line_item(
	 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_line_item_tbl	=> p_line_item_tbl);

Line: 347

  END delete_contract_line_item;

Line: 471

  PROCEDURE update_contract_line_item(
    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,
    x_clev_rec                     OUT NOCOPY clev_rec_type,
    x_klev_rec                     OUT NOCOPY klev_rec_type,
    x_cimv_rec                     OUT NOCOPY cimv_rec_type) IS

    l_clev_rec clev_rec_type := p_clev_rec;

Line: 488

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

Line: 512

    okl_contract_line_item_pvt.update_contract_line_item(
      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,
      x_clev_rec      => x_clev_rec,
      x_klev_rec      => x_klev_rec,
      x_cimv_rec      => x_cimv_rec
      );

Line: 563

  END update_contract_line_item;

Line: 574

  PROCEDURE update_contract_line_item(
    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,
    x_clev_tbl                     OUT NOCOPY clev_tbl_type,
    x_klev_tbl                     OUT NOCOPY klev_tbl_type,
    x_cimv_tbl                     OUT NOCOPY cimv_tbl_type) IS

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

Line: 619

		update_contract_line_item(
			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),
			x_clev_rec		=> x_clev_tbl(i),
      			x_klev_rec		=> x_klev_tbl(i),
      			x_cimv_rec		=> x_cimv_tbl(i));

Line: 682

  END update_contract_line_item;

Line: 685

  PROCEDURE delete_contract_line_item(
    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) IS

    l_clev_rec clev_rec_type;

Line: 699

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

Line: 722

    okl_contract_line_item_pvt.delete_contract_line_item(
      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
      );

Line: 769

  END delete_contract_line_item;

Line: 779

    PROCEDURE delete_contract_line_item(
      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) IS

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

Line: 822

  		delete_contract_line_item(
  			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));

Line: 882

    END delete_contract_line_item;