APPS.PER_ECA_BUS dependencies on PER_ELECTION_CANDIDATES

Line 29: , per_election_candidates eca

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_election_candidates eca
30: where eca.election_candidate_id = p_election_candidate_id
31: and pbg.business_group_id = eca.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_election_candidates eca

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_election_candidates eca
90: where eca.election_candidate_id = p_election_candidate_id
91: and pbg.business_group_id = eca.business_group_id;
92: --
93: -- Declare local variables

Line 246: from per_election_candidates

242: l_election_candidate_id number;
243: --
244: cursor csr_valid_del is
245: select election_candidate_id
246: from per_election_candidates
247: where election_candidate_id = p_election_candidate_id
248: and role_id is null;
249: --
250: begin

Line 325: (p_person_id in per_election_candidates.person_id%TYPE

321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: procedure chk_person_id
325: (p_person_id in per_election_candidates.person_id%TYPE
326: )
327: is
328: --
329: l_proc varchar2(72) := g_package||'chk_person_id';

Line 396: (p_election_id in per_election_candidates.election_id%TYPE

392: --
393: -- {End Of Comments}
394: -- ----------------------------------------------------------------------------
395: procedure chk_election_id
396: (p_election_id in per_election_candidates.election_id%TYPE
397: )
398: is
399: --
400: l_proc varchar2(72) := g_package||'chk_election_id';

Line 464: (p_election_id in per_election_candidates.election_id%TYPE

460: --
461: -- {End Of Comments}
462: -- ----------------------------------------------------------------------------
463: procedure chk_duplicate_candidate
464: (p_election_id in per_election_candidates.election_id%TYPE
465: ,p_person_id in per_election_candidates.person_id%TYPE
466: ,p_election_candidate_id in per_election_candidates.election_candidate_id%TYPE
467: )
468: is

Line 465: ,p_person_id in per_election_candidates.person_id%TYPE

461: -- {End Of Comments}
462: -- ----------------------------------------------------------------------------
463: procedure chk_duplicate_candidate
464: (p_election_id in per_election_candidates.election_id%TYPE
465: ,p_person_id in per_election_candidates.person_id%TYPE
466: ,p_election_candidate_id in per_election_candidates.election_candidate_id%TYPE
467: )
468: is
469: --

Line 466: ,p_election_candidate_id in per_election_candidates.election_candidate_id%TYPE

462: -- ----------------------------------------------------------------------------
463: procedure chk_duplicate_candidate
464: (p_election_id in per_election_candidates.election_id%TYPE
465: ,p_person_id in per_election_candidates.person_id%TYPE
466: ,p_election_candidate_id in per_election_candidates.election_candidate_id%TYPE
467: )
468: is
469: --
470: l_proc varchar2(72) := g_package||'chk_duplicate_candidate';

Line 476: from per_election_candidates

472: l_candidate_id number;
473: --
474: cursor csr_valid_candidate is
475: select election_candidate_id
476: from per_election_candidates
477: where election_id = p_election_id
478: and person_id = p_person_id;
479: --
480: begin

Line 546: (p_role_id in per_election_candidates.role_id%TYPE

542: --
543: -- {End Of Comments}
544: -- ----------------------------------------------------------------------------
545: procedure chk_role_id
546: (p_role_id in per_election_candidates.role_id%TYPE
547: )
548: is
549: --
550: l_proc varchar2(72) := g_package||'chk_role_id';

Line 698: ,p_descflex_name => 'PER_ELECTION_CANDIDATES'

694: -- b) During insert.
695: --
696: hr_dflex_utility.ins_or_upd_descflex_attribs
697: (p_appl_short_name => 'PER'
698: ,p_descflex_name => 'PER_ELECTION_CANDIDATES'
699: ,p_attribute_category => p_rec.attribute_category
700: ,p_attribute1_name => 'ATTRIBUTE1'
701: ,p_attribute1_value => p_rec.attribute1
702: ,p_attribute2_name => 'ATTRIBUTE2'