APPS.AME_ATY_SHD dependencies on AME_ACTION_TYPES

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

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

54: ,security_group_id
55: ,dynamic_description
56: ,description_query
57: ,object_version_number
58: from ame_action_types
59: where action_type_id = p_action_type_id
60: and p_effective_date
61: between start_date and nvl(end_date - (ame_util.oneSecond), sysdate);
62: --

Line 147: update ame_action_types t

143: --
144: -- Update the specified datetrack row setting the effective
145: -- end date to the specified new effective end date.
146: --
147: update ame_action_types t
148: set t.end_date = p_new_end_date
149: ,t.last_updated_by = l_current_user_id
150: ,t.last_update_date = p_new_end_date
151: ,t.last_update_login = l_current_user_id

Line 195: from ame_action_types

191: ,security_group_id
192: ,dynamic_description
193: ,description_query
194: ,object_version_number
195: from ame_action_types
196: where action_type_id = p_action_type_id
197: and p_effective_date
198: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
199: for update nowait;

Line 258: ,p_base_table_name => 'ame_action_types'

254: --
255: /*dt_api.validate_dt_mode
256: (p_effective_date => p_effective_date
257: ,p_datetrack_mode => p_datetrack_mode
258: ,p_base_table_name => 'ame_action_types'
259: ,p_base_key_column => 'action_type_id'
260: ,p_base_key_value => p_action_type_id
261: ,p_child_table_name1 => 'ame_actions'
262: ,p_child_key_column1 => 'action_type_id'

Line 305: fnd_message.set_token('TABLE_NAME', 'ame_action_types');

301: -- The object is locked therefore we need to supply a meaningful
302: -- error message.
303: --
304: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
305: fnd_message.set_token('TABLE_NAME', 'ame_action_types');
306: fnd_message.raise_error;
307: End lck;
308: --
309: -- ----------------------------------------------------------------------------

Line 365: from ame_action_types t

361: -- get the next ovn
362: --
363: select nvl(max(t.object_version_number),0) + 1
364: into l_ovn
365: from ame_action_types t
366: where t.action_type_id = p_action_type_id;
367: --
368: -- Return the new object_version_number.
369: --