54: (p_rec in out nocopy ame_itl_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;
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;
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: --
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
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);