The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_applicant_snapshot
(p_validate in number default hr_api.g_false_num
,p_effective_date in date
,p_person_id in number
,p_profile_snapshot_id in out nocopy number
,p_object_version_number in out nocopy number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_applicant_snapshot';
savepoint update_applicant_snapshot_swi;
irc_apl_prfl_snapshots_api.update_applicant_snapshot
(p_validate => l_validate
,p_effective_date => p_effective_date
,p_person_id => p_person_id
,p_profile_snapshot_id => p_profile_snapshot_id
,p_object_version_number => p_object_version_number
);
rollback to update_applicant_snapshot_swi;
rollback to update_applicant_snapshot_swi;
end update_applicant_snapshot;
PROCEDURE delete_applicant_snapshot
(p_validate in number default hr_api.g_false_num
,p_effective_date in date
,p_person_id in number
,p_profile_snapshot_id in number
,p_object_version_number in number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_applicant_snapshot';
savepoint delete_applicant_snapshot_swi;
irc_apl_prfl_snapshots_api.delete_applicant_snapshot
(p_validate => l_validate
,p_effective_date => p_effective_date
,p_person_id => p_person_id
,p_profile_snapshot_id => p_profile_snapshot_id
,p_object_version_number => p_object_version_number
);
rollback to delete_applicant_snapshot_swi;
rollback to delete_applicant_snapshot_swi;
end delete_applicant_snapshot;
PROCEDURE update_search_criteria
(p_validate in number default hr_api.g_false_num
,p_vacancy_id in number
,p_saved_search_criteria_id in out nocopy number
,p_object_version_number in out nocopy number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_search_criteria';
savepoint update_search_criteria_swi;
irc_saved_search_criteria_api.update_search_criteria
(p_validate => l_validate
,p_vacancy_id => p_vacancy_id
,p_saved_search_criteria_id => p_saved_search_criteria_id
,p_object_version_number => p_object_version_number
);
rollback to update_search_criteria_swi;
rollback to update_search_criteria_swi;
end update_search_criteria;
PROCEDURE delete_search_criteria
(p_validate in number default hr_api.g_false_num
,p_vacancy_id in number
,p_saved_search_criteria_id in number
,p_object_version_number in number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_search_criteria';
savepoint delete_search_criteria_swi;
irc_saved_search_criteria_api.delete_search_criteria
(p_validate => l_validate
,p_vacancy_id => p_vacancy_id
,p_saved_search_criteria_id => p_saved_search_criteria_id
,p_object_version_number => p_object_version_number
);
rollback to delete_search_criteria_swi;
rollback to delete_search_criteria_swi;
end delete_search_criteria;
PROCEDURE update_apl_profile_access
(p_validate in number default hr_api.g_false_num
,p_person_id in number
,p_apl_profile_access_id in out nocopy number
,p_object_version_number in out nocopy number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_apl_profile_access';
savepoint update_apl_profile_access_swi;
irc_apl_profile_access_api.update_apl_profile_access
(p_validate => l_validate
,p_person_id => p_person_id
,p_apl_profile_access_id => p_apl_profile_access_id
,p_object_version_number => p_object_version_number
);
rollback to update_apl_profile_access_swi;
rollback to update_apl_profile_access_swi;
end update_apl_profile_access;
PROCEDURE delete_apl_profile_access
(p_validate in number default hr_api.g_false_num
,p_person_id in number
,p_apl_profile_access_id in number
,p_object_version_number in number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_apl_profile_access';
savepoint delete_apl_profile_access_swi;
irc_apl_profile_access_api.delete_apl_profile_access
(p_validate => l_validate
,p_person_id => p_person_id
,p_apl_profile_access_id => p_apl_profile_access_id
,p_object_version_number => p_object_version_number
);
rollback to delete_apl_profile_access_swi;
rollback to delete_apl_profile_access_swi;
end delete_apl_profile_access;