[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_APPROVER_TYPES_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;
60: ,query_procedure
61: ,start_date
62: ,end_date
63: ,object_version_number
64: from ame_approver_types
65: where approver_type_id = p_approver_type_id
66: and p_effective_date between start_date
67: and nvl(end_date - (1/86400),p_effective_date);
68: --
149: --
150: -- Update the specified datetrack row setting the effective
151: -- end date to the specified new effective end date.
152: --
153: update ame_approver_types t
154: set t.end_date = p_new_effective_end_date
155: ,t.last_updated_by = l_current_user_id
156: ,t.last_update_date = p_new_effective_end_date
157: ,t.last_update_login = l_current_user_id
204: ,query_procedure
205: ,start_date
206: ,end_date
207: ,object_version_number
208: from ame_approver_types
209: where approver_type_id = p_approver_type_id
210: and p_effective_date between start_date
211: and nvl(end_date - (1/86400), sysdate)
212: for update nowait;
296: -- The object is locked therefore we need to supply a meaningful
297: -- error message.
298: --
299: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
300: fnd_message.set_token('TABLE_NAME', 'ame_approver_types');
301: fnd_message.raise_error;
302: End lck;
303: --
304: -- ----------------------------------------------------------------------------
357: -- get the next ovn
358: --
359: select nvl(max(t.object_version_number),0) + 1
360: into l_ovn
361: from ame_approver_types t
362: where t.approver_type_id = p_approver_type_id;
363: --
364: -- Return the new object_version_number.
365: --