APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_SEARCH_CRITERIA

Line 296: from irc_search_criteria

292: order by primary_flag;
293: --
294: cursor csr_isc_work is
295: select search_criteria_id, object_version_number
296: from irc_search_criteria
297: where object_id = p_root_person_id
298: and object_type = 'WPREF';
299: --
300: cursor csr_isc_person is

Line 302: from irc_search_criteria

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

Line 407: irc_search_criteria_api.delete_work_choices

403: -- Delete the work preferences
404: --
405: hr_utility.set_location(l_proc, 90);
406: for rec_isc_work in csr_isc_work loop
407: irc_search_criteria_api.delete_work_choices
408: (p_search_criteria_id => rec_isc_work.search_criteria_id
409: ,p_object_version_number => rec_isc_work.object_version_number
410: );
411: end loop;

Line 417: irc_search_criteria_api.delete_saved_search

413: -- Delete the Job Saved Searches
414: --
415: hr_utility.set_location(l_proc, 100);
416: for rec_isc_party in csr_isc_person loop
417: irc_search_criteria_api.delete_saved_search
418: (p_search_criteria_id => rec_isc_party.search_criteria_id
419: ,p_object_version_number => rec_isc_party.object_version_number
420: );
421: end loop;

Line 585: irc_search_criteria iscp,

581: )
582: from per_addresses addr,
583: per_phones phn,
584: irc_documents ido,
585: irc_search_criteria iscp,
586: irc_search_criteria iscw,
587: per_previous_employers pem,
588: per_establishment_attendances esa,
589: per_qualifications qua,

Line 586: irc_search_criteria iscw,

582: from per_addresses addr,
583: per_phones phn,
584: irc_documents ido,
585: irc_search_criteria iscp,
586: irc_search_criteria iscw,
587: per_previous_employers pem,
588: per_establishment_attendances esa,
589: per_qualifications qua,
590: per_competence_elements pce,