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

Line 257: from IRC_COMM_MESSAGES icm

253: || ';IRC_COMM_MSG_SUBJECT:'
254: || icm.MESSAGE_SUBJECT
255: || ';IRC_COMM_MSG_BODY:'
256: || substr(icm.MESSAGE_BODY,1,1000)
257: from IRC_COMM_MESSAGES icm
258: ,IRC_COMM_TOPICS ict
259: where ict.COMMUNICATION_TOPIC_ID = c_topicId
260: and icm.COMMUNICATION_TOPIC_ID = c_topicId
261: and icm.COMMUNICATION_MESSAGE_ID = c_messageId;

Line 266: from IRC_COMM_MESSAGES icm

262:
263: cursor csrMessageBodyContent (c_topicId in number
264: ,c_messageId in number) is
265: select length(icm.MESSAGE_BODY)
266: from IRC_COMM_MESSAGES icm
267: where icm.COMMUNICATION_TOPIC_ID = c_topicId
268: and icm.COMMUNICATION_MESSAGE_ID = c_messageId;
269:
270: l_messageBodyContent number;