56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: hr_utility.set_location('Entering:'||to_char(p_rec.previous_navigation_item_id), 5);
62: hr_utility.set_location('Entering:'||to_char(p_rec.next_navigation_item_id), 5);
63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: hr_utility.set_location('Entering:'||to_char(p_rec.previous_navigation_item_id), 5);
62: hr_utility.set_location('Entering:'||to_char(p_rec.next_navigation_item_id), 5);
63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
65: --
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: hr_utility.set_location('Entering:'||to_char(p_rec.previous_navigation_item_id), 5);
62: hr_utility.set_location('Entering:'||to_char(p_rec.next_navigation_item_id), 5);
63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
65: --
66: --
255: );
256: --
257: --
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: Exception
261: When hr_api.check_integrity_violated Then
262: -- A check constraint has been violated
263: --
323: --
324: Cursor C_Sel1 is select hr_item_properties_b_s.nextval from sys.dual;
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: --
330: -- Select the next sequence number
331: --
332: Open C_Sel1;
333: Fetch C_Sel1 Into p_rec.item_property_id;
334: Close C_Sel1;
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: End pre_insert;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |-----------------------------< post_insert >------------------------------|
375: --
376: l_proc varchar2(72) := g_package||'post_insert';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: begin
381: --
382: hr_itp_rki.after_insert
383: (p_effective_date => p_effective_date
532: ,p_hook_type => 'AI');
533: --
534: end;
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: End post_insert;
538: --
539: -- ----------------------------------------------------------------------------
540: -- |---------------------------------< ins >----------------------------------|
546: --
547: l_proc varchar2(72) := g_package||'ins';
548: --
549: Begin
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: -- Call the supporting insert validate operations
553: --
554: hr_itp_bus.insert_validate
570: (p_effective_date
571: ,p_rec
572: );
573: --
574: hr_utility.set_location('Leaving:'||l_proc, 20);
575: end ins;
576: --
577: -- ----------------------------------------------------------------------------
578: -- |---------------------------------< ins >----------------------------------|
654: l_rec hr_itp_shd.g_rec_type;
655: l_proc varchar2(72) := g_package||'ins';
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --
660: -- Call conversion function to turn arguments into the
661: -- p_rec structure.
662: --
747: --
748: p_item_property_id := l_rec.item_property_id;
749: p_object_version_number := l_rec.object_version_number;
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 10);
752: End ins;
753: --
754: end hr_itp_ins;