[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_userra_balances(errbuf out nocopy varchar2,
retcode out nocopy number,
p_year in varchar2,
p_category in varchar2,
p_balance in varchar2,
p_business_group_id in number) is
/************************************************************
** Local Package Variables
************************************************************/
lv_lookup_code fnd_common_lookups.lookup_code%TYPE := null;
( SELECT balance_type_id
FROM pay_balance_types
WHERE balance_name = cp_balance_name
AND business_group_id = p_business_group_id);
select 'x'
from fnd_common_lookups
where lookup_type = cp_lookup_type
and lookup_code = cp_lookup_code
and application_id = cp_application_id ;
select 'y'
from ff_user_entities fue
where user_entity_name = cp_archive_dbi;
select name from hr_organization_units
where organization_id = cp_business_group_id;
insert into fnd_lookup_values(lookup_type,
language,
lookup_code,
meaning,
description,
enabled_flag,
created_by,
creation_date,
last_updated_by,
last_update_date,
source_lang,
view_application_id,
last_update_login)
values(lv_lookup_type,
lv_legislation,
lv_lookup_code,
lv_balance,
lv_description,
lv_enabled_flag,
1,
sysdate,
2,
sysdate,
lv_legislation,
3,
0);
SELECT count(0)
INTO ln_exists
FROM pay_defined_balances db,
pay_balance_dimensions dim
WHERE db.balance_type_id = ln_bal_type_id
AND db.balance_dimension_id = dim.balance_dimension_id
AND dim.dimension_name = lv_dimension;
hr_utility.trace('Error in inserting USERRA data at step '
||to_char(ln_step)|| ' - '|| to_char(sqlcode));
END; /*insert userra balances */