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_APT_INS dependencies on AME_APPROVER_TYPES

Line 90: from ame_approver_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_approver_types t
91: where t.approver_type_id = p_rec.approver_type_id
92: and t.start_date = ame_apt_shd.g_old_rec.start_date
93: and t.end_date = p_validation_start_date;
94: --

Line 97: from ame_approver_types t

93: and t.end_date = p_validation_start_date;
94: --
95: Cursor C_Sel2 Is
96: select created_by
97: from ame_approver_types t
98: where t.approver_type_id = p_rec.approver_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_approver_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_approver_types.created_by%TYPE;
104: l_creation_date ame_approver_types.creation_date%TYPE;
105: l_last_update_date ame_approver_types.last_update_date%TYPE;
106: l_last_updated_by ame_approver_types.last_updated_by%TYPE;
107: l_last_update_login ame_approver_types.last_update_login%TYPE;

Line 104: l_creation_date ame_approver_types.creation_date%TYPE;

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

Line 105: l_last_update_date ame_approver_types.last_update_date%TYPE;

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

Line 106: l_last_updated_by ame_approver_types.last_updated_by%TYPE;

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

Line 107: l_last_update_login ame_approver_types.last_update_login%TYPE;

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

Line 182: -- Insert the row into: ame_approver_types

178: l_last_updated_by := l_current_user_id;
179: l_last_update_login := l_current_user_id;
180: End If;
181: --
182: -- Insert the row into: ame_approver_types
183: --
184: insert into ame_approver_types
185: (approver_type_id
186: ,orig_system

Line 184: insert into ame_approver_types

180: End If;
181: --
182: -- Insert the row into: ame_approver_types
183: --
184: insert into ame_approver_types
185: (approver_type_id
186: ,orig_system
187: ,query_variable_1_label
188: ,query_variable_2_label

Line 325: Select ame_approver_types_s.nextval from dual;

321: ,p_validation_end_date in date
322: ) is
323: --
324: Cursor C_Sel1 is
325: Select ame_approver_types_s.nextval from dual;
326: --
327: Cursor C_Sel2 is
328: Select null
329: from ame_approver_types

Line 329: from ame_approver_types

325: Select ame_approver_types_s.nextval from dual;
326: --
327: Cursor C_Sel2 is
328: Select null
329: from ame_approver_types
330: where approver_type_id =
331: ame_apt_ins.g_approver_type_id_i;
332: --
333: l_proc varchar2(72) := g_package||'pre_insert';

Line 351: fnd_message.set_token('TABLE_NAME','ame_approver_types');

347: --
348: -- The primary key values are already in use.
349: --
350: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
351: fnd_message.set_token('TABLE_NAME','ame_approver_types');
352: fnd_message.raise_error;
353: End If;
354: Close C_Sel2;
355: --

Line 447: (p_module_name => 'AME_APPROVER_TYPES'

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