[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_esw_ins.g_elig_scre_wtg_id_i := p_elig_scre_wtg_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_esw_ins.g_elig_scre_wtg_id_i := p_elig_scre_wtg_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
100: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;
101: l_last_updated_by ben_elig_scre_wtg_f.last_updated_by%TYPE;
102: --
103: Begin
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: -- Set the effective start and end dates to the corresponding
107: -- validation start and end dates
108: --
112: -- If the datetrack_mode is not INSERT then we must populate the WHO
113: -- columns with the 'old' creation values and 'new' updated values.
114: --
115: If (p_datetrack_mode <> hr_api.g_insert) then
116: hr_utility.set_location(l_proc, 10);
117: --
118: -- Get the object version number for the insert
119: --
120: p_rec.object_version_number :=
192: ,l_last_updated_by
193: );
194: --
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: --
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
224: --
225: l_proc varchar2(72) := g_package||'insert_dml';
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: ben_esw_ins.dt_insert_dml
231: (p_rec => p_rec
232: ,p_effective_date => p_effective_date
234: ,p_validation_start_date => p_validation_start_date
235: ,p_validation_end_date => p_validation_end_date
236: );
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End insert_dml;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |------------------------------< pre_insert >------------------------------|
296: l_proc varchar2(72) := g_package||'pre_insert';
297: l_exists varchar2(1);
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: If (ben_esw_ins.g_elig_scre_wtg_id_i is not null) Then
303: --
304: -- Verify registered primary key values not already in use
333: Close C_Sel1;
334: End If;
335: --
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: End pre_insert;
339: --
340: -- ----------------------------------------------------------------------------
341: -- |----------------------------< post_insert >-------------------------------|
379: --
380: l_proc varchar2(72) := g_package||'post_insert';
381: --
382: Begin
383: hr_utility.set_location('Entering:'||l_proc, 5);
384: begin
385: --
386: ben_esw_rki.after_insert
387: (p_effective_date
427: ,p_hook_type => 'AI');
428: --
429: end;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: End post_insert;
433: --
434: -- ----------------------------------------------------------------------------
435: -- |-------------------------------< ins_lck >--------------------------------|
479: l_validation_start_date date;
480: l_validation_end_date date;
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Validate the datetrack mode mode getting the validation start
486: -- and end dates for the specified datetrack operation.
487: --
500: --
501: p_validation_start_date := l_validation_start_date;
502: p_validation_end_date := l_validation_end_date;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 10);
505: --
506: End ins_lck;
507: --
508: -- ----------------------------------------------------------------------------
518: l_validation_start_date date;
519: l_validation_end_date date;
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Call the lock operation
525: --
526: ben_esw_ins.ins_lck
576: --
577: -- Call to raise any errors on multi-message list
578: hr_multi_message.end_validation_set;
579: --
580: hr_utility.set_location('Leaving:'||l_proc,10);
581: end ins;
582: --
583: -- ----------------------------------------------------------------------------
584: -- |---------------------------------< ins >----------------------------------|
603: l_rec ben_esw_shd.g_rec_type;
604: l_proc varchar2(72) := g_package||'ins';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: -- Call conversion function to turn arguments into the
610: -- p_rec structure.
611: --
642: p_effective_end_date := l_rec.effective_end_date;
643: p_object_version_number := l_rec.object_version_number;
644: --
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 10);
647: End ins;
648: --
649: end ben_esw_ins;