APPS.MTL_ITEM_TEMPLATES_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW(P_Item_Templates_Rec IN  MTL_ITEM_TEMPLATES_B%ROWTYPE,
                     X_ROWID              OUT NOCOPY ROWID) IS
BEGIN

   INSERT INTO MTL_ITEM_TEMPLATES_B (
      TEMPLATE_ID,
      TEMPLATE_NAME,
      DESCRIPTION,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      CONTEXT_ORGANIZATION_ID,
      GLOBAL_ATTRIBUTE_CATEGORY,
      GLOBAL_ATTRIBUTE1,
      GLOBAL_ATTRIBUTE2,
      GLOBAL_ATTRIBUTE3,
      GLOBAL_ATTRIBUTE4,
      GLOBAL_ATTRIBUTE5,
      GLOBAL_ATTRIBUTE6,
      GLOBAL_ATTRIBUTE7,
      GLOBAL_ATTRIBUTE8,
      GLOBAL_ATTRIBUTE9,
      GLOBAL_ATTRIBUTE10,
      GLOBAL_ATTRIBUTE11,
      GLOBAL_ATTRIBUTE12,
      GLOBAL_ATTRIBUTE13,
      GLOBAL_ATTRIBUTE14,
      GLOBAL_ATTRIBUTE15,
      GLOBAL_ATTRIBUTE16,
      GLOBAL_ATTRIBUTE17,
      GLOBAL_ATTRIBUTE18,
      GLOBAL_ATTRIBUTE19,
      GLOBAL_ATTRIBUTE20
)
   VALUES (
      P_Item_Templates_Rec.TEMPLATE_ID,
      P_Item_Templates_Rec.TEMPLATE_NAME,
      P_Item_Templates_Rec.DESCRIPTION,
      P_Item_Templates_Rec.LAST_UPDATE_DATE,
      P_Item_Templates_Rec.LAST_UPDATED_BY,
      P_Item_Templates_Rec.CREATION_DATE,
      P_Item_Templates_Rec.CREATED_BY,
      P_Item_Templates_Rec.LAST_UPDATE_LOGIN,
      P_Item_Templates_Rec.ATTRIBUTE_CATEGORY,
      P_Item_Templates_Rec.ATTRIBUTE1,
      P_Item_Templates_Rec.ATTRIBUTE2,
      P_Item_Templates_Rec.ATTRIBUTE3,
      P_Item_Templates_Rec.ATTRIBUTE4,
      P_Item_Templates_Rec.ATTRIBUTE5,
      P_Item_Templates_Rec.ATTRIBUTE6,
      P_Item_Templates_Rec.ATTRIBUTE7,
      P_Item_Templates_Rec.ATTRIBUTE8,
      P_Item_Templates_Rec.ATTRIBUTE9,
      P_Item_Templates_Rec.ATTRIBUTE10,
      P_Item_Templates_Rec.ATTRIBUTE11,
      P_Item_Templates_Rec.ATTRIBUTE12,
      P_Item_Templates_Rec.ATTRIBUTE13,
      P_Item_Templates_Rec.ATTRIBUTE14,
      P_Item_Templates_Rec.ATTRIBUTE15,
      P_Item_Templates_Rec.REQUEST_ID,
      P_Item_Templates_Rec.PROGRAM_APPLICATION_ID,
      P_Item_Templates_Rec.PROGRAM_ID,
      P_Item_Templates_Rec.PROGRAM_UPDATE_DATE,
      P_Item_Templates_Rec.CONTEXT_ORGANIZATION_ID,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE_CATEGORY,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE1,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE2,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE3,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE4,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE5,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE6,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE7,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE8,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE9,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE10,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE11,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE12,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE13,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE14,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE15,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE16,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE17,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE18,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE19,
      P_Item_Templates_Rec.GLOBAL_ATTRIBUTE20
)
   RETURNING ROWID INTO X_ROWID;

Line: 114

   INSERT INTO MTL_ITEM_TEMPLATES_TL (
      TEMPLATE_ID,
      TEMPLATE_NAME,
      DESCRIPTION,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      LANGUAGE,
      SOURCE_LANG)
   SELECT   P_Item_Templates_Rec.TEMPLATE_ID,
            P_Item_Templates_Rec.TEMPLATE_NAME,
            P_Item_Templates_Rec.DESCRIPTION,
            P_Item_Templates_Rec.CREATION_DATE,
            P_Item_Templates_Rec.CREATED_BY,
            P_Item_Templates_Rec.LAST_UPDATE_DATE,
            P_Item_Templates_Rec.LAST_UPDATED_BY,
            P_Item_Templates_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_TEMPLATES_TL T
                   WHERE T.TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID
                   AND   T.LANGUAGE    = L.LANGUAGE_CODE);

Line: 141

END INSERT_ROW;

Line: 146

   SELECT
        TEMPLATE_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CONTEXT_ORGANIZATION_ID
   FROM MTL_ITEM_TEMPLATES_B
   WHERE TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID;

Line: 169

   SELECT
       TEMPLATE_NAME,
       DESCRIPTION,
       DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
   FROM MTL_ITEM_TEMPLATES_TL
   WHERE TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID
   AND   USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 185

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

Line: 259

PROCEDURE UPDATE_ROW (P_Item_Templates_Rec IN  MTL_ITEM_Templates_B%ROWTYPE) IS
BEGIN
   UPDATE MTL_ITEM_TEMPLATES_B
   SET
        LAST_UPDATE_DATE = P_Item_Templates_Rec.LAST_UPDATE_DATE,
        LAST_UPDATED_BY = P_Item_Templates_Rec.LAST_UPDATED_BY,
        CREATION_DATE = P_Item_Templates_Rec.CREATION_DATE,
        CREATED_BY = P_Item_Templates_Rec.CREATED_BY,
        LAST_UPDATE_LOGIN = P_Item_Templates_Rec.LAST_UPDATE_LOGIN,
        ATTRIBUTE_CATEGORY = P_Item_Templates_Rec.ATTRIBUTE_CATEGORY,
        ATTRIBUTE1 = P_Item_Templates_Rec.ATTRIBUTE1,
        ATTRIBUTE2 = P_Item_Templates_Rec.ATTRIBUTE2,
        ATTRIBUTE3 = P_Item_Templates_Rec.ATTRIBUTE3,
        ATTRIBUTE4 = P_Item_Templates_Rec.ATTRIBUTE4,
        ATTRIBUTE5 = P_Item_Templates_Rec.ATTRIBUTE5,
        ATTRIBUTE6 = P_Item_Templates_Rec.ATTRIBUTE6,
        ATTRIBUTE7 = P_Item_Templates_Rec.ATTRIBUTE7,
        ATTRIBUTE8 = P_Item_Templates_Rec.ATTRIBUTE8,
        ATTRIBUTE9 = P_Item_Templates_Rec.ATTRIBUTE9,
        ATTRIBUTE10 = P_Item_Templates_Rec.ATTRIBUTE10,
        ATTRIBUTE11 = P_Item_Templates_Rec.ATTRIBUTE11,
        ATTRIBUTE12 = P_Item_Templates_Rec.ATTRIBUTE12,
        ATTRIBUTE13 = P_Item_Templates_Rec.ATTRIBUTE13,
        ATTRIBUTE14 = P_Item_Templates_Rec.ATTRIBUTE14,
        ATTRIBUTE15 = P_Item_Templates_Rec.ATTRIBUTE15,
        REQUEST_ID = P_Item_Templates_Rec.REQUEST_ID,
        PROGRAM_APPLICATION_ID = P_Item_Templates_Rec.PROGRAM_APPLICATION_ID,
        PROGRAM_ID = P_Item_Templates_Rec.PROGRAM_ID,
        PROGRAM_UPDATE_DATE = P_Item_Templates_Rec.PROGRAM_UPDATE_DATE ,
        CONTEXT_ORGANIZATION_ID = P_Item_Templates_Rec.CONTEXT_ORGANIZATION_ID,
        GLOBAL_ATTRIBUTE_CATEGORY = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE_CATEGORY ,
        GLOBAL_ATTRIBUTE1 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE1,
        GLOBAL_ATTRIBUTE2 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE2,
        GLOBAL_ATTRIBUTE3 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE3,
        GLOBAL_ATTRIBUTE4 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE4,
        GLOBAL_ATTRIBUTE5 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE5,
        GLOBAL_ATTRIBUTE6 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE6,
        GLOBAL_ATTRIBUTE7 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE7,
        GLOBAL_ATTRIBUTE8 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE8,
        GLOBAL_ATTRIBUTE9 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE9,
        GLOBAL_ATTRIBUTE10 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE10,
        GLOBAL_ATTRIBUTE11 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE11,
        GLOBAL_ATTRIBUTE12 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE12,
        GLOBAL_ATTRIBUTE13 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE13,
        GLOBAL_ATTRIBUTE14 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE14,
        GLOBAL_ATTRIBUTE15 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE15,
        GLOBAL_ATTRIBUTE16 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE16,
        GLOBAL_ATTRIBUTE17 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE17,
        GLOBAL_ATTRIBUTE18 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE18,
        GLOBAL_ATTRIBUTE19 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE19,
        GLOBAL_ATTRIBUTE20 = P_Item_Templates_Rec.GLOBAL_ATTRIBUTE20
   WHERE TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID;

Line: 316

   UPDATE MTL_ITEM_TEMPLATES_TL set
      TEMPLATE_NAME     = P_Item_Templates_Rec.TEMPLATE_NAME,
      DESCRIPTION       = P_Item_Templates_Rec.DESCRIPTION,
      LAST_UPDATE_DATE  = P_Item_Templates_Rec.LAST_UPDATE_DATE,
      LAST_UPDATED_BY   = P_Item_Templates_Rec.LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = P_Item_Templates_Rec.LAST_UPDATE_LOGIN,
      SOURCE_LANG       = USERENV('LANG')
   WHERE TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID
   AND  USERENV('LANG')   IN (LANGUAGE, SOURCE_LANG);

Line: 334

END UPDATE_ROW;

Line: 336

PROCEDURE DELETE_ROW (P_Template_Id IN NUMBER) IS
BEGIN

   DELETE FROM MTL_ITEM_TEMPLATES_TL
   WHERE TEMPLATE_ID = P_Template_Id;

Line: 346

   DELETE FROM MTL_ITEM_TEMPLATES_B
   WHERE TEMPLATE_ID = P_Template_Id;

Line: 356

END DELETE_ROW;

Line: 360

   DELETE FROM MTL_ITEM_TEMPLATES_TL T
   WHERE NOT EXISTS(SELECT NULL
                    FROM MTL_ITEM_TEMPLATES_B B
                    WHERE B.TEMPLATE_ID = T.TEMPLATE_ID);

Line: 365

   UPDATE MTL_ITEM_TEMPLATES_TL T
   SET (TEMPLATE_NAME,DESCRIPTION) = (SELECT B.TEMPLATE_NAME,B.DESCRIPTION
                        FROM   MTL_ITEM_TEMPLATES_TL B
                        WHERE  B.TEMPLATE_ID = T.TEMPLATE_ID
                        AND    B.LANGUAGE          = T.SOURCE_LANG)
   WHERE (T.TEMPLATE_ID,
          T.LANGUAGE) IN (SELECT SUBT.TEMPLATE_ID,
                                 SUBT.LANGUAGE
                          FROM   MTL_ITEM_TEMPLATES_TL SUBT,
                  MTL_ITEM_TEMPLATES_TL SUBB
                          WHERE  SUBB.TEMPLATE_ID = SUBT.TEMPLATE_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))
           AND (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
                                or (SUBB.TEMPLATE_NAME is null and SUBT.TEMPLATE_NAME is not null)
            or (SUBB.TEMPLATE_NAME is not null and SUBT.TEMPLATE_NAME is null)));

Line: 384

   INSERT INTO MTL_ITEM_TEMPLATES_TL (
    TEMPLATE_ID,
    TEMPLATE_NAME,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
   ) SELECT B.TEMPLATE_ID,
            B.TEMPLATE_NAME,
            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_TEMPLATES_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_TEMPLATES_TL T
                      WHERE T.TEMPLATE_ID = B.TEMPLATE_ID
                      AND T.LANGUAGE      = L.LANGUAGE_CODE);