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_CMP_BUS dependencies on IRC_COMM_PROPERTIES

Line 28: -- irc_comm_properties 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_properties 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_properties cmp

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_properties cmp
37: -- , EDIT_HERE table_name(s) 333
38: where cmp.communication_property_id = p_communication_property_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 105: -- irc_comm_properties 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_properties 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_properties cmp

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_properties cmp
113: -- , EDIT_HERE table_name(s) 333
114: where cmp.communication_property_id = p_communication_property_id;
115: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
116: --

Line 454: -- communication_property_id number(15) PK of irc_comm_properties

450: -- None.
451: --
452: -- In Parameters:
453: -- status varchar2(50) default communication status
454: -- communication_property_id number(15) PK of irc_comm_properties
455: -- effective_date date date record effective
456: -- object_version_number number(9) version of row
457: --
458: -- Post Success:

Line 518: -- communication_property_id number(15) PK of irc_comm_properties

514: -- None.
515: --
516: -- In Parameters:
517: -- flag varchar2(50) allow attachement flag
518: -- communication_property_id number(15) PK of irc_comm_properties
519: -- effective_date date date record effective
520: -- object_version_number number(9) version of row
521: --
522: -- Post Success:

Line 582: -- communication_property_id number(15) PK of irc_comm_properties

578: -- None.
579: --
580: -- In Parameters:
581: -- allow_add_recipients varchar2(50) allow add recipients
582: -- communication_property_id number(15) PK of irc_comm_properties
583: -- effective_date date date record effective
584: -- object_version_number number(9) version of row
585: --
586: -- Post Success:

Line 646: -- communication_property_id number(15) PK of irc_comm_properties

642: -- None.
643: --
644: -- In Parameters:
645: -- auto_notification_flag varchar2(1) auto_notification_flag
646: -- communication_property_id number(15) PK of irc_comm_properties
647: -- effective_date date date record effective
648: -- object_version_number number(9) version of row
649: --
650: -- Post Success:

Line 710: -- communication_property_id number(15) PK of irc_comm_properties

706: -- None.
707: --
708: -- In Parameters:
709: -- default_moderator varchar2(50) default_moderator
710: -- communication_property_id number(15) PK of irc_comm_properties
711: -- effective_date date date record effective
712: -- object_version_number number(9) version of row
713: --
714: -- Post Success:

Line 786: (p_object_id in irc_comm_properties.object_id%TYPE,

782: --
783: -- {End Of Comments}
784: -- ----------------------------------------------------------------------------
785: Procedure chk_object_id
786: (p_object_id in irc_comm_properties.object_id%TYPE,
787: p_object_type in irc_comm_properties.object_type%TYPE
788: ) IS
789: --
790: l_proc varchar2(72) := g_package || 'chk_object_id';

Line 787: p_object_type in irc_comm_properties.object_type%TYPE

783: -- {End Of Comments}
784: -- ----------------------------------------------------------------------------
785: Procedure chk_object_id
786: (p_object_id in irc_comm_properties.object_id%TYPE,
787: p_object_type in irc_comm_properties.object_type%TYPE
788: ) IS
789: --
790: l_proc varchar2(72) := g_package || 'chk_object_id';
791: l_object_id varchar2(1);

Line 801: from irc_comm_properties icp

797: where pav.vacancy_id = p_object_id ;
798: --
799: cursor csr_object_type is
800: select null
801: from irc_comm_properties icp
802: where icp.object_id = p_object_id
803: and icp.object_type = p_object_type;
804: --
805: begin

Line 841: 'IRC_COMM_PROPERTIES.OBJECT_ID'

837: exception
838: when app_exception.application_exception then
839: if hr_multi_message.exception_add
840: (p_associated_column1 =>
841: 'IRC_COMM_PROPERTIES.OBJECT_ID'
842: ) then
843: hr_utility.set_location(' Leaving:'||l_proc,60);
844: raise;
845: end if;

Line 874: (p_object_type in irc_comm_properties.object_type%TYPE

870: --
871: -- {End Of Comments}
872: -- ----------------------------------------------------------------------------
873: Procedure chk_object_type
874: (p_object_type in irc_comm_properties.object_type%TYPE
875: ) IS
876: --
877: l_proc varchar2(72) := g_package || 'chk_object_type';
878: --

Line 897: 'IRC_COMM_PROPERTIES.OBJECT_TYPE'

893: exception
894: when app_exception.application_exception then
895: if hr_multi_message.exception_add
896: (p_associated_column1 =>
897: 'IRC_COMM_PROPERTIES.OBJECT_TYPE'
898: ) then
899: hr_utility.set_location(' Leaving:'||l_proc,30);
900: raise;
901: end if;