APPS.BOM_STRUCTURE_TYPES_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Structure_Type_Name         VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Item_Catalog_Group_Id          NUMBER,
                       X_Effective_Date                 DATE,
                       X_Structure_Creation_Allowed     VARCHAR2,
                       X_Allow_Subtypes     VARCHAR2,
                       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2,
                       X_Disable_Date                   VARCHAR2,
                       X_Parent_Structure_Type_Id       NUMBER,
                       X_Enable_Attachments_Flag        VARCHAR2,
                       X_Display_Name                   VARCHAR2,
                       X_Description                    VARCHAR2,
                       X_Upload_mode                    VARCHAR2,
                       X_Custom_mode      VARCHAR2,
                       X_Owner        VARCHAR2
                      )
                      IS
  BEGIN
    declare
      srv_id number;

Line: 45

      f_ludate  date;    -- entity update date in file

Line: 47

      db_ludate date;    -- entity update date in db

Line: 54

        UPDATE BOM_STRUCTURE_TYPES_TL
          SET
            DISPLAY_NAME      = X_Display_Name,
            DESCRIPTION       = X_Description,
            LAST_UPDATE_DATE  = X_Last_Update_Date,
            LAST_UPDATED_BY   = X_Last_Updated_By,
            LAST_UPDATE_LOGIN = X_Last_Update_Login,
            SOURCE_LANG       = USERENV('LANG')
          WHERE STRUCTURE_TYPE_ID = (SELECT STRUCTURE_TYPE_ID FROM  BOM_STRUCTURE_TYPES_B
                                     WHERE  STRUCTURE_TYPE_NAME = X_Structure_Type_Name)
            AND USERENV('LANG') IN (LANGUAGE,SOURCE_LANG);

Line: 71

        f_ludate := nvl(X_Last_Update_Date, sysdate);

Line: 77

          SELECT LAST_UPDATED_BY,LAST_UPDATE_DATE
            INTO db_luby, db_ludate
          FROM BOM_STRUCTURE_TYPES_B
          WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name;

Line: 94

            SELECT BOM_STRUCTURE_TYPES_B_S.nextval INTO str_id FROM dual;

Line: 96

            INSERT INTO BOM_STRUCTURE_TYPES_B
            (
            STRUCTURE_TYPE_ID,
            STRUCTURE_TYPE_NAME,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_LOGIN,
            ITEM_CATALOG_GROUP_ID,
            EFFECTIVE_DATE,
            STRUCTURE_CREATION_ALLOWED,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            DISABLE_DATE,
            PARENT_STRUCTURE_TYPE_ID,
            ENABLE_ATTACHMENTS_FLAG,
            ALLOW_SUBTYPES
            )
            SELECT
            str_id,
            X_Structure_Type_Name,
            SYSDATE,
            X_Last_Updated_By,
            SYSDATE,
            X_Created_By,
            X_Last_Update_Login,
            X_Item_Catalog_Group_Id,
            SYSDATE,
            X_Structure_Creation_Allowed,
            X_Attribute_Category,
            X_Attribute1,
            X_Attribute2,
            X_Attribute3,
            X_Attribute4,
            X_Attribute5,
            X_Attribute6,
            X_Attribute7,
            X_Attribute8,
            X_Attribute9,
            X_Attribute10,
            X_Attribute11,
            X_Attribute12,
            X_Attribute13,
            X_Attribute14,
            X_Attribute15,
            X_Disable_Date,
            X_Parent_Structure_Type_Id,
            X_Enable_Attachments_Flag,
            X_Allow_Subtypes
            FROM DUAL
            WHERE  NOT EXISTS (SELECT 1  from BOM_STRUCTURE_TYPES_B
                     WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name );

Line: 165

            INSERT INTO BOM_STRUCTURE_TYPES_TL
            ( STRUCTURE_TYPE_ID,
            LANGUAGE,
            SOURCE_LANG,
            DISPLAY_NAME,
            DESCRIPTION,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE ,
            CREATED_BY,
            LAST_UPDATE_LOGIN
            )
            SELECT
            str_id,
            L.LANGUAGE_CODE,
            USERENV('LANG'),
            X_Display_Name,
            X_Description,
            SYSDATE,
            X_Last_Updated_By,
            SYSDATE,
            X_Created_By,
            X_Last_Update_Login
            FROM FND_LANGUAGES L
            WHERE L.INSTALLED_FLAG IN ('I','B')
            AND NOT EXISTS
            (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL,BOM_STRUCTURE_TYPES_B B
              WHERE B.STRUCTURE_TYPE_ID  = TL.STRUCTURE_TYPE_ID
              AND B.STRUCTURE_TYPE_NAME = X_Structure_Type_Name
              AND  TL.LANGUAGE = L.LANGUAGE_CODE);

Line: 196

        END IF;  -- End of IF for Insert into B and TL

Line: 202

            UPDATE BOM_STRUCTURE_TYPES_B
              SET
              ITEM_CATALOG_GROUP_ID        = X_Item_Catalog_Group_Id,
              EFFECTIVE_DATE               = X_Effective_Date,
              STRUCTURE_CREATION_ALLOWED   = X_Structure_Creation_Allowed,
              ALLOW_SUBTYPES               = X_Allow_Subtypes,
              LAST_UPDATE_DATE             = X_Last_Update_Date,
              LAST_UPDATED_BY              = X_Last_Updated_By,
              LAST_UPDATE_LOGIN            = X_Last_Update_Login,
              ATTRIBUTE_CATEGORY           = X_Attribute_Category ,
              ATTRIBUTE1                   = X_Attribute1,
              ATTRIBUTE2                   = X_Attribute2,
              ATTRIBUTE3                   = X_Attribute3,
              ATTRIBUTE4                   = X_Attribute4,
              ATTRIBUTE5                   = X_Attribute5,
              ATTRIBUTE6                   = X_Attribute6,
              ATTRIBUTE7                   = X_Attribute7,
              ATTRIBUTE8                   = X_Attribute8,
              ATTRIBUTE9                   = X_Attribute9,
              ATTRIBUTE10                  = X_Attribute10,
              ATTRIBUTE11                  = X_Attribute11,
              ATTRIBUTE12                  = X_Attribute12,
              ATTRIBUTE13                  = X_Attribute13,
              ATTRIBUTE14                  = X_Attribute14,
              ATTRIBUTE15                  = X_Attribute15,
              DISABLE_DATE                 = X_Disable_Date,
              PARENT_STRUCTURE_TYPE_ID     = X_Parent_Structure_Type_Id,
              ENABLE_ATTACHMENTS_FLAG      = X_Enable_Attachments_Flag
            WHERE
               STRUCTURE_TYPE_NAME    = X_Structure_Type_Name;

Line: 234

            UPDATE BOM_STRUCTURE_TYPES_TL
              SET
              DISPLAY_NAME      = X_Display_Name,
              DESCRIPTION       = X_Description,
              LAST_UPDATE_DATE  = X_Last_Update_Date,
              LAST_UPDATED_BY   = X_Last_Updated_By,
              LAST_UPDATE_LOGIN = X_Last_Update_Login,
              SOURCE_LANG       = USERENV('LANG')
            WHERE STRUCTURE_TYPE_ID =
              (SELECT STRUCTURE_TYPE_ID FROM  BOM_STRUCTURE_TYPES_B
               WHERE  STRUCTURE_TYPE_NAME = X_Structure_Type_Name)
               AND USERENV('LANG') IN (LANGUAGE,SOURCE_LANG);

Line: 247

        END IF; -- End of Test for Updates

Line: 250

  END Insert_Row;

Line: 259

       INSERT INTO BOM_STRUCTURE_TYPES_TL
          (
            STRUCTURE_TYPE_ID,
            LANGUAGE,
            SOURCE_LANG,
            DISPLAY_NAME,
            DESCRIPTION,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE ,
            CREATED_BY,
            LAST_UPDATE_LOGIN
            )
            SELECT
              B.structure_type_id,
              L.LANGUAGE_CODE,
              userenv('LANG'),
              B.DISPLAY_NAME,
              B.DESCRIPTION,
              SYSDATE,
              B.LAST_UPDATED_BY,
              SYSDATE,
              B.CREATED_BY,
              B.LAST_UPDATE_LOGIN
            FROM FND_LANGUAGES L,
                 BOM_STRUCTURE_TYPES_TL B
            WHERE L.INSTALLED_FLAG IN ('I','B')
                 AND NOT EXISTS
                   (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL
                      WHERE TL.STRUCTURE_TYPE_ID =   B.STRUCTURE_TYPE_ID
                 AND  TL.LANGUAGE = L.LANGUAGE_CODE);

Line: 295

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_STRUCTURE_TYPE_ID in NUMBER,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_DISABLE_DATE in DATE,
  X_STRUCTURE_TYPE_NAME in VARCHAR2,
  X_ITEM_CATALOG_GROUP_ID in NUMBER,
  X_EFFECTIVE_DATE in DATE,
  X_STRUCTURE_CREATION_ALLOWED in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_PARENT_STRUCTURE_TYPE_ID in NUMBER,
  X_ENABLE_ATTACHMENTS_FLAG in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ENABLE_UNIMPLEMENTED_BOMS IN VARCHAR2,
  X_ALLOW_SUBTYPES IN VARCHAR2

) is
  cursor C is select ROWID from BOM_STRUCTURE_TYPES_B
    where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
    ;

Line: 336

  insert into BOM_STRUCTURE_TYPES_B (
    ATTRIBUTE12,
    ATTRIBUTE13,
    DISABLE_DATE,
    STRUCTURE_TYPE_ID,
    STRUCTURE_TYPE_NAME,
    ITEM_CATALOG_GROUP_ID,
    EFFECTIVE_DATE,
    STRUCTURE_CREATION_ALLOWED,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE14,
    ATTRIBUTE15,
    PARENT_STRUCTURE_TYPE_ID,
    ENABLE_ATTACHMENTS_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ENABLE_UNIMPLEMENTED_BOMS,
    ALLOW_SUBTYPES
  ) values (
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_DISABLE_DATE,
    X_STRUCTURE_TYPE_ID,
    X_STRUCTURE_TYPE_NAME,
    X_ITEM_CATALOG_GROUP_ID,
    X_EFFECTIVE_DATE,
    X_STRUCTURE_CREATION_ALLOWED,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_PARENT_STRUCTURE_TYPE_ID,
    X_ENABLE_ATTACHMENTS_FLAG,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ENABLE_UNIMPLEMENTED_BOMS,
    X_ALLOW_SUBTYPES
  );

Line: 402

  insert into BOM_STRUCTURE_TYPES_TL (
    LAST_UPDATE_LOGIN,
    STRUCTURE_TYPE_ID,
    CREATED_BY,
    LAST_UPDATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    DISPLAY_NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_LAST_UPDATE_LOGIN,
    X_STRUCTURE_TYPE_ID,
    X_CREATED_BY,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_DATE,
    X_DISPLAY_NAME,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from BOM_STRUCTURE_TYPES_TL T
    where T.STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 440

end INSERT_ROW;

Line: 472

  cursor c is select
      ATTRIBUTE12,
      ATTRIBUTE13,
      DISABLE_DATE,
      STRUCTURE_TYPE_NAME,
      ITEM_CATALOG_GROUP_ID,
      EFFECTIVE_DATE,
      STRUCTURE_CREATION_ALLOWED,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE14,
      ATTRIBUTE15,
      PARENT_STRUCTURE_TYPE_ID,
      ENABLE_ATTACHMENTS_FLAG,
      ENABLE_UNIMPLEMENTED_BOMS,
      ALLOW_SUBTYPES
    from BOM_STRUCTURE_TYPES_B
    where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
    for update of STRUCTURE_TYPE_ID nowait;

Line: 503

  cursor c1 is select
      DISPLAY_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from BOM_STRUCTURE_TYPES_TL
    where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of STRUCTURE_TYPE_ID nowait;

Line: 516

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

Line: 591

procedure UPDATE_ROW (
  X_STRUCTURE_TYPE_ID in NUMBER,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_DISABLE_DATE in DATE,
  X_STRUCTURE_TYPE_NAME in VARCHAR2,
  X_ITEM_CATALOG_GROUP_ID in NUMBER,
  X_EFFECTIVE_DATE in DATE,
  X_STRUCTURE_CREATION_ALLOWED in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_PARENT_STRUCTURE_TYPE_ID in NUMBER,
  X_ENABLE_ATTACHMENTS_FLAG in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ENABLE_UNIMPLEMENTED_BOMS in VARCHAR2,
  X_ALLOW_SUBTYPES in VARCHAR2
) is
begin
  update BOM_STRUCTURE_TYPES_B set
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    DISABLE_DATE = X_DISABLE_DATE,
    STRUCTURE_TYPE_NAME = X_STRUCTURE_TYPE_NAME,
    ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID,
    EFFECTIVE_DATE = X_EFFECTIVE_DATE,
    STRUCTURE_CREATION_ALLOWED = X_STRUCTURE_CREATION_ALLOWED,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    PARENT_STRUCTURE_TYPE_ID = X_PARENT_STRUCTURE_TYPE_ID,
    ENABLE_ATTACHMENTS_FLAG = X_ENABLE_ATTACHMENTS_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    ENABLE_UNIMPLEMENTED_BOMS = X_ENABLE_UNIMPLEMENTED_BOMS,
    ALLOW_SUBTYPES = X_ALLOW_SUBTYPES
  where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID;

Line: 660

  update BOM_STRUCTURE_TYPES_TL set
    DISPLAY_NAME = X_DISPLAY_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 673

end UPDATE_ROW;

Line: 675

procedure DELETE_ROW (
  X_STRUCTURE_TYPE_ID in NUMBER
) is
begin
  delete from BOM_STRUCTURE_TYPES_TL
  where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID;

Line: 686

  delete from BOM_STRUCTURE_TYPES_B
  where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID;

Line: 692

end DELETE_ROW;

Line: 697

  delete from BOM_STRUCTURE_TYPES_TL T
  where not exists
    (select NULL
    from BOM_STRUCTURE_TYPES_B B
    where B.STRUCTURE_TYPE_ID = T.STRUCTURE_TYPE_ID
    );

Line: 704

  update BOM_STRUCTURE_TYPES_TL T set (
      DISPLAY_NAME,
      DESCRIPTION
    ) = (select
      B.DISPLAY_NAME,
      B.DESCRIPTION
    from BOM_STRUCTURE_TYPES_TL B
    where B.STRUCTURE_TYPE_ID = T.STRUCTURE_TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.STRUCTURE_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.STRUCTURE_TYPE_ID,
      SUBT.LANGUAGE
    from BOM_STRUCTURE_TYPES_TL SUBB, BOM_STRUCTURE_TYPES_TL SUBT
    where SUBB.STRUCTURE_TYPE_ID = SUBT.STRUCTURE_TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
      or 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: 728

  insert into BOM_STRUCTURE_TYPES_TL (
    CREATED_BY,
    LAST_UPDATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    DISPLAY_NAME,
    DESCRIPTION,
    LAST_UPDATE_LOGIN,
    STRUCTURE_TYPE_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.CREATED_BY,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATE_DATE,
    B.DISPLAY_NAME,
    B.DESCRIPTION,
    B.LAST_UPDATE_LOGIN,
    B.STRUCTURE_TYPE_ID,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from BOM_STRUCTURE_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from BOM_STRUCTURE_TYPES_TL T
    where T.STRUCTURE_TYPE_ID = B.STRUCTURE_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 768

    /* SELECT structure_type_id
    FROM bom_structure_types_b
    CONNECT BY PRIOR structure_type_id = parent_structure_type_id
    START WITH parent_structure_Type_id = c_p_parent_structure_type_id ;

Line: 773

   SELECT structure_type_id
   FROM bom_structure_types_b
   CONNECT BY PRIOR parent_structure_type_id = structure_type_id
   START WITH structure_type_id = c_p_parent_structure_type_id;

Line: 782

   SELECT parent_structure_type_id INTO l_struct_type_id_orig
   FROM bom_structure_types_b
   WHERE structure_type_id = p_structure_type_id;