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_RUL_INS dependencies on AME_RULES

Line 19: newRuleKey ame_rules.rule_key%type;

15: -- Private funtion to return the default value of rule_key
16: --
17: function getNextRuleKey return varchar2 as
18: databaseId varchar2(50);
19: newRuleKey ame_rules.rule_key%type;
20: newRuleKey1 ame_rules.rule_key%type;
21: ruleKeyId number;
22: ruleCount number;
23: seededKeyPrefix varchar2(4);

Line 20: newRuleKey1 ame_rules.rule_key%type;

16: --
17: function getNextRuleKey return varchar2 as
18: databaseId varchar2(50);
19: newRuleKey ame_rules.rule_key%type;
20: newRuleKey1 ame_rules.rule_key%type;
21: ruleKeyId number;
22: ruleCount number;
23: seededKeyPrefix varchar2(4);
24: l_proc varchar2(72) := g_package||'getNextRuleKey';

Line 50: from ame_rules

46: newRuleKey1 := newRuleKey;
47: end if;
48: select count(*)
49: into ruleCount
50: from ame_rules
51: where upper(rule_key) = upper(newRuleKey1) and
52: rownum < 2;
53: if ruleCount = 0 then
54: exit;

Line 144: from ame_rules t

140: -- Cursor to select 'old' created AOL who column values
141: --
142: Cursor C_Sel1 Is
143: select t.creation_date
144: from ame_rules t
145: where t.rule_id = p_rec.rule_id
146: and t.start_date =
147: ame_rul_shd.g_old_rec.start_date
148: and t.end_date = p_validation_start_date;

Line 152: from ame_rules t

148: and t.end_date = p_validation_start_date;
149: --
150: Cursor C_Sel2 Is
151: select created_by
152: from ame_rules t
153: where t.rule_id = p_rec.rule_id
154: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
155: and rownum < 2;
156: --

Line 158: l_created_by ame_rules.created_by%TYPE;

154: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
155: and rownum < 2;
156: --
157: l_proc varchar2(72) := g_package||'dt_insert_dml';
158: l_created_by ame_rules.created_by%TYPE;
159: l_creation_date ame_rules.creation_date%TYPE;
160: l_last_update_date ame_rules.last_update_date%TYPE;
161: l_last_updated_by ame_rules.last_updated_by%TYPE;
162: l_last_update_login ame_rules.last_update_login%TYPE;

Line 159: l_creation_date ame_rules.creation_date%TYPE;

155: and rownum < 2;
156: --
157: l_proc varchar2(72) := g_package||'dt_insert_dml';
158: l_created_by ame_rules.created_by%TYPE;
159: l_creation_date ame_rules.creation_date%TYPE;
160: l_last_update_date ame_rules.last_update_date%TYPE;
161: l_last_updated_by ame_rules.last_updated_by%TYPE;
162: l_last_update_login ame_rules.last_update_login%TYPE;
163: l_current_user_id integer;

Line 160: l_last_update_date ame_rules.last_update_date%TYPE;

156: --
157: l_proc varchar2(72) := g_package||'dt_insert_dml';
158: l_created_by ame_rules.created_by%TYPE;
159: l_creation_date ame_rules.creation_date%TYPE;
160: l_last_update_date ame_rules.last_update_date%TYPE;
161: l_last_updated_by ame_rules.last_updated_by%TYPE;
162: l_last_update_login ame_rules.last_update_login%TYPE;
163: l_current_user_id integer;
164: l_temp_count integer;

Line 161: l_last_updated_by ame_rules.last_updated_by%TYPE;

157: l_proc varchar2(72) := g_package||'dt_insert_dml';
158: l_created_by ame_rules.created_by%TYPE;
159: l_creation_date ame_rules.creation_date%TYPE;
160: l_last_update_date ame_rules.last_update_date%TYPE;
161: l_last_updated_by ame_rules.last_updated_by%TYPE;
162: l_last_update_login ame_rules.last_update_login%TYPE;
163: l_current_user_id integer;
164: l_temp_count integer;
165: --

Line 162: l_last_update_login ame_rules.last_update_login%TYPE;

158: l_created_by ame_rules.created_by%TYPE;
159: l_creation_date ame_rules.creation_date%TYPE;
160: l_last_update_date ame_rules.last_update_date%TYPE;
161: l_last_updated_by ame_rules.last_updated_by%TYPE;
162: l_last_update_login ame_rules.last_update_login%TYPE;
163: l_current_user_id integer;
164: l_temp_count integer;
165: --
166: Begin

Line 252: -- Insert the row into: ame_rules

248: End If;
249: --
250: --
251: --
252: -- Insert the row into: ame_rules
253: --
254: insert into ame_rules
255: (rule_id
256: ,rule_type

Line 254: insert into ame_rules

250: --
251: --
252: -- Insert the row into: ame_rules
253: --
254: insert into ame_rules
255: (rule_id
256: ,rule_type
257: ,action_id
258: ,start_date

Line 382: Cursor C_Sel1 is select ame_rules_s.nextval from sys.dual;

378: ,p_validation_start_date in date
379: ,p_validation_end_date in date
380: ) is
381: --
382: Cursor C_Sel1 is select ame_rules_s.nextval from sys.dual;
383: --
384: Cursor C_Sel2 is
385: Select null
386: from ame_rules

Line 386: from ame_rules

382: Cursor C_Sel1 is select ame_rules_s.nextval from sys.dual;
383: --
384: Cursor C_Sel2 is
385: Select null
386: from ame_rules
387: where rule_id =
388: ame_rul_ins.g_rule_id_i
389: and ( p_effective_date
390: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)

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

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_rules');
414: fnd_message.raise_error;
415: End If;
416: Close C_Sel2;
417: --

Line 525: (p_module_name => 'AME_RULES'

521: --
522: when hr_api.cannot_find_prog_unit then
523: --
524: hr_api.cannot_find_prog_unit_error
525: (p_module_name => 'AME_RULES'
526: ,p_hook_type => 'AI');
527: --
528: end;
529: --