[Home] [Help]
31: where party_id = p_party_id;
32: --
33: cursor csr_update_notif_pref is
34: select object_version_number,notification_preference_id
35: from irc_notification_preferences
36: where party_id = p_party_id;
37: --
38: begin
39: --
71: );
72: end if;
73: end loop;
74: --
75: -- Update the irc_notification_preferences table to make the candidate
76: -- non-searchable
77: --
78: open csr_update_notif_pref;
79: fetch csr_update_notif_pref into l_notif_pref_ovn,l_notif_pref_id;
259: where party_id = p_party_id;
260: --
261: cursor csr_irc_notif is
262: select notification_preference_id, object_version_number
263: from irc_notification_preferences
264: where party_id = p_party_id;
265: --
266: cursor csr_jbi is
267: select job_basket_item_id, object_version_number
568: end loop;
569: --
570: if(p_process_type='DEL') then
571: --
572: -- Delete from IRC_NOTIFICATION_PREFERENCES
573: --
574: hr_utility.set_location(l_proc, 115);
575: for rec_irc_notif in csr_irc_notif loop
576: irc_notification_prefs_api.delete_notification_prefs
821: --
822: cursor csr_last_login_date is
823: select inp.person_id,
824: inp.party_id
825: from irc_notification_preferences inp
826: , fnd_user usr
827: where inp.person_id = usr.employee_id
828: and is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
829: and p_months < months_between(p_effective_date,usr.last_logon_date);
830: --
831: cursor csr_last_update_date is
832: select inp.person_id,
833: inp.party_id
834: from irc_notification_preferences inp
835: where is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
836: and p_months < months_between(p_effective_date
837: ,inp.last_update_date)
838: and p_months < months_between(p_effective_date
840: --
841: cursor csr_last_application_date is
842: select inp.person_id,
843: inp.party_id
844: from irc_notification_preferences inp
845: where exists (select 1
846: from per_all_people_f per
847: , per_person_type_usages_f ptu,
848: per_person_types ppt