The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_quest_answer_val
( p_validate in boolean default false
,p_questionnaire_answer_id in number
,p_field_id in number
,p_value in varchar2 default null
,p_quest_answer_val_id out nocopy number
,p_object_version_number out nocopy number
)
is
--
-- Declare cursors and local variables
--
-- l_effective_date date;
l_proc varchar2(72) := g_package||'insert_quest_answer_val';
savepoint insert_quest_answer_val;
hr_quest_ans_val_bk1.insert_quest_answer_val_b
(
p_questionnaire_answer_id => p_questionnaire_answer_id
,p_field_id => p_field_id
,p_value => p_value
);
(p_module_name => 'insert_quest_answer_val'
,p_hook_type => 'BP'
);
hr_quest_ans_val_bk1.insert_quest_answer_val_a
(
p_questionnaire_answer_id => p_questionnaire_answer_id
,p_field_id => p_field_id
,p_value => p_value
,p_quest_answer_val_id => p_quest_answer_val_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'insert_quest_answer_val'
,p_hook_type => 'AP'
);
rollback to insert_quest_answer_val;
rollback to insert_quest_answer_val;
end insert_quest_answer_val;
procedure update_quest_answer_val
( p_validate in boolean default false
,p_quest_answer_val_id in number
,p_object_version_number in out nocopy number
,p_value in varchar2 default hr_api.g_varchar2
)
is
--
-- Declare cursors and local variables
--
l_object_version_number number;
l_proc varchar2(72) := g_package||'update_quest_answer_val';
savepoint update_quest_answer_val;
hr_quest_ans_val_bk2.update_quest_answer_val_b
(
p_quest_answer_val_id => p_quest_answer_val_id
,p_object_version_number => p_object_version_number
,p_value => p_value
);
(p_module_name => 'update_quest_answer_val'
,p_hook_type => 'BP'
);
hr_quest_ans_val_bk2.update_quest_answer_val_a
(
p_quest_answer_val_id => p_quest_answer_val_id
,p_object_version_number => p_object_version_number
,p_value => p_value
);
(p_module_name => 'update_quest_answer_val'
,p_hook_type => 'AP'
);
rollback to update_quest_answer_val;
rollback to update_quest_answer_val;
end update_quest_answer_val;
procedure delete_quest_answer_val
(
p_validate in boolean default false
,p_quest_answer_val_id in number
,p_object_version_number in number
)
is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_quest_answer_val';
savepoint delete_quest_answer_val;
hr_quest_ans_val_bk3.delete_quest_answer_val_b
(
p_quest_answer_val_id => p_quest_answer_val_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_quest_answer_val'
,p_hook_type => 'BP'
);
hr_quest_ans_val_bk3.delete_quest_answer_val_a
( p_quest_answer_val_id => p_quest_answer_val_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_quest_answer_val'
,p_hook_type => 'AP'
);
rollback to delete_quest_answer_val;
rollback to delete_quest_answer_val;
end delete_quest_answer_val;