[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_APPROVAL_GROUP_CONFIG_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;
52: ,order_number
53: ,start_date
54: ,end_date
55: ,object_version_number
56: from ame_approval_group_config
57: where approval_group_id = p_approval_group_id
58: and application_id = p_application_id
59: and p_effective_date
60: between start_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_approval_group_config t
146: set t.end_date = p_new_end_date
147: , t.object_version_number = l_object_version_number
148: where t.approval_group_id = p_approval_group_id
149: and t.application_id = p_application_id
186: ,order_number
187: ,start_date
188: ,end_date
189: ,object_version_number
190: from ame_approval_group_config
191: where approval_group_id = p_approval_group_id
192: and application_id = p_application_id
193: and p_effective_date
194: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
278: -- The object is locked therefore we need to supply a meaningful
279: -- error message.
280: --
281: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
282: fnd_message.set_token('TABLE_NAME', 'ame_approval_group_config');
283: fnd_message.raise_error;
284: End lck;
285: --
286: -- ----------------------------------------------------------------------------
333: -- get the next ovn
334: --
335: select nvl(max(t.object_version_number),0) + 1
336: into l_ovn
337: from ame_approval_group_config t
338: where t.approval_group_id = p_approval_group_id
339: and t.application_id = p_application_id;
340: --
341: -- Return the new object_version_number.