The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id,
pbg.legislation_code
from per_business_groups_perf pbg
, pay_status_processing_rules_f spr
where spr.status_processing_rule_id = p_status_processing_rule_id
and pbg.business_group_id (+) = spr.business_group_id;
select pbg.legislation_code
from per_business_groups_perf pbg
, pay_status_processing_rules_f spr
where spr.status_processing_rule_id = p_status_processing_rule_id
and pbg.business_group_id (+) = spr.business_group_id;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in pay_ppr_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
Procedure dt_update_validate
(p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) Is
--
l_proc varchar2(72) := g_package||'dt_update_validate';
End dt_update_validate;
Procedure dt_delete_validate
(p_status_processing_rule_id in number
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) Is
--
l_proc varchar2(72) := g_package||'dt_delete_validate';
If (p_datetrack_mode = hr_api.g_delete or
p_datetrack_mode = hr_api.g_zap) then
--
--
-- Ensure the arguments are not null
--
hr_api.mandatory_arg_error
(p_api_name => l_proc
,p_argument => 'validation_start_date'
,p_argument_value => p_validation_start_date
);
End dt_delete_validate;
SELECT '1'
FROM per_assignment_status_types astp
WHERE nvl(astp.assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
and ((astp.legislation_code =
nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
or ( astp.legislation_code is null and
astp.business_group_id = p_business_group_id)
or ( astp.legislation_code is null and
astp.business_group_id is null));
SELECT astp.user_status
FROM pay_ass_status_types_plus_std astp
WHERE nvl(astp.assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
and ((astp.legislation_code =
nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
or ( astp.legislation_code is null and
astp.business_group_id = p_business_group_id)
or ( astp.legislation_code is null and
astp.business_group_id is null));
select distinct ft.formula_type_name,
Decode(ft.formula_type_name,'Balance Adjustment','B','P') processing_rule
from ff_formula_types ft, ff_formulas_f ff
where ff.formula_type_id = ft.formula_type_id
and ff.formula_id = p_formula_id
and ((ff.legislation_code =
nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
or ( ff.legislation_code is null and
ff.business_group_id = p_business_group_id)
or ( ff.legislation_code is null and
ff.business_group_id is null));
fnd_message.set_name('PAY','HR_7135_SPR_FORMULA_NO_UPDATE');
select null
from pay_element_types_f element, pay_element_classifications classif,
pay_element_classifications_tl classif_tl, pay_element_types_f_tl element_tl
where classif_tl.classification_id = classif.classification_id
and classif_tl.language = userenv('LANG')
and element.Element_type_id = element_tl.Element_type_id
and element.Element_type_id = p_element_type_id
and element_tl.language = userenv('LANG')
and element.classification_id = classif.classification_id
and p_effective_date between element.effective_start_date
and element.effective_end_date
and nvl(element.business_group_id,nvl(p_business_group_id, 0)) = nvl(p_business_group_id,0)
and nvl(element.legislation_code, nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)), '~'))
= nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)),'~');
select null
from fnd_territories
where territory_code = p_legislation_code;
select '1'
from pay_status_processing_rules_f
where nvl(assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
and element_type_id = p_element_type_id
and processing_rule = nvl(p_processing_rule,'P')
and p_effective_date between effective_start_date
and effective_end_date
and status_processing_rule_id <> nvl(p_status_processing_rule_id,-1);
(p_insert IN boolean
,p_business_group_id IN number
,p_legislation_code IN varchar2
,p_legislation_subgroup IN varchar2 DEFAULT NULL) IS
--
BEGIN
--
-- Call the supporting procedure to check startup mode
--
IF (p_insert) THEN
hr_startup_data_api_support.chk_startup_action
(p_generic_allowed => FALSE
,p_startup_allowed => TRUE
,p_user_allowed => TRUE
,p_business_group_id => p_business_group_id
,p_legislation_code => p_legislation_code
,p_legislation_subgroup => p_legislation_subgroup
);
Procedure insert_validate
(p_rec in pay_ppr_shd.g_rec_type
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
,p_processing_rule out nocopy varchar2
,p_formula_mismatch_warning out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_rec in pay_ppr_shd.g_rec_type
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
,p_processing_rule out nocopy varchar2
,p_formula_mismatch_warning out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'update_validate';
dt_update_validate
(p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in pay_ppr_shd.g_rec_type
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
dt_delete_validate
(p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
,p_status_processing_rule_id => p_rec.status_processing_rule_id
);
End delete_validate;