DBA Data[Home] [Help]

APPS.PER_ELC_INS dependencies on PER_ELECTIONS

Line 58: l_created_by per_elections.created_by%TYPE;

54: (p_rec in out nocopy per_elc_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_elections.created_by%TYPE;
59: l_creation_date per_elections.creation_date%TYPE;
60: l_last_update_date per_elections.last_update_date%TYPE;
61: l_last_updated_by per_elections.last_updated_by%TYPE;
62: l_last_update_login per_elections.last_update_login%TYPE;

Line 59: l_creation_date per_elections.creation_date%TYPE;

55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_elections.created_by%TYPE;
59: l_creation_date per_elections.creation_date%TYPE;
60: l_last_update_date per_elections.last_update_date%TYPE;
61: l_last_updated_by per_elections.last_updated_by%TYPE;
62: l_last_update_login per_elections.last_update_login%TYPE;
63: --

Line 60: l_last_update_date per_elections.last_update_date%TYPE;

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_elections.created_by%TYPE;
59: l_creation_date per_elections.creation_date%TYPE;
60: l_last_update_date per_elections.last_update_date%TYPE;
61: l_last_updated_by per_elections.last_updated_by%TYPE;
62: l_last_update_login per_elections.last_update_login%TYPE;
63: --
64: Begin

Line 61: l_last_updated_by per_elections.last_updated_by%TYPE;

57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_elections.created_by%TYPE;
59: l_creation_date per_elections.creation_date%TYPE;
60: l_last_update_date per_elections.last_update_date%TYPE;
61: l_last_updated_by per_elections.last_updated_by%TYPE;
62: l_last_update_login per_elections.last_update_login%TYPE;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);

Line 62: l_last_update_login per_elections.last_update_login%TYPE;

58: l_created_by per_elections.created_by%TYPE;
59: l_creation_date per_elections.creation_date%TYPE;
60: l_last_update_date per_elections.last_update_date%TYPE;
61: l_last_updated_by per_elections.last_updated_by%TYPE;
62: l_last_update_login per_elections.last_update_login%TYPE;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: p_rec.object_version_number := 1; -- Initialise the object version

Line 79: -- Insert the row into: per_elections

75: l_last_update_date := sysdate;
76: l_last_updated_by := fnd_global.user_id;
77: l_last_update_login := fnd_global.login_id;
78: --
79: -- Insert the row into: per_elections
80: --
81: insert into per_elections
82: (election_id
83: ,business_group_id

Line 81: insert into per_elections

77: l_last_update_login := fnd_global.login_id;
78: --
79: -- Insert the row into: per_elections
80: --
81: insert into per_elections
82: (election_id
83: ,business_group_id
84: ,election_date
85: ,description

Line 305: Cursor C_Sel1 is select per_elections_s.nextval from sys.dual;

301: ) is
302: --
303: l_proc varchar2(72) := g_package||'pre_insert';
304: --
305: Cursor C_Sel1 is select per_elections_s.nextval from sys.dual;
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --

Line 514: (p_module_name => 'PER_ELECTIONS'

510: --
511: when hr_api.cannot_find_prog_unit then
512: --
513: hr_api.cannot_find_prog_unit_error
514: (p_module_name => 'PER_ELECTIONS'
515: ,p_hook_type => 'AI');
516: --
517: end;
518: --