The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_price_adjustment(
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_patv_rec IN patv_rec_type,
x_patv_rec OUT NOCOPY patv_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_adjustment(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_patv_rec ,
x_patv_rec );
PROCEDURE update_price_adjustment(
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_patv_tbl IN patv_tbl_type,
x_patv_tbl OUT NOCOPY patv_tbl_type) is
i NUMBER := 0;
update_price_adjustment(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_patv_tbl(i),
x_patv_tbl(i));
END update_price_adjustment;
PROCEDURE delete_price_adjustment(
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_patv_rec IN patv_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_adjustment(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_patv_rec );
PROCEDURE delete_price_adjustment(
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_patv_tbl IN patv_tbl_type) is
i NUMBER := 0;
delete_price_adjustment(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_patv_tbl(i));
END delete_price_adjustment;
PROCEDURE update_price_adj_assoc(
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_pacv_rec IN pacv_rec_type,
x_pacv_rec OUT NOCOPY pacv_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_assoc(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pacv_rec ,
x_pacv_rec );
PROCEDURE update_price_adj_assoc(
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_pacv_tbl IN pacv_tbl_type,
x_pacv_tbl OUT NOCOPY pacv_tbl_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_assoc(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pacv_tbl ,
x_pacv_tbl );
PROCEDURE delete_price_adj_assoc(
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_pacv_rec IN pacv_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_assoc(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pacv_rec );
PROCEDURE delete_price_adj_assoc(
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_pacv_tbl IN pacv_tbl_type ) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_assoc(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pacv_tbl );
PROCEDURE update_price_att_value(
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_pavv_rec IN pavv_rec_type,
x_pavv_rec OUT NOCOPY pavv_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_att_value(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pavv_rec ,
x_pavv_rec );
PROCEDURE update_price_att_value(
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_pavv_tbl IN pavv_tbl_type,
x_pavv_tbl OUT NOCOPY pavv_tbl_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_att_value(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pavv_tbl ,
x_pavv_tbl );
PROCEDURE delete_price_att_value(
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_pavv_rec IN pavv_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_att_value(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pavv_rec );
PROCEDURE delete_price_att_value(
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_pavv_tbl IN pavv_tbl_type ) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_att_value(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_pavv_tbl );
PROCEDURE update_price_adj_attrib(
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_paav_rec IN paav_rec_type,
x_paav_rec OUT NOCOPY paav_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_attrib(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_paav_rec ,
x_paav_rec );
PROCEDURE update_price_adj_attrib(
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_paav_tbl IN paav_tbl_type,
x_paav_tbl OUT NOCOPY paav_tbl_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_attrib(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_paav_tbl ,
x_paav_tbl );
PROCEDURE delete_price_adj_attrib(
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_paav_rec IN paav_rec_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_attrib(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_paav_rec );
PROCEDURE delete_price_adj_attrib(
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_paav_tbl IN paav_tbl_type) is
begin
OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_attrib(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_paav_tbl );