The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml(p_rec in out nocopy g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into hr_comments
( comment_id,
source_table_name,
comment_text
)
Values
( p_rec.comment_id,
p_rec.source_table_name,
p_rec.comment_text
);
End insert_dml;
Procedure update_dml(p_rec in out nocopy g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update hr_comments
set
comment_id = p_rec.comment_id,
source_table_name = p_rec.source_table_name,
comment_text = p_rec.comment_text
where comment_id = p_rec.comment_id;
End update_dml;
Procedure delete_dml(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from hr_comments
where comment_id = p_rec.comment_id;
End delete_dml;
Procedure pre_insert(p_rec in out nocopy g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select hr_comments_s.nextval from sys.dual;
End pre_insert;
Procedure pre_update(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure pre_delete(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_insert(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_insert';
End post_insert;
Procedure post_update(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
Procedure post_delete(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
End post_delete;
select comment_id,
source_table_name,
comment_text
from hr_comments
where comment_id = p_comment_id
for update nowait;
Procedure insert_validate(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;
insert_validate(p_rec);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec);
update_validate(convert_defs(p_rec));
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
delete_validate(p_rec);
pre_delete(p_rec);
delete_dml(p_rec);
post_delete(p_rec);