APPS.IRC_APL_TRACK_PURGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

		fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Snapshot');

Line: 28

		fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Snapshots deleted');

Line: 45

		fnd_file.put_line(fnd_file.log, 'call to delete Applicant Document Snapshot');

Line: 46

		fnd_file.put_line(fnd_file.log, 'List of Applicant Document Snapshots deleted');

Line: 63

		fnd_file.put_line(fnd_file.log, 'call to delete Saved Search Criteria');

Line: 64

		fnd_file.put_line(fnd_file.log, 'List of Saved Search Criteria deleted');

Line: 81

		fnd_file.put_line(fnd_file.log, 'call to delete Applicant Profile Access');

Line: 82

		fnd_file.put_line(fnd_file.log, 'List of Applicant Profile Access deleted');

Line: 107

  select aps.profile_snapshot_id, aps.person_id, aps.object_version_number
  from	 irc_apl_profile_snapshots  aps
  where	months_between(sysdate,aps.creation_date) > p_months;

Line: 112

  select doc.document_id, doc.type,
	 doc.person_id, doc.party_id, doc.end_date,
	 doc.object_version_number
  from	 irc_documents	doc
  where	doc.end_date	is not null
  and   months_between(sysdate,doc.end_date) > p_months;

Line: 120

  select iss.saved_search_criteria_id,
	 iss.vacancy_id, iss.object_version_number
  from	 irc_saved_search_criteria  iss
  where  months_between(sysdate,iss.creation_date) > p_months;

Line: 126

  select apa.apl_profile_access_id,
         apa.person_id,
	 apa.object_version_number
  from	 irc_apl_profile_access  apa
  where  months_between(sysdate,apa.creation_date) > p_months;

Line: 136

  hr_utility.set_location('Delete Applicant Profile Snapshot:'||l_proc, 20);

Line: 145

	irc_apl_prfl_snapshots_api.delete_applicant_snapshot
	( p_effective_date		=> l_effective_date
	 ,p_person_id			=> rec_apl_profile_snapshot.person_id
	 ,p_profile_snapshot_id		=> rec_apl_profile_snapshot.profile_snapshot_id
	 ,p_object_version_number	=> rec_apl_profile_snapshot.object_version_number
	);

Line: 152

	hr_utility.set_location('Print Delete Snapshot:'||l_proc,25);

Line: 161

  hr_utility.set_location('Delete Applicant Document Snapshot:'||l_proc, 30);

Line: 168

	irc_document_api.delete_document
	( p_effective_date		=> l_effective_date
	 ,p_document_id			=> rec_apl_doc_snapshot.document_id
	 ,p_object_version_number	=> rec_apl_doc_snapshot.object_version_number
	 ,p_person_id			=> rec_apl_doc_snapshot.person_id
	 ,p_party_id			=> rec_apl_doc_snapshot.party_id
	 ,p_end_date			=> rec_apl_doc_snapshot.end_date
	 ,p_type			=> rec_apl_doc_snapshot.type
	 ,p_purge			=> l_doc_purge
	);

Line: 179

	hr_utility.set_location('Print Delete Document:'||l_proc,35);

Line: 187

  hr_utility.set_location('Delete Saved Search Criteria:'||l_proc, 40);

Line: 194

	irc_saved_search_criteria_api.delete_search_criteria
	( p_vacancy_id			=> rec_saved_search_criteria.vacancy_id
	 ,p_saved_search_criteria_id	=> rec_saved_search_criteria.saved_search_criteria_id
	 ,p_object_version_number	=> rec_saved_search_criteria.object_version_number
	 );

Line: 200

	hr_utility.set_location('Print Delete Search Criteria:'||l_proc,45);

Line: 208

  hr_utility.set_location('Delete Applicant Profile Access:'||l_proc, 50);

Line: 215

	irc_apl_profile_access_api.delete_apl_profile_access
	( p_person_id		   => rec_apl_profile_access.person_id
	 ,p_apl_profile_access_id  => rec_apl_profile_access.apl_profile_access_id
         ,p_object_version_number  => rec_apl_profile_access.object_version_number
	);

Line: 221

	hr_utility.set_location('Print Delete PROFILE ACCESS:'||l_proc,55);