APPS.PER_ASG_SHD dependencies on PER_ASG_SHD

Line 1: Package Body per_asg_shd as

1: Package Body per_asg_shd as
2: /* $Header: peasgrhi.pkb 120.44.12020000.3 2013/02/13 07:11:42 srannama ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 503: where hc.comment_id = per_asg_shd.g_old_rec.comment_id;

499: --
500: Cursor C_Sel3 is
501: select hc.comment_text
502: from hr_comments hc
503: where hc.comment_id = per_asg_shd.g_old_rec.comment_id;
504: --
505: Begin
506: --
507: -- Ensure that all the mandatory arguments are not null

Line 561: Fetch C_Sel3 Into per_asg_shd.g_old_rec.comment_text;

557: p_datetrack_mode = 'CORRECTION' or
558: p_datetrack_mode = 'UPDATE_OVERRIDE' or
559: p_datetrack_mode = 'UPDATE_CHANGE_INSERT')) then
560: Open C_Sel3;
561: Fetch C_Sel3 Into per_asg_shd.g_old_rec.comment_text;
562: If C_Sel3%notfound then
563: --
564: -- The comment_text for the specified comment_id does not exist.
565: -- We must error due to data integrity problems.

Line 907: end per_asg_shd;

903: Return(l_rec);
904: --
905: End convert_args;
906: --
907: end per_asg_shd;