[Home] [Help]
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_balance_types blt
where blt.balance_type_id = p_balance_type_id
and pbg.business_group_id (+) = blt.business_group_id;
select pbg.legislation_code
from per_business_groups_perf pbg
, pay_balance_types blt
where blt.balance_type_id = p_balance_type_id
and pbg.business_group_id (+) = blt.business_group_id;
select '1'
from fnd_currencies
where currency_code = p_currency_code
and ( ( enabled_flag = 'Y') or
( hr_startup_data_api_support.g_startup_mode IN ('STARTUP') ))
and currency_flag = 'Y'
and p_effective_date between nvl(start_date_active,p_effective_date)
and nvl(end_date_active,p_effective_date);
select '1'
from fnd_currencies
where currency_code = p_currency_code
and ( ( enabled_flag = 'Y') or
( hr_startup_data_api_support.g_startup_mode IN ('STARTUP') ))
and currency_flag = 'Y';
select '1'
from pay_balance_types_tl
where balance_type_id = p_balance_type_id
and source_lang <> userenv('LANG');
select '1'
from ff_user_entities uet,
pay_defined_balances dfb
where uet.creator_id = dfb.defined_balance_id
and uet.creator_type = 'B'
and dfb.balance_type_id = p_balance_type_id;
select '1'
from hr_lookups hl
where hl.lookup_type = 'UNITS' and
(hl.lookup_code in ('M','I','N','ND') or hl.lookup_code like 'H%') and
hl.enabled_flag = 'Y' and
hl.lookup_code = p_balance_uom and
p_effective_date between nvl(hl.start_date_active,p_effective_date) and
nvl(hl.end_date_active,p_effective_date);
select '1'
from hr_lookups hl
where hl.lookup_type = 'UNITS' and
hl.lookup_code = p_balance_uom and
substr(hl.lookup_code,1,1) = substr(p_balance_uom_old,1,1) and
hl.enabled_flag = 'Y' and
p_effective_date between nvl(hl.start_date_active,p_effective_date) and
nvl(hl.end_date_active,p_effective_date);
select '1'
from pay_balance_categories_f
where balance_category_id = p_balance_category_id
and nvl(legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
nvl(p_legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))
and p_effective_date between effective_start_date
and effective_end_date;
select '1'
from pay_balance_types
where base_balance_type_id is null
and balance_type_id = p_base_balance_type_id
and ((p_business_group_id is not null
and nvl(business_group_id,-1) = p_business_group_id
or nvl(legislation_code,nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
nvl(p_legislation_code,nvl(hr_api.return_legislation_code(p_business_group_id),'~~nvl~~')))
or (p_legislation_code is not null
and nvl(legislation_code,' ') = p_legislation_code
or business_group_id is not null
and legislation_code = p_legislation_code)
or business_group_id is null
and legislation_code is null) ;
select '1'
from pay_input_values_f
where input_value_id = p_input_value_id
and uom = p_balance_uom
and p_effective_date between effective_start_date and effective_end_date;
select defined_balance_id,
balance_dimension_id,
business_group_id,
legislation_code
from pay_defined_balances dfb
where dfb.balance_type_id = p_balance_type_id;
procedure insert_primary_balance_feed
( p_effective_date in date
,p_business_group_id in number
,p_balance_type_id in number
,p_input_value_id in number
) is
--
l_proc varchar2(72) := g_package||'insert_primary_balance_feed';
select null
from pay_balance_feeds_f pbf
where pbf.balance_type_id = p_balance_type_id
and pbf.input_value_id = p_input_value_id
and nvl(pbf.business_group_id, -1) = nvl(p_business_group_id, -1)
and nvl(pbf.legislation_code, 'NULL') =
nvl(hr_api.return_legislation_code(p_business_group_id), 'NULL')
and p_effective_date between pbf.effective_start_date
and pbf.effective_end_date;
END Insert_primary_balance_feed;
select null
from fnd_territories
where territory_code = p_legislation_code;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in pay_blt_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
(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
-- EDIT_HERE: The following call should be edited if certain types of rows
-- are not permitted.
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_effective_date in date
,p_rec in pay_blt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in pay_blt_shd.g_rec_type
,p_balance_name_warning out nocopy number
) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in pay_blt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;