eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ATY_INS dependencies on AME_ACTION_TYPES

Line 90: from ame_action_types t

86: -- Cursor to select 'old' created AOL who column values
87: --
88: Cursor C_Sel1 Is
89: select t.creation_date
90: from ame_action_types t
91: where t.action_type_id = p_rec.action_type_id
92: and t.start_date = ame_aty_shd.g_old_rec.start_date
93: and t.end_date = p_validation_start_date;
94: --

Line 97: from ame_action_types t

93: and t.end_date = p_validation_start_date;
94: --
95: Cursor C_Sel2 Is
96: select created_by
97: from ame_action_types t
98: where t.action_type_id = p_rec.action_type_id
99: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
100: and rownum<2;
101: --

Line 103: l_created_by ame_action_types.created_by%TYPE;

99: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
100: and rownum<2;
101: --
102: l_proc varchar2(72) := g_package||'dt_insert_dml';
103: l_created_by ame_action_types.created_by%TYPE;
104: l_creation_date ame_action_types.creation_date%TYPE;
105: l_last_update_date ame_action_types.last_update_date%TYPE;
106: l_last_updated_by ame_action_types.last_updated_by%TYPE;
107: l_last_update_login ame_action_types.last_update_login%TYPE;

Line 104: l_creation_date ame_action_types.creation_date%TYPE;

100: and rownum<2;
101: --
102: l_proc varchar2(72) := g_package||'dt_insert_dml';
103: l_created_by ame_action_types.created_by%TYPE;
104: l_creation_date ame_action_types.creation_date%TYPE;
105: l_last_update_date ame_action_types.last_update_date%TYPE;
106: l_last_updated_by ame_action_types.last_updated_by%TYPE;
107: l_last_update_login ame_action_types.last_update_login%TYPE;
108: l_current_user_id integer;

Line 105: l_last_update_date ame_action_types.last_update_date%TYPE;

101: --
102: l_proc varchar2(72) := g_package||'dt_insert_dml';
103: l_created_by ame_action_types.created_by%TYPE;
104: l_creation_date ame_action_types.creation_date%TYPE;
105: l_last_update_date ame_action_types.last_update_date%TYPE;
106: l_last_updated_by ame_action_types.last_updated_by%TYPE;
107: l_last_update_login ame_action_types.last_update_login%TYPE;
108: l_current_user_id integer;
109: l_temp_count integer;

Line 106: l_last_updated_by ame_action_types.last_updated_by%TYPE;

102: l_proc varchar2(72) := g_package||'dt_insert_dml';
103: l_created_by ame_action_types.created_by%TYPE;
104: l_creation_date ame_action_types.creation_date%TYPE;
105: l_last_update_date ame_action_types.last_update_date%TYPE;
106: l_last_updated_by ame_action_types.last_updated_by%TYPE;
107: l_last_update_login ame_action_types.last_update_login%TYPE;
108: l_current_user_id integer;
109: l_temp_count integer;
110: --

Line 107: l_last_update_login ame_action_types.last_update_login%TYPE;

103: l_created_by ame_action_types.created_by%TYPE;
104: l_creation_date ame_action_types.creation_date%TYPE;
105: l_last_update_date ame_action_types.last_update_date%TYPE;
106: l_last_updated_by ame_action_types.last_updated_by%TYPE;
107: l_last_update_login ame_action_types.last_update_login%TYPE;
108: l_current_user_id integer;
109: l_temp_count integer;
110: --
111: Begin

Line 187: -- Insert the row into: ame_action_types

183: End If;
184: --
185: --
186: --
187: -- Insert the row into: ame_action_types
188: --
189: insert into ame_action_types
190: (action_type_id
191: ,name

Line 189: insert into ame_action_types

185: --
186: --
187: -- Insert the row into: ame_action_types
188: --
189: insert into ame_action_types
190: (action_type_id
191: ,name
192: ,procedure_name
193: ,start_date

Line 317: Cursor C_Sel1 is select ame_action_types_s.nextval from sys.dual;

313: ,p_validation_start_date in date
314: ,p_validation_end_date in date
315: ) is
316: --
317: Cursor C_Sel1 is select ame_action_types_s.nextval from sys.dual;
318: --
319: Cursor C_Sel2 is
320: Select null
321: from ame_action_types

Line 321: from ame_action_types

317: Cursor C_Sel1 is select ame_action_types_s.nextval from sys.dual;
318: --
319: Cursor C_Sel2 is
320: Select null
321: from ame_action_types
322: where action_type_id =
323: ame_aty_ins.g_action_type_id_i;
324: --
325: l_proc varchar2(72) := g_package||'pre_insert';

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

339: --
340: -- The primary key values are already in use.
341: --
342: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
343: fnd_message.set_token('TABLE_NAME','ame_action_types');
344: fnd_message.raise_error;
345: End If;
346: Close C_Sel2;
347: --

Line 449: (p_module_name => 'AME_ACTION_TYPES'

445: --
446: when hr_api.cannot_find_prog_unit then
447: --
448: hr_api.cannot_find_prog_unit_error
449: (p_module_name => 'AME_ACTION_TYPES'
450: ,p_hook_type => 'AI');
451: --
452: end;
453: --