APPS.OKC_CONTRACT_ITEM_PVT SQL Statements

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

Line: 32

  okc_cim_pvt.insert_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_cimv_rec      => p_cimv_rec,
                         x_cimv_rec      => x_cimv_rec);

Line: 44

  OKC_CVM_PVT.update_contract_version(
         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_cvmv_rec      => l_cvmv_rec,
         x_cvmv_rec      => x_out_rec);

Line: 63

procedure update_contract_item(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_cimv_rec	IN	cimv_rec_type,
                              x_cimv_rec	OUT NOCOPY	cimv_rec_type) is
--V
l_cvmv_rec  	OKC_CVM_PVT.cvmv_rec_type;

Line: 74

  select dnz_chr_id
  from OKC_K_ITEMS_V
  where id = p_cimv_rec.id;

Line: 79

  okc_cim_pvt.update_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_cimv_rec      => p_cimv_rec,
                         x_cimv_rec      => x_cimv_rec);

Line: 93

  OKC_CVM_PVT.update_contract_version(
         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_cvmv_rec      => l_cvmv_rec,
         x_cvmv_rec      => x_out_rec);

Line: 102

end update_contract_item;

Line: 112

procedure delete_contract_item(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_cimv_rec	IN	cimv_rec_type) is
i NUMBER :=0;

Line: 123

  select dnz_chr_id
  from OKC_K_ITEMS_V
  where id = p_cimv_rec.id;

Line: 138

  okc_cim_pvt.delete_row(p_api_version   => p_api_version,
                         p_init_msg_list => p_init_msg_list,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         x_return_status => x_return_status,
                         p_cimv_rec      => p_cimv_rec);

Line: 148

  OKC_CVM_PVT.update_contract_version(
         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_cvmv_rec      => l_cvmv_rec,
         x_cvmv_rec      => x_out_rec);

Line: 160

end delete_contract_item;