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
where 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_all
where candidate_id = :candidate_id
update recruiting_candidates_all
set archived_p = 't'
where candidate_id = :candidate_id
update recruiting_candidates_all
set archived_p = 'f'
where candidate_id = :candidate_id
select package_id,
first_name,
last_name,
address1,
address2,
city,
state,
zip,
zip_plus_four,
city,
state,
country,
home_phone,
cell_phone,
email,
status
from recruiting_candidates
where candidate_id = :candidate_id
update recruiting_candidates_all
set address1 = :address1,
address2 = :address2,
city = :city,
state = :state,
zip = :zip,
zip_plus_four = :zip_plus_four,
country = :country,
home_phone = :home_phone,
cell_phone = :cell_phone,
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,
comment
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;