APPS.HXC_MPC_UPLOAD_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

SELECT	bld_blk_info_type_id
FROM	hxc_bld_blk_info_types
WHERE	bld_blk_info_type	= p_bld_blk_info_type;

Line: 46

	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;

Line: 61

/* 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 );