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_ECO_BUS dependencies on PER_ELECTION_CONSTITUENCYS

Line 45: (p_election_id in per_election_constituencys.election_id%TYPE

41: --
42: -- {End Of Comments}
43: -- ----------------------------------------------------------------------------
44: procedure chk_election_id
45: (p_election_id in per_election_constituencys.election_id%TYPE
46: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
47: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
48: )
49: is

Line 46: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE

42: -- {End Of Comments}
43: -- ----------------------------------------------------------------------------
44: procedure chk_election_id
45: (p_election_id in per_election_constituencys.election_id%TYPE
46: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
47: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
48: )
49: is
50: --

Line 47: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE

43: -- ----------------------------------------------------------------------------
44: procedure chk_election_id
45: (p_election_id in per_election_constituencys.election_id%TYPE
46: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
47: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
48: )
49: is
50: --
51: l_proc varchar2(72) := g_package||'chk_election_id';

Line 134: (p_election_id in per_election_constituencys.election_id%TYPE

130: --
131: -- {End Of Comments}
132: -- ----------------------------------------------------------------------------
133: procedure chk_duplicate_constituency
134: (p_election_id in per_election_constituencys.election_id%TYPE
135: ,p_constituency_id in per_election_constituencys.constituency_id%TYPE
136: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
137: )
138: is

Line 135: ,p_constituency_id in per_election_constituencys.constituency_id%TYPE

131: -- {End Of Comments}
132: -- ----------------------------------------------------------------------------
133: procedure chk_duplicate_constituency
134: (p_election_id in per_election_constituencys.election_id%TYPE
135: ,p_constituency_id in per_election_constituencys.constituency_id%TYPE
136: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
137: )
138: is
139: --

Line 136: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE

132: -- ----------------------------------------------------------------------------
133: procedure chk_duplicate_constituency
134: (p_election_id in per_election_constituencys.election_id%TYPE
135: ,p_constituency_id in per_election_constituencys.constituency_id%TYPE
136: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
137: )
138: is
139: --
140: l_proc varchar2(72) := g_package||'chk_duplicate_constituency';

Line 146: from per_election_constituencys

142: l_constituency_id number;
143: --
144: cursor csr_valid_constituency is
145: select election_constituency_id
146: from per_election_constituencys
147: where election_id = p_election_id
148: and constituency_id = p_constituency_id;
149: --
150: begin

Line 213: (p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE

209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: procedure chk_can_delete
213: (p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
214: ,p_election_id in per_election_constituencys.election_id%TYPE
215: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
216: )
217: is

Line 214: ,p_election_id in per_election_constituencys.election_id%TYPE

210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: procedure chk_can_delete
213: (p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
214: ,p_election_id in per_election_constituencys.election_id%TYPE
215: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
216: )
217: is
218: --

Line 215: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE

211: -- ----------------------------------------------------------------------------
212: procedure chk_can_delete
213: (p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
214: ,p_election_id in per_election_constituencys.election_id%TYPE
215: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
216: )
217: is
218: --
219: l_proc varchar2(72) := g_package||'chk_can_exists';

Line 285: (p_constituency_id in per_election_constituencys.election_id%TYPE

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: procedure chk_constituency_id
285: (p_constituency_id in per_election_constituencys.election_id%TYPE
286: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
287: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
288: )
289: is

Line 286: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE

282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: procedure chk_constituency_id
285: (p_constituency_id in per_election_constituencys.election_id%TYPE
286: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
287: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
288: )
289: is
290: --

Line 287: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE

283: -- ----------------------------------------------------------------------------
284: procedure chk_constituency_id
285: (p_constituency_id in per_election_constituencys.election_id%TYPE
286: ,p_election_constituency_id in per_election_constituencys.election_constituency_id%TYPE
287: ,p_object_version_number in per_election_constituencys.object_version_number%TYPE
288: )
289: is
290: --
291: l_proc varchar2(72) := g_package||'chk_constituency_id';

Line 364: , per_election_constituencys eco

360: --
361: cursor csr_sec_grp is
362: select pbg.security_group_id
363: from per_business_groups pbg
364: , per_election_constituencys eco
365: where eco.election_constituency_id = p_election_constituency_id
366: and pbg.business_group_id = eco.business_group_id;
367: --
368: -- Declare local variables

Line 424: , per_election_constituencys eco

420: --
421: cursor csr_leg_code is
422: select pbg.legislation_code
423: from per_business_groups pbg
424: , per_election_constituencys eco
425: where eco.election_constituency_id = p_election_constituency_id
426: and pbg.business_group_id = eco.business_group_id;
427: --
428: -- Declare local variables

Line 592: ,p_descflex_name => 'PER_ELECTION_CONSTITUENCYS'

588: -- b) During insert.
589: --
590: hr_dflex_utility.ins_or_upd_descflex_attribs
591: (p_appl_short_name => 'PER'
592: ,p_descflex_name => 'PER_ELECTION_CONSTITUENCYS'
593: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
594: ,p_attribute1_name => 'ATTRIBUTE1'
595: ,p_attribute1_value => p_rec.attribute1
596: ,p_attribute2_name => 'ATTRIBUTE2'