[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_RULE_USAGES_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;
55: ,priority
56: ,approver_category
57: ,object_version_number
58: ,start_date
59: from ame_rule_usages
60: where rule_id = p_rule_id
61: and item_id = p_item_id
62: and ( p_effective_date
63: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
153: --
154: -- Update the specified datetrack row setting the effective
155: -- end date to the specified new effective end date.
156: --
157: update ame_rule_usages t
158: set t.end_date = p_new_end_date
159: ,t.last_updated_by = l_current_user_id
160: ,t.last_update_date = p_new_end_date
161: ,t.last_update_login = l_current_user_id
209: ,priority
210: ,approver_category
211: ,object_version_number
212: ,start_date
213: from ame_rule_usages
214: where rule_id = p_rule_id
215: and item_id = p_item_id
216: and start_date = p_old_start_date
217: and ( p_effective_date
326: -- The object is locked therefore we need to supply a meaningful
327: -- error message.
328: --
329: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
330: fnd_message.set_token('TABLE_NAME', 'ame_rule_usages');
331: fnd_message.raise_error;
332: End lck;
333: --
334: -- ----------------------------------------------------------------------------
388: -- get the next ovn
389: --
390: select nvl(max(t.object_version_number),0) + 1
391: into l_ovn
392: from ame_rule_usages t
393: where t.rule_id = p_rule_id
394: and t.item_id = p_item_id
395: and t.start_date = p_old_start_date;
396: --