DBA Data[Home] [Help]

APPS.OKS_REV_DISTR_PVT SQL Statements

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

Line: 19

  oks_rds_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_rdsv_rec      => p_rdsv_rec,
                         x_rdsv_rec      => x_rdsv_rec);
Line: 33

procedure update_Revenue_Distr(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_rdsv_rec	IN	rdsv_rec_type,
                              x_rdsv_rec	OUT NOCOPY	rdsv_rec_type) is
begin
  oks_rds_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_rdsv_rec      => p_rdsv_rec,
                         x_rdsv_rec      => x_rdsv_rec);
Line: 52

end update_Revenue_Distr;
Line: 57

procedure delete_Revenue_Distr(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_rdsv_rec	IN	rdsv_rec_type) is
begin
  oks_rds_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_rdsv_rec      => p_rdsv_rec);
Line: 77

end delete_Revenue_Distr;