[Home] [Help]
1: Package Body pqh_trl_upd as
2: /* $Header: pqtrlrhi.pkb 115.3 2002/12/12 21:39:54 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_trl_upd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< update_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
309: );
310: --
311: -- Call the supporting pre-update operation
312: --
313: pqh_trl_upd.pre_update(p_rec);
314: --
315: -- Update the row.
316: --
317: pqh_trl_upd.update_dml(p_rec);
313: pqh_trl_upd.pre_update(p_rec);
314: --
315: -- Update the row.
316: --
317: pqh_trl_upd.update_dml(p_rec);
318: --
319: -- Call the supporting post-update operation
320: --
321: pqh_trl_upd.post_update
317: pqh_trl_upd.update_dml(p_rec);
318: --
319: -- Call the supporting post-update operation
320: --
321: pqh_trl_upd.post_update
322: (p_rec
323: );
324: End upd;
325: --
353: -- Having converted the arguments into the
354: -- plsql record structure we call the corresponding record
355: -- business process.
356: --
357: pqh_trl_upd.upd
358: (l_rec
359: );
360: --
361: --
389: -- Update the translated values for every matching row
390: -- setting SOURCE_LANG to the specified language.
391: --
392: for l_lang in csr_upd_langs loop
393: pqh_trl_upd.upd
394: (p_table_route_id => p_table_route_id
395: ,p_language => l_lang.language
396: ,p_source_lang => p_language_code
397: ,p_display_name => p_display_name
400: --
401: hr_utility.set_location(' Leaving:'||l_proc,20);
402: End upd_tl;
403: --
404: end pqh_trl_upd;