APPS.AME_ITC_SHD dependencies on AME_ITEM_CLASSES

Line 21: If (p_constraint_name = 'AME_ITEM_CLASSES_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_ITEM_CLASSES_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;

Line 53: from ame_item_classes

49: ,name
50: ,start_date
51: ,end_date
52: ,object_version_number
53: from ame_item_classes
54: where item_class_id = p_item_class_id
55: and p_effective_date between start_date and
56: nvl(end_date - (1/86400),p_effective_date);
57: --

Line 142: update ame_item_classes t

138: --
139: -- Update the specified datetrack row setting the effective
140: -- end date to the specified new effective end date.
141: --
142: update ame_item_classes t
143: set t.end_date = p_new_effective_end_date
144: ,t.last_updated_by = l_current_user_id
145: ,t.last_update_date = p_new_effective_end_date
146: ,t.last_update_login = l_current_user_id

Line 185: from ame_item_classes

181: ,name
182: ,start_date
183: ,end_date
184: ,object_version_number
185: from ame_item_classes
186: where item_class_id = p_item_class_id
187: and p_effective_date between start_date and
188: nvl(end_date - (1/86400), sysdate)
189: for update nowait;

Line 276: fnd_message.set_token('TABLE_NAME', 'ame_item_classes');

272: -- The object is locked therefore we need to supply a meaningful
273: -- error message.
274: --
275: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
276: fnd_message.set_token('TABLE_NAME', 'ame_item_classes');
277: fnd_message.raise_error;
278: End lck;
279: --
280: -- ----------------------------------------------------------------------------

Line 326: from ame_item_classes t

322: -- get the next ovn
323: --
324: select nvl(max(t.object_version_number),0) + 1
325: into l_ovn
326: from ame_item_classes t
327: where t.item_class_id = p_item_class_id;
328: --
329: -- Return the new object_version_number.
330: --