[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;
136: where prtt_rt_val_id = p_rec.prtt_rt_val_id;
137: --
138: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
204: l_effective_date date := p_effective_date;
205: l_proc varchar2(72) := g_package||'pre_update';
206: --
207: Begin
208: hr_utility.set_location('Entering:'||l_proc, 5);
209:
210: -- If the rate is ending before it's starting, void the rate and update
211: -- the associated enrt_rt to no longer have an FK to it.
212:
226: p_object_version_number => l_enrt_rt_ovn,
227: p_effective_date => l_effective_date);
228: end if;
229: end if;
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: End pre_update;
232: --
233: -- ----------------------------------------------------------------------------
234: -- |-----------------------------< post_update >------------------------------|
269: l_old_rec ben_prv_ler.g_prv_ler_rec ;
270: l_new_rec ben_prv_ler.g_prv_ler_rec ;
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: -- Start of API User Hook for post_update.
275: --
276: begin
277: l_old_rec.prtt_enrt_rslt_id := ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
442: ,p_object_version_number_o =>ben_prv_shd.g_old_rec.object_version_number
443: );
444: hr_utility.set_location('DM Mode prv ' ||hr_general.g_data_migrator_mode ,379);
445: --bug 1408379 caliing ler_chk moved from trigger to here
446: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
447: ben_prv_ler.ler_chk(p_old => l_old_rec
448: ,p_new => l_new_rec
459: end;
460: --
461: -- End of API User Hook for post_update.
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: End post_update;
465: --
466: -- ----------------------------------------------------------------------------
467: -- |-----------------------------< convert_defs >-----------------------------|
512: l_proc varchar2(72) := g_package||'convert_defs';
513: --
514: Begin
515: --
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- We must now examine each argument value in the
519: -- p_rec plsql record structure
520: -- to see if a system default is being used. If a system default
780: ben_prv_shd.g_old_rec.pk_id;
781: End If;
782:
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 10);
785: --
786: End convert_defs;
787: --
788: -- ----------------------------------------------------------------------------
793: p_effective_date in date ) is
794: l_proc varchar2(72) := g_package||'upd';
795: --
796: Begin
797: hr_utility.set_location('Entering:'||l_proc, 5);
798: ---
799: -- We must lock the row which we need to update.
800: --
801: ben_prv_shd.lck
904: l_rec ben_prv_shd.g_rec_type;
905: l_proc varchar2(72) := g_package||'upd';
906: --
907: Begin
908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: -- Call conversion function to turn arguments into the
911: -- l_rec structure.
912: --
989:
990:
991: p_object_version_number := l_rec.object_version_number;
992: --
993: hr_utility.set_location(' Leaving:'||l_proc, 10);
994: End upd;
995: --
996: end ben_prv_upd;