7023: -- Make sure that cross_ref_item does not already exist.
7024: BEGIN
7025: SELECT cross_reference
7026: INTO l_cross_reference
7027: FROM mtl_cross_references
7028: WHERE cross_reference = p_cross_reference
7029: AND cross_reference_type = p_cross_reference_type
7030: AND organization_id = p_organization_id;
7031:
7046: l_user_id := fnd_global.user_id;
7047: l_login_id := fnd_global.login_id;
7048: l_progress := '30';
7049:
7050: -- Insert the record in mtl_cross_references
7051: INSERT INTO mtl_cross_references
7052: (
7053: inventory_item_id
7054: , organization_id
7047: l_login_id := fnd_global.login_id;
7048: l_progress := '30';
7049:
7050: -- Insert the record in mtl_cross_references
7051: INSERT INTO mtl_cross_references
7052: (
7053: inventory_item_id
7054: , organization_id
7055: , cross_reference_type