The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_serv_avail_exc(
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_saxv_rec IN saxv_rec_type,
x_saxv_rec OUT NOCOPY saxv_rec_type)
Is
l_api_name CONSTANT VARCHAR2(30) := 'insert_serv_avail_exc';
oks_avlexc_pvt.insert_row
(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_saxv_rec ,
x_saxv_rec
);
PROCEDURE update_serv_avail_exc(
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_saxv_rec IN saxv_rec_type,
x_saxv_rec OUT NOCOPY saxv_rec_type)
Is
l_api_name CONSTANT VARCHAR2(30) := 'update_serv_avail_exc';
oks_avlexc_pvt.update_row
(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_saxv_rec ,
x_saxv_rec
);
PROCEDURE delete_serv_avail_exc(
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_saxv_rec IN saxv_rec_type)
Is
l_api_name CONSTANT VARCHAR2(30) := 'delete_serv_avail_exc';
oks_avlexc_pvt.delete_row
(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_saxv_rec
);