DBA Data[Home] [Help]

APPS.PER_ELC_UPD dependencies on PER_ELECTIONS

Line 59: l_last_update_date per_elections.last_update_date%TYPE;

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

Line 60: l_last_updated_by per_elections.last_updated_by%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
64: hr_utility.set_location('Entering:'||l_proc, 5);

Line 61: l_last_update_login per_elections.last_update_login%TYPE;

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: --

Line 78: -- Update the per_elections Row

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

Line 80: update per_elections

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

Line 561: (p_module_name => 'PER_ELECTIONS'

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: --