56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: pay_eei_mig_shd.g_api_dml := true; -- Set the api dml status
64: --
190: );
191: --
192: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: Exception
196: When hr_api.check_integrity_violated Then
197: -- A check constraint has been violated
198: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
258: --
259: Cursor C_Sel1 is select pay_element_type_extra_info_s.nextval from sys.dual;
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: --
265: -- Select the next sequence number
266: --
267: Open C_Sel1;
268: Fetch C_Sel1 Into p_rec.element_type_extra_info_id;
269: Close C_Sel1;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End pre_insert;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |-----------------------------< post_insert >------------------------------|
309: --
310: l_proc varchar2(72) := g_package||'post_insert';
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: begin
315: --
316: pay_eei_rki.after_insert
317: (p_element_type_extra_info_id
445: ,p_hook_type => 'AI');
446: --
447: end;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End post_insert;
451: --
452: -- ----------------------------------------------------------------------------
453: -- |---------------------------------< ins >----------------------------------|
458: --
459: l_proc varchar2(72) := g_package||'ins';
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: --
464: -- Call the supporting insert validate operations
465: --
466: pay_eei_mig_bus.insert_validate
480: pay_eei_mig_ins.post_insert
481: (p_rec
482: );
483: --
484: hr_utility.set_location('Leaving:'||l_proc, 20);
485: end ins;
486: --
487: -- ----------------------------------------------------------------------------
488: -- |---------------------------------< ins >----------------------------------|
553: l_rec pay_eei_mig_shd.g_rec_type;
554: l_proc varchar2(72) := g_package||'ins';
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: -- Call conversion function to turn arguments into the
560: -- p_rec structure.
561: --
635: --
636: p_element_type_extra_info_id := l_rec.element_type_extra_info_id;
637: p_object_version_number := l_rec.object_version_number;
638: --
639: hr_utility.set_location(' Leaving:'||l_proc, 10);
640: End ins;
641: --
642: end pay_eei_mig_ins;