APPS.PER_APR_INS dependencies on PER_APPRAISALS

Line 79: -- Insert the row into: per_appraisals

75: hr_utility.set_location('Entering:'||l_proc, 5);
76: p_rec.object_version_number := 1; -- Initialise the object version
77:
78:
79: -- Insert the row into: per_appraisals
80:
81: insert into per_appraisals
82: ( appraisal_id,
83: business_group_id,

Line 81: insert into per_appraisals

77:
78:
79: -- Insert the row into: per_appraisals
80:
81: insert into per_appraisals
82: ( appraisal_id,
83: business_group_id,
84: object_version_number,
85: appraisal_template_id,

Line 283: Cursor C_Sel1 is select per_appraisals_s.nextval from sys.dual;

279:
280: l_proc varchar2(72) := g_package||'pre_insert';
281: l_exists varchar2(1);
282:
283: Cursor C_Sel1 is select per_appraisals_s.nextval from sys.dual;
284: --
285: Cursor C_Sel2 is
286: Select null
287: from per_appraisals

Line 287: from per_appraisals

283: Cursor C_Sel1 is select per_appraisals_s.nextval from sys.dual;
284: --
285: Cursor C_Sel2 is
286: Select null
287: from per_appraisals
288: where appraisal_id =
289: per_apr_ins.g_appraisal_id_i;
290: --
291: Begin

Line 309: fnd_message.set_token('TABLE_NAME','PER_APPRAISALS');

305: --
306: -- The primary key values are already in use.
307: --
308: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
309: fnd_message.set_token('TABLE_NAME','PER_APPRAISALS');
310: fnd_message.raise_error;
311: End If;
312: Close C_Sel2;
313: --

Line 443: ( p_module_name => 'PER_APPRAISALS'

439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: ( p_module_name => 'PER_APPRAISALS'
444: ,p_hook_type => 'AI'
445: );
446: end;
447: -- End of API User Hook for post_insert.