[Home] [Help]
341: -- Declare cursors and local variables
342: --
343: Cursor c_hr_que_ans_vals is
344:
345: SELECT quest_answer_val_id, object_version_number from HR_QUEST_ANSWER_VALUES where field_id = p_field_id;
346:
347:
348: l_proc varchar2(72) := g_package||'delete_quest_fields';
349:
387: --
388: -- Process Logic
389: --
390:
391: -- Deleting in the child table (HR_QUEST_ANSWER_VALUES)
392:
393: FOR hr_que_ans_vals_rec in c_hr_que_ans_vals LOOP
394:
395: hr_quest_ans_val_api.delete_quest_answer_val