[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: ben_bep_ins.g_elig_obj_elig_prfl_id_i := p_elig_obj_elig_prfl_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_bep_ins.g_elig_obj_elig_prfl_id_i := p_elig_obj_elig_prfl_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 ben_elig_obj_elig_profl_f.last_updated_by%TYPE;
102: l_last_update_login ben_elig_obj_elig_profl_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Set the effective start and end dates to the corresponding
108: -- validation start and end dates
109: --
113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=
228: ,l_last_update_login
229: );
230: --
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 15);
233: --
234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
260: --
261: l_proc varchar2(72) := g_package||'insert_dml';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: ben_bep_ins.dt_insert_dml
267: (p_rec => p_rec
268: ,p_effective_date => p_effective_date
270: ,p_validation_start_date => p_validation_start_date
271: ,p_validation_end_date => p_validation_end_date
272: );
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: End insert_dml;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |------------------------------< pre_insert >------------------------------|
332: l_proc varchar2(72) := g_package||'pre_insert';
333: l_exists varchar2(1);
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: If (ben_bep_ins.g_elig_obj_elig_prfl_id_i is not null) Then
339: --
340: -- Verify registered primary key values not already in use
369: Close C_Sel1;
370: End If;
371: --
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: End pre_insert;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |----------------------------< post_insert >-------------------------------|
415: --
416: l_proc varchar2(72) := g_package||'post_insert';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: begin
421: --
422: ben_bep_rki.after_insert
423: (p_effective_date
495: ,p_hook_type => 'AI');
496: --
497: end;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc, 10);
500: End post_insert;
501: --
502: -- ----------------------------------------------------------------------------
503: -- |-------------------------------< ins_lck >--------------------------------|
547: l_validation_start_date date;
548: l_validation_end_date date;
549: --
550: Begin
551: hr_utility.set_location('Entering:'||l_proc, 5);
552: --
553: -- Validate the datetrack mode mode getting the validation start
554: -- and end dates for the specified datetrack operation.
555: --
574: --
575: p_validation_start_date := l_validation_start_date;
576: p_validation_end_date := l_validation_end_date;
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 10);
579: --
580: End ins_lck;
581: --
582: -- ----------------------------------------------------------------------------
592: l_validation_start_date date;
593: l_validation_end_date date;
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: -- Call the lock operation
599: --
600: ben_bep_ins.ins_lck
650: --
651: -- Call to raise any errors on multi-message list
652: hr_multi_message.end_validation_set;
653: --
654: hr_utility.set_location('Leaving:'||l_proc,10);
655: end ins;
656: --
657: -- ----------------------------------------------------------------------------
658: -- |---------------------------------< ins >----------------------------------|
693: l_rec ben_bep_shd.g_rec_type;
694: l_proc varchar2(72) := g_package||'ins';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: -- Call conversion function to turn arguments into the
700: -- p_rec structure.
701: --
748: p_effective_end_date := l_rec.effective_end_date;
749: p_object_version_number := l_rec.object_version_number;
750: --
751: --
752: hr_utility.set_location(' Leaving:'||l_proc, 10);
753: End ins;
754: --
755: end ben_bep_ins;