[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_ber_ins.g_elig_rslt_id_i := p_elig_rslt_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_ber_ins.g_elig_rslt_id_i := p_elig_rslt_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_rslt_f.last_updated_by%TYPE;
102: l_last_update_login ben_elig_rslt_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 :=
188: ,l_last_update_login
189: );
190: --
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 15);
193: --
194: Exception
195: When hr_api.check_integrity_violated Then
196: -- A check constraint has been violated
220: --
221: l_proc varchar2(72) := g_package||'insert_dml';
222: --
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: ben_ber_ins.dt_insert_dml
227: (p_rec => p_rec
228: ,p_effective_date => p_effective_date
230: ,p_validation_start_date => p_validation_start_date
231: ,p_validation_end_date => p_validation_end_date
232: );
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 10);
235: End insert_dml;
236: --
237: -- ----------------------------------------------------------------------------
238: -- |------------------------------< pre_insert >------------------------------|
292: l_proc varchar2(72) := g_package||'pre_insert';
293: l_exists varchar2(1);
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: If (ben_ber_ins.g_elig_rslt_id_i is not null) Then
299: --
300: -- Verify registered primary key values not already in use
329: Close C_Sel1;
330: End If;
331: --
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: End pre_insert;
335: --
336: -- ----------------------------------------------------------------------------
337: -- |----------------------------< post_insert >-------------------------------|
375: --
376: l_proc varchar2(72) := g_package||'post_insert';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: begin
381: --
382: ben_ber_rki.after_insert
383: (p_effective_date
415: ,p_hook_type => 'AI');
416: --
417: end;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 10);
420: End post_insert;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |-------------------------------< ins_lck >--------------------------------|
467: l_validation_start_date date;
468: l_validation_end_date date;
469: --
470: Begin
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: -- Validate the datetrack mode mode getting the validation start
474: -- and end dates for the specified datetrack operation.
475: --
491: --
492: p_validation_start_date := l_validation_start_date;
493: p_validation_end_date := l_validation_end_date;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: --
497: End ins_lck;
498: --
499: -- ----------------------------------------------------------------------------
509: l_validation_start_date date;
510: l_validation_end_date date;
511: --
512: Begin
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- Call the lock operation
516: --
517: ben_ber_ins.ins_lck
567: --
568: -- Call to raise any errors on multi-message list
569: hr_multi_message.end_validation_set;
570: --
571: hr_utility.set_location('Leaving:'||l_proc,10);
572: end ins;
573: --
574: -- ----------------------------------------------------------------------------
575: -- |---------------------------------< ins >----------------------------------|
590: l_rec ben_ber_shd.g_rec_type;
591: l_proc varchar2(72) := g_package||'ins';
592: --
593: Begin
594: hr_utility.set_location('Entering:'||l_proc, 5);
595: --
596: -- Call conversion function to turn arguments into the
597: -- p_rec structure.
598: --
625: p_effective_end_date := l_rec.effective_end_date;
626: p_object_version_number := l_rec.object_version_number;
627: --
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: End ins;
631: --
632: end ben_ber_ins;