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.JTFB_AK_REGION_ITEMS_PKG SQL Statements

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

Line: 5


procedure INSERT_ROW (
  X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_ATTRIBUTE_APPLICATION_ID in NUMBER,
  X_ATTRIBUTE_CODE in VARCHAR2,
  X_DISPLAY_SEQUENCE in NUMBER,
  X_NODE_DISPLAY_FLAG in VARCHAR2,
  X_NODE_QUERY_FLAG in VARCHAR2,
  X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
  X_BOLD in VARCHAR2,
  X_ITALIC in VARCHAR2,
  X_VERTICAL_ALIGNMENT in VARCHAR2,
  X_HORIZONTAL_ALIGNMENT in VARCHAR2 default 'LEFT',
  X_ITEM_STYLE in VARCHAR2,
  X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
  X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_SECURITY_CODE in VARCHAR2,
  X_UPDATE_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_DISPLAY_VALUE_LENGTH in NUMBER,
  X_LOV_REGION_APPLICATION_ID in NUMBER,
  X_LOV_REGION_CODE in VARCHAR2,
  X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
  X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
  X_LOV_ATTRIBUTE_CODE in VARCHAR2,
  X_LOV_DEFAULT_FLAG in VARCHAR2,
  X_REGION_DEFAULTING_API_PKG in VARCHAR2,
  X_REGION_DEFAULTING_API_PROC in VARCHAR2,
  X_REGION_VALIDATION_API_PKG in VARCHAR2,
  X_REGION_VALIDATION_API_PROC in VARCHAR2,
  X_ORDER_SEQUENCE in NUMBER,
  X_ORDER_DIRECTION in VARCHAR2,
  X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
  X_DEFAULT_VALUE_NUMBER in NUMBER,
  X_DEFAULT_VALUE_DATE in DATE,
  X_ITEM_NAME IN VARCHAR2,
  X_DISPLAY_HEIGHT IN NUMBER,
  X_SUBMIT IN VARCHAR2,
  X_ENCRYPT IN VARCHAR2,
  X_VIEW_USAGE_NAME IN VARCHAR2,
  X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
  X_CSS_CLASS_NAME IN VARCHAR2,
  X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
  X_URL IN VARCHAR2,
  X_POPLIST_VIEWOBJECT IN VARCHAR2,
  X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
  X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
  X_IMAGE_FILE_NAME IN VARCHAR2,
  X_NESTED_REGION_CODE IN VARCHAR2,
  X_NESTED_REGION_APPL_ID IN NUMBER,
  X_MENU_NAME IN VARCHAR2,
  X_FLEXFIELD_NAME IN VARCHAR2,
  X_FLEXFIELD_APPLICATION_ID IN NUMBER,
  X_TABULAR_FUNCTION_CODE IN VARCHAR2,
  X_TIP_TYPE IN VARCHAR2,
  X_TIP_MESSAGE_NAME VARCHAR2,
  X_TIP_MESSAGE_APPLICATION_ID NUMBER,
  X_FLEX_SEGMENT_LIST VARCHAR2,
  X_ENTITY_ID VARCHAR2,
  X_ANCHOR VARCHAR2,
  X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
  X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2 := NULL,
  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_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_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2
) is
  cursor C is select ROWID from AK_REGION_ITEMS
    where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and REGION_CODE = X_REGION_CODE
    and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
    and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 105


  insert into AK_REGION_ITEMS (
    REGION_APPLICATION_ID,
    REGION_CODE,
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    DISPLAY_SEQUENCE,
   NODE_DISPLAY_FLAG,
    NODE_QUERY_FLAG,
    ATTRIBUTE_LABEL_LENGTH,
    BOLD,
    ITALIC,
    VERTICAL_ALIGNMENT,
    HORIZONTAL_ALIGNMENT,
    ITEM_STYLE,
    OBJECT_ATTRIBUTE_FLAG,
    SECURITY_CODE,
    UPDATE_FLAG,
    REQUIRED_FLAG,
    DISPLAY_VALUE_LENGTH,
    LOV_REGION_APPLICATION_ID,
    LOV_REGION_CODE,
    LOV_FOREIGN_KEY_NAME,
    LOV_ATTRIBUTE_APPLICATION_ID,
    LOV_ATTRIBUTE_CODE,
    LOV_DEFAULT_FLAG,
    REGION_DEFAULTING_API_PKG,
    REGION_DEFAULTING_API_PROC,
    REGION_VALIDATION_API_PKG,
    REGION_VALIDATION_API_PROC,
   ORDER_SEQUENCE,
   ORDER_DIRECTION,
   DEFAULT_VALUE_VARCHAR2,
   DEFAULT_VALUE_NUMBER,
   DEFAULT_VALUE_DATE,
   DISPLAY_HEIGHT,
   SUBMIT,
   ENCRYPT,
   VIEW_USAGE_NAME,
   VIEW_ATTRIBUTE_NAME,
   CSS_CLASS_NAME,
   CSS_LABEL_CLASS_NAME,
   URL,
   POPLIST_VIEWOBJECT,
   POPLIST_DISPLAY_ATTRIBUTE,
   POPLIST_VALUE_ATTRIBUTE,
   IMAGE_FILE_NAME,
   NESTED_REGION_CODE,
   NESTED_REGION_APPLICATION_ID,
   ITEM_NAME,
   MENU_NAME,
   FLEXFIELD_NAME,
   FLEXFIELD_APPLICATION_ID,
        TABULAR_FUNCTION_CODE,
        TIP_TYPE,
        TIP_MESSAGE_NAME,
        TIP_MESSAGE_APPLICATION_ID,
      FLEX_SEGMENT_LIST,
      ENTITY_ID,
      ANCHOR,
      POPLIST_VIEW_USAGE_NAME,
        SORTBY_VIEW_ATTRIBUTE_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ADMIN_CUSTOMIZABLE
  ) values (
    X_REGION_APPLICATION_ID,
    X_REGION_CODE,
    X_ATTRIBUTE_APPLICATION_ID,
    X_ATTRIBUTE_CODE,
    X_DISPLAY_SEQUENCE,
    X_NODE_DISPLAY_FLAG,
    X_NODE_QUERY_FLAG,
    X_ATTRIBUTE_LABEL_LENGTH,
    X_BOLD,
    X_ITALIC,
    X_VERTICAL_ALIGNMENT,
    L_HORIZONTAL_ALIGNMENT,
    X_ITEM_STYLE,
    X_OBJECT_ATTRIBUTE_FLAG,
    X_SECURITY_CODE,
    X_UPDATE_FLAG,
    X_REQUIRED_FLAG,
    X_DISPLAY_VALUE_LENGTH,
    X_LOV_REGION_APPLICATION_ID,
    X_LOV_REGION_CODE,
    X_LOV_FOREIGN_KEY_NAME,
    X_LOV_ATTRIBUTE_APPLICATION_ID,
    X_LOV_ATTRIBUTE_CODE,
    X_LOV_DEFAULT_FLAG,
    X_REGION_DEFAULTING_API_PKG,
    X_REGION_DEFAULTING_API_PROC,
    X_REGION_VALIDATION_API_PKG,
    X_REGION_VALIDATION_API_PROC,
   X_ORDER_SEQUENCE,
   X_ORDER_DIRECTION,
   X_DEFAULT_VALUE_VARCHAR2,
   X_DEFAULT_VALUE_NUMBER,
   X_DEFAULT_VALUE_DATE,
   X_DISPLAY_HEIGHT,
   X_SUBMIT,
   X_ENCRYPT,
   X_VIEW_USAGE_NAME,
   X_VIEW_ATTRIBUTE_NAME,
   X_CSS_CLASS_NAME,
   X_CSS_LABEL_CLASS_NAME,
   X_URL,
   X_POPLIST_VIEWOBJECT,
   X_POPLIST_DISPLAY_ATTRIBUTE,
   X_POPLIST_VALUE_ATTRIBUTE,
   X_IMAGE_FILE_NAME,
   X_NESTED_REGION_CODE,
   X_NESTED_REGION_APPL_ID,
   X_ITEM_NAME,
   X_MENU_NAME,
   X_FLEXFIELD_NAME,
   X_FLEXFIELD_APPLICATION_ID,
        X_TABULAR_FUNCTION_CODE,
        X_TIP_TYPE,
        X_TIP_MESSAGE_NAME,
        X_TIP_MESSAGE_APPLICATION_ID,
      X_FLEX_SEGMENT_LIST,
      X_ENTITY_ID,
      X_ANCHOR,
      X_POPLIST_VIEW_USAGE_NAME,
        X_SORTBY_VIEW_ATTRIBUTE_NAME,

    sysdate,
    fnd_global.user_id,
    sysdate,
    fnd_global.user_id,
    fnd_global.login_id,

    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,
    'Y'  -- ADMIN_CUSTOMIZABLE
  );

Line: 283


  insert into AK_REGION_ITEMS_TL (
    REGION_APPLICATION_ID,
    REGION_CODE,
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    LANGUAGE,
    ATTRIBUTE_LABEL_LONG,
    DESCRIPTION,
    SOURCE_LANG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) select
    X_REGION_APPLICATION_ID,
    X_REGION_CODE,
    X_ATTRIBUTE_APPLICATION_ID,
    X_ATTRIBUTE_CODE,
    L.LANGUAGE_CODE,
    X_ATTRIBUTE_LABEL_LONG,
    X_DESCRIPTION,
    userenv('LANG'),

    fnd_global.user_id,
    sysdate,
    fnd_global.user_id,
    sysdate,
    fnd_global.login_id

  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AK_REGION_ITEMS_TL T
    where T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and T.REGION_CODE = X_REGION_CODE
    and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
    and T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 323


end INSERT_ROW;

Line: 359


  X_UPDATE_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_DISPLAY_VALUE_LENGTH in NUMBER,
  X_LOV_REGION_APPLICATION_ID in NUMBER,
  X_LOV_REGION_CODE in VARCHAR2,
  X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
  X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
  X_LOV_ATTRIBUTE_CODE in VARCHAR2,
  X_LOV_DEFAULT_FLAG in VARCHAR2,
  X_REGION_DEFAULTING_API_PKG in VARCHAR2,
  X_REGION_DEFAULTING_API_PROC in VARCHAR2,
  X_REGION_VALIDATION_API_PKG in VARCHAR2,
  X_REGION_VALIDATION_API_PROC in VARCHAR2,
  X_ORDER_SEQUENCE in NUMBER,
  X_ORDER_DIRECTION in VARCHAR2,
  X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
  X_DEFAULT_VALUE_NUMBER in NUMBER,
  X_DEFAULT_VALUE_DATE in DATE,
  X_ITEM_NAME in VARCHAR2,
  X_DISPLAY_HEIGHT IN NUMBER,
  X_SUBMIT IN VARCHAR2,
  X_ENCRYPT IN VARCHAR2,
  X_VIEW_USAGE_NAME IN VARCHAR2,
  X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
  X_CSS_CLASS_NAME IN VARCHAR2,
  X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
  X_URL IN VARCHAR2,
  X_POPLIST_VIEWOBJECT IN VARCHAR2,
  X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
  X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
  X_IMAGE_FILE_NAME IN VARCHAR2,
  X_NESTED_REGION_CODE IN VARCHAR2,
  X_NESTED_REGION_APPL_ID IN NUMBER,
  X_MENU_NAME IN VARCHAR2,
  X_FLEXFIELD_NAME IN VARCHAR2,
  X_FLEXFIELD_APPLICATION_ID NUMBER,
  X_TABULAR_FUNCTION_CODE IN VARCHAR2,
  X_TIP_TYPE IN VARCHAR2,
  X_TIP_MESSAGE_NAME VARCHAR2,
  X_TIP_MESSAGE_APPLICATION_ID NUMBER,
  X_FLEX_SEGMENT_LIST VARCHAR2,
  X_ENTITY_ID VARCHAR2,
  X_ANCHOR VARCHAR2,
  X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
  X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2
) is
  cursor c is select
      OBJECT_ATTRIBUTE_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      DISPLAY_SEQUENCE,
     NODE_DISPLAY_FLAG,
      NODE_QUERY_FLAG,
      ATTRIBUTE_LABEL_LENGTH,
      BOLD,
      ITALIC,
      VERTICAL_ALIGNMENT,
      HORIZONTAL_ALIGNMENT,
      SECURITY_CODE,
      UPDATE_FLAG,
      REQUIRED_FLAG,
      DISPLAY_VALUE_LENGTH,
      LOV_REGION_APPLICATION_ID,
      LOV_REGION_CODE,
      LOV_FOREIGN_KEY_NAME,
      LOV_ATTRIBUTE_APPLICATION_ID,
      LOV_ATTRIBUTE_CODE,
      LOV_DEFAULT_FLAG,
      REGION_DEFAULTING_API_PKG,
      REGION_DEFAULTING_API_PROC,
      REGION_VALIDATION_API_PKG,
      REGION_VALIDATION_API_PROC,
     ORDER_SEQUENCE,
     ORDER_DIRECTION,
     DEFAULT_VALUE_VARCHAR2,
     DEFAULT_VALUE_NUMBER,
     DEFAULT_VALUE_DATE,
      ITEM_STYLE,
     DISPLAY_HEIGHT,
     SUBMIT,
     ENCRYPT,
     VIEW_USAGE_NAME,
     VIEW_ATTRIBUTE_NAME,
     CSS_CLASS_NAME,
     CSS_LABEL_CLASS_NAME,
     URL,
     POPLIST_VIEWOBJECT,
     POPLIST_DISPLAY_ATTRIBUTE,
     POPLIST_VALUE_ATTRIBUTE,
     IMAGE_FILE_NAME,
     NESTED_REGION_CODE,
     NESTED_REGION_APPLICATION_ID,
     ITEM_NAME,
     MENU_NAME,
     FLEXFIELD_NAME,
     FLEXFIELD_APPLICATION_ID,
     TABULAR_FUNCTION_CODE,
     TIP_TYPE,
     TIP_MESSAGE_NAME,
     TIP_MESSAGE_APPLICATION_ID,
     FLEX_SEGMENT_LIST,
     ENTITY_ID,
     ANCHOR,
     POPLIST_VIEW_USAGE_NAME,
      SORTBY_VIEW_ATTRIBUTE_NAME
    from AK_REGION_ITEMS
    where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and REGION_CODE = X_REGION_CODE
    and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
    and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
    for update of REGION_APPLICATION_ID nowait;

Line: 486


  cursor c1 is select
      ATTRIBUTE_LABEL_LONG,
      DESCRIPTION
    from AK_REGION_ITEMS_TL
    where REGION_CODE = X_REGION_CODE
    and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
    and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
    and LANGUAGE = userenv('LANG')
    for update of REGION_CODE nowait;

Line: 503


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

Line: 567


      AND (recinfo.UPDATE_FLAG = X_UPDATE_FLAG)
      AND (recinfo.REQUIRED_FLAG = X_REQUIRED_FLAG)
      AND (recinfo.DISPLAY_VALUE_LENGTH = X_DISPLAY_VALUE_LENGTH)
      and ((recinfo.LOV_REGION_APPLICATION_ID = x_LOV_REGION_APPLICATION_ID)
           or ((recinfo.LOV_REGION_APPLICATION_ID is null)
          and (x_LOV_REGION_APPLICATION_ID is null)))
      and ((recinfo.LOV_REGION_CODE = x_LOV_REGION_CODE)
           or ((recinfo.LOV_REGION_CODE is null)
          and (x_LOV_REGION_CODE is null)))
      and ((recinfo.LOV_FOREIGN_KEY_NAME = x_LOV_FOREIGN_KEY_NAME)
           or ((recinfo.LOV_FOREIGN_KEY_NAME is null)
          and (x_LOV_FOREIGN_KEY_NAME is null)))
      and ((recinfo.LOV_ATTRIBUTE_APPLICATION_ID = x_LOV_ATTRIBUTE_APPLICATION_ID)
           or ((recinfo.LOV_ATTRIBUTE_APPLICATION_ID is null)
          and (x_LOV_ATTRIBUTE_APPLICATION_ID is null)))
      and ((recinfo.LOV_ATTRIBUTE_CODE = x_LOV_ATTRIBUTE_CODE)
           or ((recinfo.LOV_ATTRIBUTE_CODE is null)
          and (x_LOV_ATTRIBUTE_CODE is null)))
      and ((recinfo.LOV_DEFAULT_FLAG = x_LOV_DEFAULT_FLAG)
           or ((recinfo.LOV_DEFAULT_FLAG is null)
          and (x_LOV_DEFAULT_FLAG is null)))
      and ((recinfo.REGION_DEFAULTING_API_PKG = x_REGION_DEFAULTING_API_PKG)
           or ((recinfo.REGION_DEFAULTING_API_PKG is null)
          and (x_REGION_DEFAULTING_API_PKG is null)))
      and ((recinfo.REGION_DEFAULTING_API_PROC = x_REGION_DEFAULTING_API_PROC)
           or ((recinfo.REGION_DEFAULTING_API_PROC is null)
          and (x_REGION_DEFAULTING_API_PROC is null)))
      and ((recinfo.REGION_VALIDATION_API_PKG = x_REGION_VALIDATION_API_PKG)
           or ((recinfo.REGION_VALIDATION_API_PKG is null)
          and (x_REGION_VALIDATION_API_PKG is null)))
      and ((recinfo.REGION_VALIDATION_API_PROC = x_REGION_VALIDATION_API_PROC)
           or ((recinfo.REGION_VALIDATION_API_PROC is null)
          and (x_REGION_VALIDATION_API_PROC is null)))
      and ((recinfo.ORDER_SEQUENCE = x_ORDER_SEQUENCE)
           or ((recinfo.ORDER_SEQUENCE is null)
          and (x_ORDER_SEQUENCE is null)))
      and ((recinfo.ORDER_DIRECTION = x_ORDER_DIRECTION)
           or ((recinfo.ORDER_DIRECTION is null)
          and (x_ORDER_DIRECTION is null)))
      and ((recinfo.DEFAULT_VALUE_VARCHAR2 = x_DEFAULT_VALUE_VARCHAR2)
           or ((recinfo.DEFAULT_VALUE_VARCHAR2 is null)
          and (x_DEFAULT_VALUE_VARCHAR2 is null)))
      and ((recinfo.DEFAULT_VALUE_NUMBER = x_DEFAULT_VALUE_NUMBER)
           or ((recinfo.DEFAULT_VALUE_NUMBER is null)
          and (x_DEFAULT_VALUE_NUMBER is null)))
      and ((recinfo.DEFAULT_VALUE_DATE = x_DEFAULT_VALUE_DATE)
           or ((recinfo.DEFAULT_VALUE_DATE is null)
          and (x_DEFAULT_VALUE_DATE is null)))
      AND (recinfo.ITEM_STYLE = X_ITEM_STYLE)
      and ((recinfo.DISPLAY_HEIGHT = X_DISPLAY_HEIGHT)
           or ((recinfo.DISPLAY_HEIGHT is null)
          and (X_DISPLAY_HEIGHT is null)))
      and ((recinfo.SUBMIT = X_SUBMIT)
           or ((recinfo.SUBMIT is null)
          and (X_SUBMIT is null)))
      and ((recinfo.ENCRYPT = X_ENCRYPT)
           or ((recinfo.ENCRYPT is null)
          and (X_ENCRYPT is null)))
      and ((recinfo.VIEW_USAGE_NAME = X_VIEW_USAGE_NAME)
           or ((recinfo.VIEW_USAGE_NAME is null)
          and (X_VIEW_USAGE_NAME is null)))
      and ((recinfo.VIEW_ATTRIBUTE_NAME = X_VIEW_ATTRIBUTE_NAME)
           or ((recinfo.VIEW_ATTRIBUTE_NAME is null)
          and (X_VIEW_ATTRIBUTE_NAME is null)))
      and ((recinfo.CSS_CLASS_NAME = X_CSS_CLASS_NAME)
           or ((recinfo.CSS_CLASS_NAME is null)
          and (X_CSS_CLASS_NAME is null)))
      and ((recinfo.CSS_LABEL_CLASS_NAME = X_CSS_LABEL_CLASS_NAME)
           or ((recinfo.CSS_LABEL_CLASS_NAME is null)
          and (X_CSS_LABEL_CLASS_NAME is null)))
      and ((recinfo.URL = X_URL)
           or ((recinfo.URL is null)
          and (X_URL is null)))
      and ((recinfo.POPLIST_VIEWOBJECT = X_POPLIST_VIEWOBJECT)
           or ((recinfo.POPLIST_VIEWOBJECT is null)
          and (X_POPLIST_VIEWOBJECT is null)))
      and ((recinfo.POPLIST_DISPLAY_ATTRIBUTE = X_POPLIST_DISPLAY_ATTRIBUTE)
           or ((recinfo.POPLIST_DISPLAY_ATTRIBUTE is null)
               and (X_POPLIST_DISPLAY_ATTRIBUTE is null)))
      and ((recinfo.POPLIST_VALUE_ATTRIBUTE = X_POPLIST_VALUE_ATTRIBUTE)
           or ((recinfo.POPLIST_VALUE_ATTRIBUTE is null)
               and (X_POPLIST_VALUE_ATTRIBUTE is null)))
      and ((recinfo.IMAGE_FILE_NAME = X_IMAGE_FILE_NAME)
           or ((recinfo.IMAGE_FILE_NAME is null)
          and (X_IMAGE_FILE_NAME is null)))
      and ((recinfo.NESTED_REGION_APPLICATION_ID = X_NESTED_REGION_APPL_ID)
           or ((recinfo.NESTED_REGION_APPLICATION_ID is null)
          and (X_NESTED_REGION_APPL_ID is null)))
      and ((recinfo.NESTED_REGION_CODE = X_NESTED_REGION_CODE)
           or ((recinfo.NESTED_REGION_CODE is null)
          and (X_NESTED_REGION_CODE is null)))
      and ((recinfo.ITEM_NAME = X_ITEM_NAME)
           or ((recinfo.ITEM_NAME is null)
               and (X_ITEM_NAME is null)))
      and ((recinfo.MENU_NAME = X_MENU_NAME)
           or ((recinfo.MENU_NAME is null)
               and (X_MENU_NAME is null)))
      and ((recinfo.FLEXFIELD_NAME = X_FLEXFIELD_NAME)
           or ((recinfo.FLEXFIELD_NAME is null)
               and (X_FLEXFIELD_NAME is null)))
      and ((recinfo.FLEXFIELD_APPLICATION_ID = X_FLEXFIELD_APPLICATION_ID)
           or ((recinfo.FLEXFIELD_APPLICATION_ID is null)
               and (X_FLEXFIELD_APPLICATION_ID is null)))
      and ((recinfo.TABULAR_FUNCTION_CODE = X_TABULAR_FUNCTION_CODE)
           or ((recinfo.TABULAR_FUNCTION_CODE is null)
               and (X_TABULAR_FUNCTION_CODE is null)))
      and ((recinfo.TIP_TYPE = X_TIP_TYPE)
           or ((recinfo.TIP_TYPE is null)
               and (X_TIP_TYPE is null)))
      and ((recinfo.TIP_MESSAGE_NAME = X_TIP_MESSAGE_NAME)
           or ((recinfo.TIP_MESSAGE_NAME is null)
               and (X_TIP_MESSAGE_NAME is null)))
      and ((recinfo.TIP_MESSAGE_APPLICATION_ID = X_TIP_MESSAGE_APPLICATION_ID)
           or ((recinfo.TIP_MESSAGE_APPLICATION_ID is null)
               and (X_TIP_MESSAGE_APPLICATION_ID is null)))
      and ((recinfo.FLEX_SEGMENT_LIST = X_FLEX_SEGMENT_LIST)
           or ((recinfo.FLEX_SEGMENT_LIST is null)
               and (X_FLEX_SEGMENT_LIST is null)))
      and ((recinfo.ENTITY_ID = X_ENTITY_ID)
           or ((recinfo.ENTITY_ID is null)
               and (X_ENTITY_ID is null)))
      and ((recinfo.ANCHOR = X_ANCHOR)
           or ((recinfo.ANCHOR is null)
               and (X_ANCHOR is null)))
      and ((recinfo.POPLIST_VIEW_USAGE_NAME = X_POPLIST_VIEW_USAGE_NAME)
           or ((recinfo.POPLIST_VIEW_USAGE_NAME is null)
               and (X_POPLIST_VIEW_USAGE_NAME is null)))
      and ((recinfo.SORTBY_VIEW_ATTRIBUTE_NAME = X_SORTBY_VIEW_ATTRIBUTE_NAME)
           or ((recinfo.SORTBY_VIEW_ATTRIBUTE_NAME is null)
               and (X_SORTBY_VIEW_ATTRIBUTE_NAME is null)))
  ) then
    null;

Line: 726


procedure UPDATE_ROW (
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_ATTRIBUTE_APPLICATION_ID in NUMBER,
  X_ATTRIBUTE_CODE in VARCHAR2,
  X_DISPLAY_SEQUENCE in NUMBER,
  X_NODE_DISPLAY_FLAG in VARCHAR2,
  X_NODE_QUERY_FLAG in VARCHAR2,
  X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
  X_BOLD in VARCHAR2,
  X_ITALIC in VARCHAR2,
  X_VERTICAL_ALIGNMENT in VARCHAR2,
  X_HORIZONTAL_ALIGNMENT in VARCHAR2 default 'LEFT',
  X_ITEM_STYLE in VARCHAR2,
  X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
  X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
  X_DESCRIPTION IN VARCHAR2,
  X_SECURITY_CODE in VARCHAR2,
  X_UPDATE_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_DISPLAY_VALUE_LENGTH in NUMBER,
  X_LOV_REGION_APPLICATION_ID in NUMBER,
  X_LOV_REGION_CODE in VARCHAR2,
  X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
  X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
  X_LOV_ATTRIBUTE_CODE in VARCHAR2,
  X_LOV_DEFAULT_FLAG in VARCHAR2,
  X_REGION_DEFAULTING_API_PKG in VARCHAR2,
  X_REGION_DEFAULTING_API_PROC in VARCHAR2,
  X_REGION_VALIDATION_API_PKG in VARCHAR2,
  X_REGION_VALIDATION_API_PROC in VARCHAR2,
  X_ORDER_SEQUENCE in NUMBER,
  X_ORDER_DIRECTION in VARCHAR2,
  X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
  X_DEFAULT_VALUE_NUMBER in NUMBER,
  X_DEFAULT_VALUE_DATE in DATE,
  X_ITEM_NAME in VARCHAR2,
  X_DISPLAY_HEIGHT IN NUMBER,
  X_SUBMIT IN VARCHAR2,
  X_ENCRYPT IN VARCHAR2,
  X_VIEW_USAGE_NAME IN VARCHAR2,
  X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
  X_CSS_CLASS_NAME IN VARCHAR2,
  X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
  X_URL IN VARCHAR2,
  X_POPLIST_VIEWOBJECT IN VARCHAR2,
  X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
  X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
  X_IMAGE_FILE_NAME IN VARCHAR2,
  X_NESTED_REGION_CODE IN VARCHAR2,
  X_NESTED_REGION_APPL_ID IN NUMBER,
  X_MENU_NAME IN VARCHAR2,
  X_FLEXFIELD_NAME IN VARCHAR2,
  X_FLEXFIELD_APPLICATION_ID NUMBER,
  X_TABULAR_FUNCTION_CODE IN VARCHAR2,
  X_TIP_TYPE IN VARCHAR2,
  X_TIP_MESSAGE_NAME VARCHAR2,
  X_TIP_MESSAGE_APPLICATION_ID NUMBER,
  X_FLEX_SEGMENT_LIST VARCHAR2,
  X_ENTITY_ID VARCHAR2,
  X_ANCHOR VARCHAR2,
  X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
  X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2 := NULL,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  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_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2
) is

  L_HORIZONTAL_ALIGNMENT Ak_Region_items.horizontal_alignment%type;

Line: 818


    update AK_REGION_ITEMS set
      REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
      REGION_CODE = X_REGION_CODE,
      ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
      ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
      DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
      NODE_DISPLAY_FLAG = X_NODE_DISPLAY_FLAG,
      NODE_QUERY_FLAG = X_NODE_QUERY_FLAG,
      ATTRIBUTE_LABEL_LENGTH = X_ATTRIBUTE_LABEL_LENGTH,
      BOLD = X_BOLD,
      ITALIC = X_ITALIC,
      VERTICAL_ALIGNMENT = X_VERTICAL_ALIGNMENT,
      HORIZONTAL_ALIGNMENT = L_HORIZONTAL_ALIGNMENT,
      ITEM_STYLE = X_ITEM_STYLE,
      SECURITY_CODE = X_SECURITY_CODE,
      UPDATE_FLAG = X_UPDATE_FLAG,
      REQUIRED_FLAG = X_REQUIRED_FLAG,
      DISPLAY_VALUE_LENGTH = X_DISPLAY_VALUE_LENGTH,
      LOV_REGION_APPLICATION_ID = X_LOV_REGION_APPLICATION_ID,
      LOV_REGION_CODE = X_LOV_REGION_CODE,
      LOV_FOREIGN_KEY_NAME = X_LOV_FOREIGN_KEY_NAME,
      LOV_ATTRIBUTE_APPLICATION_ID = X_LOV_ATTRIBUTE_APPLICATION_ID,
      LOV_ATTRIBUTE_CODE = X_LOV_ATTRIBUTE_CODE,
      LOV_DEFAULT_FLAG = X_LOV_DEFAULT_FLAG,
      REGION_DEFAULTING_API_PKG = X_REGION_DEFAULTING_API_PKG,
      REGION_DEFAULTING_API_PROC = X_REGION_DEFAULTING_API_PROC,
      REGION_VALIDATION_API_PKG = X_REGION_VALIDATION_API_PKG,
      REGION_VALIDATION_API_PROC = X_REGION_VALIDATION_API_PROC,
     ORDER_SEQUENCE = X_ORDER_SEQUENCE,
     ORDER_DIRECTION = X_ORDER_DIRECTION,
     DEFAULT_VALUE_VARCHAR2 = X_DEFAULT_VALUE_VARCHAR2,
     DEFAULT_VALUE_NUMBER = X_DEFAULT_VALUE_NUMBER,
     DEFAULT_VALUE_DATE = X_DEFAULT_VALUE_DATE,
      OBJECT_ATTRIBUTE_FLAG = X_OBJECT_ATTRIBUTE_FLAG,
     DISPLAY_HEIGHT = X_DISPLAY_HEIGHT,
     SUBMIT = X_SUBMIT,
     ENCRYPT = X_ENCRYPT,
     VIEW_USAGE_NAME = X_VIEW_USAGE_NAME,
     VIEW_ATTRIBUTE_NAME = X_VIEW_ATTRIBUTE_NAME,
     CSS_CLASS_NAME = X_CSS_CLASS_NAME,
     CSS_LABEL_CLASS_NAME = X_CSS_LABEL_CLASS_NAME,
     URL = X_URL,
     POPLIST_VIEWOBJECT = X_POPLIST_VIEWOBJECT,
          POPLIST_DISPLAY_ATTRIBUTE = X_POPLIST_DISPLAY_ATTRIBUTE,
          POPLIST_VALUE_ATTRIBUTE = X_POPLIST_VALUE_ATTRIBUTE,
     IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
     NESTED_REGION_APPLICATION_ID = X_NESTED_REGION_APPL_ID,
     NESTED_REGION_CODE = X_NESTED_REGION_CODE,
     ITEM_NAME = X_ITEM_NAME,
     MENU_NAME = X_MENU_NAME,
     FLEXFIELD_NAME = X_FLEXFIELD_NAME,
     FLEXFIELD_APPLICATION_ID = X_FLEXFIELD_APPLICATION_ID,
     TABULAR_FUNCTION_CODE = X_TABULAR_FUNCTION_CODE,
     TIP_TYPE = X_TIP_TYPE,
     TIP_MESSAGE_NAME = X_TIP_MESSAGE_NAME,
     TIP_MESSAGE_APPLICATION_ID = X_TIP_MESSAGE_APPLICATION_ID,
     FLEX_SEGMENT_LIST = X_FLEX_SEGMENT_LIST,
     ENTITY_ID = X_ENTITY_ID,
     ANCHOR = X_ANCHOR,
     POPLIST_VIEW_USAGE_NAME = X_POPLIST_VIEW_USAGE_NAME,
     SORTBY_VIEW_ATTRIBUTE_NAME = X_SORTBY_VIEW_ATTRIBUTE_NAME,

      LAST_UPDATE_DATE = sysdate,
      LAST_UPDATED_BY = fnd_global.user_id,
      LAST_UPDATE_LOGIN = fnd_global.login_id,

      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,
      ADMIN_CUSTOMIZABLE = 'Y'
    where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and REGION_CODE = X_REGION_CODE
    and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
    and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 909


  update AK_REGION_ITEMS_TL set
    ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
    DESCRIPTION = X_DESCRIPTION,

    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATED_BY = fnd_global.user_id,
    LAST_UPDATE_LOGIN = fnd_global.login_id,

    SOURCE_LANG = userenv('LANG')
  where REGION_CODE = X_REGION_CODE
  and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
  and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 926


end UPDATE_ROW;

Line: 928


procedure DELETE_ROW (
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_ATTRIBUTE_APPLICATION_ID in NUMBER,
  X_ATTRIBUTE_CODE in VARCHAR2
) is
begin
  delete from AK_REGION_ITEMS
  where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  and REGION_CODE = X_REGION_CODE
  and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
  and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 945


  delete from AK_REGION_ITEMS_TL
  where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  and REGION_CODE = X_REGION_CODE
  and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
  and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line: 953


end DELETE_ROW;

Line: 958


  delete from AK_REGION_ITEMS_TL T
  where not exists
    (select NULL
    from AK_REGION_ITEMS B
    where B.REGION_CODE = T.REGION_CODE
    and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
    and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
    and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
    );

Line: 968


  update AK_REGION_ITEMS_TL T set (
      ATTRIBUTE_LABEL_LONG,
      ATTRIBUTE_LABEL_SHORT
    ) = (select
      B.ATTRIBUTE_LABEL_LONG,
      B.ATTRIBUTE_LABEL_SHORT
    from AK_REGION_ITEMS_TL B
    where B.REGION_CODE = T.REGION_CODE
    and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
    and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
    and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.REGION_CODE,
      T.REGION_APPLICATION_ID,
      T.ATTRIBUTE_CODE,
      T.ATTRIBUTE_APPLICATION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.REGION_CODE,
      SUBT.REGION_APPLICATION_ID,
      SUBT.ATTRIBUTE_CODE,
      SUBT.ATTRIBUTE_APPLICATION_ID,
      SUBT.LANGUAGE
    from AK_REGION_ITEMS_TL SUBB, AK_REGION_ITEMS_TL SUBT
    where SUBB.REGION_CODE = SUBT.REGION_CODE
    and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
    and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
    and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.ATTRIBUTE_LABEL_LONG <> SUBT.ATTRIBUTE_LABEL_LONG
      or (SUBB.ATTRIBUTE_LABEL_LONG is null and SUBT.ATTRIBUTE_LABEL_LONG is not null)
      or (SUBB.ATTRIBUTE_LABEL_LONG is not null and SUBT.ATTRIBUTE_LABEL_LONG is null)
      or SUBB.ATTRIBUTE_LABEL_SHORT <> SUBT.ATTRIBUTE_LABEL_SHORT
      or (SUBB.ATTRIBUTE_LABEL_SHORT is null and SUBT.ATTRIBUTE_LABEL_SHORT is not null)
      or (SUBB.ATTRIBUTE_LABEL_SHORT is not null and SUBT.ATTRIBUTE_LABEL_SHORT is null)
  ));

Line: 1006


  insert into AK_REGION_ITEMS_TL (
    REGION_APPLICATION_ID,
    REGION_CODE,
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    ATTRIBUTE_LABEL_LONG,
    ATTRIBUTE_LABEL_SHORT,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.REGION_APPLICATION_ID,
    B.REGION_CODE,
    B.ATTRIBUTE_APPLICATION_ID,
    B.ATTRIBUTE_CODE,
    B.ATTRIBUTE_LABEL_LONG,
    B.ATTRIBUTE_LABEL_SHORT,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AK_REGION_ITEMS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AK_REGION_ITEMS_TL T
    where T.REGION_CODE = B.REGION_CODE
    and T.REGION_APPLICATION_ID = B.REGION_APPLICATION_ID
    and T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
    and T.ATTRIBUTE_APPLICATION_ID = B.ATTRIBUTE_APPLICATION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);