APPS.PER_GRD_INS dependencies on PER_GRADES

Line 94: -- Insert the row into: per_grades

90: p_rec.object_version_number := 1; -- Initialise the object version
91: --
92: per_grd_shd.g_api_dml := true; -- Set the api dml status
93: --
94: -- Insert the row into: per_grades
95: --
96: insert into per_grades
97: (grade_id
98: ,business_group_id

Line 96: insert into per_grades

92: per_grd_shd.g_api_dml := true; -- Set the api dml status
93: --
94: -- Insert the row into: per_grades
95: --
96: insert into per_grades
97: (grade_id
98: ,business_group_id
99: ,grade_definition_id
100: ,date_from

Line 280: Cursor C_Sel1 is select per_grades_s.nextval from sys.dual;

276: Procedure pre_insert
277: (p_rec in out nocopy per_grd_shd.g_rec_type
278: ) is
279: --
280: Cursor C_Sel1 is select per_grades_s.nextval from sys.dual;
281: --
282: Cursor C_Sel2 is
283: Select null
284: from per_grades

Line 284: from per_grades

280: Cursor C_Sel1 is select per_grades_s.nextval from sys.dual;
281: --
282: Cursor C_Sel2 is
283: Select null
284: from per_grades
285: where grade_id =
286: per_grd_ins.g_grade_id_i;
287: --
288: l_proc varchar2(72) := g_package||'pre_insert';

Line 306: fnd_message.set_token('TABLE_NAME','per_grades');

302: --
303: -- The primary key values are already in use.
304: --
305: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
306: fnd_message.set_token('TABLE_NAME','per_grades');
307: fnd_message.raise_error;
308: End If;
309: Close C_Sel2;
310: hr_utility.set_location(l_proc, 10);

Line 495: (p_module_name => 'PER_GRADES'

491: --
492: when hr_api.cannot_find_prog_unit then
493: --
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'PER_GRADES'
496: ,p_hook_type => 'AI');
497: --
498: end;
499: --