APPS.PER_PRT_INS dependencies on PER_PERFORMANCE_RATINGS

Line 81: -- Insert the row into: per_performance_ratings

77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: p_rec.object_version_number := 1; -- Initialise the object version
80:
81: -- Insert the row into: per_performance_ratings
82:
83: insert into per_performance_ratings
84: ( performance_rating_id,
85: person_id,

Line 83: insert into per_performance_ratings

79: p_rec.object_version_number := 1; -- Initialise the object version
80:
81: -- Insert the row into: per_performance_ratings
82:
83: insert into per_performance_ratings
84: ( performance_rating_id,
85: person_id,
86: objective_id,
87: object_version_number,

Line 206: Cursor C_Sel1 is select per_performance_ratings_s.nextval from sys.dual;

202:
203: l_proc varchar2(72) := g_package||'pre_insert';
204: l_exists varchar2(1);
205: --
206: Cursor C_Sel1 is select per_performance_ratings_s.nextval from sys.dual;
207: --
208: --
209: Cursor C_Sel2 is
210: Select null

Line 211: from per_performance_ratings

207: --
208: --
209: Cursor C_Sel2 is
210: Select null
211: from per_performance_ratings
212: where performance_rating_id =
213: per_prt_ins.g_performance_rating_id_i;
214: --
215:

Line 234: fnd_message.set_token('TABLE_NAME','PER_PERFORMANCE_RATINGS');

230: --
231: -- The primary key values are already in use.
232: --
233: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
234: fnd_message.set_token('TABLE_NAME','PER_PERFORMANCE_RATINGS');
235: fnd_message.raise_error;
236: End If;
237: Close C_Sel2;
238: --

Line 328: ( p_module_name => 'PER_PERFORMANCE_RATINGS'

324: p_appr_line_score => p_rec.appr_line_score);
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: ( p_module_name => 'PER_PERFORMANCE_RATINGS'
329: ,p_hook_type => 'AI'
330: );
331: end;
332: -- End of API User Hook for post_insert.