APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_SEARCH_CRITERIA

Line 299: from irc_search_criteria

295: order by primary_flag, date_from desc;
296: --
297: cursor csr_isc_work is
298: select search_criteria_id, object_version_number
299: from irc_search_criteria
300: where object_id = p_root_person_id
301: and object_type = 'WPREF';
302: --
303: cursor csr_isc_person is

Line 305: from irc_search_criteria

301: and object_type = 'WPREF';
302: --
303: cursor csr_isc_person is
304: select search_criteria_id, object_version_number
305: from irc_search_criteria
306: where object_id = p_root_person_id
307: and object_type = 'PERSON';
308: --
309: cursor csr_phn_party is

Line 491: irc_search_criteria_api.delete_work_choices

487: -- Delete the work preferences
488: --
489: hr_utility.set_location(l_proc, 90);
490: for rec_isc_work in csr_isc_work loop
491: irc_search_criteria_api.delete_work_choices
492: (p_search_criteria_id => rec_isc_work.search_criteria_id
493: ,p_object_version_number => rec_isc_work.object_version_number
494: );
495: end loop;

Line 501: irc_search_criteria_api.delete_saved_search

497: -- Delete the Job Saved Searches
498: --
499: hr_utility.set_location(l_proc, 100);
500: for rec_isc_party in csr_isc_person loop
501: irc_search_criteria_api.delete_saved_search
502: (p_search_criteria_id => rec_isc_party.search_criteria_id
503: ,p_object_version_number => rec_isc_party.object_version_number
504: );
505: end loop;

Line 712: irc_search_criteria iscp,

708: )
709: from per_addresses addr,
710: per_phones phn,
711: irc_documents ido,
712: irc_search_criteria iscp,
713: irc_search_criteria iscw,
714: per_previous_employers pem,
715: per_establishment_attendances esa,
716: per_qualifications qua,

Line 713: irc_search_criteria iscw,

709: from per_addresses addr,
710: per_phones phn,
711: irc_documents ido,
712: irc_search_criteria iscp,
713: irc_search_criteria iscw,
714: per_previous_employers pem,
715: per_establishment_attendances esa,
716: per_qualifications qua,
717: per_competence_elements pce,