[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_CONDITIONS_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;
57: ,end_date
58: ,security_group_id
59: ,condition_key
60: ,object_version_number
61: from ame_conditions
62: where condition_id = p_condition_id
63: and p_effective_date
64: between start_date
65: and nvl(end_date - ame_util.oneSecond,p_effective_date);
145: --
146: -- Update the specified datetrack row setting the effective
147: -- end date to the specified new effective end date.
148: --
149: update ame_conditions t
150: set t.end_date = p_new_end_date
151: ,t.last_updated_by = l_current_user_id
152: ,t.last_update_date = p_new_end_date
153: ,t.last_update_login = l_current_user_id
197: ,end_date
198: ,security_group_id
199: ,condition_key
200: ,object_version_number
201: from ame_conditions
202: where condition_id = p_condition_id
203: and p_effective_date
204: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
205: for update nowait;
288: -- The object is locked therefore we need to supply a meaningful
289: -- error message.
290: --
291: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
292: fnd_message.set_token('TABLE_NAME', 'ame_conditions');
293: fnd_message.raise_error;
294: End lck;
295: --
296: -- ----------------------------------------------------------------------------
354: -- get the next ovn
355: --
356: select nvl(max(t.object_version_number),0) + 1
357: into l_ovn
358: from ame_conditions t
359: where t.condition_id = p_condition_id;
360: --
361: -- Return the new object_version_number.
362: --