[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_beo_ins.g_elig_obj_id_i := p_elig_obj_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_beo_ins.g_elig_obj_id_i := p_elig_obj_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_f.last_updated_by%TYPE;
102: l_last_update_login ben_elig_obj_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 :=
186: ,l_last_update_login
187: );
188: --
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 15);
191: --
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
218: --
219: l_proc varchar2(72) := g_package||'insert_dml';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: --
224: ben_beo_ins.dt_insert_dml
225: (p_rec => p_rec
226: ,p_effective_date => p_effective_date
228: ,p_validation_start_date => p_validation_start_date
229: ,p_validation_end_date => p_validation_end_date
230: );
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: End insert_dml;
234: --
235: -- ----------------------------------------------------------------------------
236: -- |------------------------------< pre_insert >------------------------------|
290: l_proc varchar2(72) := g_package||'pre_insert';
291: l_exists varchar2(1);
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: If (ben_beo_ins.g_elig_obj_id_i is not null) Then
297: --
298: -- Verify registered primary key values not already in use
327: Close C_Sel1;
328: End If;
329: --
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: End pre_insert;
333: --
334: -- ----------------------------------------------------------------------------
335: -- |----------------------------< post_insert >-------------------------------|
373: --
374: l_proc varchar2(72) := g_package||'post_insert';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: begin
379: --
380: ben_beo_rki.after_insert
381: (p_effective_date
411: ,p_hook_type => 'AI');
412: --
413: end;
414: --
415: hr_utility.set_location(' Leaving:'||l_proc, 10);
416: End post_insert;
417: --
418: -- ----------------------------------------------------------------------------
419: -- |-------------------------------< ins_lck >--------------------------------|
463: l_validation_start_date date;
464: l_validation_end_date date;
465: --
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: -- Validate the datetrack mode mode getting the validation start
470: -- and end dates for the specified datetrack operation.
471: --
487: --
488: p_validation_start_date := l_validation_start_date;
489: p_validation_end_date := l_validation_end_date;
490: --
491: hr_utility.set_location(' Leaving:'||l_proc, 10);
492: --
493: End ins_lck;
494: --
495: -- ----------------------------------------------------------------------------
505: l_validation_start_date date;
506: l_validation_end_date date;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call the lock operation
512: --
513: ben_beo_ins.ins_lck
563: --
564: -- Call to raise any errors on multi-message list
565: hr_multi_message.end_validation_set;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,10);
568: end ins;
569: --
570: -- ----------------------------------------------------------------------------
571: -- |---------------------------------< ins >----------------------------------|
585: l_rec ben_beo_shd.g_rec_type;
586: l_proc varchar2(72) := g_package||'ins';
587: --
588: Begin
589: hr_utility.set_location('Entering:'||l_proc, 5);
590: --
591: -- Call conversion function to turn arguments into the
592: -- p_rec structure.
593: --
619: p_effective_end_date := l_rec.effective_end_date;
620: p_object_version_number := l_rec.object_version_number;
621: --
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 10);
624: End ins;
625: --
626: end ben_beo_ins;