[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_ATTRIBUTES_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
56: ,approver_type_id
57: ,item_class_id
58: ,object_version_number
59: ,created_by
60: from ame_attributes
61: where attribute_id = p_attribute_id
62: and p_effective_date
63: between start_date
64: and nvl(end_date - ame_util.oneSecond,p_effective_date);
141: --
142: -- Update the specified datetrack row setting the effective
143: -- end date to the specified new effective end date.
144: --
145: update ame_attributes t
146: set t.end_date = p_new_end_date
147: , t.object_version_number = l_object_version_number
148: where t.attribute_id = p_attribute_id
149: and p_effective_date
189: ,approver_type_id
190: ,item_class_id
191: ,object_version_number
192: ,created_by
193: from ame_attributes
194: where attribute_id = p_attribute_id
195: and p_effective_date
196: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
197: for update nowait;
280: -- The object is locked therefore we need to supply a meaningful
281: -- error message.
282: --
283: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
284: fnd_message.set_token('TABLE_NAME', 'ame_attributes');
285: fnd_message.raise_error;
286: End lck;
287: --
288: -- ----------------------------------------------------------------------------
342: -- get the next ovn
343: --
344: select nvl(max(t.object_version_number),0) + 1
345: into l_ovn
346: from ame_attributes t
347: where t.attribute_id = p_attribute_id;
348: --
349: -- Return the new object_version_number.
350: --