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_CMM_BUS dependencies on IRC_COMM_MESSAGES

Line 28: -- irc_comm_messages 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_messages 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_messages cmm

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_messages cmm
37: -- , EDIT_HERE table_name(s) 333
38: where cmm.communication_message_id = p_communication_message_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 105: -- irc_comm_messages 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_messages 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_messages cmm

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_messages cmm
113: -- , EDIT_HERE table_name(s) 333
114: where cmm.communication_message_id = p_communication_message_id;
115: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
116: --

Line 287: l_topic_id irc_comm_messages.communication_topic_id%type;

283: ) is
284: --
285: l_proc varchar2(72) := g_package||'chk_comm_topic_id';
286: --
287: l_topic_id irc_comm_messages.communication_topic_id%type;
288: --
289: l_api_updating boolean;
290: --
291: cursor csr_topic_id is

Line 327: (p_associated_column1 => 'IRC_COMM_MESSAGES.COMMUNICATION_TOPIC_ID'

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

Line 355: (p_message_subject in irc_comm_messages.message_subject%type

351: --
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure chk_message_subject
355: (p_message_subject in irc_comm_messages.message_subject%type
356: ) is
357: --
358: l_proc varchar2(72) := g_package||'chk_message_subject';
359: --

Line 383: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_SUBJECT'

379: --
380: exception
381: when app_exception.application_exception then
382: if hr_multi_message.exception_add
383: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_SUBJECT'
384: ) then
385: --
386: hr_utility.set_location(' Leaving:'||l_proc,30);
387: --

Line 411: (p_message_body in irc_comm_messages.message_body%type

407: --
408: -- {End Of Comments}
409: -- ----------------------------------------------------------------------------
410: Procedure chk_message_body
411: (p_message_body in irc_comm_messages.message_body%type
412: ) is
413: --
414: l_proc varchar2(72) := g_package||'chk_message_body';
415: --

Line 436: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_BODY'

432: --
433: exception
434: when app_exception.application_exception then
435: if hr_multi_message.exception_add
436: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_BODY'
437: ) then
438: --
439: hr_utility.set_location(' Leaving:'||l_proc,30);
440: --

Line 464: (p_message_post_date in irc_comm_messages.message_post_date%type

460: --
461: -- {End Of Comments}
462: -- ----------------------------------------------------------------------------
463: Procedure chk_message_post_date
464: (p_message_post_date in irc_comm_messages.message_post_date%type
465: ) is
466: --
467: l_proc varchar2(72) := g_package||'chk_message_post_date';
468: --

Line 483: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_POST_DATE'

479: --
480: exception
481: when app_exception.application_exception then
482: if hr_multi_message.exception_add
483: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_POST_DATE'
484: ) then
485: --
486: hr_utility.set_location(' Leaving:'||l_proc,20);
487: --

Line 511: (p_sender_type in irc_comm_messages.sender_type%type ,

507: --
508: -- {End Of Comments}
509: -- ----------------------------------------------------------------------------
510: Procedure chk_sender
511: (p_sender_type in irc_comm_messages.sender_type%type ,
512: p_sender_id in irc_comm_messages.sender_id%type
513: ) is
514: --
515: l_proc varchar2(72) := g_package||'chk_sender';

Line 512: p_sender_id in irc_comm_messages.sender_id%type

508: -- {End Of Comments}
509: -- ----------------------------------------------------------------------------
510: Procedure chk_sender
511: (p_sender_type in irc_comm_messages.sender_type%type ,
512: p_sender_id in irc_comm_messages.sender_id%type
513: ) is
514: --
515: l_proc varchar2(72) := g_package||'chk_sender';
516: l_sender_id per_all_people_f.person_id%type;

Line 582: (p_associated_column1 => 'IRC_COMM_MESSAGES.SENDER_TYPE'

578:
579: exception
580: when app_exception.application_exception then
581: if hr_multi_message.exception_add
582: (p_associated_column1 => 'IRC_COMM_MESSAGES.SENDER_TYPE'
583: ,p_associated_column2 => 'IRC_COMM_MESSAGES.SENDER_ID'
584: ) then
585: --
586: hr_utility.set_location(' Leaving:'||l_proc,70);

Line 583: ,p_associated_column2 => 'IRC_COMM_MESSAGES.SENDER_ID'

579: exception
580: when app_exception.application_exception then
581: if hr_multi_message.exception_add
582: (p_associated_column1 => 'IRC_COMM_MESSAGES.SENDER_TYPE'
583: ,p_associated_column2 => 'IRC_COMM_MESSAGES.SENDER_ID'
584: ) then
585: --
586: hr_utility.set_location(' Leaving:'||l_proc,70);
587: --

Line 611: (p_document_type in irc_comm_messages.document_type%type ,

607: --
608: -- {End Of Comments}
609: -- ----------------------------------------------------------------------------
610: Procedure chk_document
611: (p_document_type in irc_comm_messages.document_type%type ,
612: p_document_id in irc_comm_messages.document_id%type
613: ) is
614: --
615: l_proc varchar2(72) := g_package||'chk_document';

Line 612: p_document_id in irc_comm_messages.document_id%type

608: -- {End Of Comments}
609: -- ----------------------------------------------------------------------------
610: Procedure chk_document
611: (p_document_type in irc_comm_messages.document_type%type ,
612: p_document_id in irc_comm_messages.document_id%type
613: ) is
614: --
615: l_proc varchar2(72) := g_package||'chk_document';
616: l_document_id irc_documents.document_id%type;

Line 654: (p_associated_column1 => 'IRC_COMM_MESSAGES.DOCUMENT_TYPE'

650: end if;
651: exception
652: when app_exception.application_exception then
653: if hr_multi_message.exception_add
654: (p_associated_column1 => 'IRC_COMM_MESSAGES.DOCUMENT_TYPE'
655: ,p_associated_column2 => 'IRC_COMM_MESSAGES.DOCUMENT_ID'
656: ) then
657: --
658: hr_utility.set_location(' Leaving:'||l_proc,40);

Line 655: ,p_associated_column2 => 'IRC_COMM_MESSAGES.DOCUMENT_ID'

651: exception
652: when app_exception.application_exception then
653: if hr_multi_message.exception_add
654: (p_associated_column1 => 'IRC_COMM_MESSAGES.DOCUMENT_TYPE'
655: ,p_associated_column2 => 'IRC_COMM_MESSAGES.DOCUMENT_ID'
656: ) then
657: --
658: hr_utility.set_location(' Leaving:'||l_proc,40);
659: --

Line 671: (p_deleted_flag in irc_comm_messages.deleted_flag%type

667: -- ----------------------------------------------------------------------------
668: -- |---------------------------< chk_deleted_flag >---------------------------|
669: -- ----------------------------------------------------------------------------
670: Procedure chk_deleted_flag
671: (p_deleted_flag in irc_comm_messages.deleted_flag%type
672: ) is
673: --
674: l_proc varchar2(72) := g_package||'chk_deleted_flag';
675: --

Line 693: (p_associated_column1 => 'IRC_COMM_MESSAGES.DELETED_FLAG'

689: --
690: exception
691: when app_exception.application_exception then
692: if hr_multi_message.exception_add
693: (p_associated_column1 => 'IRC_COMM_MESSAGES.DELETED_FLAG'
694: ) then
695: --
696: hr_utility.set_location(' Leaving:'||l_proc,20);
697: --