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

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

Line: 14


   PROCEDURE Check_Configuration_delete
  (
    X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
    X_CUSTOMIZATION_CODE           IN VARCHAR2,
    X_REGION_APPLICATION_ID        IN NUMBER,
    X_REGION_CODE                  IN VARCHAR2,
    X_INIT_MSG_LIST                IN VARCHAR2   := FND_API.G_FALSE,
    X_RETURN_STATUS                OUT NOCOPY VARCHAR2,
    X_ERRORCODE                    OUT NOCOPY NUMBER
  )
  IS

    l_count NUMBER;

Line: 35


    SELECT
      COUNT(*)
    INTO
      l_count
    FROM
      EGO_CUSTOMIZATION_EXT
    WHERE
      RF_CUSTOMIZATION_APPL_ID = X_CUSTOMIZATION_APPLICATION_ID
      AND RF_CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
      AND RF_REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
      AND RF_REGION_CODE = X_REGION_CODE;

Line: 49


    SELECT
          property_varchar2_value INTO l_name
    FROM
          ak_custom_regions_tl
    WHERE
          property_name = 'RESULT_NAME'
          AND LANGUAGE = userenv('LANG')
          AND customization_application_id = x_customization_application_id
          AND customization_code = x_customization_code
          AND region_application_id = x_region_application_id
          AND region_code = x_region_code ;

Line: 64


      SELECT
        NAME INTO l_name
      FROM
        EGO_RESULTS_FORMAT_V
      WHERE
        CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
        AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
        AND REGION_CODE = X_REGION_CODE;

Line: 86


  END Check_Configuration_delete;

Line: 99


     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_CLASSIFICATION_1             IN     VARCHAR2 DEFAULT NULL,
     X_CLASSIFICATION_2             IN     VARCHAR2 DEFAULT NULL,
     X_CLASSIFICATION_3             IN     VARCHAR2 DEFAULT NULL,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT    NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT    NOCOPY NUMBER
  )
IS

  l_Sysdate                DATE := Sysdate;

Line: 133


         AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
X_ROWID                        => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
X_REGION_CODE                  => X_REGION_CODE,
X_PROPERTY_NAME                => 'CONFIG_NAME',
X_PROPERTY_VARCHAR2_VALUE      => X_NAME,
X_PROPERTY_NUMBER_VALUE        => NULL,
X_CRITERIA_JOIN_CONDITION      => NULL,
X_CREATED_BY                   => X_CREATED_BY,
X_CREATION_DATE                => X_CREATION_DATE,
X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
          );

Line: 152


  INSERT INTO EGO_CUSTOMIZATION_EXT
    (
  CUSTOMIZATION_APPLICATION_ID,
  CUSTOMIZATION_CODE,
  REGION_APPLICATION_ID,
  REGION_CODE,
  CLASSIFICATION1,
  CLASSIFICATION2,
  CLASSIFICATION3,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN
   )
    VALUES
    (
  X_CUSTOMIZATION_APPLICATION_ID,
  X_CUSTOMIZATION_CODE,
  X_REGION_APPLICATION_ID,
  X_REGION_CODE,
  X_CLASSIFICATION_1,
  X_CLASSIFICATION_2,
  X_CLASSIFICATION_3,
  g_current_user_id,
  l_Sysdate,
  g_current_user_id,
  l_Sysdate,
  g_current_user_id
    );

Line: 200


  PROCEDURE update_type_Config
  (
     X_CUSTOMIZATION_APPLICATION_ID IN     NUMBER,
     X_CUSTOMIZATION_CODE           IN     VARCHAR2,
     X_REGION_APPLICATION_ID        IN     NUMBER,
     X_REGION_CODE                  IN     VARCHAR2,
     X_NAME                         IN     VARCHAR2,
     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_CLASSIFICATION_1             IN     VARCHAR2 DEFAULT NULL,
     X_CLASSIFICATION_2             IN     VARCHAR2 DEFAULT NULL,
     X_CLASSIFICATION_3             IN     VARCHAR2 DEFAULT NULL,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT    NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT    NOCOPY NUMBER
  )
 IS
    l_Sysdate                DATE := Sysdate;

Line: 240


	AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
X_REGION_CODE                  => X_REGION_CODE,
X_PROPERTY_NAME                => 'CONFIG_NAME',
X_PROPERTY_VARCHAR2_VALUE      => X_NAME,
X_PROPERTY_NUMBER_VALUE        => NULL,
X_CRITERIA_JOIN_CONDITION      => NULL,
X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
          );

Line: 267


END update_type_Config;

Line: 271


 PROCEDURE delete_type_config
  (
     X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
     X_CUSTOMIZATION_CODE           IN VARCHAR2,
     X_REGION_APPLICATION_ID        IN NUMBER,
     X_REGION_CODE                  IN VARCHAR2,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT NOCOPY NUMBER
  )
  IS

  BEGIN

  IF FND_API.To_Boolean(x_init_msg_list) THEN
   FND_MSG_PUB.Initialize;

Line: 289


    Check_Configuration_delete
     (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       FND_API.G_FALSE,
       X_RETURN_STATUS,
       X_ERRORCODE
     );

Line: 302


  DELETE FROM AK_CUSTOM_REGIONS
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  AND REGION_CODE = X_REGION_CODE;

Line: 308


 DELETE FROM AK_CUSTOM_REGIONS_TL
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  AND REGION_CODE = X_REGION_CODE;

Line: 314


  DELETE FROM EGO_CUSTOMIZATION_EXT
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  AND REGION_CODE = X_REGION_CODE;

Line: 320


 DELETE FROM AK_CUSTOM_REGION_ITEMS
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  AND REGION_CODE = X_REGION_CODE;

Line: 326


 DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  AND REGION_CODE = X_REGION_CODE;

Line: 340


  END delete_type_config;

Line: 359


     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT    NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT    NOCOPY NUMBER
  )
IS

  l_Sysdate                DATE := Sysdate;

Line: 377


  AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
    X_ROWID                        => l_rowid,
    X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
    X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
    X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
    X_REGION_CODE                  => X_REGION_CODE,
    X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
    X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
    X_PROPERTY_NAME                => 'DISPLAY_SEQUENCE',
    X_PROPERTY_VARCHAR2_VALUE      => null,
    X_PROPERTY_NUMBER_VALUE        => X_DISPLAY_SEQUENCE,
    X_PROPERTY_DATE_VALUE          => NULL,
    X_CREATED_BY                   => X_CREATED_BY,
    X_CREATION_DATE                => X_CREATION_DATE,
    X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
  );

Line: 398


    AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
      X_ROWID                        => l_rowid,
      X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
      X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
      X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
      X_REGION_CODE                  => X_REGION_CODE,
      X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
      X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
      X_PROPERTY_NAME                => 'ORDER_SEQUENCE',
      X_PROPERTY_VARCHAR2_VALUE      => NULL,
      X_PROPERTY_NUMBER_VALUE        => X_ORDER_SEQUENCE,
      X_PROPERTY_DATE_VALUE          => NULL,
      X_CREATED_BY                   => X_CREATED_BY,
      X_CREATION_DATE                => X_CREATION_DATE,
      X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
    );

Line: 421


   AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
      X_ROWID                        => l_rowid,
      X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
      X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
      X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
      X_REGION_CODE                  => X_REGION_CODE,
      X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
      X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
      X_PROPERTY_NAME                => 'ORDER_DIRECTION',
      X_PROPERTY_VARCHAR2_VALUE      => X_ORDER_DIRECTION,
      X_PROPERTY_NUMBER_VALUE        => NULL,
      X_PROPERTY_DATE_VALUE          => NULL,
      X_CREATED_BY                   => X_CREATED_BY,
      X_CREATION_DATE                => X_CREATION_DATE,
      X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
    );

Line: 443


   AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
      X_ROWID                        => l_rowid,
      X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
      X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
      X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
      X_REGION_CODE                  => X_REGION_CODE,
      X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
      X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
      X_PROPERTY_NAME                => 'COLUMN_NAME',
      X_PROPERTY_VARCHAR2_VALUE      => X_COLUMN_NAME,
      X_PROPERTY_NUMBER_VALUE        => NULL,
      X_PROPERTY_DATE_VALUE          => NULL,
      X_CREATED_BY                   => X_CREATED_BY,
      X_CREATION_DATE                => X_CREATION_DATE,
      X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
    );

Line: 465


   AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
      X_ROWID                        => l_rowid,
      X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
      X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
      X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
      X_REGION_CODE                  => X_REGION_CODE,
      X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
      X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
      X_PROPERTY_NAME                => 'SHOW_TOTAL',
      X_PROPERTY_VARCHAR2_VALUE      => X_SHOW_TOTAL,
      X_PROPERTY_NUMBER_VALUE        => NULL,
      X_PROPERTY_DATE_VALUE          => NULL,
      X_CREATED_BY                   => X_CREATED_BY,
      X_CREATION_DATE                => X_CREATION_DATE,
      X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
    );

Line: 495


  PROCEDURE update_Primary_Attribute
  (
     X_CUSTOMIZATION_APPLICATION_ID IN     NUMBER,
     X_CUSTOMIZATION_CODE           IN     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_ORDER_SEQUENCE               IN     NUMBER,
     X_ORDER_DIRECTION              IN     VARCHAR2,
     X_COLUMN_NAME                  IN     VARCHAR2 := NULL,
     X_SHOW_TOTAL                   IN     VARCHAR2 := NULL,
     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT    NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT    NOCOPY NUMBER
  )
IS

  l_Sysdate                DATE := Sysdate;

Line: 527


   AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
     X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
     X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
     X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
     X_REGION_CODE                  => X_REGION_CODE,
     X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
     X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
     X_PROPERTY_NAME                => 'DISPLAY_SEQUENCE',
     X_PROPERTY_VARCHAR2_VALUE      => NULL,
     X_PROPERTY_NUMBER_VALUE        => X_DISPLAY_SEQUENCE,
     X_PROPERTY_DATE_VALUE          => NULL,
     X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
     X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
     X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
   );

Line: 543


  SELECT
    COUNT(*) INTO l_count
  FROM
    AK_CUSTOM_REGION_ITEMS
  WHERE
    CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
    AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
    AND 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
    AND PROPERTY_NAME = 'ORDER_SEQUENCE';

Line: 559


      DELETE FROM AK_CUSTOM_REGION_ITEMS
        WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
        AND 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
        AND PROPERTY_NAME = 'ORDER_SEQUENCE';

Line: 573


      AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
        X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
        X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
        X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
        X_REGION_CODE                  => X_REGION_CODE,
        X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
        X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
        X_PROPERTY_NAME                => 'ORDER_SEQUENCE',
        X_PROPERTY_VARCHAR2_VALUE      => NULL,
        X_PROPERTY_NUMBER_VALUE        => X_ORDER_SEQUENCE,
        X_PROPERTY_DATE_VALUE          => NULL,
        X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
      );

Line: 591


       AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
          X_ROWID                        => l_rowid,
          X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
          X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
          X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
          X_REGION_CODE                  => X_REGION_CODE,
          X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
          X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
          X_PROPERTY_NAME                => 'ORDER_SEQUENCE',
          X_PROPERTY_VARCHAR2_VALUE      => NULL,
          X_PROPERTY_NUMBER_VALUE        => X_ORDER_SEQUENCE,
          X_PROPERTY_DATE_VALUE          => NULL,
          X_CREATED_BY                   => X_LAST_UPDATED_BY,
          X_CREATION_DATE                => SYSDATE,
          X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
          X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
          X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
        );

Line: 615


  SELECT
    COUNT(*) INTO l_count
  FROM
    AK_CUSTOM_REGION_ITEMS
  WHERE
    CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
    AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
    AND 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
    AND PROPERTY_NAME = 'ORDER_DIRECTION';

Line: 631


      DELETE FROM AK_CUSTOM_REGION_ITEMS
        WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
        AND 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
        AND PROPERTY_NAME = 'ORDER_DIRECTION';

Line: 645


      AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
        X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
        X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
        X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
        X_REGION_CODE                  => X_REGION_CODE,
        X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
        X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
        X_PROPERTY_NAME                => 'ORDER_DIRECTION',
        X_PROPERTY_VARCHAR2_VALUE      => X_ORDER_DIRECTION,
        X_PROPERTY_NUMBER_VALUE        => NULL,
        X_PROPERTY_DATE_VALUE          => NULL,
        X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
      );

Line: 663


       AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
          X_ROWID                        => l_rowid,
          X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
          X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
          X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
          X_REGION_CODE                  => X_REGION_CODE,
          X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
          X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
          X_PROPERTY_NAME                => 'ORDER_DIRECTION',
          X_PROPERTY_VARCHAR2_VALUE      => X_ORDER_DIRECTION,
          X_PROPERTY_NUMBER_VALUE        => NULL,
          X_PROPERTY_DATE_VALUE          => NULL,
          X_CREATED_BY                   => X_LAST_UPDATED_BY,
          X_CREATION_DATE                => SYSDATE,
          X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
          X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
          X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
        );

Line: 686


  SELECT
    COUNT(*) INTO l_count
  FROM
    AK_CUSTOM_REGION_ITEMS
  WHERE
    CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
    AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
    AND 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
    AND PROPERTY_NAME = 'COLUMN_NAME';

Line: 702


      DELETE FROM AK_CUSTOM_REGION_ITEMS
        WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
        AND 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
        AND PROPERTY_NAME = 'COLUMN_NAME';

Line: 716


      AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
        X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
        X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
        X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
        X_REGION_CODE                  => X_REGION_CODE,
        X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
        X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
        X_PROPERTY_NAME                => 'COLUMN_NAME',
        X_PROPERTY_VARCHAR2_VALUE      => X_COLUMN_NAME,
        X_PROPERTY_NUMBER_VALUE        => NULL,
        X_PROPERTY_DATE_VALUE          => NULL,
        X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
      );

Line: 734


       AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
          X_ROWID                        => l_rowid,
          X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
          X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
          X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
          X_REGION_CODE                  => X_REGION_CODE,
          X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
          X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
          X_PROPERTY_NAME                => 'COLUMN_NAME',
          X_PROPERTY_VARCHAR2_VALUE      => X_COLUMN_NAME,
          X_PROPERTY_NUMBER_VALUE        => NULL,
          X_PROPERTY_DATE_VALUE          => NULL,
          X_CREATED_BY                   => X_LAST_UPDATED_BY,
          X_CREATION_DATE                => SYSDATE,
          X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
          X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
          X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
        );

Line: 757


  SELECT
    COUNT(*) INTO l_count
  FROM
    AK_CUSTOM_REGION_ITEMS
  WHERE
    CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
    AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
    AND 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
    AND PROPERTY_NAME = 'SHOW_TOTAL';

Line: 773


      DELETE FROM AK_CUSTOM_REGION_ITEMS
        WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
        AND 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
        AND PROPERTY_NAME = 'SHOW_TOTAL';

Line: 787


      AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
        X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
        X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
        X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
        X_REGION_CODE                  => X_REGION_CODE,
        X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
        X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
        X_PROPERTY_NAME                => 'SHOW_TOTAL',
        X_PROPERTY_VARCHAR2_VALUE      => X_SHOW_TOTAL,
        X_PROPERTY_NUMBER_VALUE        => NULL,
        X_PROPERTY_DATE_VALUE          => NULL,
        X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
      );

Line: 805


       AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
          X_ROWID                        => l_rowid,
          X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
          X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
          X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
          X_REGION_CODE                  => X_REGION_CODE,
          X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
          X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
          X_PROPERTY_NAME                => 'SHOW_TOTAL',
          X_PROPERTY_VARCHAR2_VALUE      => X_SHOW_TOTAL,
          X_PROPERTY_NUMBER_VALUE        => NULL,
          X_PROPERTY_DATE_VALUE          => NULL,
          X_CREATED_BY                   => X_LAST_UPDATED_BY,
          X_CREATION_DATE                => SYSDATE,
          X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
          X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
          X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
        );

Line: 833


  END update_Primary_Attribute;

Line: 837


 PROCEDURE delete_Primary_Attribute
  (
     X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
     X_CUSTOMIZATION_CODE           IN VARCHAR2,
     X_REGION_APPLICATION_ID        IN NUMBER,
     X_REGION_CODE                  IN VARCHAR2,
     X_ATTRIBUTE_APPLICATION_ID     IN NUMBER,
     X_ATTRIBUTE_CODE               IN VARCHAR2,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT NOCOPY NUMBER
  )
  IS

  BEGIN

  IF FND_API.To_Boolean(x_init_msg_list) THEN
   FND_MSG_PUB.Initialize;

Line: 857


 DELETE FROM AK_CUSTOM_REGION_ITEMS
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND 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: 865


 DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND 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: 877


  END delete_Primary_Attribute;

Line: 893


     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT    NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT    NOCOPY NUMBER
  )
IS

  l_Sysdate                DATE := Sysdate;

Line: 911


         AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID                        => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
X_REGION_CODE                  => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME                => 'SECTION_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE      => NULL,
X_PROPERTY_NUMBER_VALUE        => X_DISPLAY_SEQUENCE,
X_PROPERTY_DATE_VALUE          => NULL,
X_CREATED_BY                   => X_CREATED_BY,
X_CREATION_DATE                => X_CREATION_DATE,
X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
          );

Line: 940


  PROCEDURE update_config_section
  (
     X_CUSTOMIZATION_APPLICATION_ID IN     NUMBER,
     X_CUSTOMIZATION_CODE           IN     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_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT    NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT    NOCOPY NUMBER
  )
IS

  l_Sysdate                DATE := Sysdate;

Line: 967


         AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE           => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID        => X_REGION_APPLICATION_ID,
X_REGION_CODE                  => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID     => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE               => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME                => 'SECTION_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE      => NULL,
X_PROPERTY_NUMBER_VALUE        => X_DISPLAY_SEQUENCE,
X_PROPERTY_DATE_VALUE          => NULL,
X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN
          );

Line: 987


  END update_config_section;

Line: 991


 PROCEDURE delete_config_section
  (
     X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
     X_CUSTOMIZATION_CODE           IN VARCHAR2,
     X_REGION_APPLICATION_ID        IN NUMBER,
     X_REGION_CODE                  IN VARCHAR2,
     X_ATTRIBUTE_APPLICATION_ID     IN NUMBER,
     X_ATTRIBUTE_CODE               IN VARCHAR2,
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE,
     X_RETURN_STATUS                OUT NOCOPY VARCHAR2,
     X_ERRORCODE                    OUT NOCOPY NUMBER
  )
  IS

  BEGIN

  IF FND_API.To_Boolean(x_init_msg_list) THEN
   FND_MSG_PUB.Initialize;

Line: 1011


 DELETE FROM AK_CUSTOM_REGION_ITEMS
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND 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: 1019


 DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
  WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
  AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
  AND 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: 1031


  END delete_config_section;

Line: 1060


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_RESULTS_FORMAT_V
        WHERE
          NAME = X_NAME
          AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
          AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
          AND REGION_CODE = X_REGION_CODE
          AND (CUSTOMIZATION_LEVEL_ID = 60 OR (CUSTOMIZATION_LEVEL_ID = 30 AND WEB_USER_ID = X_WEB_USER_ID))
          AND CUSTOMIZATION_CODE <> X_CUSTOMIZATION_CODE
          AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
          AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
          AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);

Line: 1079


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_RESULTS_FORMAT_V
        WHERE
          NAME = X_NAME
          AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
          AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
          AND REGION_CODE = X_REGION_CODE
          AND CUSTOMIZATION_CODE <> X_CUSTOMIZATION_CODE
          AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
          AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
          AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);

Line: 1102


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_RESULTS_FORMAT_V
        WHERE
          NAME = X_NAME
          AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
          AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
          AND REGION_CODE = X_REGION_CODE
          AND (CUSTOMIZATION_LEVEL_ID = 60 OR (CUSTOMIZATION_LEVEL_ID = 30 AND WEB_USER_ID = X_WEB_USER_ID))
          AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
          AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
          AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);

Line: 1121


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_RESULTS_FORMAT_V
        WHERE
          NAME = X_NAME
          AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
          AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
          AND REGION_CODE = X_REGION_CODE
          AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
          AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
          AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);