[Home] [Help]
29: where party_id = p_party_id;
30: --
31: cursor csr_update_notif_pref is
32: select object_version_number,notification_preference_id
33: from irc_notification_preferences
34: where party_id = p_party_id;
35: --
36: begin
37: --
66: ,p_orig_hire_warning => l_orig_hire_warning
67: );
68: end loop;
69: --
70: -- Update the irc_notification_preferences table to make the candidate
71: -- non-searchable
72: --
73: open csr_update_notif_pref;
74: fetch csr_update_notif_pref into l_notif_pref_ovn,l_notif_pref_id;
256: where party_id = p_party_id;
257: --
258: cursor csr_irc_notif is
259: select notification_preference_id, object_version_number
260: from irc_notification_preferences
261: where party_id = p_party_id;
262: --
263: cursor csr_jbi is
264: select job_basket_item_id, object_version_number
441: end loop;
442: --
443: if(p_process_type='DEL') then
444: --
445: -- Delete from IRC_NOTIFICATION_PREFERENCES
446: --
447: hr_utility.set_location(l_proc, 115);
448: for rec_irc_notif in csr_irc_notif loop
449: irc_notification_prefs_api.delete_notification_prefs
694: --
695: cursor csr_last_login_date is
696: select inp.person_id,
697: inp.party_id
698: from irc_notification_preferences inp
699: , fnd_user usr
700: where inp.person_id = usr.employee_id
701: and is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
702: and p_months < months_between(p_effective_date,usr.last_logon_date);
703: --
704: cursor csr_last_update_date is
705: select inp.person_id,
706: inp.party_id
707: from irc_notification_preferences inp
708: where is_free_to_purge(inp.party_id,p_effective_date)='TRUE'
709: and p_months < months_between(p_effective_date
710: ,inp.last_update_date)
711: and p_months < months_between(p_effective_date
713: --
714: cursor csr_last_application_date is
715: select inp.person_id,
716: inp.party_id
717: from irc_notification_preferences inp
718: where exists (select 1
719: from per_all_people_f per
720: , per_person_type_usages_f ptu,
721: per_person_types ppt