[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
(select ff.descriptive_flex_context_code
from fnd_descr_flex_contexts_vl ff
where ff.DESCRIPTIVE_FLEX_CONTEXT_NAME = p_reference_object
and p_alias_type = 'OTL_ALT_DDF'
union
select to_char(ff.FLEX_VALUE_SET_ID)
from fnd_flex_value_sets ff
where ff.FLEX_VALUE_SET_NAME = p_reference_object
and p_alias_type in ('VALUE_SET_NONE','VALUE_SET_TABLE')
);
SELECT alias_type_id
FROM hxc_alias_types
WHERE alias_type = p_alias_type
and reference_object = p_alias_reference_object;
SELECT alias_definition_id
, DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
, business_group_id
, legislation_code
, alias_context_code
, description
, alias_definition_name
, timecard_field
, object_version_number
INTO l_alias_definition_id
,l_owner
,l_business_group_id
,l_legislation_code
,l_alias_context_code
,l_description
,l_alias_definition_name
,l_timecard_field
,l_ovn
FROM hxc_alias_definitions had
WHERE had.alias_definition_name = p_alias_definition_name
and had.ALIAS_TYPE_ID = l_alias_type_id;
-- only update if the alias component mapping that has actually changed
hxc_had_upd.upd
(p_alias_definition_id => l_alias_definition_id
,p_object_version_number => l_ovn
,p_alias_definition_name => p_alias_definition_name
,p_alias_context_code => p_alias_context_code
,p_business_group_id => null
,p_legislation_code => p_legislation_code
,p_timecard_field => p_timecard_field
,p_description => p_description
,p_prompt => p_prompt
,p_alias_type_id => l_alias_type_id
);