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_APU_INS dependencies on AME_APPROVER_TYPE_USAGES

Line 93: from ame_approver_type_usages t

89: -- Cursor to select 'old' created AOL who column values
90: --
91: Cursor C_Sel1 Is
92: select t.creation_date
93: from ame_approver_type_usages t
94: where t.approver_type_id = p_rec.approver_type_id
95: and t.action_type_id = p_rec.action_type_id
96: and t.start_date = ame_apu_shd.g_old_rec.start_date
97: and t.end_date = p_validation_start_date;

Line 101: from ame_approver_type_usages t

97: and t.end_date = p_validation_start_date;
98: --
99: Cursor C_Sel2 Is
100: select created_by
101: from ame_approver_type_usages t
102: where t.approver_type_id = p_rec.approver_type_id
103: and t.action_type_id = p_rec.action_type_id
104: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
105: and rownum<2;

Line 108: l_created_by ame_approver_type_usages.created_by%TYPE;

104: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
105: and rownum<2;
106: --
107: l_proc varchar2(72) := g_package||'dt_insert_dml';
108: l_created_by ame_approver_type_usages.created_by%TYPE;
109: l_creation_date ame_approver_type_usages.creation_date%TYPE;
110: l_last_update_date ame_approver_type_usages.last_update_date%TYPE;
111: l_last_updated_by ame_approver_type_usages.last_updated_by%TYPE;
112: l_last_update_login ame_approver_type_usages.last_update_login%TYPE;

Line 109: l_creation_date ame_approver_type_usages.creation_date%TYPE;

105: and rownum<2;
106: --
107: l_proc varchar2(72) := g_package||'dt_insert_dml';
108: l_created_by ame_approver_type_usages.created_by%TYPE;
109: l_creation_date ame_approver_type_usages.creation_date%TYPE;
110: l_last_update_date ame_approver_type_usages.last_update_date%TYPE;
111: l_last_updated_by ame_approver_type_usages.last_updated_by%TYPE;
112: l_last_update_login ame_approver_type_usages.last_update_login%TYPE;
113: l_current_user_id integer;

Line 110: l_last_update_date ame_approver_type_usages.last_update_date%TYPE;

106: --
107: l_proc varchar2(72) := g_package||'dt_insert_dml';
108: l_created_by ame_approver_type_usages.created_by%TYPE;
109: l_creation_date ame_approver_type_usages.creation_date%TYPE;
110: l_last_update_date ame_approver_type_usages.last_update_date%TYPE;
111: l_last_updated_by ame_approver_type_usages.last_updated_by%TYPE;
112: l_last_update_login ame_approver_type_usages.last_update_login%TYPE;
113: l_current_user_id integer;
114: l_temp_count integer;

Line 111: l_last_updated_by ame_approver_type_usages.last_updated_by%TYPE;

107: l_proc varchar2(72) := g_package||'dt_insert_dml';
108: l_created_by ame_approver_type_usages.created_by%TYPE;
109: l_creation_date ame_approver_type_usages.creation_date%TYPE;
110: l_last_update_date ame_approver_type_usages.last_update_date%TYPE;
111: l_last_updated_by ame_approver_type_usages.last_updated_by%TYPE;
112: l_last_update_login ame_approver_type_usages.last_update_login%TYPE;
113: l_current_user_id integer;
114: l_temp_count integer;
115: --

Line 112: l_last_update_login ame_approver_type_usages.last_update_login%TYPE;

108: l_created_by ame_approver_type_usages.created_by%TYPE;
109: l_creation_date ame_approver_type_usages.creation_date%TYPE;
110: l_last_update_date ame_approver_type_usages.last_update_date%TYPE;
111: l_last_updated_by ame_approver_type_usages.last_updated_by%TYPE;
112: l_last_update_login ame_approver_type_usages.last_update_login%TYPE;
113: l_current_user_id integer;
114: l_temp_count integer;
115: --
116: Begin

Line 191: -- Insert the row into: ame_approver_type_usages

187: End If;
188: --
189: --
190: --
191: -- Insert the row into: ame_approver_type_usages
192: --
193: insert into ame_approver_type_usages
194: (approver_type_id
195: ,action_type_id

Line 193: insert into ame_approver_type_usages

189: --
190: --
191: -- Insert the row into: ame_approver_type_usages
192: --
193: insert into ame_approver_type_usages
194: (approver_type_id
195: ,action_type_id
196: ,start_date
197: ,end_date

Line 311: -- Cursor C_Sel1 is select ame_approver_type_usages_s.nextval from sys.dual;

307: ,p_validation_start_date in date
308: ,p_validation_end_date in date
309: ) is
310: --
311: -- Cursor C_Sel1 is select ame_approver_type_usages_s.nextval from sys.dual;
312: --
313: Cursor C_Sel2 is
314: Select null
315: from ame_approver_type_usages

Line 315: from ame_approver_type_usages

311: -- Cursor C_Sel1 is select ame_approver_type_usages_s.nextval from sys.dual;
312: --
313: Cursor C_Sel2 is
314: Select null
315: from ame_approver_type_usages
316: where approver_type_id =
317: ame_apu_ins.g_approver_type_id_i
318: and action_type_id =
319: ame_apu_ins.g_action_type_id_i;

Line 340: fnd_message.set_token('TABLE_NAME','ame_approver_type_usages');

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

Line 442: (p_module_name => 'AME_APPROVER_TYPE_USAGES'

438: --
439: when hr_api.cannot_find_prog_unit then
440: --
441: hr_api.cannot_find_prog_unit_error
442: (p_module_name => 'AME_APPROVER_TYPE_USAGES'
443: ,p_hook_type => 'AI');
444: --
445: end;
446: --