APPS.AME_AGL_UPD dependencies on AME_APPROVAL_GROUPS

Line 59: l_last_update_date ame_approval_groups.last_update_date%TYPE;

55: (p_rec in out nocopy ame_agl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date ame_approval_groups.last_update_date%TYPE;
60: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
61: l_last_update_login ame_approval_groups.last_update_login%TYPE;
62: l_current_user_id integer;
63: --

Line 60: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;

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

Line 61: l_last_update_login ame_approval_groups.last_update_login%TYPE;

57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date ame_approval_groups.last_update_date%TYPE;
60: l_last_updated_by ame_approval_groups.last_updated_by%TYPE;
61: l_last_update_login ame_approval_groups.last_update_login%TYPE;
62: l_current_user_id integer;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);

Line 72: -- Update the ame_approval_groups_tl Row

68: l_last_updated_by := l_current_user_id;
69: l_last_update_login := l_current_user_id;
70:
71: --
72: -- Update the ame_approval_groups_tl Row
73: --
74: update ame_approval_groups_tl
75: set
76: approval_group_id = p_rec.approval_group_id

Line 74: update ame_approval_groups_tl

70:
71: --
72: -- Update the ame_approval_groups_tl Row
73: --
74: update ame_approval_groups_tl
75: set
76: approval_group_id = p_rec.approval_group_id
77: ,language = p_rec.language
78: ,source_lang = p_rec.source_lang

Line 222: (p_module_name => 'AME_APPROVAL_GROUPS_TL'

218: --
219: when hr_api.cannot_find_prog_unit then
220: --
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'AME_APPROVAL_GROUPS_TL'
223: ,p_hook_type => 'AU');
224: --
225: end;
226: --

Line 406: from ame_approval_groups_tl agl

402: -- source_lang match the specified language.
403: --
404: cursor csr_upd_langs is
405: select agl.language
406: from ame_approval_groups_tl agl
407: where agl.approval_group_id = p_approval_group_id
408: and p_language_code in (agl.language
409: ,agl.source_lang);
410: --