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_CMR_BUS dependencies on IRC_COMM_RECIPIENTS

Line 28: -- irc_comm_recipients and PER_BUSINESS_GROUPS_PERF

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- irc_comm_recipients 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_comm_recipients cmr

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_comm_recipients cmr
37: -- , EDIT_HERE table_name(s) 333
38: where cmr.communication_recipient_id = p_communication_recipient_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 105: -- irc_comm_recipients and PER_BUSINESS_GROUPS_PERF

101: --
102: -- Declare cursor
103: --
104: -- EDIT_HERE In the following cursor statement add join(s) between
105: -- irc_comm_recipients 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_comm_recipients cmr

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_comm_recipients cmr
113: -- , EDIT_HERE table_name(s) 333
114: where cmr.communication_recipient_id = p_communication_recipient_id;
115: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
116: --

Line 276: (p_communication_object_type in irc_comm_recipients.communication_object_type%type ,

272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure chk_communication_object
276: (p_communication_object_type in irc_comm_recipients.communication_object_type%type ,
277: p_communication_object_id in irc_comm_recipients.communication_object_id%type
278: ) is
279: --
280: l_proc varchar2(72) := g_package||'chk_communication_object';

Line 277: p_communication_object_id in irc_comm_recipients.communication_object_id%type

273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure chk_communication_object
276: (p_communication_object_type in irc_comm_recipients.communication_object_type%type ,
277: p_communication_object_id in irc_comm_recipients.communication_object_id%type
278: ) is
279: --
280: l_proc varchar2(72) := g_package||'chk_communication_object';
281: l_comm_object_id irc_comm_topics.communication_topic_id%type;

Line 325: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_TYPE'

321: end if;
322: exception
323: when app_exception.application_exception then
324: if hr_multi_message.exception_add
325: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_TYPE'
326: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_ID'
327: ) then
328: --
329: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 326: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_ID'

322: exception
323: when app_exception.application_exception then
324: if hr_multi_message.exception_add
325: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_TYPE'
326: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_ID'
327: ) then
328: --
329: hr_utility.set_location(' Leaving:'||l_proc,50);
330: --

Line 354: (p_recipient_type in irc_comm_recipients.recipient_type%type ,

350: --
351: -- {End Of Comments}
352: -- ----------------------------------------------------------------------------
353: Procedure chk_recipient
354: (p_recipient_type in irc_comm_recipients.recipient_type%type ,
355: p_recipient_id in irc_comm_recipients.recipient_id%type ,
356: p_communication_object_type in irc_comm_recipients.communication_object_type%type,
357: p_communication_object_id in irc_comm_recipients.communication_object_id%type
358: ) is

Line 355: p_recipient_id in irc_comm_recipients.recipient_id%type ,

351: -- {End Of Comments}
352: -- ----------------------------------------------------------------------------
353: Procedure chk_recipient
354: (p_recipient_type in irc_comm_recipients.recipient_type%type ,
355: p_recipient_id in irc_comm_recipients.recipient_id%type ,
356: p_communication_object_type in irc_comm_recipients.communication_object_type%type,
357: p_communication_object_id in irc_comm_recipients.communication_object_id%type
358: ) is
359: --

Line 356: p_communication_object_type in irc_comm_recipients.communication_object_type%type,

352: -- ----------------------------------------------------------------------------
353: Procedure chk_recipient
354: (p_recipient_type in irc_comm_recipients.recipient_type%type ,
355: p_recipient_id in irc_comm_recipients.recipient_id%type ,
356: p_communication_object_type in irc_comm_recipients.communication_object_type%type,
357: p_communication_object_id in irc_comm_recipients.communication_object_id%type
358: ) is
359: --
360: l_proc varchar2(72) := g_package||'chk_recipient';

Line 357: p_communication_object_id in irc_comm_recipients.communication_object_id%type

353: Procedure chk_recipient
354: (p_recipient_type in irc_comm_recipients.recipient_type%type ,
355: p_recipient_id in irc_comm_recipients.recipient_id%type ,
356: p_communication_object_type in irc_comm_recipients.communication_object_type%type,
357: p_communication_object_id in irc_comm_recipients.communication_object_id%type
358: ) is
359: --
360: l_proc varchar2(72) := g_package||'chk_recipient';
361: l_recipient_id per_all_people_f.person_id%type;

Line 375: from irc_comm_recipients

371: where vendor_id = p_recipient_id;
372: --
373: cursor csr_recipient is
374: select communication_recipient_id
375: from irc_comm_recipients
376: where communication_object_type = p_communication_object_type
377: and communication_object_id = p_communication_object_id
378: and recipient_type = p_recipient_type
379: and recipient_id = p_recipient_id;

Line 449: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.RECIPIENT_TYPE'

445: --
446: exception
447: when app_exception.application_exception then
448: if hr_multi_message.exception_add
449: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.RECIPIENT_TYPE'
450: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.RECIPIENT_ID'
451: ) then
452: --
453: hr_utility.set_location(' Leaving:'||l_proc,90);

Line 450: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.RECIPIENT_ID'

446: exception
447: when app_exception.application_exception then
448: if hr_multi_message.exception_add
449: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.RECIPIENT_TYPE'
450: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.RECIPIENT_ID'
451: ) then
452: --
453: hr_utility.set_location(' Leaving:'||l_proc,90);
454: --

Line 478: (p_start_date_active in irc_comm_recipients.start_date_active%type

474: --
475: -- {End Of Comments}
476: -- ----------------------------------------------------------------------------
477: Procedure chk_active_dates
478: (p_start_date_active in irc_comm_recipients.start_date_active%type
479: ,p_end_date_active in irc_comm_recipients.end_date_active%type
480: ) is
481: --
482: l_proc varchar2(72) := g_package||'chk_active_dates';

Line 479: ,p_end_date_active in irc_comm_recipients.end_date_active%type

475: -- {End Of Comments}
476: -- ----------------------------------------------------------------------------
477: Procedure chk_active_dates
478: (p_start_date_active in irc_comm_recipients.start_date_active%type
479: ,p_end_date_active in irc_comm_recipients.end_date_active%type
480: ) is
481: --
482: l_proc varchar2(72) := g_package||'chk_active_dates';
483: --

Line 503: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.START_DATE_ACTIVE'

499: --
500: exception
501: when app_exception.application_exception then
502: if hr_multi_message.exception_add
503: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.START_DATE_ACTIVE'
504: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.END_DATE_ACTIVE'
505: ) then
506: --
507: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 504: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.END_DATE_ACTIVE'

500: exception
501: when app_exception.application_exception then
502: if hr_multi_message.exception_add
503: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.START_DATE_ACTIVE'
504: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.END_DATE_ACTIVE'
505: ) then
506: --
507: hr_utility.set_location(' Leaving:'||l_proc,20);
508: --

Line 520: (p_primary_flag in irc_comm_recipients.primary_flag%type

516: -- ----------------------------------------------------------------------------
517: -- |---------------------------< chk_primary_flag >---------------------------|
518: -- ----------------------------------------------------------------------------
519: Procedure chk_primary_flag
520: (p_primary_flag in irc_comm_recipients.primary_flag%type
521: ) is
522: --
523: l_proc varchar2(72) := g_package||'chk_primary_flag';
524: --

Line 542: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.PRIMARY_FLAG'

538: --
539: exception
540: when app_exception.application_exception then
541: if hr_multi_message.exception_add
542: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.PRIMARY_FLAG'
543: ) then
544: --
545: hr_utility.set_location(' Leaving:'||l_proc,30);
546: --