4225: l_item_name_source VARCHAR2(30) :=p_item_name_source;
4226: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4227: l_cross_reference_type mtl_cross_references.cross_reference_type%TYPE :=p_cross_reference_type;
4228: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4229: l_item_attribute_category fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
4230: l_tax_name_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4231: l_item_model_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4232: l_tax_name mtl_system_items_b.attribute1%TYPE;
4233: l_item_model mtl_system_items_b.attribute1%TYPE;
4226: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4227: l_cross_reference_type mtl_cross_references.cross_reference_type%TYPE :=p_cross_reference_type;
4228: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4229: l_item_attribute_category fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
4230: l_tax_name_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4231: l_item_model_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4232: l_tax_name mtl_system_items_b.attribute1%TYPE;
4233: l_item_model mtl_system_items_b.attribute1%TYPE;
4234: l_dbg_msg VARCHAR2(1000);
4227: l_cross_reference_type mtl_cross_references.cross_reference_type%TYPE :=p_cross_reference_type;
4228: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4229: l_item_attribute_category fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
4230: l_tax_name_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4231: l_item_model_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4232: l_tax_name mtl_system_items_b.attribute1%TYPE;
4233: l_item_model mtl_system_items_b.attribute1%TYPE;
4234: l_dbg_msg VARCHAR2(1000);
4235: l_item_status MTL_ITEM_STATUS.INVENTORY_ITEM_STATUS_CODE%TYPE :=p_item_status;