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