[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_APPROVAL_GROUPS_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;
53: ,query_string
54: ,is_static
55: ,security_group_id
56: ,object_version_number
57: from ame_approval_groups
58: where approval_group_id = p_approval_group_id
59: and p_effective_date
60: between start_date
61: and nvl(end_date - ame_util.oneSecond,p_effective_date);
138: --
139: -- Update the specified datetrack row setting the effective
140: -- end date to the specified new effective end date.
141: --
142: update ame_approval_groups t
143: set t.end_date = p_new_end_date
144: , t.object_version_number = l_object_version_number
145: where t.approval_group_id = p_approval_group_id
146: and p_effective_date
183: ,query_string
184: ,is_static
185: ,security_group_id
186: ,object_version_number
187: from ame_approval_groups
188: where approval_group_id = p_approval_group_id
189: and p_effective_date
190: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
191: for update nowait;
274: -- The object is locked therefore we need to supply a meaningful
275: -- error message.
276: --
277: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
278: fnd_message.set_token('TABLE_NAME', 'ame_approval_groups');
279: fnd_message.raise_error;
280: End lck;
281: --
282: -- ----------------------------------------------------------------------------
332: -- get the next ovn
333: --
334: select nvl(max(t.object_version_number),0) + 1
335: into l_ovn
336: from ame_approval_groups t
337: where t.approval_group_id = p_approval_group_id;
338: --
339: -- Return the new object_version_number.
340: --