DBA Data[Home] [Help]

APPS.OKS_ORDER_CONTACTS_PVT SQL Statements

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

Line: 26

  oks_coc_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_cocv_rec      => p_cocv_rec,
                         x_cocv_rec      => x_cocv_rec);
Line: 47

procedure update_Order_Contact(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_cocv_rec	IN	cocv_rec_type,
                              x_cocv_rec	OUT NOCOPY	cocv_rec_type) is
begin
  oks_coc_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_cocv_rec      => p_cocv_rec,
                         x_cocv_rec      => x_cocv_rec);
Line: 66

end update_Order_Contact;
Line: 76

procedure delete_Order_Contact(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_cocv_rec	IN	cocv_rec_type) is
begin
  oks_coc_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_cocv_rec      => p_cocv_rec);
Line: 96

end delete_Order_Contact;