APPS.PER_ELC_BUS dependencies on PER_ELECTIONS

Line 49: (p_election_id in per_elections.election_id%TYPE

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

Line 50: ,p_object_version_number in per_elections.object_version_number%TYPE

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: --

Line 51: ,p_rep_body_id in per_elections.rep_body_id%TYPE

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';

Line 140: (p_election_id in per_elections.election_id%TYPE

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: --

Line 141: ,p_object_version_number in per_elections.object_version_number%TYPE

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';

Line 238: (p_election_date in per_elections.election_date%TYPE

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: )

Line 239: ,p_election_id in per_elections.election_id%TYPE

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

Line 240: ,p_result_publish_date in per_elections.result_publish_date%TYPE

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: --

Line 241: ,p_object_version_number in per_elections.object_version_number%TYPE

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';

Line 306: , per_elections elc

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

Line 366: , per_elections elc

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

Line 711: ,p_descflex_name => 'PER_ELECTIONS'

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'