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_ITEM_CATALOG_GROUPS_UTIL SQL Statements

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

Line: 4


PROCEDURE INSERT_ROW (P_Catalog_Group_Rec IN  MTL_ITEM_CATALOG_GROUPS%ROWTYPE
                     ,X_ROWID             OUT NOCOPY ROWID) IS

   l_return_status VARCHAR2(1);   --Bug 4639946

Line: 10


   INSERT INTO MTL_ITEM_CATALOG_GROUPS_B (
    PARENT_CATALOG_GROUP_ID,
    ITEM_CREATION_ALLOWED_FLAG,
    ITEM_CATALOG_GROUP_ID,
    INACTIVE_DATE,
    SUMMARY_FLAG,
    ENABLED_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    SEGMENT1,
    SEGMENT2,
    SEGMENT3,
    SEGMENT4,
    SEGMENT5,
    SEGMENT6,
    SEGMENT7,
    SEGMENT8,
    SEGMENT9,
    SEGMENT10,
    SEGMENT11,
    SEGMENT12,
    SEGMENT13,
    SEGMENT14,
    SEGMENT15,
    SEGMENT16,
    SEGMENT17,
    SEGMENT18,
    SEGMENT19,
    SEGMENT20,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    REQUEST_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
   ) VALUES (
    P_Catalog_Group_Rec.PARENT_CATALOG_GROUP_ID,
    NVL(P_Catalog_Group_Rec.ITEM_CREATION_ALLOWED_FLAG,'Y'),
    P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID,
    P_Catalog_Group_Rec.INACTIVE_DATE,
    P_Catalog_Group_Rec.SUMMARY_FLAG,
    P_Catalog_Group_Rec.ENABLED_FLAG,
    P_Catalog_Group_Rec.START_DATE_ACTIVE,
    P_Catalog_Group_Rec.END_DATE_ACTIVE,
    P_Catalog_Group_Rec.SEGMENT1,
    P_Catalog_Group_Rec.SEGMENT2,
    P_Catalog_Group_Rec.SEGMENT3,
    P_Catalog_Group_Rec.SEGMENT4,
    P_Catalog_Group_Rec.SEGMENT5,
    P_Catalog_Group_Rec.SEGMENT6,
    P_Catalog_Group_Rec.SEGMENT7,
    P_Catalog_Group_Rec.SEGMENT8,
    P_Catalog_Group_Rec.SEGMENT9,
    P_Catalog_Group_Rec.SEGMENT10,
    P_Catalog_Group_Rec.SEGMENT11,
    P_Catalog_Group_Rec.SEGMENT12,
    P_Catalog_Group_Rec.SEGMENT13,
    P_Catalog_Group_Rec.SEGMENT14,
    P_Catalog_Group_Rec.SEGMENT15,
    P_Catalog_Group_Rec.SEGMENT16,
    P_Catalog_Group_Rec.SEGMENT17,
    P_Catalog_Group_Rec.SEGMENT18,
    P_Catalog_Group_Rec.SEGMENT19,
    P_Catalog_Group_Rec.SEGMENT20,
    P_Catalog_Group_Rec.ATTRIBUTE_CATEGORY,
    P_Catalog_Group_Rec.ATTRIBUTE1,
    P_Catalog_Group_Rec.ATTRIBUTE2,
    P_Catalog_Group_Rec.ATTRIBUTE3,
    P_Catalog_Group_Rec.ATTRIBUTE4,
    P_Catalog_Group_Rec.ATTRIBUTE5,
    P_Catalog_Group_Rec.ATTRIBUTE6,
    P_Catalog_Group_Rec.ATTRIBUTE7,
    P_Catalog_Group_Rec.ATTRIBUTE8,
    P_Catalog_Group_Rec.ATTRIBUTE9,
    P_Catalog_Group_Rec.ATTRIBUTE10,
    P_Catalog_Group_Rec.ATTRIBUTE11,
    P_Catalog_Group_Rec.ATTRIBUTE12,
    P_Catalog_Group_Rec.ATTRIBUTE13,
    P_Catalog_Group_Rec.ATTRIBUTE14,
    P_Catalog_Group_Rec.ATTRIBUTE15,
    P_Catalog_Group_Rec.REQUEST_ID,
    P_Catalog_Group_Rec.CREATION_DATE,
    P_Catalog_Group_Rec.CREATED_BY,
    P_Catalog_Group_Rec.LAST_UPDATE_DATE,
    P_Catalog_Group_Rec.LAST_UPDATED_BY,
    P_Catalog_Group_Rec.LAST_UPDATE_LOGIN
   ) RETURNING ROWID INTO X_ROWID;

Line: 114


   INSERT INTO MTL_ITEM_CATALOG_GROUPS_TL (
    ITEM_CATALOG_GROUP_ID,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
   ) SELECT
      P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID,
      P_Catalog_Group_Rec.DESCRIPTION,
      P_Catalog_Group_Rec.CREATION_DATE,
      P_Catalog_Group_Rec.CREATED_BY,
      P_Catalog_Group_Rec.LAST_UPDATE_DATE,
      P_Catalog_Group_Rec.LAST_UPDATED_BY,
      P_Catalog_Group_Rec.LAST_UPDATE_LOGIN,
      L.LANGUAGE_CODE,
      USERENV('LANG')
     FROM FND_LANGUAGES L
     WHERE L.INSTALLED_FLAG in ('I', 'B')
     AND NOT EXISTS   (SELECT  NULL
                       FROM MTL_ITEM_CATALOG_GROUPS_TL T
                       WHERE T.ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
                       AND   T.LANGUAGE = L.LANGUAGE_CODE);

Line: 155


END INSERT_ROW;

Line: 160


     SELECT
      PARENT_CATALOG_GROUP_ID,
      ITEM_CREATION_ALLOWED_FLAG,
      INACTIVE_DATE,
      SUMMARY_FLAG,
      ENABLED_FLAG,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      SEGMENT1,
      SEGMENT2,
      SEGMENT3,
      SEGMENT4,
      SEGMENT5,
      SEGMENT6,
      SEGMENT7,
      SEGMENT8,
      SEGMENT9,
      SEGMENT10,
      SEGMENT11,
      SEGMENT12,
      SEGMENT13,
      SEGMENT14,
      SEGMENT15,
      SEGMENT16,
      SEGMENT17,
      SEGMENT18,
      SEGMENT19,
      SEGMENT20,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      REQUEST_ID
     FROM MTL_ITEM_CATALOG_GROUPS_B
     WHERE ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
     FOR UPDATE OF ITEM_CATALOG_GROUP_ID NOWAIT;

Line: 211


     SELECT
      DESCRIPTION,
      DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
     FROM MTL_ITEM_CATALOG_GROUPS_TL
     WHERE ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
     AND userenv('LANG')         IN (LANGUAGE, SOURCE_LANG)
     FOR UPDATE OF ITEM_CATALOG_GROUP_ID NOWAIT;

Line: 227


      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 344


PROCEDURE UPDATE_ROW (P_Catalog_Group_Rec IN  MTL_ITEM_CATALOG_GROUPS%ROWTYPE) IS

   l_old_parent_id  NUMBER;       --Bug: 4639946

Line: 351


   Select PARENT_CATALOG_GROUP_ID into l_old_parent_id
   From MTL_ITEM_CATALOG_GROUPS_B
   WHERE ITEM_CATALOG_GROUP_ID  = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID;

Line: 359


   UPDATE MTL_ITEM_CATALOG_GROUPS_B
   SET
    PARENT_CATALOG_GROUP_ID     = P_Catalog_Group_Rec.PARENT_CATALOG_GROUP_ID,
    ITEM_CREATION_ALLOWED_FLAG  = NVL(P_Catalog_Group_Rec.ITEM_CREATION_ALLOWED_FLAG,ITEM_CREATION_ALLOWED_FLAG),
    INACTIVE_DATE               = P_Catalog_Group_Rec.INACTIVE_DATE,
    SUMMARY_FLAG                = P_Catalog_Group_Rec.SUMMARY_FLAG,
    ENABLED_FLAG		= P_Catalog_Group_Rec.ENABLED_FLAG,
    START_DATE_ACTIVE		= P_Catalog_Group_Rec.START_DATE_ACTIVE,
    END_DATE_ACTIVE		= P_Catalog_Group_Rec.END_DATE_ACTIVE,
    SEGMENT1			= P_Catalog_Group_Rec.SEGMENT1,
    SEGMENT2			= P_Catalog_Group_Rec.SEGMENT2,
    SEGMENT3			= P_Catalog_Group_Rec.SEGMENT3,
    SEGMENT4			= P_Catalog_Group_Rec.SEGMENT4,
    SEGMENT5			= P_Catalog_Group_Rec.SEGMENT5,
    SEGMENT6			= P_Catalog_Group_Rec.SEGMENT6,
    SEGMENT7			= P_Catalog_Group_Rec.SEGMENT7,
    SEGMENT8			= P_Catalog_Group_Rec.SEGMENT8,
    SEGMENT9			= P_Catalog_Group_Rec.SEGMENT9,
    SEGMENT10			= P_Catalog_Group_Rec.SEGMENT10,
    SEGMENT11			= P_Catalog_Group_Rec.SEGMENT11,
    SEGMENT12			= P_Catalog_Group_Rec.SEGMENT12,
    SEGMENT13			= P_Catalog_Group_Rec.SEGMENT13,
    SEGMENT14			= P_Catalog_Group_Rec.SEGMENT14,
    SEGMENT15			= P_Catalog_Group_Rec.SEGMENT15,
    SEGMENT16			= P_Catalog_Group_Rec.SEGMENT16,
    SEGMENT17			= P_Catalog_Group_Rec.SEGMENT17,
    SEGMENT18			= P_Catalog_Group_Rec.SEGMENT18,
    SEGMENT19			= P_Catalog_Group_Rec.SEGMENT19,
    SEGMENT20			= P_Catalog_Group_Rec.SEGMENT20,
    ATTRIBUTE_CATEGORY		= P_Catalog_Group_Rec.ATTRIBUTE_CATEGORY,
    ATTRIBUTE1			= P_Catalog_Group_Rec.ATTRIBUTE1,
    ATTRIBUTE2			= P_Catalog_Group_Rec.ATTRIBUTE2,
    ATTRIBUTE3			= P_Catalog_Group_Rec.ATTRIBUTE3,
    ATTRIBUTE4			= P_Catalog_Group_Rec.ATTRIBUTE4,
    ATTRIBUTE5			= P_Catalog_Group_Rec.ATTRIBUTE5,
    ATTRIBUTE6			= P_Catalog_Group_Rec.ATTRIBUTE6,
    ATTRIBUTE7			= P_Catalog_Group_Rec.ATTRIBUTE7,
    ATTRIBUTE8			= P_Catalog_Group_Rec.ATTRIBUTE8,
    ATTRIBUTE9			= P_Catalog_Group_Rec.ATTRIBUTE9,
    ATTRIBUTE10			= P_Catalog_Group_Rec.ATTRIBUTE10,
    ATTRIBUTE11			= P_Catalog_Group_Rec.ATTRIBUTE11,
    ATTRIBUTE12			= P_Catalog_Group_Rec.ATTRIBUTE12,
    ATTRIBUTE13			= P_Catalog_Group_Rec.ATTRIBUTE13,
    ATTRIBUTE14			= P_Catalog_Group_Rec.ATTRIBUTE14,
    ATTRIBUTE15			= P_Catalog_Group_Rec.ATTRIBUTE15,
    REQUEST_ID			= P_Catalog_Group_Rec.REQUEST_ID,
    LAST_UPDATE_DATE		= P_Catalog_Group_Rec.LAST_UPDATE_DATE,
    LAST_UPDATED_BY		= P_Catalog_Group_Rec.LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN		= P_Catalog_Group_Rec.LAST_UPDATE_LOGIN
   WHERE ITEM_CATALOG_GROUP_ID  = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID;

Line: 415


   UPDATE MTL_ITEM_CATALOG_GROUPS_TL
   SET
    DESCRIPTION		= P_Catalog_Group_Rec.DESCRIPTION,
    LAST_UPDATE_DATE	= P_Catalog_Group_Rec.LAST_UPDATE_DATE,
    LAST_UPDATED_BY	= P_Catalog_Group_Rec.LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN	= P_Catalog_Group_Rec.LAST_UPDATE_LOGIN,
    SOURCE_LANG		= USERENV('LANG')
   WHERE ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
   AND   USERENV('LANG')       IN (LANGUAGE, SOURCE_LANG);

Line: 444


END UPDATE_ROW;

Line: 446


PROCEDURE DELETE_ROW (X_ITEM_CATALOG_GROUP_ID IN MTL_ITEM_CATALOG_GROUPS.ITEM_CATALOG_GROUP_ID%TYPE)
IS
BEGIN

   DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL
   WHERE  ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID;

Line: 457


   DELETE FROM MTL_ITEM_CATALOG_GROUPS_B
   WHERE  ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID;

Line: 464


END DELETE_ROW;

Line: 469


   DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL T
   WHERE NOT EXISTS (SELECT NULL
		     FROM   MTL_ITEM_CATALOG_GROUPS_B B
		     WHERE  B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID);

Line: 474


   UPDATE MTL_ITEM_CATALOG_GROUPS_TL T
   SET (DESCRIPTION) = (SELECT B.DESCRIPTION
		        FROM   MTL_ITEM_CATALOG_GROUPS_TL B
			WHERE  B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID
			AND    B.LANGUAGE = T.SOURCE_LANG)
   WHERE ( T.ITEM_CATALOG_GROUP_ID,T.LANGUAGE)
     IN (SELECT	SUBT.ITEM_CATALOG_GROUP_ID,
	        SUBT.LANGUAGE
	 FROM   MTL_ITEM_CATALOG_GROUPS_TL SUBB,
		MTL_ITEM_CATALOG_GROUPS_TL SUBT
	 WHERE  SUBB.ITEM_CATALOG_GROUP_ID = SUBT.ITEM_CATALOG_GROUP_ID
	 AND    SUBB.LANGUAGE = SUBT.SOURCE_LANG
	 AND   (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
            or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
            or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)));

Line: 490


   INSERT INTO MTL_ITEM_CATALOG_GROUPS_TL (
    ITEM_CATALOG_GROUP_ID,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
   ) SELECT
    B.ITEM_CATALOG_GROUP_ID,
    B.DESCRIPTION,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
   FROM MTL_ITEM_CATALOG_GROUPS_TL B,
	FND_LANGUAGES L
   WHERE L.INSTALLED_FLAG in ('I', 'B')
   AND   B.LANGUAGE = userenv('LANG')
   AND NOT EXISTS  (SELECT NULL
		    FROM MTL_ITEM_CATALOG_GROUPS_TL T
		    WHERE T.ITEM_CATALOG_GROUP_ID = B.ITEM_CATALOG_GROUP_ID
		    AND   T.LANGUAGE = L.LANGUAGE_CODE);