[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;
123: where crt_ordr_id = p_rec.crt_ordr_id;
124: --
125: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
183: --
184: l_proc varchar2(72) := g_package||'pre_update';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: End pre_update;
191: --
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: End pre_update;
191: --
192: -- ----------------------------------------------------------------------------
193: -- |-----------------------------< post_update >------------------------------|
227: l_old_rec ben_crt_ler.g_crt_ler_rec ;
228: l_new_rec ben_crt_ler.g_crt_ler_rec ;
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: --
234: -- Start of API User Hook for post_update.
235: --
359: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
360: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
361: );
362: --
363: hr_utility.set_location('D M Modie crt ' ||hr_general.g_data_migrator_mode , 378);
364: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
365: hr_utility.set_location(' calling ler check in update ' , 1408379 );
366: --for bug 1408379 the call for this functiom moved from trigger
367: ben_crt_ler.ler_chk(p_old => l_old_rec,
361: );
362: --
363: hr_utility.set_location('D M Modie crt ' ||hr_general.g_data_migrator_mode , 378);
364: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
365: hr_utility.set_location(' calling ler check in update ' , 1408379 );
366: --for bug 1408379 the call for this functiom moved from trigger
367: ben_crt_ler.ler_chk(p_old => l_old_rec,
368: p_new => l_new_rec ,
369: p_effective_date => p_effective_date );
380: --
381: -- End of API User Hook for post_update.
382: --
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 10);
385: End post_update;
386: --
387: -- ----------------------------------------------------------------------------
388: -- |-----------------------------< convert_defs >-----------------------------|
432: l_proc varchar2(72) := g_package||'convert_defs';
433: --
434: Begin
435: --
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- We must now examine each argument value in the
439: -- p_rec plsql record structure
440: -- to see if a system default is being used. If a system default
640: p_rec.pl_typ_id :=
641: ben_crt_shd.g_old_rec.pl_typ_id;
642: End If;
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: --
646: End convert_defs;
647: --
648: -- ----------------------------------------------------------------------------
656: --
657: l_proc varchar2(72) := g_package||'upd';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);
661: --
662: -- We must lock the row which we need to update.
663: ---
664: ben_crt_shd.lck
757: l_rec ben_crt_shd.g_rec_type;
758: l_proc varchar2(72) := g_package||'upd';
759: --
760: Begin
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: -- Call conversion function to turn arguments into the
764: -- l_rec structure.
765: --
827: upd(
828: p_effective_date,l_rec);
829: p_object_version_number := l_rec.object_version_number;
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: End upd;
833: --
834: end ben_crt_upd;