DBA Data[Home] [Help]

APPS.HR_CTX_SHD dependencies on HR_CTX_SHD

Line 1: Package Body hr_ctx_shd as

1: Package Body hr_ctx_shd as
2: /* $Header: hrctxrhi.pkb 120.0 2005/05/30 23:30:30 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 99: = hr_ctx_shd.g_old_rec.context_id and

95: --
96: l_fct_ret := false;
97: Else
98: If (p_context_id
99: = hr_ctx_shd.g_old_rec.context_id and
100: p_object_version_number
101: = hr_ctx_shd.g_old_rec.object_version_number
102: ) Then
103: --

Line 101: = hr_ctx_shd.g_old_rec.object_version_number

97: Else
98: If (p_context_id
99: = hr_ctx_shd.g_old_rec.context_id and
100: p_object_version_number
101: = hr_ctx_shd.g_old_rec.object_version_number
102: ) Then
103: --
104: -- The g_old_rec is current therefore we must
105: -- set the returning function to true

Line 113: Fetch C_Sel1 Into hr_ctx_shd.g_old_rec;

109: --
110: -- Select the current row into g_old_rec
111: --
112: Open C_Sel1;
113: Fetch C_Sel1 Into hr_ctx_shd.g_old_rec;
114: If C_Sel1%notfound Then
115: Close C_Sel1;
116: --
117: -- The primary key is invalid therefore we must error

Line 124: <> hr_ctx_shd.g_old_rec.object_version_number) Then

120: fnd_message.raise_error;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number
124: <> hr_ctx_shd.g_old_rec.object_version_number) Then
125: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
126: fnd_message.raise_error;
127: End If;
128: l_fct_ret := true;

Line 202: Fetch C_Sel1 Into hr_ctx_shd.g_old_rec;

198: ,p_argument_value => p_object_version_number
199: );
200: --
201: Open C_Sel1;
202: Fetch C_Sel1 Into hr_ctx_shd.g_old_rec;
203: If C_Sel1%notfound then
204: Close C_Sel1;
205: --
206: -- The primary key is invalid therefore we must error

Line 213: <> hr_ctx_shd.g_old_rec.object_version_number) Then

209: fnd_message.raise_error;
210: End If;
211: Close C_Sel1;
212: If (p_object_version_number
213: <> hr_ctx_shd.g_old_rec.object_version_number) Then
214: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
215: fnd_message.raise_error;
216: End If;
217: --

Line 319: end hr_ctx_shd;

315: Return(l_rec);
316: --
317: End convert_args;
318: --
319: end hr_ctx_shd;