APPS.PER_PEA_INS dependencies on PER_PERSON_ANALYSES

Line 86: -- Insert the row into: per_person_analyses

82: p_rec.object_version_number := 1; -- Initialise the object version
83: --
84: per_pea_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Insert the row into: per_person_analyses
87: --
88: insert into per_person_analyses
89: (
90: person_analysis_id,

Line 88: insert into per_person_analyses

84: per_pea_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Insert the row into: per_person_analyses
87: --
88: insert into per_person_analyses
89: (
90: person_analysis_id,
91: business_group_id,
92: analysis_criteria_id,

Line 231: Cursor C_Sel1 is select per_person_analyses_s.nextval from sys.dual;

227: --
228: l_proc varchar2(72) := g_package||'pre_insert';
229: l_exists varchar2(1);
230: --
231: Cursor C_Sel1 is select per_person_analyses_s.nextval from sys.dual;
232: --
233: Cursor C_Sel2 is Select null from per_person_analyses
234: where person_analysis_id = per_pea_ins.g_person_analysis_id_i;
235: --

Line 233: Cursor C_Sel2 is Select null from per_person_analyses

229: l_exists varchar2(1);
230: --
231: Cursor C_Sel1 is select per_person_analyses_s.nextval from sys.dual;
232: --
233: Cursor C_Sel2 is Select null from per_person_analyses
234: where person_analysis_id = per_pea_ins.g_person_analysis_id_i;
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);

Line 251: fnd_message.set_name('TABLE_NAME','PER_PERSON_ANALYSES');

247: --
248: -- The primary key values are already in use.
249: --
250: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
251: fnd_message.set_name('TABLE_NAME','PER_PERSON_ANALYSES');
252: fnd_message.raise_error;
253: End If;
254: Close C_Sel2;
255: --

Line 402: (p_module_name => 'PER_PERSON_ANALYSES'

398:
399: exception
400: when hr_api.cannot_find_prog_unit then
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'PER_PERSON_ANALYSES'
403: ,p_hook_type => 'AI'
404: );
405: end;
406: -- End of API User Hook for post_insert.