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_ACF_INS dependencies on AME_ACTION_TYPE_CONFIG

Line 93: from ame_action_type_config 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_action_type_config t
94: where t.action_type_id = p_rec.action_type_id
95: and t.application_id = p_rec.application_id
96: and t.start_date = ame_acf_shd.g_old_rec.start_date
97: and t.end_date = p_validation_start_date;

Line 101: from ame_action_type_config t

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

Line 108: l_created_by ame_action_type_config.created_by%TYPE;

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

Line 109: l_creation_date ame_action_type_config.creation_date%TYPE;

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

Line 110: l_last_update_date ame_action_type_config.last_update_date%TYPE;

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

Line 111: l_last_updated_by ame_action_type_config.last_updated_by%TYPE;

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

Line 112: l_last_update_login ame_action_type_config.last_update_login%TYPE;

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

Line 191: -- Insert the row into: ame_action_type_config

187: End If;
188: --
189: --
190: --
191: -- Insert the row into: ame_action_type_config
192: --
193: insert into ame_action_type_config
194: (application_id
195: ,action_type_id

Line 193: insert into ame_action_type_config

189: --
190: --
191: -- Insert the row into: ame_action_type_config
192: --
193: insert into ame_action_type_config
194: (application_id
195: ,action_type_id
196: ,voting_regime
197: ,order_number

Line 323: from ame_action_type_config

319: nvl(end_date - (1/86400) , sysdate)
320: and rownum < 2;
321: select count(*)
322: into l_temp_count
323: from ame_action_type_config
324: where
325: application_id = p_application_id and
326: sysdate between start_date and
327: nvl(end_date - ame_util.oneSecond, sysdate);

Line 333: from ame_action_type_config,

329: p_order_number := 1;
330: else
331: select (nvl(max(order_number), 0) + 1)
332: into p_order_number
333: from ame_action_type_config,
334: ame_action_type_usages
335: where
336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
337: ame_action_type_config.application_id = p_application_id and

Line 336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and

332: into p_order_number
333: from ame_action_type_config,
334: ame_action_type_usages
335: where
336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
337: ame_action_type_config.application_id = p_application_id and
338: ame_action_type_usages.rule_type = l_rule_type and
339: p_effective_date between ame_action_type_config.start_date and
340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and

Line 337: ame_action_type_config.application_id = p_application_id and

333: from ame_action_type_config,
334: ame_action_type_usages
335: where
336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
337: ame_action_type_config.application_id = p_application_id and
338: ame_action_type_usages.rule_type = l_rule_type and
339: p_effective_date between ame_action_type_config.start_date and
340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and
341: p_effective_date between ame_action_type_usages.start_date and

Line 339: p_effective_date between ame_action_type_config.start_date and

335: where
336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
337: ame_action_type_config.application_id = p_application_id and
338: ame_action_type_usages.rule_type = l_rule_type and
339: p_effective_date between ame_action_type_config.start_date and
340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and
341: p_effective_date between ame_action_type_usages.start_date and
342: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, p_effective_date);
343: end if;

Line 340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and

336: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
337: ame_action_type_config.application_id = p_application_id and
338: ame_action_type_usages.rule_type = l_rule_type and
339: p_effective_date between ame_action_type_config.start_date and
340: nvl(ame_action_type_config.end_date - ame_util.oneSecond, p_effective_date) and
341: p_effective_date between ame_action_type_usages.start_date and
342: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, p_effective_date);
343: end if;
344: else

Line 412: -- Cursor C_Sel1 is select ame_action_type_config_s.nextval from sys.dual;

408: ,p_validation_start_date in date
409: ,p_validation_end_date in date
410: ) is
411: --
412: -- Cursor C_Sel1 is select ame_action_type_config_s.nextval from sys.dual;
413: --
414: Cursor C_Sel2 is
415: Select null
416: from ame_action_type_config

Line 416: from ame_action_type_config

412: -- Cursor C_Sel1 is select ame_action_type_config_s.nextval from sys.dual;
413: --
414: Cursor C_Sel2 is
415: Select null
416: from ame_action_type_config
417: where application_id =
418: ame_acf_ins.g_application_id_i
419: and action_type_id =
420: ame_acf_ins.g_action_type_id_i;

Line 442: fnd_message.set_token('TABLE_NAME','ame_action_type_config');

438: --
439: -- The primary key values are already in use.
440: --
441: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
442: fnd_message.set_token('TABLE_NAME','ame_action_type_config');
443: fnd_message.raise_error;
444: End If;
445: Close C_Sel2;
446: --

Line 560: (p_module_name => 'AME_ACTION_TYPE_CONFIG'

556: --
557: when hr_api.cannot_find_prog_unit then
558: --
559: hr_api.cannot_find_prog_unit_error
560: (p_module_name => 'AME_ACTION_TYPE_CONFIG'
561: ,p_hook_type => 'AI');
562: --
563: end;
564: --