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

Line 291: l_party_id irc_notification_preferences.party_id%type;

287: ,p_effective_date date
288: ) IS
289: --
290: l_proc varchar2(72) := g_package || 'chk_person_id';
291: l_party_id irc_notification_preferences.party_id%type;
292: l_var varchar2(30);
293: --
294: --
295: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.

Line 303: -- if the ALLOW_ACCESS = 'Y' in irc_notification_preferences

299: from per_all_people_f
300: where person_id = p_person_id;
301: --
302: -- Cursor to check that the Person can be contacted ie., to check
303: -- if the ALLOW_ACCESS = 'Y' in irc_notification_preferences
304: --
305: cursor csr_not_pref is
306: select null
307: from IRC_NOTIFICATION_PREFERENCES

Line 307: from IRC_NOTIFICATION_PREFERENCES

303: -- if the ALLOW_ACCESS = 'Y' in irc_notification_preferences
304: --
305: cursor csr_not_pref is
306: select null
307: from IRC_NOTIFICATION_PREFERENCES
308: where person_id = p_person_id
309: and allow_access = 'Y';
310: Begin
311: --