APPS.PER_PAR_INS dependencies on PER_PARTICIPANTS

Line 75: -- Insert the row into: per_participants

71: Begin
72: hr_utility.set_location('Entering:'||l_proc, 5);
73: p_rec.object_version_number := 1; -- Initialise the object version
74: --
75: -- Insert the row into: per_participants
76: --
77: insert into per_participants
78: ( participant_id,
79: business_group_id,

Line 77: insert into per_participants

73: p_rec.object_version_number := 1; -- Initialise the object version
74: --
75: -- Insert the row into: per_participants
76: --
77: insert into per_participants
78: ( participant_id,
79: business_group_id,
80: object_version_number,
81: questionnaire_template_id,

Line 213: Cursor C_Sel1 is select per_participants_s.nextval from sys.dual;

209: l_proc varchar2(72) := g_package||'pre_insert';
210: l_exists varchar2(1);
211:
212: --
213: Cursor C_Sel1 is select per_participants_s.nextval from sys.dual;
214: --
215: --
216: Cursor C_Sel2 is
217: Select null

Line 218: from per_participants

214: --
215: --
216: Cursor C_Sel2 is
217: Select null
218: from per_participants
219: where participant_id =
220: per_par_ins.g_participant_id_i;
221: --
222:

Line 242: fnd_message.set_token('TABLE_NAME','PER_PARTICIPANTS');

238: --
239: -- The primary key values are already in use.
240: --
241: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
242: fnd_message.set_token('TABLE_NAME','PER_PARTICIPANTS');
243: fnd_message.raise_error;
244: End If;
245: Close C_Sel2;
246: --

Line 343: ( p_module_name => 'PER_PARTICIPANTS'

339:
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: ( p_module_name => 'PER_PARTICIPANTS'
344: ,p_hook_type => 'AI'
345: );
346: end;
347: -- End of API User Hook for post_insert.