The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bld_blk_info_type_id
FROM hxc_bld_blk_info_types
WHERE bld_blk_info_type = p_bld_blk_info_type;
SELECT mapping_component_id
, object_version_number
, DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
, field_name
, bld_blk_info_type
, segment
INTO l_mapping_component_id
, l_ovn
, l_owner
, l_field_name
, l_bld_blk_info_type
, l_segment
FROM hxc_mapping_components_v
WHERE name = P_NAME;
/* ALLOW UPDATE TO FLAG THAT MAPPING COMPONENTS CANNOT BE UPDATED
THROUGH THE LOADER IF THEY ARE REFERENCED BY MAPPING */
IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
THEN
-- only update if the mapping component has actually changed
-- v115.3 - if mpc being used need to use hcdelmpc.sql first
IF ( ( p_segment <> l_segment ) OR ( p_field_name <> l_field_name )
OR ( p_bld_blk_info_type <> l_bld_blk_info_type ) )
THEN
hxc_mpc_upd.upd (
p_mapping_component_id => l_mapping_component_id
, p_object_version_number => l_ovn
, p_field_name => p_field_name
, p_name => p_name
, p_bld_blk_info_type_id => l_bld_blk_info_type_id
, p_segment => p_segment );