eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ECA_INS dependencies on PER_ELECTION_CANDIDATES

Line 58: l_created_by per_election_candidates.created_by%TYPE;

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

Line 59: l_creation_date per_election_candidates.creation_date%TYPE;

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

Line 60: l_last_update_date per_election_candidates.last_update_date%TYPE;

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

Line 61: l_last_updated_by per_election_candidates.last_updated_by%TYPE;

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

Line 62: l_last_update_login per_election_candidates.last_update_login%TYPE;

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

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: -- Insert the row into: per_election_candidates
78: --
79: insert into per_election_candidates
80: (election_candidate_id
81: ,business_group_id

Line 79: insert into per_election_candidates

75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Insert the row into: per_election_candidates
78: --
79: insert into per_election_candidates
80: (election_candidate_id
81: ,business_group_id
82: ,election_id
83: ,person_id

Line 299: Cursor C_Sel1 is select per_election_candidates_s.nextval from sys.dual;

295: ) is
296: --
297: l_proc varchar2(72) := g_package||'pre_insert';
298: --
299: Cursor C_Sel1 is select per_election_candidates_s.nextval from sys.dual;
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --

Line 502: (p_module_name => 'PER_ELECTION_CANDIDATES'

498: --
499: when hr_api.cannot_find_prog_unit then
500: --
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'PER_ELECTION_CANDIDATES'
503: ,p_hook_type => 'AI');
504: --
505: end;
506: --