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_CREATE_NOTIFICATION_PKG dependencies on IRC_NOTIFICATION_PREFERENCES

Line 69: FROM irc_notification_preferences inp

65: where ppf.party_id = ppf1.party_id
66: and trunc(sysdate) between ppf.effective_start_date
67: and ppf.effective_end_date
68: AND NOT EXISTS ( SELECT /*+ no_unnest */ 1
69: FROM irc_notification_preferences inp
70: ,per_all_people_f ppf2
71: WHERE ppf.party_id = ppf2.party_id
72: AND ppf2.person_id = inp.person_id
73: AND trunc(sysdate) between ppf2.effective_start_date

Line 130: insert into irc_notification_preferences

126: if(l_rows_processed > 0)
127: then
128: forall i in l_person_ids.first..l_person_ids.last
129: --
130: insert into irc_notification_preferences
131: ( NOTIFICATION_PREFERENCE_ID
132: ,PERSON_ID
133: ,PARTY_ID
134: ,MATCHING_JOBS