DBA Data[Home] [Help]

APPS.PAY_PPM_SHD dependencies on PAY_PPM_SHD

Line 1: Package Body pay_ppm_shd as

1: Package Body pay_ppm_shd as
2: /* $Header: pyppmrhi.pkb 120.3.12010000.5 2010/03/30 06:46:19 priupadh ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_ppm_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_ppm_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< return_api_dml_status >-------------------------|
12: -- ----------------------------------------------------------------------------

Line 439: where hc.comment_id = pay_ppm_shd.g_old_rec.comment_id;

435: --
436: Cursor C_Sel3 is
437: select hc.comment_text
438: from hr_comments hc
439: where hc.comment_id = pay_ppm_shd.g_old_rec.comment_id;
440: --
441: Begin
442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --

Line 507: Fetch C_Sel3 Into pay_ppm_shd.g_old_rec.comments;

503: p_datetrack_mode = 'CORRECTION' or
504: p_datetrack_mode = 'UPDATE_OVERRIDE' or
505: p_datetrack_mode = 'UPDATE_CHANGE_INSERT')) then
506: Open C_Sel3;
507: Fetch C_Sel3 Into pay_ppm_shd.g_old_rec.comments;
508: If C_Sel3%notfound then
509: --
510: -- The comments for the specified comment_id does not exist.
511: -- We must error due to data integrity problems.

Line 742: end pay_ppm_shd;

738: Return(l_rec);
739: --
740: End convert_args;
741: --
742: end pay_ppm_shd;