[Home] [Help]
1: Package Body OTA_ONT_UPD as
2: /* $Header: otontrhi.pkb 120.0 2005/05/29 07:29:47 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_ont_upd.'; -- Global package name
9:
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
330: hr_multi_message.end_validation_set;
331: --
332: -- Call the supporting pre-update operation
333: --
334: ota_ont_upd.pre_update(p_rec);
335: --
336: -- Update the row.
337: --
338: ota_ont_upd.update_dml(p_rec);
334: ota_ont_upd.pre_update(p_rec);
335: --
336: -- Update the row.
337: --
338: ota_ont_upd.update_dml(p_rec);
339: --
340: -- Call the supporting post-update operation
341: --
342: ota_ont_upd.post_update
338: ota_ont_upd.update_dml(p_rec);
339: --
340: -- Call the supporting post-update operation
341: --
342: ota_ont_upd.post_update
343: (p_effective_date
344: ,p_rec
345: );
346: --
381: -- Having converted the arguments into the
382: -- plsql record structure we call the corresponding record
383: -- business process.
384: --
385: ota_ont_upd.upd
386: (p_effective_date
387: ,l_rec
388: );
389: --
420: -- Update the translated values for every matching row
421: -- setting SOURCE_LANG to the specified language.
422: --
423: for l_lang in csr_upd_langs loop
424: ota_ont_upd.upd
425: (p_effective_date => p_effective_date
426: ,p_offering_id => p_offering_id
427: ,p_language => l_lang.language
428: ,p_source_lang => p_language_code
433: --
434: hr_utility.set_location(' Leaving:'||l_proc,20);
435: End upd_tl;
436: --
437: end ota_ont_upd;