55: (p_rec in out nocopy per_eco_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: l_last_update_date per_election_constituencys.last_update_date%TYPE;
60: l_last_updated_by per_election_constituencys.last_updated_by%TYPE;
61: l_last_update_login per_election_constituencys.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_election_constituencys.last_update_date%TYPE;
60: l_last_updated_by per_election_constituencys.last_updated_by%TYPE;
61: l_last_update_login per_election_constituencys.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_election_constituencys.last_update_date%TYPE;
60: l_last_updated_by per_election_constituencys.last_updated_by%TYPE;
61: l_last_update_login per_election_constituencys.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: --
73: l_last_update_date := sysdate;
74: l_last_updated_by := fnd_global.user_id;
75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Update the per_election_constituencys Row
78: --
79: update per_election_constituencys
80: set
81: election_constituency_id = p_rec.election_constituency_id
75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Update the per_election_constituencys Row
78: --
79: update per_election_constituencys
80: set
81: election_constituency_id = p_rec.election_constituency_id
82: ,election_id = p_rec.election_id
83: ,business_group_id = p_rec.business_group_id
381: --
382: when hr_api.cannot_find_prog_unit then
383: --
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'
386: ,p_hook_type => 'AU');
387: --
388: end;
389: --