[Home] [Help]
20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
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);
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: --
31: --
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by per_contact_extra_info_f.last_updated_by%TYPE;
102: l_last_update_login per_contact_extra_info_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
292: ,l_last_update_login
293: );
294: --
295: per_rei_shd.g_api_dml := false; -- Unset the api dml status
296: hr_utility.set_location(' Leaving:'||l_proc, 15);
297: --
298: Exception
299: When hr_api.check_integrity_violated Then
300: -- A check constraint has been violated
324: --
325: l_proc varchar2(72) := g_package||'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
334: ,p_validation_start_date => p_validation_start_date
335: ,p_validation_end_date => p_validation_end_date
336: );
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 10);
339: End insert_dml;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |------------------------------< pre_insert >------------------------------|
396: l_proc varchar2(72) := g_package||'pre_insert';
397: l_exists varchar2(1);
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
433: Close C_Sel1;
434: End If;
435: --
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: End pre_insert;
439: --
440: -- ----------------------------------------------------------------------------
441: -- |----------------------------< post_insert >-------------------------------|
479: --
480: l_proc varchar2(72) := g_package||'post_insert';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: begin
485: --
486: per_rei_rki.after_insert
487: (p_effective_date
625: ,p_hook_type => 'AI');
626: --
627: end;
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: End post_insert;
631: --
632: -- ----------------------------------------------------------------------------
633: -- |-------------------------------< ins_lck >--------------------------------|
678: l_validation_end_date date;
679: l_person_id number;
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: select person_id
685: into l_person_id
686: from per_contact_relationships
707: --
708: p_validation_start_date := l_validation_start_date;
709: p_validation_end_date := l_validation_end_date;
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712: --
713: End ins_lck;
714: --
715: -- ----------------------------------------------------------------------------
725: l_validation_start_date date;
726: l_validation_end_date date;
727: --
728: Begin
729: hr_utility.set_location('Entering:'||l_proc, 5);
730: --
731: -- Call the lock operation
732: --
733: per_rei_ins.ins_lck
783: --
784: -- Call to raise any errors on multi-message list
785: hr_multi_message.end_validation_set;
786: --
787: hr_utility.set_location(' Leaving:'||l_proc,10);
788: end ins;
789: --
790: -- ----------------------------------------------------------------------------
791: -- |---------------------------------< ins >----------------------------------|
859: l_rec per_rei_shd.g_rec_type;
860: l_proc varchar2(72) := g_package||'ins';
861: --
862: Begin
863: hr_utility.set_location('Entering:'||l_proc, 5);
864: --
865: -- Call conversion function to turn arguments into the
866: -- p_rec structure.
867: --
947: p_effective_end_date := l_rec.effective_end_date;
948: p_object_version_number := l_rec.object_version_number;
949: --
950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 10);
952: End ins;
953: --
954: end per_rei_ins;