[Home] [Help]
1: Package Body hr_ttl_upd as
2: /* $Header: hrttlrhi.pkb 115.1 2004/04/05 07:21 menderby noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hr_ttl_upd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< update_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
312: hr_multi_message.end_validation_set;
313: --
314: -- Call the supporting pre-update operation
315: --
316: hr_ttl_upd.pre_update(p_rec);
317: --
318: -- Update the row.
319: --
320: hr_ttl_upd.update_dml(p_rec);
316: hr_ttl_upd.pre_update(p_rec);
317: --
318: -- Update the row.
319: --
320: hr_ttl_upd.update_dml(p_rec);
321: --
322: -- Call the supporting post-update operation
323: --
324: hr_ttl_upd.post_update
320: hr_ttl_upd.update_dml(p_rec);
321: --
322: -- Call the supporting post-update operation
323: --
324: hr_ttl_upd.post_update
325: (p_rec
326: );
327: --
328: -- Call to raise any errors on multi-message list
359: -- Having converted the arguments into the
360: -- plsql record structure we call the corresponding record
361: -- business process.
362: --
363: hr_ttl_upd.upd
364: (l_rec
365: );
366: --
367: --
396: -- Update the translated values for every matching row
397: -- setting SOURCE_LANG to the specified language.
398: --
399: for l_lang in csr_upd_langs loop
400: hr_ttl_upd.upd
401: (p_topic_id => p_topic_id
402: ,p_language => l_lang.language
403: ,p_source_lang => p_language_code
404: ,p_name => p_name
407: --
408: hr_utility.set_location(' Leaving:'||l_proc,20);
409: End upd_tl;
410: --
411: end hr_ttl_upd;