The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_scsv_rec.last_updated_by := p_scsv_rec1.last_updated_by;
l_scsv_rec.last_update_date := p_scsv_rec1.last_update_date;
l_scsv_rec.last_update_login := p_scsv_rec1.last_update_login;
l_srev_rec.last_updated_by := p_srev_rec1.last_updated_by;
l_srev_rec.last_update_date := p_srev_rec1.last_update_date;
l_srev_rec.last_update_login := p_srev_rec1.last_update_login;
l_srdv_rec.last_updated_by := p_srdv_rec1.last_updated_by;
l_srdv_rec.last_update_date := p_srdv_rec1.last_update_date;
l_srdv_rec.last_update_login := p_srdv_rec1.last_update_login;
l_rrdv_rec.last_updated_by := p_rrdv_rec1.last_updated_by;
l_rrdv_rec.last_update_date := p_rrdv_rec1.last_update_date;
l_rrdv_rec.last_update_login := p_rrdv_rec1.last_update_login;
l_stlv_rec.last_updated_by := p_stlv_rec1.last_updated_by;
l_stlv_rec.last_update_date := p_stlv_rec1.last_update_date;
l_stlv_rec.last_update_login := p_stlv_rec1.last_update_login;
l_lsrv_rec.last_updated_by := p_lsrv_rec1.last_updated_by;
l_lsrv_rec.last_update_date := p_lsrv_rec1.last_update_date;
l_lsrv_rec.last_update_login := p_lsrv_rec1.last_update_login;
l_lrgv_rec.last_updated_by := p_lrgv_rec1.last_updated_by;
l_lrgv_rec.last_update_date := p_lrgv_rec1.last_update_date;
l_lrgv_rec.last_update_login := p_lrgv_rec1.last_update_login;
l_srav_rec.last_updated_by := p_srav_rec1.last_updated_by;
l_srav_rec.last_update_date := p_srav_rec1.last_update_date;
l_srav_rec.last_update_login := p_srav_rec1.last_update_login;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_subclass';
okc_subclass_pvt.update_subclass(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_subclass(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_scsv_tbl(i),
x_scsv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_subclass';
okc_subclass_pvt.delete_subclass(
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
i NUMBER := 0;
delete_subclass(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_scsv_tbl(i));
END delete_subclass;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_subclass_roles';
okc_subclass_pvt.update_subclass_roles(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_subclass_roles(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_srev_tbl(i),
x_srev_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_subclass_roles';
okc_subclass_pvt.delete_subclass_roles(
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
i NUMBER := 0;
delete_subclass_roles(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_srev_tbl(i));
END delete_subclass_roles;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_subclass_rg_defs';
okc_subclass_pvt.update_subclass_rg_defs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_subclass_rg_defs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_srdv_tbl(i),
x_srdv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_subclass_rg_defs';
okc_subclass_pvt.delete_subclass_rg_defs(
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
i NUMBER := 0;
delete_subclass_rg_defs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_srdv_tbl(i));
END delete_subclass_rg_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_rec IN rrdv_rec_type,
x_rrdv_rec OUT NOCOPY rrdv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_rg_role_defs';
okc_subclass_pvt.update_rg_role_defs(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_rg_role_defs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_rrdv_tbl(i),
x_rrdv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_rg_role_defs';
okc_subclass_pvt.delete_rg_role_defs(
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
i NUMBER := 0;
delete_rg_role_defs(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_rrdv_tbl(i));
END delete_rg_role_defs;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_subclass_top_line';
okc_subclass_pvt.update_subclass_top_line(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_subclass_top_line(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_stlv_tbl(i),
x_stlv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_subclass_top_line';
okc_subclass_pvt.delete_subclass_top_line(
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
i NUMBER := 0;
delete_subclass_top_line(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_stlv_tbl(i));
END delete_subclass_top_line;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_line_style_roles';
okc_subclass_pvt.update_line_style_roles(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_line_style_roles(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_lsrv_tbl(i),
x_lsrv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_line_style_roles';
okc_subclass_pvt.delete_line_style_roles(
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
i NUMBER := 0;
delete_line_style_roles(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_lsrv_tbl(i));
END delete_line_style_roles;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_lse_rule_groups';
okc_subclass_pvt.update_lse_rule_groups(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_lse_rule_groups(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_lrgv_tbl(i),
x_lrgv_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_lse_rule_groups';
okc_subclass_pvt.delete_lse_rule_groups(
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
i NUMBER := 0;
delete_lse_rule_groups(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_lrgv_tbl(i));
END delete_lse_rule_groups;
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
l_api_name CONSTANT VARCHAR2(30) := 'update_subclass_resps';
okc_subclass_pvt.update_subclass_resps(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_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
i NUMBER := 0;
update_subclass_resps(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_srav_tbl(i),
x_srav_tbl(i));
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
l_api_name CONSTANT VARCHAR2(30) := 'delete_subclass_resps';
okc_subclass_pvt.delete_subclass_resps(
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
i NUMBER := 0;
delete_subclass_resps(
p_api_version,
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
p_srav_tbl(i));
END delete_subclass_resps;