postgresql7.1
select recruiting_status_type__disable(:status_type_id);
select recruiting_status_type__enable(:status_type_id);
select package_id,
short_desc,
long_desc,
enabled_p
from recruiting_status_types
where status_type_id = :status_type_id;
update recruiting_status_types
set short_desc = :short_desc,
long_desc = :long_desc,
enabled_p = :enabled_p,
package_id = :package_id
where status_type_id = :status_type_id
select recruiting_criteria__disable(:criteria_id);
select recruiting_criteria__enable(:criteria_id);
select package_id,
criteria_name,
description,
enabled_p
from recruiting_criteria
where criteria_id = :criteria_id;
update recruiting_criteria
set package_id = :package_id,
criteria_name = :criteria_name,
description = :description
where criteria_id = :criteria_id
delete from recruiting_ratings rr
where rr.interview_id = recruiting_interviews.interview_id
and recruiting_interviews.candidate_id = :candidate_id;
delete from recruiting_interviews
where candidate_id = :candidate_id;
delete from recruiting_candidates
where candidate_id = :candidate_id;
select package_id,
first_name,
last_name,
address1,
address2,
city,
state,
zip,
zip_plus_four,
city,
state,
country,
email,
status
from recruiting_candidates
where candidate_id = :candidate_id;
update recruiting_candidates
set first_name = :first_name,
last_name = :last_name,
address1 = :address1,
address2 = :address2,
city = :city,
state = :state,
zip = :zip,
zip_plus_four = :zip_plus_four,
country = :country,
email = :email,
status = :status
where candidate_id = :candidate_id
delete from recruiting_ratings
where interview_id = :interview_id;
delete from recruiting_interviews
where interview_id = :interview_id;
select package_id,
interviewer_id,
candidate_id,
should_hire_p
from recruiting_interviews
where interview_id = :interview_id;
delete from recruiting_ratings
where rating_id = :rating_id;
select package_id,
interview_id,
criteria_id,
rating
from recruiting_ratings
where rating_id = :rating_id;