1: Package Body per_inc_shd as
2: /* $Header: peincrhi.pkb 115.29 2003/08/31 00:49:48 kjagadee noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_inc_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< constraint_error >---------------------------|
12: -- ----------------------------------------------------------------------------
184: --
185: l_fct_ret := false;
186: Else
187: If (p_incident_id
188: = per_inc_shd.g_old_rec.incident_id and
189: p_object_version_number
190: = per_inc_shd.g_old_rec.object_version_number
191: ) Then
192: --
186: Else
187: If (p_incident_id
188: = per_inc_shd.g_old_rec.incident_id and
189: p_object_version_number
190: = per_inc_shd.g_old_rec.object_version_number
191: ) Then
192: --
193: -- The g_old_rec is current therefore we must
194: -- set the returning function to true
198: --
199: -- Select the current row into g_old_rec
200: --
201: Open C_Sel1;
202: Fetch C_Sel1 Into per_inc_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
209: fnd_message.raise_error;
210: End If;
211: Close C_Sel1;
212: If (p_object_version_number
213: <> per_inc_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: l_fct_ret := true;
360: ,p_argument_value => p_incident_id
361: );
362: --
363: Open C_Sel1;
364: Fetch C_Sel1 Into per_inc_shd.g_old_rec;
365: If C_Sel1%notfound then
366: Close C_Sel1;
367: --
368: -- The primary key is invalid therefore we must error
371: fnd_message.raise_error;
372: End If;
373: Close C_Sel1;
374: If (p_object_version_number
375: <> per_inc_shd.g_old_rec.object_version_number) Then
376: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
377: fnd_message.raise_error;
378: End If;
379: --
639: Return(l_rec);
640: --
641: End convert_args;
642: --
643: end per_inc_shd;