[Home] [Help]
1: Package Body pay_opt_upd as
2: /* $Header: pyoptrhi.pkb 115.3 2002/12/05 17:29:47 nbristow noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_opt_upd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< update_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
309: );
310: --
311: -- Call the supporting pre-update operation
312: --
313: pay_opt_upd.pre_update(p_rec);
314: --
315: -- Update the row.
316: --
317: pay_opt_upd.update_dml(p_rec);
313: pay_opt_upd.pre_update(p_rec);
314: --
315: -- Update the row.
316: --
317: pay_opt_upd.update_dml(p_rec);
318: --
319: -- Call the supporting post-update operation
320: --
321: pay_opt_upd.post_update
317: pay_opt_upd.update_dml(p_rec);
318: --
319: -- Call the supporting post-update operation
320: --
321: pay_opt_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: pay_opt_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: pay_opt_upd.upd
394: (p_org_payment_method_id => p_org_payment_method_id
395: ,p_language => l_lang.language
396: ,p_source_lang => p_language_code
397: ,p_org_payment_method_name => p_org_payment_method_name
400: --
401: hr_utility.set_location(' Leaving:'||l_proc,20);
402: End upd_tl;
403: --
404: end pay_opt_upd;