APPS.HR_QUESTIONNAIRE_API dependencies on HR_QUEST_FIELDS

Line 306: SELECT field_id, object_version_number from HR_QUEST_FIELDS where questionnaire_template_id = p_questionnaire_template_id;

302: SELECT questionnaire_answer_id /*, object_version_number */ from HR_QUEST_ANSWERS where questionnaire_template_id = p_questionnaire_template_id;
303:
304: Cursor c_hr_que_flds is
305:
306: SELECT field_id, object_version_number from HR_QUEST_FIELDS where questionnaire_template_id = p_questionnaire_template_id;
307:
308: l_effective_date date;
309: l_proc varchar2(72) := g_package||'delete_questionnaire';
310: begin

Line 361: -- Deleting Matchig Rows in the child table (HR_QUEST_FIELDS)

357:
358: END LOOP;
359:
360:
361: -- Deleting Matchig Rows in the child table (HR_QUEST_FIELDS)
362:
363: FOR hr_que_flds_rec in c_hr_que_flds LOOP
364:
365: hr_quest_fields_api.delete_quest_fields

Line 365: hr_quest_fields_api.delete_quest_fields

361: -- Deleting Matchig Rows in the child table (HR_QUEST_FIELDS)
362:
363: FOR hr_que_flds_rec in c_hr_que_flds LOOP
364:
365: hr_quest_fields_api.delete_quest_fields
366: (
367: p_validate => false -- as per documentaion always should pass false when one BP calls another BP
368: ,p_field_id => hr_que_flds_rec.field_id
369: ,p_object_version_number => hr_que_flds_rec.object_version_number