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_APG_INS dependencies on AME_APPROVAL_GROUPS

Line 90: from ame_approval_groups t

86: -- Cursor to select 'old' created AOL who column values
87: --
88: Cursor C_Sel1 Is
89: select t.creation_date
90: from ame_approval_groups t
91: where t.approval_group_id = p_rec.approval_group_id
92: and t.start_date =
93: ame_apg_shd.g_old_rec.start_date
94: and t.end_date = p_validation_start_date;

Line 98: from ame_approval_groups t

94: and t.end_date = p_validation_start_date;
95: --
96: Cursor C_Sel2 Is
97: select created_by
98: from ame_approval_groups t
99: where t.approval_group_id = p_rec.approval_group_id
100: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
101: and rownum<2;
102: --

Line 104: l_created_by ame_approval_groups.created_by%TYPE;

100: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
101: and rownum<2;
102: --
103: l_proc varchar2(72) := g_package||'dt_insert_dml';
104: l_created_by ame_approval_groups.created_by%TYPE;
105: l_creation_date ame_approval_groups.creation_date%TYPE;
106: l_last_update_date ame_approval_groups.last_update_date%TYPE;
107: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
108: l_last_update_login ame_approval_groups.last_update_login%TYPE;

Line 105: l_creation_date ame_approval_groups.creation_date%TYPE;

101: and rownum<2;
102: --
103: l_proc varchar2(72) := g_package||'dt_insert_dml';
104: l_created_by ame_approval_groups.created_by%TYPE;
105: l_creation_date ame_approval_groups.creation_date%TYPE;
106: l_last_update_date ame_approval_groups.last_update_date%TYPE;
107: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
108: l_last_update_login ame_approval_groups.last_update_login%TYPE;
109: l_current_user_id integer;

Line 106: l_last_update_date ame_approval_groups.last_update_date%TYPE;

102: --
103: l_proc varchar2(72) := g_package||'dt_insert_dml';
104: l_created_by ame_approval_groups.created_by%TYPE;
105: l_creation_date ame_approval_groups.creation_date%TYPE;
106: l_last_update_date ame_approval_groups.last_update_date%TYPE;
107: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
108: l_last_update_login ame_approval_groups.last_update_login%TYPE;
109: l_current_user_id integer;
110: l_temp_count integer;

Line 107: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;

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

Line 108: l_last_update_login ame_approval_groups.last_update_login%TYPE;

104: l_created_by ame_approval_groups.created_by%TYPE;
105: l_creation_date ame_approval_groups.creation_date%TYPE;
106: l_last_update_date ame_approval_groups.last_update_date%TYPE;
107: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
108: l_last_update_login ame_approval_groups.last_update_login%TYPE;
109: l_current_user_id integer;
110: l_temp_count integer;
111: --
112: Begin

Line 186: -- Insert the row into: ame_approval_groups

182: End If;
183: --
184: --
185: --
186: -- Insert the row into: ame_approval_groups
187: --
188: insert into ame_approval_groups
189: (approval_group_id
190: ,name

Line 188: insert into ame_approval_groups

184: --
185: --
186: -- Insert the row into: ame_approval_groups
187: --
188: insert into ame_approval_groups
189: (approval_group_id
190: ,name
191: ,start_date
192: ,end_date

Line 314: Cursor C_Sel1 is select ame_approval_groups_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_approval_groups_s.nextval from sys.dual;
315: --
316: Cursor C_Sel2 is
317: Select null
318: from ame_approval_groups

Line 318: from ame_approval_groups

314: Cursor C_Sel1 is select ame_approval_groups_s.nextval from sys.dual;
315: --
316: Cursor C_Sel2 is
317: Select null
318: from ame_approval_groups
319: where approval_group_id =
320: ame_apg_ins.g_approval_group_id_i
321: and p_effective_date between start_date
322: and nvl(end_date - ame_util.oneSecond , p_effective_date);

Line 342: fnd_message.set_token('TABLE_NAME','ame_approval_groups');

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

Line 446: (p_module_name => 'AME_APPROVAL_GROUPS'

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