DBA Data[Home] [Help]

APPS.HR_QUEST_PERFORM_WEB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

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';
Line: 38

END Delete_Quest_Answer_Values;
Line: 44

PROCEDURE Delete_Quest_Answer
   (p_questionnaire_answer_id    IN NUMBER
   )
IS
--
l_proc varchar2(200) := g_package || 'Delete_Quest_Answer';
Line: 59

   select quest_answer_val_id,object_version_number
   from hr_quest_answer_values
   where questionnaire_answer_id = p_questionnaire_answer_id;
Line: 69

        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
        );
Line: 87

END Delete_Quest_Answer;