eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CROSS_REFERENCES_PVT SQL Statements

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

Line: 70


    SELECT *
    FROM mtl_cross_references
    WHERE CROSS_REFERENCE_ID=c_cross_reference_id;

Line: 82


          SELECT
          SOURCE_SYSTEM_ID
         ,START_DATE_ACTIVE
         ,END_DATE_ACTIVE
         ,OBJECT_VERSION_NUMBER
         ,UOM_CODE
         ,REVISION_ID
         ,EPC_GTIN_SERIAL
         ,INVENTORY_ITEM_ID
         ,ORGANIZATION_ID
         ,CROSS_REFERENCE_TYPE
         ,CROSS_REFERENCE
         ,ORG_INDEPENDENT_FLAG
         ,REQUEST_ID
         ,ATTRIBUTE1
         ,ATTRIBUTE2
         ,ATTRIBUTE3
         ,ATTRIBUTE4
         ,ATTRIBUTE5
         ,ATTRIBUTE6
         ,ATTRIBUTE7
         ,ATTRIBUTE8
         ,ATTRIBUTE9
         ,ATTRIBUTE10
         ,ATTRIBUTE11
         ,ATTRIBUTE12
         ,ATTRIBUTE13
         ,ATTRIBUTE14
         ,ATTRIBUTE15
         ,ATTRIBUTE_CATEGORY
  FROM MTL_CROSS_REFERENCES_B
      WHERE CROSS_REFERENCE_ID=c_cross_reference_id
  FOR UPDATE OF INVENTORY_ITEM_ID NOWAIT;

Line: 118


      SELECT
          DESCRIPTION
         ,DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
      FROM MTL_CROSS_REFERENCES_TL
      WHERE CROSS_REFERENCE_ID = c_cross_reference_id
      AND   USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
      FOR UPDATE OF CROSS_REFERENCE_ID NOWAIT;

Line: 161


     (l_XRef_Rec.Transaction_Type <> 'CREATE' AND l_XRef_Rec.Transaction_Type <> 'UPDATE' AND
      l_XRef_Rec.Transaction_Type <> 'DELETE') THEN

             l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

Line: 184


 	 SELECT 'x' INTO l_prod_exists
 	 FROM fnd_grants
 	 WHERE object_id IN
 	   (SELECT object_id FROM fnd_objects
 	    WHERE obj_name = 'EGO_ITEM');

Line: 199


        SELECT status INTO l_pim_exists
	FROM FND_PRODUCT_INSTALLATIONS
	WHERE application_id = 431;

Line: 218


        p_message_name		      =>  'INV_IOI_ITEM_UPDATE_PRIV'
        ,p_application_id		  =>  'INV'
        ,p_message_type		      =>  'E'
        ,p_entity_code		      =>  G_Entity_Code
        ,p_entity_index		      => l_Xref_Indx
        ,p_table_name		      => 'MTL_CROSS_REFERENCES'
        );

Line: 234


          SELECT 'x' INTO l_exists
		  FROM mtl_system_items_b
		  WHERE inventory_item_id =l_XRef_Rec.Inventory_Item_Id;

Line: 293


          SELECT 'x' INTO l_exists
		  FROM MTL_CROSS_REFERENCE_TYPES
		  WHERE cross_reference_type           =l_XRef_Rec.Cross_Reference_Type
		  AND trunc(nvl(disable_date,sysdate)) >= trunc(sysdate);

Line: 385


            SELECT 'x' INTO l_exists
            FROM mtl_system_items_b
            WHERE Inventory_item_id    = l_XRef_Rec.Inventory_Item_Id
            AND Organization_id        = l_XRef_Rec.Organization_Id;

Line: 427


                  SELECT 'x' INTO l_uom_code_valid
            FROM dual
            WHERE
            l_Xref_Rec.Uom_Code IN (
                                   select  Uom_code
                                   from mtl_uom_conversions_view
                                   where inventory_item_id = l_XRef_Rec.Inventory_Item_Id
                                   and organization_id = Decode (l_XRef_Rec.organization_id,FND_API.G_MISS_CHAR,organization_id,NULL,organization_id,organization_id)
                                   )
            AND ROWNUM=1;

Line: 481


             SELECT 'x' INTO l_rev_id_invalid
             FROM dual
             WHERE
             l_Xref_Rec.Revision_Id IN (
                                   select item_rev.revision_id
                                   from mtl_item_revisions_vl item_rev
                                   where item_rev.inventory_item_id = l_XRef_Rec.Inventory_Item_Id
                                   and item_rev.organization_id = l_XRef_Rec.organization_id
                                   )
             AND ROWNUM=1;

Line: 514


          SELECT  'x' INTO l_XRef_exists
          FROM mtl_cross_references
          WHERE Cross_Reference_Type        = l_XRef_Rec.Cross_Reference_Type
          AND Inventory_Item_Id             = l_XRef_Rec.Inventory_Item_Id
          AND Cross_Reference               =l_XRef_Rec.Cross_Reference
          AND Decode(Organization_Id,NULL,Org_Independent_Flag,Organization_Id) =
              Decode(nvl(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Organization_Id);

Line: 574


        SELECT Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Inventory_Item_Id),
               Decode(l_XRef_Rec.Organization_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Organization_Id),
               Decode(l_XRef_Rec.Cross_Reference_Type,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference_Type),
               Decode(l_XRef_Rec.Cross_Reference,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Cross_Reference),
               Decode(l_XRef_Rec.Description,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Description),
               Decode(l_XRef_Rec.Org_Independent_Flag,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Org_Independent_Flag),
               Decode(l_XRef_Rec.Last_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
               Decode(l_XRef_Rec.Last_Updated_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Updated_By),
               Decode(l_XRef_Rec.Creation_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Creation_Date),
               Decode(l_XRef_Rec.Created_By,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Created_By),
               Decode(l_XRef_Rec.Last_Update_Login,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Last_Update_Login),
               Decode(l_XRef_Rec.Request_id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Request_id),
               Decode(l_XRef_Rec.Program_Application_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Application_Id),
               Decode(l_XRef_Rec.Program_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Program_Id),
               Decode(l_XRef_Rec.Program_Update_Date,FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Program_Update_Date),
               Decode(l_XRef_Rec.Attribute1,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute1),
               Decode(l_XRef_Rec.Attribute2,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute2),
               Decode(l_XRef_Rec.Attribute3,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute3),
               Decode(l_XRef_Rec.Attribute4,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute4),
               Decode(l_XRef_Rec.Attribute5,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute5),
               Decode(l_XRef_Rec.Attribute6,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute6),
               Decode(l_XRef_Rec.Attribute7,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute7),
               Decode(l_XRef_Rec.Attribute8,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute8),
               Decode(l_XRef_Rec.Attribute9,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute9),
               Decode(l_XRef_Rec.Attribute10,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute10),
               Decode(l_XRef_Rec.Attribute11,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute11),
               Decode(l_XRef_Rec.Attribute12,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute12),
               Decode(l_XRef_Rec.Attribute13,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute13),
               Decode(l_XRef_Rec.Attribute14,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute14),
               Decode(l_XRef_Rec.Attribute15,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute15),
               Decode(l_XRef_Rec.Attribute_category,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Attribute_category),
               Decode(l_XRef_Rec.Uom_Code,FND_API.G_MISS_CHAR,NULL,l_XRef_Rec.Uom_Code),
               Decode(l_XRef_Rec.Revision_Id,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Revision_Id),
	       Decode(l_XRef_Rec.Epc_Gtin_Serial,FND_API.G_MISS_NUM,NULL,l_XRef_Rec.Epc_Gtin_Serial)

        INTO   l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
               l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,
               l_XRef_Rec.Created_By,l_XRef_Rec.Last_Update_Login,l_XRef_Rec.Request_id,l_XRef_Rec.Program_Application_Id,l_XRef_Rec.Program_Id,
               l_XRef_Rec.Program_Update_Date,l_XRef_Rec.Attribute1,l_XRef_Rec.Attribute2,l_XRef_Rec.Attribute3,l_XRef_Rec.Attribute4,
               l_XRef_Rec.Attribute5,l_XRef_Rec.Attribute6,l_XRef_Rec.Attribute7,l_XRef_Rec.Attribute8,l_XRef_Rec.Attribute9,l_XRef_Rec.Attribute10,
               l_XRef_Rec.Attribute11,l_XRef_Rec.Attribute12,l_XRef_Rec.Attribute13,l_XRef_Rec.Attribute14,l_XRef_Rec.Attribute15,
               l_XRef_Rec.Attribute_category,l_XRef_Rec.Uom_Code,l_XRef_Rec.Revision_Id, l_XRef_Rec.Epc_Gtin_Serial
        FROM dual;

Line: 618


        MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
	      P_UOM_CODE               =>  l_XRef_Rec.Uom_Code  /*bug 14138918  */
	      ,P_REVISION_ID           =>  l_Xref_Rec.Revision_Id /*bug 14138918  */
	      ,P_INVENTORY_ITEM_ID     => l_XRef_Rec.Inventory_Item_Id
	      ,P_ORGANIZATION_ID       => l_XRef_Rec.Organization_Id
	      ,P_CROSS_REFERENCE_TYPE  => l_XRef_Rec.Cross_Reference_Type
	      ,P_CROSS_REFERENCE       => l_XRef_Rec.Cross_Reference
	      ,P_ORG_INDEPENDENT_FLAG  => Nvl(l_XRef_Rec.Org_Independent_Flag,'N')
	      ,P_REQUEST_ID            => l_XRef_Rec.Request_Id
	      ,P_ATTRIBUTE1            => l_XRef_Rec.Attribute1
	      ,P_ATTRIBUTE2            => l_XRef_Rec.Attribute2
	      ,P_ATTRIBUTE3            => l_XRef_Rec.Attribute3
	      ,P_ATTRIBUTE4            => l_XRef_Rec.Attribute4
	      ,P_ATTRIBUTE5            => l_XRef_Rec.Attribute5
	      ,P_ATTRIBUTE6            => l_XRef_Rec.Attribute6
	      ,P_ATTRIBUTE7            => l_XRef_Rec.Attribute7
	      ,P_ATTRIBUTE8            => l_XRef_Rec.Attribute8
	      ,P_ATTRIBUTE9            => l_XRef_Rec.Attribute9
	      ,P_ATTRIBUTE10           => l_XRef_Rec.Attribute10
	      ,P_ATTRIBUTE11           => l_XRef_Rec.Attribute11
	      ,P_ATTRIBUTE12           => l_XRef_Rec.Attribute12
	      ,P_ATTRIBUTE13           => l_XRef_Rec.Attribute13
	      ,P_ATTRIBUTE14           => l_XRef_Rec.Attribute14
	      ,P_ATTRIBUTE15           => l_XRef_Rec.Attribute15
	      ,P_ATTRIBUTE_CATEGORY    => l_XRef_Rec.Attribute_category
	      ,P_DESCRIPTION           => l_XRef_Rec.Description
	      ,P_CREATION_DATE         => Nvl(l_XRef_Rec.Creation_Date,SYSDATE)
	      ,P_CREATED_BY            => Nvl(l_XRef_Rec.Created_By,FND_GLOBAL.USER_ID)
	      ,P_LAST_UPDATE_DATE      => Nvl(l_XRef_Rec.Last_Update_Date,SYSDATE)
	      ,P_LAST_UPDATED_BY       => Nvl(l_XRef_Rec.Last_Updated_By,FND_GLOBAL.USER_ID)
	      ,P_LAST_UPDATE_LOGIN     => Nvl(l_XRef_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
	      ,P_PROGRAM_APPLICATION_ID=> NULL
	      ,P_PROGRAM_ID            => NULL
	      ,P_PROGRAM_UPDATE_DATE   => NULL
	      ,P_EPC_GTIN_SERIAL =>l_XRef_Rec.Epc_Gtin_Serial
	      ,P_SOURCE_SYSTEM_ID       => NULL
        ,P_START_DATE_ACTIVE      => NULL
        ,P_END_DATE_ACTIVE        => NULL
        ,P_OBJECT_VERSION_NUMBER  =>NULL
         ,X_CROSS_REFERENCE_ID  =>returned_cross_ref_id
                            );

Line: 676


      ELSIF  l_XRef_Rec.Transaction_Type = 'UPDATE' THEN

        -- Current cols should not be NULL.
        IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN

          l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;  -- assigning the record status as error

Line: 694


	-- removing as only cross_reference_id is required for update
        --
	-- cannot pass NULL to these Columns
        /*IF l_XRef_Rec.Inventory_Item_Id IS NULL
           OR l_XRef_Rec.Cross_Reference_Type IS NULL
		      OR l_XRef_Rec.Cross_Reference IS NULL THEN

	      l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;  -- assigning the record status as error

Line: 713


	 -- removing as only cross_reference_id is required for update

        -- getting original values and checking for existance of record
        OPEN  mtl_xref_cur(l_XRef_Rec.CROSS_REFERENCE_ID);

Line: 738


        SELECT Decode(Nvl(l_XRef_Rec.Inventory_Item_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Inventory_Item_Id,-999999,NULL,l_XRef_Rec.Inventory_Item_Id),
               Decode(Nvl(l_XRef_Rec.Organization_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Organization_Id,-999999,NULL,l_XRef_Rec.Organization_Id),
               Decode(Nvl(l_XRef_Rec.Cross_Reference_Type, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference_Type,'!',NULL,l_XRef_Rec.Cross_Reference_Type),
               Decode(Nvl(l_XRef_Rec.Cross_Reference, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Cross_Reference,'!',NULL,l_XRef_Rec.Cross_Reference),
               Decode(Nvl(l_XRef_Rec.Description, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Description,'!',NULL,l_XRef_Rec.Description),
               Decode(Nvl(l_XRef_Rec.Org_Independent_Flag, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Org_Independent_Flag,'!',NULL,l_XRef_Rec.Org_Independent_Flag),
               Decode(Nvl(l_XRef_Rec.Last_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,NULL,l_XRef_Rec.Last_Update_Date),
               Decode(Nvl(l_XRef_Rec.Last_Updated_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Updated_By),
               Decode(Nvl(l_XRef_Rec.Creation_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Creation_Date,l_XRef_Rec.Creation_Date),
               Decode(Nvl(l_XRef_Rec.Created_By, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Created_By,-999999,NULL,l_XRef_Rec.Created_By),
               Decode(Nvl(l_XRef_Rec.Last_Update_Login, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,NULL,-999999,NULL,l_XRef_Rec.Last_Update_Login),
               Decode(Nvl(l_XRef_Rec.Request_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Request_id,-999999,NULL,l_XRef_Rec.Request_id),
               Decode(Nvl(l_XRef_Rec.Program_Application_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Program_Application_Id,-999999,NULL,l_XRef_Rec.Program_Application_Id),
               Decode(Nvl(l_XRef_Rec.Program_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_XRef_Rec.Program_Id,-999999,NULL,l_mtl_XRef_Rec.Program_Id),
               Decode(Nvl(l_XRef_Rec.Program_Update_Date, FND_API.G_MISS_DATE),FND_API.G_MISS_DATE,l_mtl_XRef_Rec.Program_Update_Date,l_XRef_Rec.Program_Update_Date),
               Decode(Nvl(l_XRef_Rec.Attribute1, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute1,'!',NULL,l_XRef_Rec.Attribute1),
               Decode(Nvl(l_XRef_Rec.Attribute2, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute2,'!',NULL,l_XRef_Rec.Attribute2),
               Decode(Nvl(l_XRef_Rec.Attribute3, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute3,'!',NULL,l_XRef_Rec.Attribute3),
               Decode(Nvl(l_XRef_Rec.Attribute4, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute4,'!',NULL,l_XRef_Rec.Attribute4),
               Decode(Nvl(l_XRef_Rec.Attribute5, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute5,'!',NULL,l_XRef_Rec.Attribute5),
               Decode(Nvl(l_XRef_Rec.Attribute6, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute6,'!',NULL,l_XRef_Rec.Attribute6),
               Decode(Nvl(l_XRef_Rec.Attribute7, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute7,'!',NULL,l_XRef_Rec.Attribute7),
               Decode(Nvl(l_XRef_Rec.Attribute8, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute8,'!',NULL,l_XRef_Rec.Attribute8),
               Decode(Nvl(l_XRef_Rec.Attribute9, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute9,'!',NULL,l_XRef_Rec.Attribute9),
               Decode(Nvl(l_XRef_Rec.Attribute10, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute10,'!',NULL,l_XRef_Rec.Attribute10),
               Decode(Nvl(l_XRef_Rec.Attribute11, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute11,'!',NULL,l_XRef_Rec.Attribute11),
               Decode(Nvl(l_XRef_Rec.Attribute12, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute12,'!',NULL,l_XRef_Rec.Attribute12),
               Decode(Nvl(l_XRef_Rec.Attribute13, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute13,'!',NULL,l_XRef_Rec.Attribute13),
               Decode(Nvl(l_XRef_Rec.Attribute14, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute14,'!',NULL,l_XRef_Rec.Attribute14),
               Decode(Nvl(l_XRef_Rec.Attribute15, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute15,'!',NULL,l_XRef_Rec.Attribute15),
               Decode(Nvl(l_XRef_Rec.Attribute_category, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Attribute_category,'!',NULL,l_XRef_Rec.Attribute_category),
               Decode(Nvl(l_XRef_Rec.Uom_Code, FND_API.G_MISS_CHAR),FND_API.G_MISS_CHAR,l_mtl_XRef_Rec.Uom_Code,'!',NULL,l_XRef_Rec.Uom_Code),
               Decode(Nvl(l_XRef_Rec.Revision_Id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Revision_Id,-999999,NULL,l_XRef_Rec.Revision_Id),
               Decode(Nvl(l_XRef_Rec.Epc_Gtin_Serial, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,l_mtl_XRef_Rec.Epc_Gtin_Serial,-999999,NULL,l_XRef_Rec.Epc_Gtin_Serial)
        INTO   l_XRef_Rec.Inventory_Item_Id,l_XRef_Rec.Organization_Id, l_XRef_Rec.Cross_Reference_Type,l_XRef_Rec.Cross_Reference,
               l_XRef_Rec.Description,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Last_Update_Date,l_XRef_Rec.Last_Updated_By,l_XRef_Rec.Creation_Date,
               l_XRef_Rec.Created_By,l_XRef_Rec.Last_Update_Login,l_XRef_Rec.Request_id,l_XRef_Rec.Program_Application_Id,l_XRef_Rec.Program_Id,
         l_XRef_Rec.Program_Update_Date,l_XRef_Rec.Attribute1,l_XRef_Rec.Attribute2,l_XRef_Rec.Attribute3,l_XRef_Rec.Attribute4,
         l_XRef_Rec.Attribute5,l_XRef_Rec.Attribute6,l_XRef_Rec.Attribute7,l_XRef_Rec.Attribute8,l_XRef_Rec.Attribute9,l_XRef_Rec.Attribute10,
         l_XRef_Rec.Attribute11,l_XRef_Rec.Attribute12,l_XRef_Rec.Attribute13,l_XRef_Rec.Attribute14,l_XRef_Rec.Attribute15,
         l_XRef_Rec.Attribute_category,l_XRef_Rec.Uom_Code,l_XRef_Rec.Revision_Id,l_XRef_Rec.Epc_Gtin_Serial

        FROM dual;

Line: 826


            SELECT 'x' INTO l_exists
            FROM mtl_system_items_b
            WHERE Inventory_item_id       = l_XRef_Rec.Inventory_Item_Id
			AND Organization_id           = l_XRef_Rec.Organization_Id;

Line: 865


              SELECT 'x' INTO l_uom_code_valid
              FROM dual
              WHERE
              l_Xref_Rec.Uom_Code IN (
                                   select  Uom_code
                                   from mtl_uom_conversions_view
                                   where inventory_item_id = l_mtl_XRef_rec.INVENTORY_ITEM_ID
                                   and organization_id = Decode (l_mtl_XRef_rec.Organization_Id,FND_API.G_MISS_CHAR,organization_id,NULL,organization_id,organization_id)
                                   )
              AND ROWNUM=1;

Line: 918


 	          SELECT 'x' INTO l_rev_id_invalid
            FROM dual
            WHERE
            l_Xref_Rec.Revision_Id IN (
                                   select item_rev.revision_id
                                   from mtl_item_revisions_vl item_rev
                                   where item_rev.inventory_item_id = Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,l_mtl_XRef_rec.Inventory_Item_Id,l_XRef_Rec.Inventory_Item_Id)
                                   and item_rev.organization_id = Decode(l_XRef_Rec.organization_id,FND_API.G_MISS_NUM, l_mtl_XRef_rec.Organization_Id,l_XRef_Rec.organization_id)
                                   )
            AND ROWNUM=1;

Line: 976


            SELECT  'x' INTO l_XRef_exists
			FROM mtl_cross_references
            WHERE Cross_Reference_Type        = l_XRef_Rec.Cross_Reference_Type
            AND Inventory_Item_Id             = l_XRef_Rec.Inventory_Item_Id
            AND Cross_Reference               = l_XRef_Rec.Cross_Reference
            AND Decode(Organization_Id,NULL,Org_Independent_Flag,Organization_Id) =
                Decode(l_XRef_Rec.Organization_Id,NULL,l_XRef_Rec.Org_Independent_Flag,l_XRef_Rec.Organization_Id)
		AND Cross_Reference_Id <> l_XRef_Rec.Cross_Reference_Id;

Line: 1025


		-- calling update
        MTL_CROSS_REFERENCES_PKG.UPDATE_ROW(
          P_INVENTORY_ITEM_ID             => l_XRef_Rec.Inventory_Item_Id
          ,P_ORGANIZATION_ID              => l_XRef_Rec.Organization_Id
          ,P_CROSS_REFERENCE_TYPE         => l_XRef_Rec.Cross_Reference_Type
          ,P_CROSS_REFERENCE              => l_XRef_Rec.Cross_Reference
          ,P_CROSS_REFERENCE_ID    => l_XRef_Rec.Cross_Reference_Id
          ,P_ORG_INDEPENDENT_FLAG         => l_XRef_Rec.Org_Independent_Flag
          ,P_REQUEST_ID                   =>  l_XRef_Rec.Request_Id
          ,P_ATTRIBUTE1                   => l_XRef_Rec.Attribute1
          ,P_ATTRIBUTE2                   => l_XRef_Rec.Attribute2
          ,P_ATTRIBUTE3                   => l_XRef_Rec.Attribute3
          ,P_ATTRIBUTE4                   => l_XRef_Rec.Attribute4
          ,P_ATTRIBUTE5                   => l_XRef_Rec.Attribute5
          ,P_ATTRIBUTE6                   => l_XRef_Rec.Attribute6
          ,P_ATTRIBUTE7                   => l_XRef_Rec.Attribute7
          ,P_ATTRIBUTE8                   => l_XRef_Rec.Attribute8
          ,P_ATTRIBUTE9                   => l_XRef_Rec.Attribute9
          ,P_ATTRIBUTE10                  => l_XRef_Rec.Attribute10
          ,P_ATTRIBUTE11                  => l_XRef_Rec.Attribute11
          ,P_ATTRIBUTE12                  => l_XRef_Rec.Attribute12
          ,P_ATTRIBUTE13                  => l_XRef_Rec.Attribute13
          ,P_ATTRIBUTE14                  => l_XRef_Rec.Attribute14
          ,P_ATTRIBUTE15                  => l_XRef_Rec.Attribute15
          ,P_ATTRIBUTE_CATEGORY           => l_XRef_Rec.Attribute_category
          ,P_DESCRIPTION                  => l_XRef_Rec.Description
          ,P_LAST_UPDATE_DATE             => Nvl(l_XRef_Rec.Last_Update_Date,SYSDATE)
          ,P_LAST_UPDATED_BY              => Nvl(l_XRef_Rec.Last_Updated_By,FND_GLOBAL.USER_ID)
          ,P_LAST_UPDATE_LOGIN            => Nvl(l_XRef_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
          ,P_UOM_CODE                     => l_XRef_Rec.Uom_Code /* bug 14138918 */
          ,P_REVISION_ID                  => l_XRef_Rec.Revision_Id /* bug 14138918 */
          ,P_EPC_GTIN_SERIAL              => l_XRef_rec.EPC_GTIN_SERIAL
	  ,P_SOURCE_SYSTEM_ID             => NULL
          ,P_START_DATE_ACTIVE            => NULL
          ,P_END_DATE_ACTIVE              => NULL
          ,X_OBJECT_VERSION_NUMBER        =>returned_object_version_number
          );

Line: 1066


           ,p_dml_type             => 'UPDATE'
           ,p_inventory_item_id    => l_XRef_Rec.Inventory_Item_Id
           ,p_organization_id      => l_XRef_Rec.Organization_Id
           ,p_cross_reference_type => l_XRef_Rec.Cross_Reference_Type
           ,p_cross_reference      => l_XRef_Rec.Cross_Reference
	   );

Line: 1078


	  ELSIF  l_XRef_Rec.Transaction_Type = 'DELETE' THEN
        -- current cols should not be NULL.
     IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN

          l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;  -- assigning the record status as error

Line: 1126


        MTL_CROSS_REFERENCES_PKG.DELETE_ROW(
          P_CROSS_REFERENCE_ID     => l_XRef_Rec.CROSS_REFERENCE_ID );

Line: 1133


          ,p_dml_type             => 'DELETE'
          ,p_inventory_item_id    => l_lock_b_recinfo.INVENTORY_ITEM_ID
          ,p_organization_id      => l_lock_b_recinfo.ORGANIZATION_ID
          ,p_cross_reference_type => l_lock_b_recinfo.CROSS_REFERENCE_TYPE
          ,p_cross_reference      => l_lock_b_recinfo.CROSS_REFERENCE);

Line: 1289


        SELECT 'x'
        INTO l_uom_exists
        FROM mtl_units_of_measure_tl
        WHERE UOM_CODE          = l_GTIN_XRef_Rec.UOM_CODE;

Line: 1320


        SELECT  'x'
        INTO l_gtin_xref_exists
        FROM mtl_cross_references
        WHERE CROSS_REFERENCE_TYPE  = l_GTIN_XRef_Rec.CROSS_REFERENCE_TYPE
        AND INVENTORY_ITEM_ID       = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID
        AND UOM_CODE                = l_GTIN_XRef_Rec.UOM_CODE
        AND NOT CROSS_REFERENCE_ID  = l_GTIN_XRef_Rec.CROSS_REFERENCE_ID;

Line: 1367


      SELECT  'x'  INTO l_gtin_packitem_exists
      FROM mtl_cross_references
      WHERE CROSS_REFERENCE_TYPE        = l_GTIN_XRef_Rec.CROSS_REFERENCE_TYPE
      AND NOT INVENTORY_ITEM_ID         = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID
      AND CROSS_REFERENCE               = l_GTIN_XRef_Rec.CROSS_REFERENCE
      AND UOM_CODE                      = l_GTIN_XRef_Rec.UOM_CODE;

Line: 1409


        SELECT 'x' INTO l_item_revision_exists
        FROM mtl_item_revisions
        WHERE INVENTORY_ITEM_ID = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID
        AND REVISION_ID         = l_GTIN_XRef_Rec.REVISION_ID
        AND ORGANIZATION_ID     = l_GTIN_XRef_Rec.ORGANIZATION_ID;

Line: 1434


          SELECT i.organization_id INTO l_master_org
          FROM mtl_parameters p, mtl_system_items_b i
          WHERE p.organization_id = p.master_organization_id
 	  AND i.organization_id = p.organization_id
 	  AND i.inventory_item_id = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID;

Line: 1454


 	  SELECT 'x' INTO l_item_revision_exists
 	  FROM mtl_item_revisions
 	  WHERE INVENTORY_ITEM_ID = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID
 	  AND REVISION_ID         = l_GTIN_XRef_Rec.REVISION_ID
 	  AND ORGANIZATION_ID     = l_master_org;

Line: 1713


  SELECT A.ROWID, A.*
  FROM MTL_CROSS_REFERENCES_INTERFACE A
  WHERE DECODE(C_DATA_SET_ID, NULL, -1, A.SET_PROCESS_ID) = NVL(C_DATA_SET_ID, -1)
  AND A.PROCESS_FLAG = 1;

Line: 1727


      UPDATE MTL_CROSS_REFERENCES_INTERFACE
        SET Transaction_Id = MTL_CROSS_REF_INTERFACE_S.NEXTVAL,
            Request_Id = FND_GLOBAL.CONC_REQUEST_ID
      WHERE ROWID = l_mtl_xref_rec.ROWID;

Line: 1745


          SELECT A.UOM_CODE
          INTO L_UOM_CODE
          FROM MTL_UNITS_OF_MEASURE_TL A
          WHERE A.UNIT_OF_MEASURE_TL = L_MTL_XREF_REC.UNIT_OF_MEASURE_TL
          AND A.LANGUAGE = l_mtl_xref_rec.UOM_LANGUAGE;

Line: 1764


    SELECT  mtp.organization_id into p_organization_id
            FROM    mtl_parameters mtp
            WHERE   mtp.organization_code = l_mtl_xref_rec.ORGANIZATION_CODE;

Line: 1819


      SELECT  msk.inventory_item_id into p_inventory_item_id
              FROM    mtl_system_items_b_kfv msk
              WHERE   msk.concatenated_segments = l_mtl_xref_rec.ITEM_NUMBER
              and organization_id=l_mtl_xref_rec.ORGANIZATION_ID;

Line: 1876


      SELECT revision_id INTO p_revision_id
      FROM mtl_item_revisions_b
      WHERE inventory_item_id=l_mtl_xref_rec.INVENTORY_ITEM_ID
      AND organization_id=  l_mtl_xref_rec.ORGANIZATION_ID
      AND revision= l_mtl_xref_rec.revision;

Line: 1958


      l_XRef_Rec.LAST_UPDATE_DATE     := l_mtl_xref_rec.LAST_UPDATE_DATE;

Line: 1959


      l_XRef_Rec.LAST_UPDATED_BY      := l_mtl_xref_rec.LAST_UPDATED_BY;

Line: 1962


      l_XRef_Rec.LAST_UPDATE_LOGIN    := l_mtl_xref_rec.LAST_UPDATE_LOGIN;

Line: 1979


        UPDATE MTL_CROSS_REFERENCES_INTERFACE
        SET process_flag = 3
        WHERE Transaction_Id = l_mtl_xref_rec.Transaction_Id;

Line: 2010


        UPDATE MTL_CROSS_REFERENCES_INTERFACE
        SET process_flag = 7
        WHERE Transaction_Id = l_mtl_xref_rec.Transaction_Id;

Line: 2069


   INSERT INTO mtl_interface_errors
   (
   TRANSACTION_ID,
   UNIQUE_ID,
   ORGANIZATION_ID,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_LOGIN,
   COLUMN_NAME,
   TABLE_NAME,
   MESSAGE_NAME,
   ERROR_MESSAGE,
   REQUEST_ID,
   PROGRAM_APPLICATION_ID,
   PROGRAM_ID,
   PROGRAM_UPDATE_DATE
   )
   VALUES
   (
   trans_id,
   mtl_system_items_interface_s.NEXTVAL,
   org_id,
   l_sysdate,
   user_id,
   l_sysdate,
   user_id,
   login_id,
   p_column_name,
   tbl_name,
   msg_name,
   SUBSTRB(error_text, 1,2000),
   req_id,
   prog_appid,
   prog_id,
   l_sysdate
   );

Line: 2160


   DELETE FROM MTL_CROSS_REFERENCES_INTERFACE
   WHERE process_flag = l_process_flag_7
    AND set_process_id=p_data_set_id
    AND rownum < l_rownum;