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_ITC_INS dependencies on AME_ITEM_CLASSES

Line 90: from ame_item_classes 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_item_classes t
91: where t.item_class_id = p_rec.item_class_id
92: and t.start_date = ame_itc_shd.g_old_rec.start_date
93: and t.end_date = p_validation_start_date;
94: --

Line 97: from ame_item_classes t

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

Line 104: l_creation_date ame_item_classes.creation_date%TYPE;

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

Line 105: l_last_update_date ame_item_classes.last_update_date%TYPE;

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

Line 106: l_last_updated_by ame_item_classes.last_updated_by%TYPE;

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

Line 107: l_last_update_login ame_item_classes.last_update_login%TYPE;

103: l_created_by ame_item_classes.created_by%TYPE;
104: l_creation_date ame_item_classes.creation_date%TYPE;
105: l_last_update_date ame_item_classes.last_update_date%TYPE;
106: l_last_updated_by ame_item_classes.last_updated_by%TYPE;
107: l_last_update_login ame_item_classes.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_item_classes

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_item_classes
183: --
184: insert into ame_item_classes
185: (item_class_id
186: ,name

Line 184: insert into ame_item_classes

180: End If;
181: --
182: -- Insert the row into: ame_item_classes
183: --
184: insert into ame_item_classes
185: (item_class_id
186: ,name
187: ,start_date
188: ,end_date

Line 304: from ame_item_classes

300: ) is
301: --
302: Cursor C_Sel1 is
303: Select count(*)+1
304: from ame_item_classes
305: where
306: sysdate between start_date and
307: nvl(end_date - ame_util.oneSecond, sysdate);
308: --

Line 311: from ame_item_classes

307: nvl(end_date - ame_util.oneSecond, sysdate);
308: --
309: Cursor C_Sel2 is
310: Select null
311: from ame_item_classes
312: where item_class_id =
313: ame_itc_ins.g_item_class_id_i;
314: --
315: l_proc varchar2(72) := g_package||'pre_insert';

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

329: --
330: -- The primary key values are already in use.
331: --
332: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
333: fnd_message.set_token('TABLE_NAME','ame_item_classes');
334: fnd_message.raise_error;
335: End If;
336: Close C_Sel2;
337: --

Line 420: (p_module_name => 'AME_ITEM_CLASSES'

416: --
417: when hr_api.cannot_find_prog_unit then
418: --
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'AME_ITEM_CLASSES'
421: ,p_hook_type => 'AI');
422: --
423: end;
424: --