[Home] [Help]
306: --
307:
308: Cursor c_hr_que_ans is
309:
310: SELECT questionnaire_answer_id /*, object_version_number */ from HR_QUEST_ANSWERS where questionnaire_template_id = p_questionnaire_template_id;
311:
312: Cursor c_hr_que_flds is
313:
314: SELECT field_id, object_version_number from HR_QUEST_FIELDS where questionnaire_template_id = p_questionnaire_template_id;
351:
352: --
353: -- Process Logic
354:
355: -- Deleting Matchig Rows in the child table (HR_QUEST_ANSWERS)
356:
357: FOR hr_que_ans_rec in c_hr_que_ans LOOP
358:
359: hr_quest_answer_api.delete_quest_answer