APPS.PER_ASN_INS dependencies on PER_ASSESSMENTS

Line 77: -- Insert the row into: per_assessments

73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: -- Insert the row into: per_assessments
78: --
79: insert into per_assessments
80: ( assessment_id,
81: assessment_type_id,

Line 79: insert into per_assessments

75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: -- Insert the row into: per_assessments
78: --
79: insert into per_assessments
80: ( assessment_id,
81: assessment_type_id,
82: business_group_id,
83: person_id,

Line 218: Cursor C_Sel1 is select per_assessments_s.nextval from sys.dual;

214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: l_exists varchar2(1);
217: --
218: Cursor C_Sel1 is select per_assessments_s.nextval from sys.dual;
219: --
220: --
221: Cursor C_Sel2 is
222: Select null

Line 223: from per_assessments

219: --
220: --
221: Cursor C_Sel2 is
222: Select null
223: from per_assessments
224: where assessment_id =
225: per_asn_ins.g_assessment_id_i;
226: --
227:

Line 248: fnd_message.set_token('TABLE_NAME','PER_ASSESSMENTS');

244: --
245: -- The primary key values are already in use.
246: --
247: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
248: fnd_message.set_token('TABLE_NAME','PER_ASSESSMENTS');
249: fnd_message.raise_error;
250: End If;
251: Close C_Sel2;
252: --

Line 354: ( p_module_name => 'PER_ASSESSMENTS'

350: p_attribute20 => p_rec.attribute20 );
351: exception
352: when hr_api.cannot_find_prog_unit then
353: hr_api.cannot_find_prog_unit_error
354: ( p_module_name => 'PER_ASSESSMENTS'
355: ,p_hook_type => 'AI'
356: );
357: end;
358: -- End of API User Hook for post_insert.