[Home] [Help]
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
122: where elig_dpnt_id = p_rec.elig_dpnt_id;
123: --
124: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: --
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: End pre_update;
190: --
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: End pre_update;
190: --
191: -- ----------------------------------------------------------------------------
192: -- |-----------------------------< post_update >------------------------------|
228: l_old_rec ben_egd_ler.g_egd_ler_rec;
229: l_new_rec ben_egd_ler.g_egd_ler_rec;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- Life event trigger
235: --
236: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
252: l_new_rec.ovrdn_flag := p_rec.ovrdn_flag;
253: l_new_rec.create_dt := p_rec.create_dt;
254: l_new_rec.per_in_ler_id := p_rec.per_in_ler_id; --Bug 5630251
255:
256: hr_utility.set_location(' Old per_in_ler_id ' || l_old_rec.per_in_ler_id , 9876 );
257: --
258: ben_egd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_date);
259: --
260: -- Start of API User Hook for post_update.
379: --
380: -- End of API User Hook for post_update.
381: --
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End post_update;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |-----------------------------< convert_defs >-----------------------------|
431: l_proc varchar2(72) := g_package||'convert_defs';
432: --
433: Begin
434: --
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- We must now examine each argument value in the
438: -- p_rec plsql record structure
439: -- to see if a system default is being used. If a system default
636: ben_egd_shd.g_old_rec.program_update_date;
637: End If;
638:
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: --
642: End convert_defs;
643: --
644: -- ----------------------------------------------------------------------------
652: --
653: l_proc varchar2(72) := g_package||'upd';
654: --
655: Begin
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: --
658: -- We must lock the row which we need to update.
659: --
660: ben_egd_shd.lck
749: l_rec ben_egd_shd.g_rec_type;
750: l_proc varchar2(72) := g_package||'upd';
751: --
752: Begin
753: hr_utility.set_location('Entering:'||l_proc, 5);
754: --
755: -- Call conversion function to turn arguments into the
756: -- l_rec structure.
757: --
818: upd(
819: p_effective_date,l_rec);
820: p_object_version_number := l_rec.object_version_number;
821: --
822: hr_utility.set_location(' Leaving:'||l_proc, 10);
823: End upd;
824: --
825: end ben_egd_upd;