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_CON_INS dependencies on AME_CONDITIONS

Line 59: from ame_conditions

55: newConditionKey1 := newConditionKey;
56: end if;
57: select count(*)
58: into conditionCount
59: from ame_conditions
60: where upper(condition_key) = upper(newConditionKey1) and
61: rownum < 2;
62: if conditionCount = 0 then
63: exit;

Line 153: from ame_conditions t

149: -- Cursor to select 'old' created AOL who column values
150: --
151: Cursor C_Sel1 Is
152: select t.creation_date
153: from ame_conditions t
154: where t.condition_id = p_rec.condition_id
155: and t.start_date =
156: ame_con_shd.g_old_rec.start_date
157: and t.end_date = p_validation_start_date;

Line 161: from ame_conditions t

157: and t.end_date = p_validation_start_date;
158: --
159: Cursor C_Sel2 Is
160: select created_by
161: from ame_conditions t
162: where t.condition_id = p_rec.condition_id
163: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
164: and rownum < 2;
165: --

Line 167: l_created_by ame_conditions.created_by%TYPE;

163: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
164: and rownum < 2;
165: --
166: l_proc varchar2(72) := g_package||'dt_insert_dml';
167: l_created_by ame_conditions.created_by%TYPE;
168: l_creation_date ame_conditions.creation_date%TYPE;
169: l_last_update_date ame_conditions.last_update_date%TYPE;
170: l_last_updated_by ame_conditions.last_updated_by%TYPE;
171: l_last_update_login ame_conditions.last_update_login%TYPE;

Line 168: l_creation_date ame_conditions.creation_date%TYPE;

164: and rownum < 2;
165: --
166: l_proc varchar2(72) := g_package||'dt_insert_dml';
167: l_created_by ame_conditions.created_by%TYPE;
168: l_creation_date ame_conditions.creation_date%TYPE;
169: l_last_update_date ame_conditions.last_update_date%TYPE;
170: l_last_updated_by ame_conditions.last_updated_by%TYPE;
171: l_last_update_login ame_conditions.last_update_login%TYPE;
172: l_current_user_id integer;

Line 169: l_last_update_date ame_conditions.last_update_date%TYPE;

165: --
166: l_proc varchar2(72) := g_package||'dt_insert_dml';
167: l_created_by ame_conditions.created_by%TYPE;
168: l_creation_date ame_conditions.creation_date%TYPE;
169: l_last_update_date ame_conditions.last_update_date%TYPE;
170: l_last_updated_by ame_conditions.last_updated_by%TYPE;
171: l_last_update_login ame_conditions.last_update_login%TYPE;
172: l_current_user_id integer;
173: l_temp_count integer;

Line 170: l_last_updated_by ame_conditions.last_updated_by%TYPE;

166: l_proc varchar2(72) := g_package||'dt_insert_dml';
167: l_created_by ame_conditions.created_by%TYPE;
168: l_creation_date ame_conditions.creation_date%TYPE;
169: l_last_update_date ame_conditions.last_update_date%TYPE;
170: l_last_updated_by ame_conditions.last_updated_by%TYPE;
171: l_last_update_login ame_conditions.last_update_login%TYPE;
172: l_current_user_id integer;
173: l_temp_count integer;
174: --

Line 171: l_last_update_login ame_conditions.last_update_login%TYPE;

167: l_created_by ame_conditions.created_by%TYPE;
168: l_creation_date ame_conditions.creation_date%TYPE;
169: l_last_update_date ame_conditions.last_update_date%TYPE;
170: l_last_updated_by ame_conditions.last_updated_by%TYPE;
171: l_last_update_login ame_conditions.last_update_login%TYPE;
172: l_current_user_id integer;
173: l_temp_count integer;
174: --
175: Begin

Line 249: -- Insert the row into: ame_conditions

245: End If;
246: --
247: --
248: --
249: -- Insert the row into: ame_conditions
250: --
251: insert into ame_conditions
252: (condition_id
253: ,condition_type

Line 251: insert into ame_conditions

247: --
248: --
249: -- Insert the row into: ame_conditions
250: --
251: insert into ame_conditions
252: (condition_id
253: ,condition_type
254: ,attribute_id
255: ,parameter_one

Line 385: Cursor C_Sel1 is select ame_conditions_s.nextval from sys.dual;

381: ,p_validation_start_date in date
382: ,p_validation_end_date in date
383: ) is
384: --
385: Cursor C_Sel1 is select ame_conditions_s.nextval from sys.dual;
386: --
387: Cursor C_Sel2 is
388: Select null
389: from ame_conditions

Line 389: from ame_conditions

385: Cursor C_Sel1 is select ame_conditions_s.nextval from sys.dual;
386: --
387: Cursor C_Sel2 is
388: Select null
389: from ame_conditions
390: where condition_id =
391: ame_con_ins.g_condition_id_i
392: and p_effective_date between start_date
393: and nvl(end_date - ame_util.oneSecond , p_effective_date);

Line 413: fnd_message.set_token('TABLE_NAME','ame_conditions');

409: --
410: -- The primary key values are already in use.
411: --
412: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
413: fnd_message.set_token('TABLE_NAME','ame_conditions');
414: fnd_message.raise_error;
415: End If;
416: Close C_Sel2;
417: --

Line 528: (p_module_name => 'AME_CONDITIONS'

524: --
525: when hr_api.cannot_find_prog_unit then
526: --
527: hr_api.cannot_find_prog_unit_error
528: (p_module_name => 'AME_CONDITIONS'
529: ,p_hook_type => 'AI');
530: --
531: end;
532: --