APPS.OKL_K_PARTY_ROLES_PVT SQL Statements

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

Line: 64

       OKL_LLA_UTIL_PVT.check_line_update_allowed
         (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_cle_id          => p_cplv_rec.cle_id);

Line: 104

    OKL_KPL_PVT.Insert_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_kplv_rec        => l_kplv_rec,
      x_kplv_rec        => x_kplv_rec);

Line: 276

  PROCEDURE update_k_party_role(
    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_cplv_rec                     IN  okl_okc_migration_pvt.cplv_rec_type,
    p_kplv_rec                     IN  kplv_rec_type,
    x_cplv_rec                     OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
    x_kplv_rec                     OUT NOCOPY kplv_rec_type) IS

    l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line: 290

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

Line: 295

	select 'x'
	from OKL_K_PARTY_ROLES_V
	where id = l_id;

Line: 304

     SELECT cle_id
     FROM okc_k_party_roles_b cpl
     WHERE cpl.id = p_cpl_id;

Line: 337

      OKL_LLA_UTIL_PVT.check_line_update_allowed
         (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_cle_id          => l_cpl_rec.cle_id);

Line: 356

     okl_okc_migration_pvt.update_k_party_role
     (
       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_cplv_rec       => l_cplv_rec,
       x_cplv_rec       => x_cplv_rec);

Line: 385

        OKL_KPL_PVT.Update_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_kplv_rec		=> l_kplv_rec,
            x_kplv_rec		=> x_kplv_rec);

Line: 394

        OKL_KPL_PVT.Insert_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_kplv_rec		=> l_kplv_rec,
            x_kplv_rec		=> x_kplv_rec);

Line: 449

  END update_k_party_role;

Line: 459

  PROCEDURE update_k_party_role(
    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_cplv_tbl                     IN  okl_okc_migration_pvt.cplv_tbl_type,
    p_kplv_tbl                     IN  kplv_tbl_type,
    x_cplv_tbl                     OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,
    x_kplv_tbl                     OUT NOCOPY kplv_tbl_type) IS

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

Line: 499

		update_k_party_role(
			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_cplv_rec        => p_cplv_tbl(i),
         		p_kplv_rec        => l_kplv_tbl(i),
			x_cplv_rec        => x_cplv_tbl(i),
      	                x_kplv_rec        => x_kplv_tbl(i));

Line: 560

  END update_k_party_role;

Line: 570

  PROCEDURE delete_k_party_role(
    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_cplv_rec                     IN  okl_okc_migration_pvt.cplv_rec_type,
    p_kplv_rec                     IN  kplv_rec_type) IS

    l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line: 582

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

Line: 588

    SELECT cle_id
    FROM okc_k_party_roles_b cpl
    WHERE cpl.id = p_cpl_id;

Line: 621

      OKL_LLA_UTIL_PVT.check_line_update_allowed
         (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_cle_id          => l_cpl_rec.cle_id);

Line: 643

    okl_okc_migration_pvt.delete_k_party_role(
	 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_cplv_rec	 => l_cplv_rec);

Line: 659

        OKL_KPL_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_kplv_rec		=> p_kplv_rec);

Line: 702

  END delete_k_party_role;

Line: 713

  PROCEDURE delete_k_party_role(
    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_cplv_tbl                     IN  okl_okc_migration_pvt.cplv_tbl_type,
    p_kplv_tbl                     IN  kplv_tbl_type) IS

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

Line: 752

		delete_k_party_role(
			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_cplv_rec      => p_cplv_tbl(i),
      	    	        p_kplv_rec      => l_kplv_tbl(i));

Line: 811

  END delete_k_party_role;