45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: procedure chk_rep_body_id
49: (p_election_id in per_elections.election_id%TYPE
50: ,p_object_version_number in per_elections.object_version_number%TYPE
51: ,p_rep_body_id in per_elections.rep_body_id%TYPE
52: )
53: is
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: procedure chk_rep_body_id
49: (p_election_id in per_elections.election_id%TYPE
50: ,p_object_version_number in per_elections.object_version_number%TYPE
51: ,p_rep_body_id in per_elections.rep_body_id%TYPE
52: )
53: is
54: --
47: -- ----------------------------------------------------------------------------
48: procedure chk_rep_body_id
49: (p_election_id in per_elections.election_id%TYPE
50: ,p_object_version_number in per_elections.object_version_number%TYPE
51: ,p_rep_body_id in per_elections.rep_body_id%TYPE
52: )
53: is
54: --
55: l_proc varchar2(72) := g_package||'chk_rep_body_id';
136: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: procedure chk_can_delete
140: (p_election_id in per_elections.election_id%TYPE
141: ,p_object_version_number in per_elections.object_version_number%TYPE
142: )
143: is
144: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: procedure chk_can_delete
140: (p_election_id in per_elections.election_id%TYPE
141: ,p_object_version_number in per_elections.object_version_number%TYPE
142: )
143: is
144: --
145: l_proc varchar2(72) := g_package||'chk_can_exists';
234: --
235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: procedure chk_election_date
238: (p_election_date in per_elections.election_date%TYPE
239: ,p_election_id in per_elections.election_id%TYPE
240: ,p_result_publish_date in per_elections.result_publish_date%TYPE
241: ,p_object_version_number in per_elections.object_version_number%TYPE
242: )
235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: procedure chk_election_date
238: (p_election_date in per_elections.election_date%TYPE
239: ,p_election_id in per_elections.election_id%TYPE
240: ,p_result_publish_date in per_elections.result_publish_date%TYPE
241: ,p_object_version_number in per_elections.object_version_number%TYPE
242: )
243: is
236: -- ----------------------------------------------------------------------------
237: procedure chk_election_date
238: (p_election_date in per_elections.election_date%TYPE
239: ,p_election_id in per_elections.election_id%TYPE
240: ,p_result_publish_date in per_elections.result_publish_date%TYPE
241: ,p_object_version_number in per_elections.object_version_number%TYPE
242: )
243: is
244: --
237: procedure chk_election_date
238: (p_election_date in per_elections.election_date%TYPE
239: ,p_election_id in per_elections.election_id%TYPE
240: ,p_result_publish_date in per_elections.result_publish_date%TYPE
241: ,p_object_version_number in per_elections.object_version_number%TYPE
242: )
243: is
244: --
245: l_proc varchar2(72) := g_package||'chk_rep_body_id';
302: --
303: cursor csr_sec_grp is
304: select pbg.security_group_id
305: from per_business_groups pbg
306: , per_elections elc
307: where elc.election_id = p_election_id
308: and pbg.business_group_id = elc.business_group_id;
309: --
310: -- Declare local variables
362: --
363: cursor csr_leg_code is
364: select pbg.legislation_code
365: from per_business_groups pbg
366: , per_elections elc
367: where elc.election_id = p_election_id
368: and pbg.business_group_id = elc.business_group_id;
369: --
370: -- Declare local variables
707: -- b) During insert.
708: --
709: hr_dflex_utility.ins_or_upd_descflex_attribs
710: (p_appl_short_name => 'PER'
711: ,p_descflex_name => 'PER_ELECTIONS'
712: ,p_attribute_category => p_rec.attribute_category
713: ,p_attribute1_name => 'ATTRIBUTE1'
714: ,p_attribute1_value => p_rec.attribute1
715: ,p_attribute2_name => 'ATTRIBUTE2'