1: Package Body ota_ctl_upd as
2: /* $Header: otctlrhi.pkb 120.2 2005/12/01 16:42 cmora noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_ctl_upd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< update_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
379: hr_multi_message.end_validation_set;
380: --
381: -- Call the supporting pre-update operation
382: --
383: ota_ctl_upd.pre_update(p_rec);
384: --
385: -- Update the row.
386: --
387: ota_ctl_upd.update_dml(p_rec);
383: ota_ctl_upd.pre_update(p_rec);
384: --
385: -- Update the row.
386: --
387: ota_ctl_upd.update_dml(p_rec);
388: --
389: -- Call the supporting post-update operation
390: --
391: ota_ctl_upd.post_update
387: ota_ctl_upd.update_dml(p_rec);
388: --
389: -- Call the supporting post-update operation
390: --
391: ota_ctl_upd.post_update
392: (p_effective_date
393: ,p_rec
394: );
395: --
442: -- Having converted the arguments into the
443: -- plsql record structure we call the corresponding record
444: -- business process.
445: --
446: ota_ctl_upd.upd
447: (p_effective_date
448: ,l_rec
449: );
450: --
487: -- Update the translated values for every matching row
488: -- setting SOURCE_LANG to the specified language.
489: --
490: for l_lang in csr_upd_langs loop
491: ota_ctl_upd.upd
492: (p_effective_date => p_effective_date
493: ,p_certification_id => p_certification_id
494: ,p_language => l_lang.language
495: ,p_source_lang => p_language_code
506: --
507: hr_utility.set_location(' Leaving:'||l_proc,20);
508: End upd_tl;
509: --
510: end ota_ctl_upd;