DBA Data[Home] [Help]

APPS.OKC_SALES_CREDIT_PVT SQL Statements

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

Line: 29

  okC_scr_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_scrv_rec      => p_scrv_rec,
                         x_scrv_rec      => x_scrv_rec);
Line: 66

  okC_scr_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_scrv_tbl      => p_scrv_tbl,
                         x_scrv_tbl      => x_scrv_tbl);
Line: 89

procedure update_Sales_Credit(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_scrv_rec	IN	scrv_rec_type,
                              x_scrv_rec	OUT NOCOPY	scrv_rec_type) is
begin
  okC_scr_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_scrv_rec      => p_scrv_rec,
                         x_scrv_rec      => x_scrv_rec);
Line: 114

end update_Sales_Credit;
Line: 124

procedure delete_Sales_Credit(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_scrv_rec	IN	scrv_rec_type) is
begin
  okC_scr_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_scrv_rec      => p_scrv_rec);
Line: 151

end delete_Sales_Credit;