The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Delete_Quest_Answer_Values
(p_quest_answer_val_id IN NUMBER
,P_object_version_number IN NUMBER
)
IS
l_proc varchar2(200) := g_package || 'Delete_Quest_Answer_Values';
END Delete_Quest_Answer_Values;
PROCEDURE Delete_Quest_Answer
(p_questionnaire_answer_id IN NUMBER
)
IS
--
l_proc varchar2(200) := g_package || 'Delete_Quest_Answer';
select quest_answer_val_id,object_version_number
from hr_quest_answer_values
where questionnaire_answer_id = p_questionnaire_answer_id;
Delete_Quest_Answer_Values
(p_quest_answer_val_id=>R_C_Quest_Answer_Values.quest_answer_val_id
,p_object_version_number=>R_C_Quest_Answer_Values.object_version_number
);
END Delete_Quest_Answer;