[Home] [Help]
17: --
18: l_proc varchar2(72) := g_package||'set_base_key_value';
19: --
20: Begin
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: per_abs_ins.g_absence_attendance_id_i := p_absence_attendance_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: per_abs_ins.g_absence_attendance_id_i := p_absence_attendance_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: End set_base_key_value;
27:
28: --
29: -- ----------------------------------------------------------------------------
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: per_abs_shd.g_api_dml := true; -- Set the api dml status
83: --
265: );
266: --
267: per_abs_shd.g_api_dml := false; -- Unset the api dml status
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: Exception
271: When hr_api.check_integrity_violated Then
272: -- A check constraint has been violated
273: per_abs_shd.g_api_dml := false; -- Unset the api dml status
352: --
353:
354: Begin
355:
356: hr_utility.set_location('Entering:'||l_proc, 5);
357:
358: /*
359: per_abs_bus.chk_cal_duration
360: (p_absence_attendance_id => p_rec.absence_attendance_id
373: );
374: p_entitlement_warning := l_entitlement_warning;
375: */
376:
377: hr_utility.set_location(l_proc, 10);
378:
379: -- nachuri changes for using base key passed from bc4j
380: If per_abs_ins.g_absence_attendance_id_i is not null then
381: --
411: --
412: End If;
413:
414:
415: hr_utility.set_location(l_proc, 20);
416:
417: --
418: -- Fetch the next occurrence number
419: --
430: p_rec.absence_hours := per_abs_shd.g_absence_hours;
431: p_rec.absence_days := per_abs_shd.g_absence_days;
432:
433:
434: hr_utility.set_location(' Leaving:'||l_proc, 50);
435:
436: End pre_insert;
437: --
438: -- ----------------------------------------------------------------------------
474: --
475: l_proc varchar2(72) := g_package||'post_insert';
476: --
477: Begin
478: hr_utility.set_location('Entering:'||l_proc, 5);
479: begin
480: hr_utility.set_location(l_proc, 10);
481:
482: per_abs_rki.after_insert
476: --
477: Begin
478: hr_utility.set_location('Entering:'||l_proc, 5);
479: begin
480: hr_utility.set_location(l_proc, 10);
481:
482: per_abs_rki.after_insert
483: (p_effective_date => p_effective_date
484: ,p_absence_attendance_id
668: ,p_hook_type => 'AI');
669: --
670: end;
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: End post_insert;
674: --
675: -- ----------------------------------------------------------------------------
676: -- |---------------------------------< ins >----------------------------------|
690: l_proc varchar2(72) := g_package||'ins';
691: --
692: Begin
693:
694: hr_utility.set_location('Entering:'||l_proc, 5);
695: --
696: -- Call the supporting insert validate operations
697: --
698: per_abs_bus.insert_validate
721: (p_effective_date
722: ,p_rec
723: );
724: --
725: hr_utility.set_location('Leaving:'||l_proc, 20);
726:
727: end ins;
728: --
729: -- ----------------------------------------------------------------------------
836: l_absence_days number;
837: l_absence_hours number;
838: --
839: Begin
840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: -- Call conversion function to turn arguments into the
843: -- p_rec structure.
844: --
957: p_absence_days := l_rec.absence_days;
958: p_absence_hours := l_rec.absence_hours;
959: p_occurrence := l_rec.occurrence;
960: --
961: hr_utility.set_location(' Leaving:'||l_proc, 10);
962: End ins;
963: --
964: end per_abs_ins;