[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_ACTION_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;
50: ,action_id
51: ,start_date
52: ,end_date
53: ,object_version_number
54: from ame_action_usages
55: where action_id = p_action_id
56: and rule_id = p_rule_id
57: and ( p_effective_date
58: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
146: --
147: -- Update the specified datetrack row setting the effective
148: -- end date to the specified new effective end date.
149: --
150: update ame_action_usages t
151: set t.end_date = p_new_end_date
152: ,t.last_updated_by = l_current_user_id
153: ,t.last_update_date = p_new_end_date
154: ,t.last_update_login = l_current_user_id
195: ,action_id
196: ,start_date
197: ,end_date
198: ,object_version_number
199: from ame_action_usages
200: where action_id = p_action_id
201: and rule_id = p_rule_id
202: and ( p_effective_date
203: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
318: -- The object is locked therefore we need to supply a meaningful
319: -- error message.
320: --
321: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
322: fnd_message.set_token('TABLE_NAME', 'ame_action_usages');
323: fnd_message.raise_error;
324: End lck;
325: --
326: -- ----------------------------------------------------------------------------
369: -- get the next ovn
370: --
371: select nvl(max(t.object_version_number),0) + 1
372: into l_ovn
373: from ame_action_usages t
374: where t.action_id = p_action_id
375: and t.rule_id = p_rule_id;
376: --
377: -- Return the new object_version_number.