APPS.PER_ABS_INS dependencies on PER_ABS_INS

Line 1: Package Body per_abs_ins as

1: Package Body per_abs_ins as
2: /* $Header: peabsrhi.pkb 120.27.12020000.3 2012/11/05 11:44:22 srannama ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_abs_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_abs_ins.'; -- Global package name
9:
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 23: per_abs_ins.g_absence_attendance_id_i := p_absence_attendance_id;

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);
26: End set_base_key_value;
27:

Line 342: where absence_attendance_id = per_abs_ins.g_absence_attendance_id_i;

338:
339: Cursor C_Sel2 is
340: select null
341: from per_absence_attendances
342: where absence_attendance_id = per_abs_ins.g_absence_attendance_id_i;
343:
344:
345: Cursor c_get_occurrence is
346: select nvl(max(abs.occurrence), 0) + 1

Line 380: If per_abs_ins.g_absence_attendance_id_i is not null then

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: --
382: -- Verify registered primary key values not already in use
383: --
384: Open C_Sel2;

Line 399: p_rec.absence_attendance_id := per_abs_ins.g_absence_attendance_id_i;

395: Close C_Sel2;
396: --
397: -- Use registered key values and clear globals
398: --
399: p_rec.absence_attendance_id := per_abs_ins.g_absence_attendance_id_i;
400: per_abs_ins.g_absence_attendance_id_i := null;
401: --
402: else
403: --

Line 400: per_abs_ins.g_absence_attendance_id_i := null;

396: --
397: -- Use registered key values and clear globals
398: --
399: p_rec.absence_attendance_id := per_abs_ins.g_absence_attendance_id_i;
400: per_abs_ins.g_absence_attendance_id_i := null;
401: --
402: else
403: --
404: --

Line 712: per_abs_ins.pre_insert(p_rec, p_effective_date);

708: );
709: --
710: -- Call the supporting pre_insert operation
711: --
712: per_abs_ins.pre_insert(p_rec, p_effective_date);
713: --
714: -- Insert the row
715: --
716: per_abs_ins.insert_dml(p_rec);

Line 716: per_abs_ins.insert_dml(p_rec);

712: per_abs_ins.pre_insert(p_rec, p_effective_date);
713: --
714: -- Insert the row
715: --
716: per_abs_ins.insert_dml(p_rec);
717: --
718: -- Call the supporting post-insert operation
719: --
720: per_abs_ins.post_insert

Line 720: per_abs_ins.post_insert

716: per_abs_ins.insert_dml(p_rec);
717: --
718: -- Call the supporting post-insert operation
719: --
720: per_abs_ins.post_insert
721: (p_effective_date
722: ,p_rec
723: );
724: --

Line 940: per_abs_ins.ins

936: --
937: -- Having converted the arguments into the per_abs_rec
938: -- plsql record structure we call the corresponding record business process.
939: --
940: per_abs_ins.ins
941: (p_effective_date => p_effective_date
942: ,p_rec => l_rec
943: ,p_dur_dys_less_warning => p_dur_dys_less_warning
944: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning

Line 964: end per_abs_ins;

960: --
961: hr_utility.set_location(' Leaving:'||l_proc, 10);
962: End ins;
963: --
964: end per_abs_ins;