[Home] [Help]
79: l_last_updated_by ben_actl_prem_f.last_updated_by%TYPE;
80: l_last_update_login ben_actl_prem_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=
99: -- If the datetrack_mode is not INSERT then we must populate the WHO
100: -- columns with the 'old' creation values and 'new' updated values.
101: --
102: If (p_datetrack_mode <> 'INSERT') then
103: hr_utility.set_location(l_proc, 10);
104: --
105: -- Select the 'old' created values
106: --
107: Open C_Sel1;
281: l_last_update_login
282: );
283: --
284: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
285: hr_utility.set_location(' Leaving:'||l_proc, 15);
286: --
287: Exception
288: When hr_api.check_integrity_violated Then
289: -- A check constraint has been violated
312: --
313: l_proc varchar2(72) := g_package||'insert_dml';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: dt_insert_dml(p_rec => p_rec,
319: p_effective_date => p_effective_date,
320: p_datetrack_mode => p_datetrack_mode,
320: p_datetrack_mode => p_datetrack_mode,
321: p_validation_start_date => p_validation_start_date,
322: p_validation_end_date => p_validation_end_date);
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End insert_dml;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |------------------------------< pre_insert >------------------------------|
376: --
377: --
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: --
383: open c1;
384: fetch c1 into p_rec.actl_prem_id;
384: fetch c1 into p_rec.actl_prem_id;
385: close c1;
386: --
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End pre_insert;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |-----------------------------< post_insert >------------------------------|
429: --
430: l_proc varchar2(72) := g_package||'post_insert';
431: --
432: Begin
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: --
435: --
436: -- Start of API User Hook for post_insert.
437: --
524: --
525: -- End of API User Hook for post_insert.
526: --
527: --
528: hr_utility.set_location(' Leaving:'||l_proc, 10);
529: End post_insert;
530: --
531: -- ----------------------------------------------------------------------------
532: -- |-------------------------------< ins_lck >--------------------------------|
576: l_validation_start_date date;
577: l_validation_end_date date;
578: --
579: Begin
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: -- Validate the datetrack mode mode getting the validation start
583: -- and end dates for the specified datetrack operation.
584: --
599: --
600: p_validation_start_date := l_validation_start_date;
601: p_validation_end_date := l_validation_end_date;
602: --
603: hr_utility.set_location(' Leaving:'||l_proc, 10);
604: --
605: End ins_lck;
606: --
607: -- ----------------------------------------------------------------------------
618: l_validation_start_date date;
619: l_validation_end_date date;
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call the lock operation
625: --
626: ins_lck
746: l_rec ben_apr_shd.g_rec_type;
747: l_proc varchar2(72) := g_package||'ins';
748: --
749: Begin
750: hr_utility.set_location('Entering:'||l_proc, 5);
751: --
752: -- Call conversion function to turn arguments into the
753: -- p_rec structure.
754: --
838: p_effective_end_date := l_rec.effective_end_date;
839: p_object_version_number := l_rec.object_version_number;
840: --
841: --
842: hr_utility.set_location(' Leaving:'||l_proc, 10);
843: End ins;
844: --
845: end ben_apr_ins;