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.14.12010000.3 2008/10/01 06:47:05 pvelugul 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 605: where hc.comment_id = per_per_shd.g_old_rec.comment_id;

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

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

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

Line 1048: end per_per_shd;

1044: Return(l_rec);
1045: --
1046: End convert_args;
1047: --
1048: end per_per_shd;