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

Line 58: l_created_by ame_approval_groups.created_by%TYPE;

54: (p_rec in out nocopy ame_agl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_approval_groups.created_by%TYPE;
59: l_creation_date ame_approval_groups.creation_date%TYPE;
60: l_last_update_date ame_approval_groups.last_update_date%TYPE;
61: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
62: l_last_update_login ame_approval_groups.last_update_login%TYPE;

Line 59: l_creation_date ame_approval_groups.creation_date%TYPE;

55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_approval_groups.created_by%TYPE;
59: l_creation_date ame_approval_groups.creation_date%TYPE;
60: l_last_update_date ame_approval_groups.last_update_date%TYPE;
61: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
62: l_last_update_login ame_approval_groups.last_update_login%TYPE;
63: l_current_user_id integer;

Line 60: l_last_update_date ame_approval_groups.last_update_date%TYPE;

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_approval_groups.created_by%TYPE;
59: l_creation_date ame_approval_groups.creation_date%TYPE;
60: l_last_update_date ame_approval_groups.last_update_date%TYPE;
61: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
62: l_last_update_login ame_approval_groups.last_update_login%TYPE;
63: l_current_user_id integer;
64: --

Line 61: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;

57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_approval_groups.created_by%TYPE;
59: l_creation_date ame_approval_groups.creation_date%TYPE;
60: l_last_update_date ame_approval_groups.last_update_date%TYPE;
61: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
62: l_last_update_login ame_approval_groups.last_update_login%TYPE;
63: l_current_user_id integer;
64: --
65: Begin

Line 62: l_last_update_login ame_approval_groups.last_update_login%TYPE;

58: l_created_by ame_approval_groups.created_by%TYPE;
59: l_creation_date ame_approval_groups.creation_date%TYPE;
60: l_last_update_date ame_approval_groups.last_update_date%TYPE;
61: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
62: l_last_update_login ame_approval_groups.last_update_login%TYPE;
63: l_current_user_id integer;
64: --
65: Begin
66: hr_utility.set_location('Entering:'||l_proc, 5);

Line 81: -- Insert the row into: ame_approval_groups_tl

77: --
78: --
79: --
80: --
81: -- Insert the row into: ame_approval_groups_tl
82: --
83: insert into ame_approval_groups_tl
84: (approval_group_id
85: ,language

Line 83: insert into ame_approval_groups_tl

79: --
80: --
81: -- Insert the row into: ame_approval_groups_tl
82: --
83: insert into ame_approval_groups_tl
84: (approval_group_id
85: ,language
86: ,source_lang
87: ,user_approval_group_name

Line 244: (p_module_name => 'AME_APPROVAL_GROUPS_TL'

240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'AME_APPROVAL_GROUPS_TL'
245: ,p_hook_type => 'AI');
246: --
247: end;
248: --

Line 359: from ame_approval_groups_tl agl

355: select l.language_code
356: from fnd_languages l
357: where l.installed_flag in ('I','B')
358: and not exists (select null
359: from ame_approval_groups_tl agl
360: where agl.approval_group_id = p_approval_group_id
361: and agl.language = l.language_code);
362: --
363: l_proc varchar2(72) := g_package || 'ins_tl';