DBA Data[Home] [Help]

APPS.PER_PER_SHD dependencies on PER_PER_SHD

Line 1: Package Body per_per_shd as

1: Package Body per_per_shd as
2: /* $Header: peperrhi.pkb 120.20.12020000.5 2013/05/16 10:39:02 srannama ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 606: where hc.comment_id = per_per_shd.g_old_rec.comment_id;

602: --
603: Cursor C_Sel3 is
604: select hc.comment_text
605: from hr_comments hc
606: where hc.comment_id = per_per_shd.g_old_rec.comment_id;
607: --
608:
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);

Line 663: Fetch C_Sel3 Into per_per_shd.g_old_rec.comments;

659: p_datetrack_mode = 'CORRECTION' or
660: p_datetrack_mode = 'UPDATE_OVERRIDE' or
661: p_datetrack_mode = 'UPDATE_CHANGE_INSERT')) then
662: Open C_Sel3;
663: Fetch C_Sel3 Into per_per_shd.g_old_rec.comments;
664: If C_Sel3%notfound then
665: --
666: -- The comments for the specified comment_id does not exist.
667: -- We must error due to data integrity problems.

Line 1052: end per_per_shd;

1048: Return(l_rec);
1049: --
1050: End convert_args;
1051: --
1052: end per_per_shd;