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_RLU_INS dependencies on AME_RULE_USAGES

Line 93: from ame_rule_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_rule_usages t
94: where t.rule_id = p_rec.rule_id
95: and t.item_id = p_rec.item_id
96: and t.start_date =
97: ame_rlu_shd.g_old_rec.start_date

Line 102: from ame_rule_usages t

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

Line 109: l_created_by ame_rule_usages.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_rule_usages.created_by%TYPE;
110: l_creation_date ame_rule_usages.creation_date%TYPE;
111: l_last_update_date ame_rule_usages.last_update_date%TYPE;
112: l_last_updated_by ame_rule_usages.last_updated_by%TYPE;
113: l_last_update_login ame_rule_usages.last_update_login%TYPE;

Line 110: l_creation_date ame_rule_usages.creation_date%TYPE;

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

Line 111: l_last_update_date ame_rule_usages.last_update_date%TYPE;

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

Line 112: l_last_updated_by ame_rule_usages.last_updated_by%TYPE;

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

Line 113: l_last_update_login ame_rule_usages.last_update_login%TYPE;

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

Line 204: -- Insert the row into: ame_rule_usages

200: End If;
201: --
202: --
203: --
204: -- Insert the row into: ame_rule_usages
205: --
206: insert into ame_rule_usages
207: (item_id
208: ,usage_type

Line 206: insert into ame_rule_usages

202: --
203: --
204: -- Insert the row into: ame_rule_usages
205: --
206: insert into ame_rule_usages
207: (item_id
208: ,usage_type
209: ,rule_id
210: ,start_date

Line 332: -- Cursor C_Sel1 is select ame_rule_usages_s.nextval from sys.dual;

328: ,p_validation_start_date in date
329: ,p_validation_end_date in date
330: ) is
331: --
332: -- Cursor C_Sel1 is select ame_rule_usages_s.nextval from sys.dual;
333: --
334: Cursor C_Sel2 is
335: Select null
336: from ame_rule_usages

Line 336: from ame_rule_usages

332: -- Cursor C_Sel1 is select ame_rule_usages_s.nextval from sys.dual;
333: --
334: Cursor C_Sel2 is
335: Select null
336: from ame_rule_usages
337: where item_id =
338: ame_rlu_ins.g_item_id_i
339: and rule_id =
340: ame_rlu_ins.g_rule_id_i

Line 363: fnd_message.set_token('TABLE_NAME','ame_rule_usages');

359: --
360: -- The primary key values are already in use.
361: --
362: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
363: fnd_message.set_token('TABLE_NAME','ame_rule_usages');
364: fnd_message.raise_error;
365: End If;
366: Close C_Sel2;
367: --

Line 460: (p_module_name => 'AME_RULE_USAGES'

456: --
457: when hr_api.cannot_find_prog_unit then
458: --
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'AME_RULE_USAGES'
461: ,p_hook_type => 'AI');
462: --
463: end;
464: --