APPS.PER_ECA_SHD dependencies on PER_ELECTION_CANDIDATES

Line 21: If (p_constraint_name = 'PER_ELECTION_CANDIDATES_FK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_ELECTION_CANDIDATES_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 26: ElsIf (p_constraint_name = 'PER_ELECTION_CANDIDATES_FK2') Then

22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PER_ELECTION_CANDIDATES_FK2') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 128: from per_election_candidates

124: ,candidate_information28
125: ,candidate_information29
126: ,candidate_information30
127: ,object_version_number
128: from per_election_candidates
129: where election_candidate_id = p_election_candidate_id;
130: --
131: l_fct_ret boolean;
132: --

Line 262: from per_election_candidates

258: ,candidate_information28
259: ,candidate_information29
260: ,candidate_information30
261: ,object_version_number
262: from per_election_candidates
263: where election_candidate_id = p_election_candidate_id
264: for update nowait;
265: --
266: l_proc varchar2(72) := g_package||'lck';

Line 305: fnd_message.set_token('TABLE_NAME', 'per_election_candidates');

301: -- The object is locked therefore we need to supply a meaningful
302: -- error message.
303: --
304: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
305: fnd_message.set_token('TABLE_NAME', 'per_election_candidates');
306: fnd_message.raise_error;
307: End lck;
308: --
309: -- ----------------------------------------------------------------------------