APPS.OKS_DEFAULTS_PVT SQL Statements

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

Line: 18

procedure Insert_defaults(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_cdtv_rec	IN	cdtv_rec_type,
                              X_cdtv_rec	OUT NOCOPY	cdtv_rec_type) is
begin
  oks_cdt_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_cdtv_rec      => p_cdtv_rec,
                         x_cdtv_rec      => x_cdtv_rec);

Line: 38

end Insert_defaults;

Line: 48

procedure update_defaults(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_cdtv_rec	IN	cdtv_rec_type,
                              x_cdtv_rec    OUT NOCOPY cdtv_rec_type) is
--V
--V
begin
  oks_cdt_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_cdtv_rec      => p_cdtv_rec,
                         x_cdtv_rec      => x_cdtv_rec);

Line: 69

end update_defaults;

Line: 79

procedure delete_defaults(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_cdtv_rec	IN	cdtv_rec_type) is
begin
  oks_cdt_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_cdtv_rec      => p_cdtv_rec);

Line: 99

end delete_defaults;