DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PUB SQL Statements

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

Line: 22

  G_NO_UPDATE_ALLOWED_EXCEPTION exception;
Line: 23

  G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKL_NO_UPDATE_ALLOWED';
Line: 267

  PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update            IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    p_chrv_rec                     IN  okl_okc_migration_pvt.chrv_rec_type,
    p_khrv_rec                     IN  khrv_rec_type,
    x_chrv_rec                     OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
    x_khrv_rec                     OUT NOCOPY khrv_rec_type) IS

    l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
Line: 282

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
Line: 319

    okl_contract_pvt.update_contract_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_restricted_update => p_restricted_update,
      p_chrv_rec      => l_chrv_rec,
      p_khrv_rec      => l_khrv_rec,
      x_chrv_rec      => x_chrv_rec,
      x_khrv_rec      => x_khrv_rec);
Line: 376

  END update_contract_header;
Line: 387

  PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update            IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    p_chrv_tbl                     IN  okl_okc_migration_pvt.chrv_tbl_type,
    p_khrv_tbl                     IN  khrv_tbl_type,
    x_chrv_tbl                     OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
    x_khrv_tbl                     OUT NOCOPY khrv_tbl_type) IS

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

		update_contract_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_restricted_update => p_restricted_update,
			p_chrv_rec		=> p_chrv_tbl(i),
      		p_khrv_rec		=> l_khrv_tbl(i),
			x_chrv_rec		=> x_chrv_tbl(i),
      		x_khrv_rec		=> x_khrv_tbl(i));
Line: 469

    ROLLBACK  TO update_contract_header_pub;
Line: 471

   FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_contract_header');
Line: 475

  END update_contract_header;
Line: 488

  PROCEDURE update_contract_header(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_restricted_update            IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
    p_chrv_rec                     IN  okl_okc_migration_pvt.chrv_rec_type,
    p_khrv_rec                     IN  khrv_rec_type,
    p_edit_mode                    IN  VARCHAR2,
    x_chrv_rec                     OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
    x_khrv_rec                     OUT NOCOPY khrv_rec_type) IS

    l_chrv_rec           okl_okc_migration_pvt.chrv_rec_type;
Line: 505

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
Line: 543

    okl_contract_pvt.update_contract_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_restricted_update => p_restricted_update,
      p_chrv_rec      => l_chrv_rec,
      p_khrv_rec      => l_khrv_rec,
      p_edit_mode     => p_edit_mode,
      x_chrv_rec      => x_chrv_rec,
      x_khrv_rec      => x_khrv_rec);
Line: 603

  END update_contract_header;
Line: 614

  PROCEDURE delete_contract(
    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_contract_id                  IN  okc_k_headers_b.id%type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT';
Line: 644

    okl_contract_pvt.delete_contract(
      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_contract_id      => p_contract_id);
Line: 687

  END delete_contract;
Line: 698

  PROCEDURE delete_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_chrv_rec                     IN  okl_okc_migration_pvt.chrv_rec_type,
    p_khrv_rec                     IN  khrv_rec_type) IS

    l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
Line: 710

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
Line: 737

    okl_contract_pvt.delete_contract_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_chrv_rec      => l_chrv_rec,
      p_khrv_rec      => l_khrv_rec);
Line: 788

  END delete_contract_header;
Line: 799

  PROCEDURE delete_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_chrv_tbl                     IN  okl_okc_migration_pvt.chrv_tbl_type,
    p_khrv_tbl                     IN  khrv_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
Line: 838

		delete_contract_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_chrv_rec		=> p_chrv_tbl(i),
      		p_khrv_rec		=> l_khrv_tbl(i));
Line: 898

  END delete_contract_header;
Line: 1556

  PROCEDURE update_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_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  okl_okc_migration_pvt.clev_rec_type,
    p_klev_rec                     IN  klev_rec_type,
    x_clev_rec                     OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
    x_klev_rec                     OUT NOCOPY klev_rec_type) IS

    l_clev_rec okl_okc_migration_pvt.clev_rec_type;
Line: 1570

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
Line: 1608

    okl_contract_pvt.update_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_clev_rec      => l_clev_rec,
      p_klev_rec      => l_klev_rec,
      x_clev_rec      => x_clev_rec,
      x_klev_rec      => x_klev_rec);
Line: 1664

  END update_contract_line;
Line: 1675

  PROCEDURE update_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_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  okl_okc_migration_pvt.clev_tbl_type,
    p_klev_tbl                     IN  klev_tbl_type,
    x_clev_tbl                     OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
    x_klev_tbl                     OUT NOCOPY klev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
Line: 1717

		update_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_clev_rec		=> p_clev_tbl(i),
      		p_klev_rec		=> l_klev_tbl(i),
			x_clev_rec		=> x_clev_tbl(i),
      		x_klev_rec		=> x_klev_tbl(i));
Line: 1779

  END update_contract_line;
Line: 1793

  PROCEDURE update_contract_line(
    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_clev_rec                     IN  okl_okc_migration_pvt.clev_rec_type,
    p_klev_rec                     IN  klev_rec_type,
    p_edit_mode                    IN  VARCHAR2,
    x_clev_rec                     OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
    x_klev_rec                     OUT NOCOPY klev_rec_type) IS

    l_clev_rec okl_okc_migration_pvt.clev_rec_type;
Line: 1808

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
Line: 1846

    okl_contract_pvt.update_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_clev_rec      => l_clev_rec,
      p_klev_rec      => l_klev_rec,
      p_edit_mode     => p_edit_mode,
      x_clev_rec      => x_clev_rec,
      x_klev_rec      => x_klev_rec);
Line: 1903

  END update_contract_line;
Line: 1918

  PROCEDURE update_contract_line(
    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_clev_tbl                     IN  okl_okc_migration_pvt.clev_tbl_type,
    p_klev_tbl                     IN  klev_tbl_type,
    p_edit_mode                    IN  VARCHAR2,
    x_clev_tbl                     OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
    x_klev_tbl                     OUT NOCOPY klev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
Line: 1942

		update_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_clev_rec		=> p_clev_tbl(i),
      		p_klev_rec		=> l_klev_tbl(i),
            p_edit_mode     => p_edit_mode,
			x_clev_rec		=> x_clev_tbl(i),
      		x_klev_rec		=> x_klev_tbl(i));
Line: 2002

  END update_contract_line;
Line: 2011

  PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_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  okl_okc_migration_pvt.clev_rec_type,
    p_klev_rec                     IN  klev_rec_type) IS

    l_clev_rec okl_okc_migration_pvt.clev_rec_type;
Line: 2023

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 2059

    okl_contract_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_clev_rec      => l_clev_rec,
      p_klev_rec      => l_klev_rec);
Line: 2111

  END delete_contract_line;
Line: 2122

  PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_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  okl_okc_migration_pvt.clev_tbl_type,
    p_klev_tbl                     IN  klev_tbl_type) IS

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 2161

		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_clev_rec		=> p_clev_tbl(i),
      		p_klev_rec		=> l_klev_tbl(i));
Line: 2221

  END delete_contract_line;
Line: 2231

 PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_line_id                     IN NUMBER) IS

    l_api_version	CONSTANT	NUMBER      := 1.0;
Line: 2241

    l_api_name            CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 2263

    okl_contract_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_line_id       => p_line_id);
Line: 2307

  END delete_contract_line;
Line: 2320

 PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_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  okl_okc_migration_pvt.clev_rec_type,
    p_klev_rec                     IN  klev_rec_type,
    p_delete_cascade_yn            IN  VARCHAR2) is

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 2354

    OKL_CONTRACT_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_clev_rec          => p_clev_rec,
    p_klev_rec          => p_klev_rec,
    p_delete_cascade_yn => p_delete_cascade_yn);
Line: 2399

  END delete_contract_line;
Line: 2401

PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_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  okl_okc_migration_pvt.clev_tbl_type,
    p_klev_tbl                     IN  klev_tbl_type,
    p_delete_cascade_yn            IN  varchar2) is
    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
Line: 2434

    OKL_CONTRACT_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_clev_tbl          => p_clev_tbl,
    p_klev_tbl          => p_klev_tbl,
    p_delete_cascade_yn => p_delete_cascade_yn);
Line: 2479

  END delete_contract_line;
Line: 2941

  PROCEDURE update_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN okl_okc_migration_pvt.gvev_rec_type,
    x_gvev_rec                     OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type)is
begin
           okl_contract_pvt.update_governance
            (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_gvev_rec           =>   p_gvev_rec,
             x_gvev_rec           =>   x_gvev_rec);
Line: 2961

  PROCEDURE update_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_tbl                     IN okl_okc_migration_pvt.gvev_tbl_type,
    x_gvev_tbl                     OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type)is
begin
            okl_contract_pvt.update_governance
            (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_gvev_tbl           =>   p_gvev_tbl,
             x_gvev_tbl           =>   x_gvev_tbl);
Line: 2981

  PROCEDURE delete_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN okl_okc_migration_pvt.gvev_rec_type)is
begin
            okl_contract_pvt.delete_governance
            (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_gvev_rec           =>   p_gvev_rec);
Line: 2999

  PROCEDURE delete_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_tbl                     IN okl_okc_migration_pvt.gvev_tbl_type)is
begin
            okl_contract_pvt.delete_governance
            (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_gvev_tbl           =>   p_gvev_tbl);