48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: -- Insert the row into: pay_element_templates
56: --
202: p_rec.configuration_information30,
203: p_rec.object_version_number
204: );
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: Exception
208: When hr_api.check_integrity_violated Then
209: -- A check constraint has been violated
210: pay_etm_shd.constraint_error
264: --
265: Cursor C_Sel1 is select pay_element_templates_s.nextval from sys.dual;
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: --
271: -- Select the next sequence number
272: --
273: Open C_Sel1;
274: Fetch C_Sel1 Into p_rec.template_id;
275: Close C_Sel1;
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: End pre_insert;
279: --
280: -- ----------------------------------------------------------------------------
281: -- |-----------------------------< post_insert >------------------------------|
313: --
314: l_proc varchar2(72) := g_package||'post_insert';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: End post_insert;
321: --
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 10);
320: End post_insert;
321: --
322: -- ----------------------------------------------------------------------------
323: -- |---------------------------------< ins >----------------------------------|
329: --
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call the supporting insert validate operations
336: --
337: pay_etm_bus.insert_validate(p_effective_date, p_rec);
432: l_rec pay_etm_shd.g_rec_type;
433: l_proc varchar2(72) := g_package||'ins';
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Call conversion function to turn arguments into the
439: -- p_rec structure.
440: --
525: --
526: p_template_id := l_rec.template_id;
527: p_object_version_number := l_rec.object_version_number;
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
530: End ins;
531: --
532: end pay_etm_ins;