1: Package Body hr_itp_shd as
2: /* $Header: hritprhi.pkb 115.11 2003/12/03 07:01:45 adhunter noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hr_itp_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< constraint_error >---------------------------|
12: -- ----------------------------------------------------------------------------
212: --
213: l_fct_ret := false;
214: Else
215: If (p_item_property_id
216: = hr_itp_shd.g_old_rec.item_property_id and
217: p_object_version_number
218: = hr_tdg_shd.g_old_rec.object_version_number
219: ) Then
220: --
226: --
227: -- Select the current row into g_old_rec
228: --
229: Open C_Sel1;
230: Fetch C_Sel1 Into hr_itp_shd.g_old_rec;
231: If C_Sel1%notfound Then
232: Close C_Sel1;
233: --
234: -- The primary key is invalid therefore we must error
352: ,p_argument => 'object_version_number'
353: ,p_argument_value => p_object_version_number
354: );
355: Open C_Sel1;
356: Fetch C_Sel1 Into hr_itp_shd.g_old_rec;
357: If C_Sel1%notfound then
358: Close C_Sel1;
359: --
360: -- The primary key is invalid therefore we must error
544: Return(l_rec);
545: --
546: End convert_args;
547: --
548: end hr_itp_shd;