The following lines contain the word 'select', 'insert', 'update' or 'delete':
okc_scs_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_scsv_rec,
x_scsv_rec);
okc_scs_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_scsv_tbl,
x_scsv_tbl);
PROCEDURE update_subclass(
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_scsv_rec IN scsv_rec_type,
x_scsv_rec OUT NOCOPY scsv_rec_type) IS
BEGIN
okc_scs_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_scsv_rec,
x_scsv_rec);
END update_subclass;
PROCEDURE update_subclass(
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_scsv_tbl IN scsv_tbl_type,
x_scsv_tbl OUT NOCOPY scsv_tbl_type) IS
BEGIN
okc_scs_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_scsv_tbl,
x_scsv_tbl);
END update_subclass;
PROCEDURE delete_subclass(
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_scsv_rec IN scsv_rec_type) IS
BEGIN
okc_scs_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_scsv_rec);
END delete_subclass;
PROCEDURE delete_subclass(
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_scsv_tbl IN scsv_tbl_type) IS
BEGIN
okc_scs_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_scsv_tbl);
END delete_subclass;
okc_sre_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srev_rec,
x_srev_rec);
okc_sre_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srev_tbl,
x_srev_tbl);
PROCEDURE update_subclass_roles(
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_srev_rec IN srev_rec_type,
x_srev_rec OUT NOCOPY srev_rec_type) IS
BEGIN
okc_sre_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srev_rec,
x_srev_rec);
END update_subclass_roles;
PROCEDURE update_subclass_roles(
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_srev_tbl IN srev_tbl_type,
x_srev_tbl OUT NOCOPY srev_tbl_type) IS
BEGIN
okc_sre_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srev_tbl,
x_srev_tbl);
END update_subclass_roles;
PROCEDURE delete_subclass_roles(
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_srev_rec IN srev_rec_type) IS
BEGIN
okc_sre_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srev_rec);
END delete_subclass_roles;
PROCEDURE delete_subclass_roles(
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_srev_tbl IN srev_tbl_type) IS
BEGIN
okc_sre_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srev_tbl);
END delete_subclass_roles;
okc_srd_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srdv_rec,
x_srdv_rec);
okc_srd_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srdv_tbl,
x_srdv_tbl);
PROCEDURE update_subclass_rg_defs(
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_srdv_rec IN srdv_rec_type,
x_srdv_rec OUT NOCOPY srdv_rec_type) IS
BEGIN
okc_srd_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srdv_rec,
x_srdv_rec);
END update_subclass_rg_defs;
PROCEDURE update_subclass_rg_defs(
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_srdv_tbl IN srdv_tbl_type,
x_srdv_tbl OUT NOCOPY srdv_tbl_type) IS
BEGIN
okc_srd_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srdv_tbl,
x_srdv_tbl);
END update_subclass_rg_defs;
PROCEDURE delete_subclass_rg_defs(
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_srdv_rec IN srdv_rec_type) IS
BEGIN
okc_srd_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srdv_rec);
END delete_subclass_rg_defs;
PROCEDURE delete_subclass_rg_defs(
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_srdv_tbl IN srdv_tbl_type) IS
BEGIN
okc_srd_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srdv_tbl);
END delete_subclass_rg_defs;
okc_rrd_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rrdv_rec,
x_rrdv_rec);
okc_rrd_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rrdv_tbl,
x_rrdv_tbl);
PROCEDURE update_rg_role_defs(
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_rrdv_rec IN rrdv_rec_type,
x_rrdv_rec OUT NOCOPY rrdv_rec_type) IS
BEGIN
okc_rrd_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rrdv_rec,
x_rrdv_rec);
END update_rg_role_defs;
PROCEDURE update_rg_role_defs(
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_rrdv_tbl IN rrdv_tbl_type,
x_rrdv_tbl OUT NOCOPY rrdv_tbl_type) IS
BEGIN
okc_rrd_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rrdv_tbl,
x_rrdv_tbl);
END update_rg_role_defs;
PROCEDURE delete_rg_role_defs(
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_rrdv_rec IN rrdv_rec_type) IS
BEGIN
okc_rrd_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rrdv_rec);
END delete_rg_role_defs;
PROCEDURE delete_rg_role_defs(
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_rrdv_tbl IN rrdv_tbl_type) IS
BEGIN
okc_rrd_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rrdv_tbl);
END delete_rg_role_defs;
okc_stl_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stlv_rec,
x_stlv_rec);
okc_stl_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stlv_tbl,
x_stlv_tbl);
PROCEDURE update_subclass_top_line(
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_stlv_rec IN stlv_rec_type,
x_stlv_rec OUT NOCOPY stlv_rec_type) IS
BEGIN
okc_stl_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stlv_rec,
x_stlv_rec);
END update_subclass_top_line;
PROCEDURE update_subclass_top_line(
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_stlv_tbl IN stlv_tbl_type,
x_stlv_tbl OUT NOCOPY stlv_tbl_type) IS
BEGIN
okc_stl_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stlv_tbl,
x_stlv_tbl);
END update_subclass_top_line;
PROCEDURE delete_subclass_top_line(
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_stlv_rec IN stlv_rec_type) IS
BEGIN
okc_stl_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stlv_rec);
END delete_subclass_top_line;
PROCEDURE delete_subclass_top_line(
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_stlv_tbl IN stlv_tbl_type) IS
BEGIN
okc_stl_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_stlv_tbl);
END delete_subclass_top_line;
okc_lsr_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsrv_rec,
x_lsrv_rec);
okc_lsr_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsrv_tbl,
x_lsrv_tbl);
PROCEDURE update_line_style_roles(
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_lsrv_rec IN lsrv_rec_type,
x_lsrv_rec OUT NOCOPY lsrv_rec_type) IS
BEGIN
okc_lsr_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsrv_rec,
x_lsrv_rec);
END update_line_style_roles;
PROCEDURE update_line_style_roles(
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_lsrv_tbl IN lsrv_tbl_type,
x_lsrv_tbl OUT NOCOPY lsrv_tbl_type) IS
BEGIN
okc_lsr_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsrv_tbl,
x_lsrv_tbl);
END update_line_style_roles;
PROCEDURE delete_line_style_roles(
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_lsrv_rec IN lsrv_rec_type) IS
BEGIN
okc_lsr_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsrv_rec);
END delete_line_style_roles;
PROCEDURE delete_line_style_roles(
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_lsrv_tbl IN lsrv_tbl_type) IS
BEGIN
okc_lsr_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsrv_tbl);
END delete_line_style_roles;
okc_lrg_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lrgv_rec,
x_lrgv_rec);
okc_lrg_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lrgv_tbl,
x_lrgv_tbl);
PROCEDURE update_lse_rule_groups(
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_lrgv_rec IN lrgv_rec_type,
x_lrgv_rec OUT NOCOPY lrgv_rec_type) IS
BEGIN
okc_lrg_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lrgv_rec,
x_lrgv_rec);
END update_lse_rule_groups;
PROCEDURE update_lse_rule_groups(
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_lrgv_tbl IN lrgv_tbl_type,
x_lrgv_tbl OUT NOCOPY lrgv_tbl_type) IS
BEGIN
okc_lrg_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lrgv_tbl,
x_lrgv_tbl);
END update_lse_rule_groups;
PROCEDURE delete_lse_rule_groups(
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_lrgv_rec IN lrgv_rec_type) IS
BEGIN
okc_lrg_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lrgv_rec);
END delete_lse_rule_groups;
PROCEDURE delete_lse_rule_groups(
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_lrgv_tbl IN lrgv_tbl_type) IS
BEGIN
okc_lrg_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lrgv_tbl);
END delete_lse_rule_groups;
okc_sra_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srav_rec,
x_srav_rec);
okc_sra_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srav_tbl,
x_srav_tbl);
PROCEDURE update_subclass_resps(
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_srav_rec IN srav_rec_type,
x_srav_rec OUT NOCOPY srav_rec_type) IS
BEGIN
okc_sra_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srav_rec,
x_srav_rec);
END update_subclass_resps;
PROCEDURE update_subclass_resps(
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_srav_tbl IN srav_tbl_type,
x_srav_tbl OUT NOCOPY srav_tbl_type) IS
BEGIN
okc_sra_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srav_tbl,
x_srav_tbl);
END update_subclass_resps;
PROCEDURE delete_subclass_resps(
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_srav_rec IN srav_rec_type) IS
BEGIN
okc_sra_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srav_rec);
END delete_subclass_resps;
PROCEDURE delete_subclass_resps(
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_srav_tbl IN srav_tbl_type) IS
BEGIN
okc_sra_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_srav_tbl);
END delete_subclass_resps;
SELECT
cls_code,
meaning ,
description,
start_date,
end_date ,
create_opp_yn ,
access_level
FROM okc_subclasses_v
WHERE code=b_scs_code;
SELECT
id,
rle_code ,
scs_code ,
start_date ,
end_date ,
access_level
FROM okc_subclass_roles_v
WHERE scs_code=b_scs_code;
SELECT
id,
rgd_code,
scs_code,
start_date,
end_date,
access_level
FROM okc_subclass_rg_defs_v
WHERE scs_code=b_scs_code;
SELECT
srd_id,
sre_id,
subject_object_flag,
optional_yn,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
access_level
FROM okc_rg_role_defs_v
WHERE srd_id IN
( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code)
AND sre_id IN
(SELECT id FROM okc_subclass_roles_v WHERE scs_code=b_scs_code);
SELECT
lse_id,
scs_code,
start_date,
end_date,
access_level
FROM okc_subclass_top_line_v
WHERE scs_code=b_scs_code;
SELECT
lse_id,
sre_id,
access_level
FROM OKC_LINE_STYLE_ROLES_v
WHERE sre_id IN
(SELECT id FROM okc_subclass_roles_v WHERE scs_code=b_scs_code);
SELECT
lse_id,
srd_id,
access_level
FROM OKC_LSE_RULE_GROUPS_v
WHERE srd_id IN
( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code);
SELECT
resp_id,
scs_code,
access_level,
start_date,
end_date
FROM OKC_subclass_resps_v
WHERE scs_code=b_scs_code;
SELECT
sts_code,
opn_code,
ste_code,
scs_code,
allowed_yn ,
attribute_category ,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
FROM okc_assents_v
WHERE scs_code=b_scs_code;
sre_relationship_tbl.delete;
srd_relationship_tbl.delete;
l_srev_tbl.delete;
lx_srev_tbl.delete;
l_srdv_tbl.delete;
lx_srdv_tbl.delete;
l_rrdv_tbl.delete;
lx_rrdv_tbl.delete;
l_stlv_tbl.delete;
lx_stlv_tbl.delete;
l_lsrv_tbl.delete;
lx_lsrv_tbl.delete;
l_lrgv_tbl.delete;
lx_lrgv_tbl.delete;
l_srav_tbl.delete;
lx_srav_tbl.delete;
l_astv_tbl.delete;
lx_astv_tbl.delete;