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.IRC_ILC_BUS dependencies on IRC_LINKED_CANDIDATES

Line 28: -- IRC_LINKED_CANDIDATES and PER_BUSINESS_GROUPS_PERF

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- IRC_LINKED_CANDIDATES and PER_BUSINESS_GROUPS_PERF
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 36: , IRC_LINKED_CANDIDATES ilc

32: cursor csr_sec_grp is
33: select pbg.security_group_id,
34: pbg.legislation_code
35: from per_business_groups_perf pbg
36: , IRC_LINKED_CANDIDATES ilc
37: -- , EDIT_HERE table_name(s) 333
38: where ilc.link_id = p_link_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 105: -- IRC_LINKED_CANDIDATES and PER_BUSINESS_GROUPS_PERF

101: --
102: -- Declare cursor
103: --
104: -- EDIT_HERE In the following cursor statement add join(s) between
105: -- IRC_LINKED_CANDIDATES and PER_BUSINESS_GROUPS_PERF
106: -- so that the legislation_code for
107: -- the current business group context can be derived.
108: -- Remove this comment when the edit has been completed.
109: cursor csr_leg_code is

Line 112: , IRC_LINKED_CANDIDATES ilc

108: -- Remove this comment when the edit has been completed.
109: cursor csr_leg_code is
110: select pbg.legislation_code
111: from per_business_groups_perf pbg
112: , IRC_LINKED_CANDIDATES ilc
113: -- , EDIT_HERE table_name(s) 333
114: where ilc.link_id = p_link_id;
115: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
116: --

Line 265: (p_party_id in irc_linked_candidates.party_id%TYPE

261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure chk_party_id
265: (p_party_id in irc_linked_candidates.party_id%TYPE
266: ,p_effective_date in Date
267: ) IS
268: --
269: l_proc varchar2(72) := g_package || 'chk_party_id';

Line 296: 'IRC_LINKED_CANDIDATES.PARTY_ID'

292: exception
293: when app_exception.application_exception then
294: if hr_multi_message.exception_add
295: (p_associated_column1 =>
296: 'IRC_LINKED_CANDIDATES.PARTY_ID'
297: ) then
298: hr_utility.set_location(' Leaving:'||l_proc,40);
299: raise;
300: end if;

Line 308: (p_status in irc_linked_candidates.status%TYPE

304: -- ----------------------------------------------------------------------------
305: -- |-----------------------------< chk_status >-------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure chk_status
308: (p_status in irc_linked_candidates.status%TYPE
309: ,p_effective_date in date
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'chk_status';

Line 337: (p_party_id in irc_linked_candidates.party_id%TYPE

333: -- ----------------------------------------------------------------------------
334: -- |-----------------------------< chk_cand_link >----------------------------|
335: -- ----------------------------------------------------------------------------
336: Procedure chk_cand_link
337: (p_party_id in irc_linked_candidates.party_id%TYPE
338: ,p_duplicate_set_id in irc_linked_candidates.duplicate_set_id%TYPE
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'chk_cand_link';

Line 338: ,p_duplicate_set_id in irc_linked_candidates.duplicate_set_id%TYPE

334: -- |-----------------------------< chk_cand_link >----------------------------|
335: -- ----------------------------------------------------------------------------
336: Procedure chk_cand_link
337: (p_party_id in irc_linked_candidates.party_id%TYPE
338: ,p_duplicate_set_id in irc_linked_candidates.duplicate_set_id%TYPE
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'chk_cand_link';
342: l_cand_linked varchar2(1);

Line 346: from irc_linked_candidates ilc

342: l_cand_linked varchar2(1);
343: --
344: cursor csr_cand_link is
345: select null
346: from irc_linked_candidates ilc
347: where ilc.party_id = p_party_id
348: and ilc.duplicate_set_id <> p_duplicate_set_id
349: and ilc.status in ('CONFIRMED','POTENTIAL');
350: --

Line 370: 'IRC_LINKED_CANDIDATES.PARTY_ID'

366: exception
367: when app_exception.application_exception then
368: if hr_multi_message.exception_add
369: (p_associated_column1 =>
370: 'IRC_LINKED_CANDIDATES.PARTY_ID'
371: ) then
372: hr_utility.set_location(' Leaving:'||l_proc,40);
373: raise;
374: end if;

Line 383: (p_party_id in irc_linked_candidates.party_id%TYPE

379: -- ----------------------------------------------------------------------------
380: -- |-----------------------------< chk_duplcate_set >-------------------------|
381: -- ----------------------------------------------------------------------------
382: Procedure chk_duplcate_set
383: (p_party_id in irc_linked_candidates.party_id%TYPE
384: ,p_duplicate_set_id in irc_linked_candidates.duplicate_set_id%TYPE
385: ) is
386: --
387: l_proc varchar2(72) := g_package||'chk_duplcate_set';

Line 384: ,p_duplicate_set_id in irc_linked_candidates.duplicate_set_id%TYPE

380: -- |-----------------------------< chk_duplcate_set >-------------------------|
381: -- ----------------------------------------------------------------------------
382: Procedure chk_duplcate_set
383: (p_party_id in irc_linked_candidates.party_id%TYPE
384: ,p_duplicate_set_id in irc_linked_candidates.duplicate_set_id%TYPE
385: ) is
386: --
387: l_proc varchar2(72) := g_package||'chk_duplcate_set';
388: l_dup_set varchar2(1);

Line 392: from irc_linked_candidates ilc

388: l_dup_set varchar2(1);
389: --
390: cursor csr_duplcate_set is
391: select null
392: from irc_linked_candidates ilc
393: where ilc.party_id = p_party_id
394: and ilc.duplicate_set_id = p_duplicate_set_id;
395: --
396: Begin

Line 415: 'IRC_LINKED_CANDIDATES.PARTY_ID'

411: exception
412: when app_exception.application_exception then
413: if hr_multi_message.exception_add
414: (p_associated_column1 =>
415: 'IRC_LINKED_CANDIDATES.PARTY_ID'
416: ,p_associated_column2 =>
417: 'IRC_LINKED_CANDIDATES.DUPLICATE_SET_ID'
418: ) then
419: hr_utility.set_location(' Leaving:'||l_proc,40);

Line 417: 'IRC_LINKED_CANDIDATES.DUPLICATE_SET_ID'

413: if hr_multi_message.exception_add
414: (p_associated_column1 =>
415: 'IRC_LINKED_CANDIDATES.PARTY_ID'
416: ,p_associated_column2 =>
417: 'IRC_LINKED_CANDIDATES.DUPLICATE_SET_ID'
418: ) then
419: hr_utility.set_location(' Leaving:'||l_proc,40);
420: raise;
421: end if;