APPS.PER_REI_INS dependencies on PER_REI_INS

Line 1: Package Body per_rei_ins as

1: Package Body per_rei_ins as
2: /* $Header: pereirhi.pkb 115.6 2003/10/07 19:01:25 ttagawa noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_rei_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 26: per_rei_ins.g_contact_extra_info_id_i := p_contact_extra_info_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_rei_ins.g_contact_extra_info_id_i := p_contact_extra_info_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 330: per_rei_ins.dt_insert_dml

326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: per_rei_ins.dt_insert_dml
331: (p_rec => p_rec
332: ,p_effective_date => p_effective_date
333: ,p_datetrack_mode => p_datetrack_mode
334: ,p_validation_start_date => p_validation_start_date

Line 394: per_rei_ins.g_contact_extra_info_id_i;

390: Cursor C_Sel2 is
391: Select null
392: from per_contact_extra_info_f
393: where contact_extra_info_id =
394: per_rei_ins.g_contact_extra_info_id_i;
395: --
396: l_proc varchar2(72) := g_package||'pre_insert';
397: l_exists varchar2(1);
398: --

Line 402: If (per_rei_ins.g_contact_extra_info_id_i is not null) Then

398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: If (per_rei_ins.g_contact_extra_info_id_i is not null) Then
403: --
404: -- Verify registered primary key values not already in use
405: --
406: Open C_Sel2;

Line 422: per_rei_ins.g_contact_extra_info_id_i;

418: --
419: -- Use registered key values and clear globals
420: --
421: p_rec.contact_extra_info_id :=
422: per_rei_ins.g_contact_extra_info_id_i;
423: per_rei_ins.g_contact_extra_info_id_i := null;
424: Else
425: --
426: -- No registerd key values, so select the next sequence number

Line 423: per_rei_ins.g_contact_extra_info_id_i := null;

419: -- Use registered key values and clear globals
420: --
421: p_rec.contact_extra_info_id :=
422: per_rei_ins.g_contact_extra_info_id_i;
423: per_rei_ins.g_contact_extra_info_id_i := null;
424: Else
425: --
426: -- No registerd key values, so select the next sequence number
427: --

Line 733: per_rei_ins.ins_lck

729: hr_utility.set_location('Entering:'||l_proc, 5);
730: --
731: -- Call the lock operation
732: --
733: per_rei_ins.ins_lck
734: (p_effective_date => p_effective_date
735: ,p_datetrack_mode => l_datetrack_mode
736: ,p_rec => p_rec
737: ,p_validation_start_date => l_validation_start_date

Line 756: per_rei_ins.pre_insert

752: hr_multi_message.end_validation_set;
753: --
754: -- Call the supporting pre-insert operation
755: --
756: per_rei_ins.pre_insert
757: (p_rec => p_rec
758: ,p_effective_date => p_effective_date
759: ,p_datetrack_mode => l_datetrack_mode
760: ,p_validation_start_date => l_validation_start_date

Line 766: per_rei_ins.insert_dml

762: );
763: --
764: -- Insert the row
765: --
766: per_rei_ins.insert_dml
767: (p_rec => p_rec
768: ,p_effective_date => p_effective_date
769: ,p_datetrack_mode => l_datetrack_mode
770: ,p_validation_start_date => l_validation_start_date

Line 776: per_rei_ins.post_insert

772: );
773: --
774: -- Call the supporting post-insert operation
775: --
776: per_rei_ins.post_insert
777: (p_rec => p_rec
778: ,p_effective_date => p_effective_date
779: ,p_datetrack_mode => l_datetrack_mode
780: ,p_validation_start_date => l_validation_start_date

Line 938: per_rei_ins.ins

934: -- Having converted the arguments into the per_rei_rec
935: -- plsql record structure we call the corresponding record
936: -- business process.
937: --
938: per_rei_ins.ins
939: (p_effective_date
940: ,l_rec
941: );
942: --

Line 954: end per_rei_ins;

950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 10);
952: End ins;
953: --
954: end per_rei_ins;