[Home] [Help]
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';
SELECT 'Y'
FROM DUAL
WHERE EXISTS (
SELECT NULL
FROM per_periods_of_service ppser
WHERE person_id = p_appraisee_person_id
AND ppser.date_start = (SELECT MAX (date_start)
FROM per_periods_of_service
WHERE person_id = ppser.person_id)
AND NVL (ppser.actual_termination_date, TRUNC (SYSDATE)) > TRUNC (SYSDATE)
UNION
SELECT NULL
FROM per_periods_of_placement ppser
WHERE person_id = p_appraisee_person_id
AND ppser.date_start = (SELECT MAX (date_start)
FROM per_periods_of_placement
WHERE person_id = ppser.person_id)
AND NVL (ppser.actual_termination_date, TRUNC (SYSDATE)) > TRUNC (SYSDATE));
SELECT show_future_term_employee
FROM per_appraisal_templates
WHERE appraisal_template_id = p_appraisal_template_id;
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 TRUNC(SYSDATE) BETWEEN per.effective_start_date AND per.effective_end_date
AND ptu.person_id = per.person_id
and TRUNC(SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
and ptu.person_type_id = ppt.person_type_id
and ppt.system_person_type IN ('EMP','CWK','EMP_APL','CWK_APL','EX_EMP','EX_CWK','EX_EMP_APL');
cursor csr_allow_term_update is
SELECT NVL(SHOW_TERM_CONTIGENT,'N') term_cwk,NVL(SHOW_TERM_EMPLOYEE,'N') term_emp
FROM per_appraisal_templates
WHERE appraisal_template_id = p_rec.appraisal_template_id;
OPEN csr_allow_term_update;
FETCH csr_allow_term_update INTO l_allow_term_emp, l_allow_term_cwk;
CLOSE csr_allow_term_update;
-- Update not allowed
IF NOT l_allow_appraisal AND l_allow_term_emp ='N' THEN
fnd_message.set_name('PER','PER_52456_APR_UPD_EX_EMP_APR');
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 ppf, wf_roles usr
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)
AND ppf.person_id = usr.orig_system_id
AND usr.orig_system = 'PER';
select 'Y'
from per_all_people_f ppf, wf_roles usr
where person_id = p_main_appraiser_id
and p_effective_date between
effective_start_date and nvl(effective_end_date,hr_api.g_eot)
AND ppf.person_id = usr.orig_system_id
AND usr.orig_system = 'PER';
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 NVL (show_term_employee ,'N'), NVL (show_term_contigent,'N'), NVL (show_future_term_employee,'N')
FROM per_appraisal_templates
WHERE appraisal_template_id = p_appraisal_template_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','EX_EMP','EX_CWK','EX_EMP_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);
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;