DBA Data[Home] [Help]

APPS.PER_ECO_INS dependencies on PER_ELECTION_CONSTITUENCYS

Line 58: l_created_by per_election_constituencys.created_by%TYPE;

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

Line 59: l_creation_date per_election_constituencys.creation_date%TYPE;

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

Line 60: l_last_update_date per_election_constituencys.last_update_date%TYPE;

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

Line 61: l_last_updated_by per_election_constituencys.last_updated_by%TYPE;

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

Line 62: l_last_update_login per_election_constituencys.last_update_login%TYPE;

58: l_created_by per_election_constituencys.created_by%TYPE;
59: l_creation_date per_election_constituencys.creation_date%TYPE;
60: l_last_update_date per_election_constituencys.last_update_date%TYPE;
61: l_last_updated_by per_election_constituencys.last_updated_by%TYPE;
62: l_last_update_login per_election_constituencys.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 78: -- Insert the row into: per_election_constituencys

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: -- Insert the row into: per_election_constituencys
79: --
80: hr_utility.set_location('Entering:'||l_proc, 10);
81: insert into per_election_constituencys
82: (election_constituency_id

Line 81: insert into per_election_constituencys

77: --
78: -- Insert the row into: per_election_constituencys
79: --
80: hr_utility.set_location('Entering:'||l_proc, 10);
81: insert into per_election_constituencys
82: (election_constituency_id
83: ,election_id
84: ,business_group_id
85: ,constituency_id

Line 239: Cursor C_Sel1 is select per_election_constituencys_s.nextval from sys.dual;

235: ) is
236: --
237: l_proc varchar2(72) := g_package||'pre_insert';
238: --
239: Cursor C_Sel1 is select per_election_constituencys_s.nextval from sys.dual;
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --

Line 378: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'

374: --
375: when hr_api.cannot_find_prog_unit then
376: --
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'
379: ,p_hook_type => 'AI');
380: --
381: end;
382: --