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_STV_INS dependencies on AME_STRING_VALUES

Line 93: from ame_string_values 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_string_values t
94: where t.condition_id = p_rec.condition_id
95: and t.string_value = p_rec.string_value
96: and t.start_date =
97: ame_stv_shd.g_old_rec.start_date

Line 102: from ame_string_values t

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

Line 109: l_created_by ame_string_values.created_by%TYPE;

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

Line 110: l_creation_date ame_string_values.creation_date%TYPE;

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

Line 111: l_last_update_date ame_string_values.last_update_date%TYPE;

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

Line 112: l_last_updated_by ame_string_values.last_updated_by%TYPE;

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

Line 113: l_last_update_login ame_string_values.last_update_login%TYPE;

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

Line 192: -- Insert the row into: ame_string_values

188: End If;
189: --
190: --
191: --
192: -- Insert the row into: ame_string_values
193: --
194: insert into ame_string_values
195: (condition_id
196: ,string_value

Line 194: insert into ame_string_values

190: --
191: --
192: -- Insert the row into: ame_string_values
193: --
194: insert into ame_string_values
195: (condition_id
196: ,string_value
197: ,start_date
198: ,end_date

Line 314: /Cursor C_Sel1 is select ame_string_values_s.nextval from sys.dual;/

310: ,p_validation_start_date in date
311: ,p_validation_end_date in date
312: ) is
313: --
314: /*Cursor C_Sel1 is select ame_string_values_s.nextval from sys.dual;*/
315: --
316: Cursor C_Sel2 is
317: Select null
318: from ame_string_values

Line 318: from ame_string_values

314: /*Cursor C_Sel1 is select ame_string_values_s.nextval from sys.dual;*/
315: --
316: Cursor C_Sel2 is
317: Select null
318: from ame_string_values
319: where condition_id =
320: ame_stv_ins.g_condition_id_i
321: and string_value =
322: ame_stv_ins.g_string_value_i

Line 345: fnd_message.set_token('TABLE_NAME','ame_string_values');

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

Line 447: (p_module_name => 'AME_STRING_VALUES'

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