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: --
213: );
214: --
215: --
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: Exception
219: When hr_api.check_integrity_violated Then
220: -- A check constraint has been violated
221: --
281: --
282: Cursor C_Sel1 is select hr_item_properties_b_s.nextval from sys.dual;
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: --
288: -- Select the next sequence number
289: --
290: Open C_Sel1;
291: Fetch C_Sel1 Into p_rec.item_property_id;
292: Close C_Sel1;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: End pre_insert;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |-----------------------------< post_insert >------------------------------|
333: --
334: l_proc varchar2(72) := g_package||'post_insert';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: begin
339: --
340: hr_itp_rki.after_insert
341: (p_effective_date => p_effective_date
490: ,p_hook_type => 'AI');
491: --
492: end;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 10);
495: End post_insert;
496: --
497: -- ----------------------------------------------------------------------------
498: -- |---------------------------------< ins >----------------------------------|
504: --
505: l_proc varchar2(72) := g_package||'ins';
506: --
507: Begin
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: -- Call the supporting insert validate operations
511: --
512: hr_itp_bus.insert_validate
528: (p_effective_date
529: ,p_rec
530: );
531: --
532: hr_utility.set_location('Leaving:'||l_proc, 20);
533: end ins;
534: --
535: -- ----------------------------------------------------------------------------
536: -- |---------------------------------< ins >----------------------------------|
612: l_rec hr_itp_shd.g_rec_type;
613: l_proc varchar2(72) := g_package||'ins';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: -- Call conversion function to turn arguments into the
619: -- p_rec structure.
620: --
705: --
706: p_item_property_id := l_rec.item_property_id;
707: p_object_version_number := l_rec.object_version_number;
708: --
709: hr_utility.set_location(' Leaving:'||l_proc, 10);
710: End ins;
711: --
712: end hr_itp_ins;