1: Package Body per_ckl_shd as
2: /* $Header: pecklrhi.pkb 120.2 2005/11/15 09:02:02 lsilveir noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_ckl_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< constraint_error >---------------------------|
12: -- ----------------------------------------------------------------------------
111: --
112: l_fct_ret := false;
113: Else
114: If (p_checklist_id
115: = per_ckl_shd.g_old_rec.checklist_id and
116: p_object_version_number
117: = per_ckl_shd.g_old_rec.object_version_number
118: ) Then
119: --
113: Else
114: If (p_checklist_id
115: = per_ckl_shd.g_old_rec.checklist_id and
116: p_object_version_number
117: = per_ckl_shd.g_old_rec.object_version_number
118: ) Then
119: --
120: -- The g_old_rec is current therefore we must
121: -- set the returning function to true
125: --
126: -- Select the current row into g_old_rec
127: --
128: Open C_Sel1;
129: Fetch C_Sel1 Into per_ckl_shd.g_old_rec;
130: If C_Sel1%notfound Then
131: Close C_Sel1;
132: --
133: -- The primary key is invalid therefore we must error
136: fnd_message.raise_error;
137: End If;
138: Close C_Sel1;
139: If (p_object_version_number
140: <> per_ckl_shd.g_old_rec.object_version_number) Then
141: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
142: fnd_message.raise_error;
143: End If;
144: l_fct_ret := true;
230: ,p_argument_value => p_object_version_number
231: );
232: --
233: Open C_Sel1;
234: Fetch C_Sel1 Into per_ckl_shd.g_old_rec;
235: If C_Sel1%notfound then
236: Close C_Sel1;
237: --
238: -- The primary key is invalid therefore we must error
241: fnd_message.raise_error;
242: End If;
243: Close C_Sel1;
244: If (p_object_version_number
245: <> per_ckl_shd.g_old_rec.object_version_number) Then
246: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
247: fnd_message.raise_error;
248: End If;
249: --
379: Return(l_rec);
380: --
381: End convert_args;
382: --
383: end per_ckl_shd;