DBA Data[Home] [Help]

APPS.HR_QSA_INS dependencies on HR_QUEST_ANSWERS

Line 81: -- Insert the row into: hr_quest_answers

77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: --
81: -- Insert the row into: hr_quest_answers
82: --
83: insert into hr_quest_answers
84: ( questionnaire_answer_id,
85: questionnaire_template_id,

Line 83: insert into hr_quest_answers

79: --
80: --
81: -- Insert the row into: hr_quest_answers
82: --
83: insert into hr_quest_answers
84: ( questionnaire_answer_id,
85: questionnaire_template_id,
86: type,
87: type_object_id,

Line 158: Cursor C_Sel1 is select hr_quest_answers_s.nextval from sys.dual;

154: --
155: l_proc varchar2(72) := g_package||'pre_insert';
156: l_exists varchar2(1);
157: --
158: Cursor C_Sel1 is select hr_quest_answers_s.nextval from sys.dual;
159: --
160: Cursor C_Sel2 is
161: select null
162: from hr_quest_answers

Line 162: from hr_quest_answers

158: Cursor C_Sel1 is select hr_quest_answers_s.nextval from sys.dual;
159: --
160: Cursor C_Sel2 is
161: select null
162: from hr_quest_answers
163: where questionnaire_answer_id = hr_qsa_ins.g_questionnaire_answer_id_i;
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);

Line 255: (p_module_name => 'HR_QUEST_ANSWERS'

251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'HR_QUEST_ANSWERS'
256: ,p_hook_type => 'AI'
257: );
258: end;
259: --