55: (p_rec in out nocopy per_elc_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_elections.last_update_date%TYPE;
60: l_last_updated_by per_elections.last_updated_by%TYPE;
61: l_last_update_login per_elections.last_update_login%TYPE;
62: --
63: Begin
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_elections.last_update_date%TYPE;
60: l_last_updated_by per_elections.last_updated_by%TYPE;
61: l_last_update_login per_elections.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_elections.last_update_date%TYPE;
60: l_last_updated_by per_elections.last_updated_by%TYPE;
61: l_last_update_login per_elections.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: --
74: l_last_update_date := sysdate;
75: l_last_updated_by := fnd_global.user_id;
76: l_last_update_login := fnd_global.login_id;
77: --
78: -- Update the per_elections Row
79: --
80: update per_elections
81: set
82: election_id = p_rec.election_id
76: l_last_update_login := fnd_global.login_id;
77: --
78: -- Update the per_elections Row
79: --
80: update per_elections
81: set
82: election_id = p_rec.election_id
83: ,business_group_id = p_rec.business_group_id
84: ,election_date = p_rec.election_date
557: --
558: when hr_api.cannot_find_prog_unit then
559: --
560: hr_api.cannot_find_prog_unit_error
561: (p_module_name => 'PER_ELECTIONS'
562: ,p_hook_type => 'AU');
563: --
564: end;
565: --