APPS.HR_QUESTIONNAIRE_API dependencies on HR_QUEST_FIELDS

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

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;
315:
316: l_effective_date date;
317: l_proc varchar2(72) := g_package||'delete_questionnaire';
318: begin

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

365:
366: END LOOP;
367:
368:
369: -- Deleting Matchig Rows in the child table (HR_QUEST_FIELDS)
370:
371: FOR hr_que_flds_rec in c_hr_que_flds LOOP
372:
373: hr_quest_fields_api.delete_quest_fields

Line 373: hr_quest_fields_api.delete_quest_fields

369: -- Deleting Matchig Rows in the child table (HR_QUEST_FIELDS)
370:
371: FOR hr_que_flds_rec in c_hr_que_flds LOOP
372:
373: hr_quest_fields_api.delete_quest_fields
374: (
375: p_validate => false -- as per documentaion always should pass false when one BP calls another BP
376: ,p_field_id => hr_que_flds_rec.field_id
377: ,p_object_version_number => hr_que_flds_rec.object_version_number