The following lines contain the word 'select', 'insert', 'update' or 'delete':
select inf.org_information14
from hr_organization_information inf
, per_appraisals apr
where apr.appraisal_id = p_appraisal_id
and inf.organization_id = apr.business_group_id
and inf.org_information_context || '' = 'Business Group Information';
Procedure chk_non_updateable_args(p_rec in per_apr_shd.g_rec_type) is
l_proc varchar2(72) := g_package||'chk_non_updateable_args';
end chk_non_updateable_args;
procedure chk_update_allowed
(p_rec in per_apr_shd.g_rec_type
)
is
l_proc varchar2(72) := g_package || 'chk_update_allowed';
select ppt.system_person_type
from per_person_types ppt
, per_person_type_usages_f ptu
, per_all_people_f per
where per.person_id = p_rec.appraisee_person_id
and p_rec.appraisal_date BETWEEN per.effective_start_date AND per.effective_end_date
AND ptu.person_id = per.person_id
and p_rec.appraisal_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date
and ptu.person_type_id = ppt.person_type_id;
end chk_update_allowed;
select null
from hr_quest_answers qsa
where p_appraisal_id = qsa.type_object_id
and qsa.type = 'APPRAISAL';
select business_group_id
from per_appraisal_templates
where appraisal_template_id = p_appraisal_template_id;
select 'Y'
from per_appraisal_templates
where appraisal_template_id = p_appraisal_template_id
and p_effective_date between
nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);
select business_group_id
from per_all_people_f
where person_id = p_person_id;
select business_group_id
from per_all_people_f
where person_id = p_person_id;
select 'Y'
from per_all_people_f
where person_id = p_person_id
and p_effective_date between
effective_start_date and nvl(effective_end_date,hr_api.g_eot);
select 'Y'
from per_all_people_f
where person_id = p_person_id
and p_effective_date between
effective_start_date and nvl(effective_end_date,hr_api.g_eot);
select 'Y'
from per_all_people_f
where person_id = p_main_appraiser_id
and business_group_id = p_business_group_id
and p_effective_date between
effective_start_date and nvl(effective_end_date,hr_api.g_eot);
select 'Y'
from per_all_people_f
where person_id = p_main_appraiser_id
and p_effective_date between
effective_start_date and nvl(effective_end_date,hr_api.g_eot);
select distinct(min(effective_start_date)), business_group_id
from per_all_people_f per
where per.person_id = p_group_initiator_id
group by business_group_id;
select pt.system_person_type
from
per_all_people_f per
,per_person_type_usages_f ptu
,per_person_types pt
where per.person_id = p_person_id
and p_date BETWEEN per.effective_start_date and per.effective_end_date
AND per.person_id = ptu.person_id
AND p_date between ptu.effective_start_date AND ptu.effective_End_date
AND ptu.person_type_id = pt.person_type_id
AND pt.system_person_type IN ('EMP','CWK','EMP_APL','CWK_APL');
select business_group_id,rating_scale_id
from per_rating_levels
where rating_level_id = p_overall_performance_level_id;
select 'Y'
from per_appraisal_templates
where rating_scale_id = l_rating_scale_id
and appraisal_template_id = p_appraisal_template_id;
procedure chk_appraisal_delete
(p_appraisal_id in per_appraisals.appraisal_id%TYPE
,p_object_version_number in per_appraisals.object_version_number%TYPE
,p_overall_performance_level_id in per_appraisals.overall_performance_level_id%TYPE
)
is
l_exists varchar2(1);
l_proc varchar2(72) := g_package||'chk_appraisal_delete';
select 'Y'
from dual
where exists (select null
from per_assign_proposal_answers
where answer_for_key = p_appraisal_id);
select 'Y'
from per_objectives
where appraisal_id = p_appraisal_id;
select 'Y'
from per_assessments
where appraisal_id = p_appraisal_id;
select 'Y'
from per_performance_ratings
where appraisal_id = p_appraisal_id;
select 'Y'
from per_participants par
where par.participation_in_id = p_appraisal_id
and par.participation_in_table = 'PER_APPRAISALS'
and par.participation_in_column = 'APPRAISAL_ID';
select 'Y'
from hr_quest_answers qsa
where qsa.type_object_id = p_appraisal_id
and qsa.type = 'APPRAISAL';
end chk_appraisal_delete;
SELECT pmp.plan_id
FROM per_perf_mgmt_plans pmp
WHERE pmp.plan_id = p_plan_id;
Procedure insert_validate(p_rec in per_apr_shd.g_rec_type
,p_effective_date in date)
is
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in per_apr_shd.g_rec_type
,p_effective_date in date) is
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args(p_rec => p_rec);
per_apr_bus.chk_update_allowed
(p_rec => p_rec);
if (p_rec.appraisal_system_status <> 'DELETED') then
per_apr_bus.chk_appraisal_dates
(p_appraisal_date => p_rec.appraisal_date
,p_appraisal_period_start_date => p_rec.appraisal_period_start_date
,p_appraisal_period_end_date => p_rec.appraisal_period_end_date
,p_next_appraisal_date => p_rec.next_appraisal_date
,p_appraisee_person_id => p_rec.appraisee_person_id
,p_appraiser_person_id => p_rec.appraiser_person_id
,p_main_appraiser_id => p_rec.main_appraiser_id
);
End update_validate;
Procedure delete_validate(p_rec in per_apr_shd.g_rec_type) is
l_proc varchar2(72) := g_package||'delete_validate';
per_apr_bus.chk_appraisal_delete
(p_appraisal_id => p_rec.appraisal_id
,p_object_version_number => p_rec.object_version_number
,p_overall_performance_level_id => p_rec.overall_performance_level_id
) ;
End delete_validate;
select legislation_code
from per_business_groups pbg,
per_appraisals pap
where pap.appraisal_id = p_appraisal_id
and pbg.business_group_id = pap.business_group_id;