APPS.IRC_PARTY_PERSON_UTL dependencies on IRC_NOTIFICATION_PREFERENCES

Line 32: from irc_notification_preferences;

28: from hz_parties
29: where orig_system_reference='PER:IRC'
30: union
31: select party_id,person_id
32: from irc_notification_preferences;
33:
34: cursor get_party_id2 is
35: select party_id,party_id person_id
36: from hz_parties

Line 40: from irc_notification_preferences

36: from hz_parties
37: where orig_system_reference='PER:IRC'
38: union
39: select party_id,person_id
40: from irc_notification_preferences
41: union
42: select party_id,person_id
43: from per_addresses
44: where party_id is not null

Line 183: select 1 from irc_notification_preferences

179: where object_id=p_person_id
180: and object_type='WPREF';
181:
182: cursor get_notification_prefs(p_party_id number) is
183: select 1 from irc_notification_preferences
184: where party_id=p_party_id;
185:
186: l_dummy number;
187: l_start_date date;

Line 619: update irc_notification_preferences inp

615: open get_notification_prefs(l_party_ids(i));
616: fetch get_notification_prefs into l_dummy;
617: if get_notification_prefs%found then
618: close get_notification_prefs;
619: update irc_notification_preferences inp
620: set person_id=l_person_ids(i)
621: where party_id=l_party_ids(i)
622: and person_id is null;
623: else

Line 625: insert into irc_notification_preferences

621: where party_id=l_party_ids(i)
622: and person_id is null;
623: else
624: close get_notification_prefs;
625: insert into irc_notification_preferences
626: (notification_preference_id
627: ,party_id
628: ,person_id
629: ,matching_jobs