The following lines contain the word 'select', 'insert', 'update' or 'delete':
okc_pat_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_patv_rec,
x_patv_rec);
okc_pat_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_patv_tbl,
x_patv_tbl);
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_pat_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_patv_rec,
x_patv_rec);
END update_price_adjustment;
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
BEGIN
okc_pat_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_patv_tbl,
x_patv_tbl);
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
l_patv_rec okc_price_adjustment_PUB.patv_rec_type; --for price adjustments
SELECT A.id,A.chr_id,A.cle_id
FROM OKC_PRICE_ADJUSTMENTS_V A,
OKC_PRICE_ADJ_ASSOCS_V B
WHERE B.pat_id_from = p_patv_rec.id
AND A.ID = B.PAT_ID
AND (A.chr_id = p_patv_rec.chr_id
OR A.cle_id = p_patv_rec.cle_id);
SELECT id
FROM OKC_PRICE_ADJ_ASSOCS_V
WHERE pat_id_from = p_patv_rec.id;
SELECT id
FROM OKC_PRICE_ADJ_ATTRIBS_V
WHERE pat_id = p_patv_rec.id;
okc_pat_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_patv_rec );
OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(
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_patv_rec => l_patv_rec);
OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(
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_pacv_rec => l_pacv_rec );
OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(
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_paav_rec => l_pavv_rec);
END delete_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_tbl IN patv_tbl_type)IS
BEGIN
okc_pat_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_patv_tbl);
END delete_price_adjustment;
okc_pac_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pacv_rec,
x_pacv_rec);
okc_pac_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pacv_tbl,
x_pacv_tbl);
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_pac_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pacv_rec,
x_pacv_rec);
END update_price_adj_assoc;
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_pac_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pacv_tbl,
x_pacv_tbl);
END update_price_adj_assoc;
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_pac_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pacv_rec );
END delete_price_adj_assoc;
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_pac_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pacv_tbl);
END delete_price_adj_assoc;
okc_paa_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_paav_rec,
x_paav_rec);
okc_paa_pvt.insert_row(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_paav_tbl ,
x_paav_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_paa_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_paav_rec,
x_paav_rec);
END update_price_adj_attrib;
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_paa_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_paav_tbl,
x_paav_tbl);
END update_price_adj_attrib;
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_paa_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_paav_rec );
END delete_price_adj_attrib;
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_paa_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_paav_tbl);
END delete_price_adj_attrib;
okc_pav_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pavv_rec,
x_pavv_rec);
okc_pav_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pavv_tbl,
x_pavv_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_pav_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pavv_rec,
x_pavv_rec);
END update_price_att_value;
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_pav_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pavv_tbl,
x_pavv_tbl);
END update_price_att_value;
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_pav_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pavv_rec );
END delete_price_att_value;
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_pav_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_pavv_tbl);
END delete_price_att_value;