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

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

Line: 15


  PROCEDURE Update_Result_Format_Default
  (
    X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
    X_REGION_APPLICATION_ID        IN NUMBER,
    X_REGION_CODE                  IN VARCHAR2,
    X_WEB_USER_ID                  IN NUMBER,
    X_CUSTOMIZATION_LEVEL_ID       IN NUMBER,
    X_IMPORT_FLAG                  IN VARCHAR2,
    X_CLASSIFICATION_1             IN VARCHAR2,
    X_CLASSIFICATION_2             IN VARCHAR2,
    X_CLASSIFICATION_3             IN VARCHAR2,
    X_DATA_LEVEL                   IN VARCHAR2
  )
  IS

    l_count NUMBER;

Line: 34


     select name_query.customization_code customization_code
     from
     AK_CUSTOM_REGIONS_TL name_query ,
     AK_CUSTOM_REGIONS level_id_query ,
     AK_CUSTOM_REGIONS user_id_query ,
     EGO_CUSTOMIZATION_EXT ect ,
     AK_CUSTOM_REGIONS data_level_query
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and name_query.customization_application_id = level_id_query.customization_application_id
     and name_query.customization_code = level_id_query.customization_code
     and name_query.region_application_id = level_id_query.region_application_id
     and name_query.region_code = level_id_query.region_code
     and level_id_query.property_name = 'CUSTOMIZATION_LEVEL_ID'
     and name_query.customization_application_id = ect.customization_application_id
     and name_query.customization_code = ect.customization_code
     and name_query.region_application_id = ect.region_application_id
     and name_query.region_code = ect.region_code
     and data_level_query.property_name (+) = 'DATA_LEVEL'
     and name_query.customization_application_id = data_level_query.customization_application_id(+)
     and name_query.customization_code = data_level_query.customization_code (+)
     and name_query.region_application_id = data_level_query.region_application_id(+)
     and name_query.region_code = data_level_query.region_code(+)
     and user_id_query.property_name = 'WEB_USER_ID'
     and name_query.customization_application_id = user_id_query.customization_application_id
     and name_query.customization_code = user_id_query.customization_code
     and name_query.region_application_id = user_id_query.region_application_id
     and name_query.region_code = user_id_query.region_code
     and name_query.customization_application_id = x_customization_application_id
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code
     and level_id_query.property_number_value = x_customization_level_id
     and nvl(user_id_query.property_number_value, -1) = nvl(x_web_user_id, -1)
     and nvl(ect.classification1, g_null_value) = nvl(x_classification_1, g_null_value)
     and nvl(ect.classification2, g_null_value) = nvl(x_classification_2, g_null_value)
     and nvl(ect.classification3, g_null_value) = nvl(x_classification_3, g_null_value)
     and nvl(data_level_query.property_varchar2_value, g_null_value) = nvl(x_data_level, g_null_value);

Line: 83


        UPDATE AK_CUSTOM_REGIONS
      SET
        PROPERTY_VARCHAR2_VALUE = 'N'
      WHERE
        CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
        AND REGION_CODE = X_REGION_CODE
        AND PROPERTY_NAME = 'DEFAULT_RESULT_FLAG'
        AND CUSTOMIZATION_CODE = l_custmztn_code_tbl(i);

Line: 94


        UPDATE AK_CUSTOM_REGIONS_TL
      SET
        PROPERTY_VARCHAR2_VALUE = 'N'
      WHERE
        CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
        AND REGION_CODE = X_REGION_CODE
        AND PROPERTY_NAME = 'DEFAULT_RESULT_FLAG'
        AND CUSTOMIZATION_CODE = l_custmztn_code_tbl(i);

Line: 124


     select name_query.property_varchar2_value name
     from AK_CUSTOM_REGIONS_TL name_query
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and name_query.customization_application_id = x_customization_application_id
     and name_query.customization_code = x_customization_code
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code;

Line: 139


    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: 195


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_CRITERIA_TEMPLATES_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: 214


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_CRITERIA_TEMPLATES_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: 236


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_CRITERIA_TEMPLATES_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: 254


        SELECT
          COUNT(*)
        INTO
          l_count
        FROM
          EGO_CRITERIA_TEMPLATES_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);

Line: 297


     select count(*) count
     from
     AK_CUSTOM_REGIONS_TL name_query ,
     AK_CUSTOM_REGIONS level_id_query ,
     AK_CUSTOM_REGIONS user_id_query ,
     EGO_CUSTOMIZATION_EXT ect
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and name_query.customization_application_id = level_id_query.customization_application_id
     and name_query.customization_code = level_id_query.customization_code
     and name_query.region_application_id = level_id_query.region_application_id
     and name_query.region_code = level_id_query.region_code
     and level_id_query.property_name = 'CUSTOMIZATION_LEVEL_ID'
     and name_query.customization_application_id = ect.customization_application_id
     and name_query.customization_code = ect.customization_code
     and name_query.region_application_id = ect.region_application_id
     and name_query.region_code = ect.region_code
     and user_id_query.property_name = 'WEB_USER_ID'
     and name_query.customization_application_id = user_id_query.customization_application_id
     and name_query.customization_code = user_id_query.customization_code
     and name_query.region_application_id = user_id_query.region_application_id
     and name_query.region_code = user_id_query.region_code
     and name_query.property_varchar2_value = x_name
     and name_query.customization_application_id = x_customization_application_id
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code
     and (level_id_query.property_number_value = 60
          OR
         (level_id_query.property_number_value = 30 AND
          user_id_query.property_number_value = x_web_user_id))
     and name_query.customization_code <> x_customization_code
     and nvl(ect.classification1, g_null_value) = nvl(x_classification1, g_null_value)
     and nvl(ect.classification2, g_null_value) = nvl(x_classification2, g_null_value)
     and nvl(ect.classification3, g_null_value) = nvl(x_classification3, g_null_value);

Line: 334


     select count(*) count
     from
     AK_CUSTOM_REGIONS_TL name_query ,
     AK_CUSTOM_REGIONS level_id_query ,
     AK_CUSTOM_REGIONS user_id_query ,
     EGO_CUSTOMIZATION_EXT ect
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and name_query.customization_application_id = level_id_query.customization_application_id
     and name_query.customization_code = level_id_query.customization_code
     and name_query.region_application_id = level_id_query.region_application_id
     and name_query.region_code = level_id_query.region_code
     and level_id_query.property_name = 'CUSTOMIZATION_LEVEL_ID'
     and name_query.customization_application_id = ect.customization_application_id
     and name_query.customization_code = ect.customization_code
     and name_query.region_application_id = ect.region_application_id
     and name_query.region_code = ect.region_code
     and user_id_query.property_name = 'WEB_USER_ID'
     and name_query.customization_application_id = user_id_query.customization_application_id
     and name_query.customization_code = user_id_query.customization_code
     and name_query.region_application_id = user_id_query.region_application_id
     and name_query.region_code = user_id_query.region_code
     and name_query.property_varchar2_value = x_name
     and name_query.customization_application_id = x_customization_application_id
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code
     and name_query.customization_code <> x_customization_code
     and nvl(ect.classification1, g_null_value) = nvl(x_classification1, g_null_value)
     and nvl(ect.classification2, g_null_value) = nvl(x_classification2, g_null_value)
     and nvl(ect.classification3, g_null_value) = nvl(x_classification3, g_null_value);

Line: 367


     select count(*) count
     from
     AK_CUSTOM_REGIONS_TL name_query ,
     AK_CUSTOM_REGIONS level_id_query ,
     AK_CUSTOM_REGIONS user_id_query ,
     EGO_CUSTOMIZATION_EXT ect
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and name_query.customization_application_id = level_id_query.customization_application_id
     and name_query.customization_code = level_id_query.customization_code
     and name_query.region_application_id = level_id_query.region_application_id
     and name_query.region_code = level_id_query.region_code
     and level_id_query.property_name = 'CUSTOMIZATION_LEVEL_ID'
     and name_query.customization_application_id = ect.customization_application_id
     and name_query.customization_code = ect.customization_code
     and name_query.region_application_id = ect.region_application_id
     and name_query.region_code = ect.region_code
     and user_id_query.property_name = 'WEB_USER_ID'
     and name_query.customization_application_id = user_id_query.customization_application_id
     and name_query.customization_code = user_id_query.customization_code
     and name_query.region_application_id = user_id_query.region_application_id
     and name_query.region_code = user_id_query.region_code
     and name_query.property_varchar2_value = x_name
     and name_query.customization_application_id = x_customization_application_id
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code
     and (level_id_query.property_number_value = 60
          OR
         (level_id_query.property_number_value = 30 AND
          user_id_query.property_number_value = x_web_user_id))
     and nvl(ect.classification1, g_null_value) = nvl(x_classification1, g_null_value)
     and nvl(ect.classification2, g_null_value) = nvl(x_classification2, g_null_value)
     and nvl(ect.classification3, g_null_value) = nvl(x_classification3, g_null_value);

Line: 403


     select count(*) count
     from
     AK_CUSTOM_REGIONS_TL name_query ,
     AK_CUSTOM_REGIONS level_id_query ,
     AK_CUSTOM_REGIONS user_id_query ,
     EGO_CUSTOMIZATION_EXT ect
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and name_query.customization_application_id = level_id_query.customization_application_id
     and name_query.customization_code = level_id_query.customization_code
     and name_query.region_application_id = level_id_query.region_application_id
     and name_query.region_code = level_id_query.region_code
     and level_id_query.property_name = 'CUSTOMIZATION_LEVEL_ID'
     and name_query.customization_application_id = ect.customization_application_id
     and name_query.customization_code = ect.customization_code
     and name_query.region_application_id = ect.region_application_id
     and name_query.region_code = ect.region_code
     and user_id_query.property_name = 'WEB_USER_ID'
     and name_query.customization_application_id = user_id_query.customization_application_id
     and name_query.customization_code = user_id_query.customization_code
     and name_query.region_application_id = user_id_query.region_application_id
     and name_query.region_code = user_id_query.region_code
     and name_query.property_varchar2_value = x_name
     and name_query.customization_application_id = x_customization_application_id
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code
     and nvl(ect.classification1, g_null_value) = nvl(x_classification1, g_null_value)
     and nvl(ect.classification2, g_null_value) = nvl(x_classification2, g_null_value)
     and nvl(ect.classification3, g_null_value) = nvl(x_classification3, g_null_value);

Line: 492


     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_START_DATE_ACTIVE            IN     DATE,
     X_END_DATE_ACTIVE              IN     DATE,
     X_CLASSIFICATION_1             IN     VARCHAR2 DEFAULT NULL,
     X_CLASSIFICATION_2             IN     VARCHAR2 DEFAULT NULL,
     X_CLASSIFICATION_3             IN     VARCHAR2 DEFAULT NULL,
     X_RF_CUSTOMIZATION_APPL_ID     IN     NUMBER   DEFAULT NULL,
     X_RF_CUSTOMIZATION_CODE        IN     VARCHAR2 DEFAULT NULL,
     X_RF_REGION_APPLICATION_ID     IN     NUMBER   DEFAULT NULL,
     X_RF_REGION_CODE               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: 539


        UPDATE
          AK_CUSTOMIZATIONS
        SET
          DEFAULT_CUSTOMIZATION_FLAG = 'N'
        WHERE
          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 = X_CUSTOMIZATION_LEVEL_ID
          AND NVL(WEB_USER_ID, -1) = NVL(X_WEB_USER_ID, -1)
          AND CUSTOMIZATION_CODE IN (
                                     SELECT
                                       CUSTOMIZATION_CODE
                                     FROM
                                       EGO_CUSTOMIZATION_EXT
                                     WHERE
                                       CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
                                       AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
                                       AND REGION_CODE = X_REGION_CODE
                                       AND NVL(CLASSIFICATION1, ' ') = NVL(X_CLASSIFICATION_1, ' ')
                                       AND NVL(CLASSIFICATION2, ' ') = NVL(X_CLASSIFICATION_2, ' ')
                                       AND NVL(CLASSIFICATION3, ' ') = NVL(X_CLASSIFICATION_3, ' ')
                                     );

Line: 571


       AK_CUSTOMIZATIONS_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_NAME                         => X_NAME,
         X_DESCRIPTION                  => X_DESCRIPTION,
         X_VERTICALIZATION_ID           => X_VERTICALIZATION_ID,
         X_LOCALIZATION_CODE            => X_LOCALIZATION_CODE,
         X_ORG_ID                       => X_ORG_ID,
         X_SITE_ID                      => X_SITE_ID,
         X_RESPONSIBILITY_ID            => X_RESPONSIBILITY_ID,
         X_WEB_USER_ID                  => X_WEB_USER_ID,
         X_DEFAULT_CUSTOMIZATION_FLAG   => X_DEFAULT_CUSTOMIZATION_FLAG,
         X_CUSTOMIZATION_LEVEL_ID       => X_CUSTOMIZATION_LEVEL_ID,
         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,
         X_START_DATE_ACTIVE            => X_START_DATE_ACTIVE,
         X_END_DATE_ACTIVE              => X_END_DATE_ACTIVE
       );

Line: 597


      INSERT INTO EGO_CUSTOMIZATION_EXT
      (
        CUSTOMIZATION_APPLICATION_ID,
        CUSTOMIZATION_CODE,
        REGION_APPLICATION_ID,
        REGION_CODE,
        CLASSIFICATION1,
        CLASSIFICATION2,
        CLASSIFICATION3,
        RF_CUSTOMIZATION_APPL_ID,
        RF_CUSTOMIZATION_CODE,
        RF_REGION_APPLICATION_ID,
        RF_REGION_CODE,
        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,
        X_RF_CUSTOMIZATION_APPL_ID,
        X_RF_CUSTOMIZATION_CODE,
        X_RF_REGION_APPLICATION_ID,
        X_RF_REGION_CODE,
        l_current_user,
        l_Sysdate,
        l_current_user,
        l_Sysdate,
        l_current_user
      );

Line: 651


  PROCEDURE Update_Criteria_Template
  (
    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_DESCRIPTION                  IN     VARCHAR2,
    X_VERTICALIZATION_ID           IN     VARCHAR2,
    X_LOCALIZATION_CODE            IN     VARCHAR2,
    X_ORG_ID                       IN     NUMBER,
    X_SITE_ID                      IN     NUMBER,
    X_RESPONSIBILITY_ID            IN     NUMBER,
    X_WEB_USER_ID                  IN     NUMBER,
    X_DEFAULT_CUSTOMIZATION_FLAG   IN     VARCHAR2,
    X_CUSTOMIZATION_LEVEL_ID       IN     NUMBER,
    X_LAST_UPDATED_BY              IN     NUMBER,
    X_LAST_UPDATE_DATE             IN     DATE,
    X_LAST_UPDATE_LOGIN            IN     NUMBER,
    X_START_DATE_ACTIVE            IN     DATE,
    X_END_DATE_ACTIVE              IN     DATE,
    X_CLASSIFICATION_1             IN     VARCHAR2 DEFAULT NULL,
    X_CLASSIFICATION_2             IN     VARCHAR2 DEFAULT NULL,
    X_CLASSIFICATION_3             IN     VARCHAR2 DEFAULT NULL,
    X_RF_CUSTOMIZATION_APPL_ID     IN     NUMBER DEFAULT NULL,
    X_RF_CUSTOMIZATION_CODE        IN     VARCHAR2 DEFAULT NULL,
    X_RF_REGION_APPLICATION_ID     IN     NUMBER DEFAULT NULL,
    X_RF_REGION_CODE               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: 709


      UPDATE
        AK_CUSTOMIZATIONS
      SET
        DEFAULT_CUSTOMIZATION_FLAG = 'N'
      WHERE
        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 = X_CUSTOMIZATION_LEVEL_ID
        AND NVL(WEB_USER_ID, -1) = NVL(X_WEB_USER_ID, -1)
        AND CUSTOMIZATION_CODE IN (
                                   SELECT
                                     CUSTOMIZATION_CODE
                                   FROM
                                     EGO_CUSTOMIZATION_EXT
                                   WHERE
                                     CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
                                     AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
                                     AND REGION_CODE = X_REGION_CODE
                                     AND NVL(CLASSIFICATION1, ' ') = NVL(X_CLASSIFICATION_1, ' ')
                                     AND NVL(CLASSIFICATION2, ' ') = NVL(X_CLASSIFICATION_2, ' ')
                                     AND NVL(CLASSIFICATION3, ' ') = NVL(X_CLASSIFICATION_3, ' ')
                                  );

Line: 735


       AK_CUSTOMIZATIONS_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_NAME                         => X_NAME,
         X_DESCRIPTION                  => X_DESCRIPTION,
         X_VERTICALIZATION_ID           => X_VERTICALIZATION_ID,
         X_LOCALIZATION_CODE            => X_LOCALIZATION_CODE,
         X_ORG_ID                       => X_ORG_ID,
         X_SITE_ID                      => X_SITE_ID,
         X_RESPONSIBILITY_ID            => X_RESPONSIBILITY_ID,
         X_WEB_USER_ID                  => X_WEB_USER_ID,
         X_DEFAULT_CUSTOMIZATION_FLAG   => X_DEFAULT_CUSTOMIZATION_FLAG,
         X_CUSTOMIZATION_LEVEL_ID       => X_CUSTOMIZATION_LEVEL_ID,
         X_LAST_UPDATED_BY              => X_LAST_UPDATED_BY,
         X_LAST_UPDATE_DATE             => X_LAST_UPDATE_DATE,
         X_LAST_UPDATE_LOGIN            => X_LAST_UPDATE_LOGIN,
         X_START_DATE_ACTIVE            => X_START_DATE_ACTIVE,
         X_END_DATE_ACTIVE              => X_END_DATE_ACTIVE
       );

Line: 760


      UPDATE
        EGO_CUSTOMIZATION_EXT
      SET
        RF_CUSTOMIZATION_APPL_ID = X_RF_CUSTOMIZATION_APPL_ID,
        RF_CUSTOMIZATION_CODE = X_RF_CUSTOMIZATION_CODE,
        RF_REGION_APPLICATION_ID = X_RF_REGION_APPLICATION_ID,
        RF_REGION_CODE = X_RF_REGION_CODE
      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: 784


  END Update_Criteria_Template;

Line: 788


 PROCEDURE Delete_Criteria_Template
  (
     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_name                   VARCHAR2(2000);

Line: 809


    SELECT
      COUNT(*)
    INTO
      l_count
    FROM
      EGO_CUSTOMIZATION_RF
    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: 823


      AK_CUSTOMIZATIONS_PKG.DELETE_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
      );

Line: 831


      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: 840


      DELETE
      FROM
        EGO_CUSTOMIZATION_RF
      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: 849


      DELETE
      FROM
        AK_CRITERIA
      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: 862


      SELECT
        NAME INTO l_name
      FROM
        EGO_CRITERIA_TEMPLATES_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: 880


  END Delete_Criteria_Template;

Line: 888


    ,p_last_update_date              IN   VARCHAR2
    ,p_last_updated_by               IN   NUMBER
    ,p_name                          IN   VARCHAR2
    ,p_description                   IN   VARCHAR2
    ,x_return_status                 OUT  NOCOPY VARCHAR2
    ,x_msg_data                      OUT  NOCOPY VARCHAR2
  ) IS

  CURSOR c_get_last_update_info IS
  SELECT last_updated_by, last_update_date
  FROM   ak_customizations_tl
  WHERE  customization_application_id = p_customization_application_id
    AND  customization_code      =  p_customization_code
    AND  region_application_id   =  p_region_application_id
    AND  region_code             =  p_region_code
    AND  USERENV('LANG') IN (language, source_lang);

Line: 905


    l_last_update_date            ak_customizations.last_update_date%TYPE;

Line: 906


    l_last_updated_by             ak_customizations.last_updated_by%TYPE;

Line: 920


    OPEN C_get_last_update_info;

Line: 921


    FETCH c_get_last_update_info
    INTO  l_last_updated_by, l_last_update_date;

Line: 923


    CLOSE c_get_last_update_info;

Line: 925


    IF (fnd_load_util.upload_test(p_last_updated_by
                                 ,p_last_update_date
                                 ,l_last_updated_by
                                 ,l_last_update_date
                                 ,NULL)) THEN
      SELECT
         verticalization_id
        ,localization_code
        ,org_id
        ,site_id
        ,responsibility_id
        ,web_user_id
        ,default_customization_flag
        ,customization_level_id
        ,start_date_active
        ,end_date_active
      INTO
         l_verticalization_id
        ,l_localization_code
        ,l_org_id
        ,l_site_id
        ,l_responsibility_id
        ,l_web_user_id
        ,l_default_customization_flag
        ,l_customization_level_id
        ,l_start_date_active
        ,l_end_date_active
      FROM  ak_customizations
      WHERE CUSTOMIZATION_APPLICATION_ID = p_customization_application_id
        AND CUSTOMIZATION_CODE           = p_customization_code
        AND REGION_APPLICATION_ID        = p_region_application_id
        AND REGION_CODE                  = p_region_code
        AND CUSTOMIZATION_LEVEL_ID       = p_customization_level_id;

Line: 959


      AK_CUSTOMIZATIONS_PKG.UPDATE_ROW
       (
         X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
         X_CUSTOMIZATION_CODE           => p_customization_code,
         X_REGION_APPLICATION_ID        => p_region_application_id,
         X_REGION_CODE                  => p_region_code,
         X_NAME                         => p_name,
         X_DESCRIPTION                  => p_description,
         X_VERTICALIZATION_ID           => l_verticalization_id,
         X_LOCALIZATION_CODE            => l_localization_code,
         X_ORG_ID                       => l_org_id,
         X_SITE_ID                      => l_site_id,
         X_RESPONSIBILITY_ID            => l_responsibility_id,
         X_WEB_USER_ID                  => l_web_user_id,
         X_DEFAULT_CUSTOMIZATION_FLAG   => l_default_customization_flag,
         X_CUSTOMIZATION_LEVEL_ID       => p_customization_level_id,
         X_LAST_UPDATED_BY              => p_last_updated_by,
         X_LAST_UPDATE_DATE             => SYSDATE,
         X_LAST_UPDATE_LOGIN            => fnd_global.login_id,
         X_START_DATE_ACTIVE            => l_start_date_active,
         X_END_DATE_ACTIVE              => l_end_date_active
       );

Line: 1004


     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: 1023


    INSERT INTO EGO_CUSTOMIZATION_RF
    (
      CUSTOMIZATION_APPLICATION_ID,
      CUSTOMIZATION_CODE,
      REGION_APPLICATION_ID,
      REGION_CODE,
      RF_CUSTOMIZATION_APPL_ID,
      RF_CUSTOMIZATION_CODE,
      RF_REGION_APPLICATION_ID,
      RF_REGION_CODE,
      RF_TAG,
      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_RF_CUSTOMIZATION_APPL_ID,
      X_RF_CUSTOMIZATION_CODE,
      X_RF_REGION_APPLICATION_ID,
      X_RF_REGION_CODE,
      X_RF_TAG,
      X_CREATED_BY,
      X_CREATION_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN
    );

Line: 1066


  PROCEDURE update_criteria_template_rf
  (
     X_CUSTOMIZATION_APPLICATION_ID IN     NUMBER,
     X_CUSTOMIZATION_CODE           IN     VARCHAR2,
     X_REGION_APPLICATION_ID        IN     NUMBER,
     X_REGION_CODE                  IN     VARCHAR2,
     X_RF_CUSTOMIZATION_APPL_ID     IN     NUMBER,
     X_RF_CUSTOMIZATION_CODE        IN     VARCHAR2,
     X_RF_REGION_APPLICATION_ID     IN     NUMBER,
     X_RF_REGION_CODE               IN     VARCHAR2,
     X_RF_TAG                       IN     VARCHAR2,
     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: 1095


  SELECT
    COUNT(*) INTO l_count
  FROM
    EGO_CUSTOMIZATION_RF
  WHERE
    CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
    AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
    AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    AND REGION_CODE = X_REGION_CODE
    AND RF_TAG = X_RF_TAG;

Line: 1109


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

Line: 1122


      UPDATE EGO_CUSTOMIZATION_RF SET
        RF_CUSTOMIZATION_APPL_ID = X_RF_CUSTOMIZATION_APPL_ID,
        RF_CUSTOMIZATION_CODE = X_RF_CUSTOMIZATION_CODE,
        RF_REGION_APPLICATION_ID = X_RF_REGION_APPLICATION_ID,
        RF_REGION_CODE = X_RF_REGION_CODE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      WHERE
        CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
        AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
        AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
        AND REGION_CODE = X_REGION_CODE
        AND RF_TAG = X_RF_TAG;

Line: 1144


  END update_criteria_template_rf;

Line: 1147


  PROCEDURE delete_criteria_template_rf
  (
     X_CUSTOMIZATION_APPLICATION_ID IN     NUMBER,
     X_CUSTOMIZATION_CODE           IN     VARCHAR2,
     X_REGION_APPLICATION_ID        IN     NUMBER,
     X_REGION_CODE                  IN     VARCHAR2,
     X_RF_TAG                       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_Sysdate                DATE := Sysdate;

Line: 1169


  SELECT
    COUNT(*) INTO l_count
  FROM
    EGO_CUSTOMIZATION_RF
  WHERE
    CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
    AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
    AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    AND REGION_CODE = X_REGION_CODE
    AND RF_TAG = X_RF_TAG;

Line: 1182


    DELETE FROM EGO_CUSTOMIZATION_RF
    WHERE
      CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
      AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
      AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
      AND REGION_CODE = X_REGION_CODE
      AND RF_TAG = X_RF_TAG;

Line: 1195


  END delete_criteria_template_rf;

Line: 1215


     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: 1249


         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                => 'RESULT_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: 1266


         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                => 'RESULT_DESCRIPTION',
X_PROPERTY_VARCHAR2_VALUE      => X_DESCRIPTION,
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: 1288


     Update_Result_Format_Default
     (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_WEB_USER_ID,
       X_CUSTOMIZATION_LEVEL_ID,
       X_IMPORT_FLAG,
       X_CLASSIFICATION_1,
       X_CLASSIFICATION_2,
       X_CLASSIFICATION_3,
       X_DATA_LEVEL
     );

Line: 1304


         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                => 'DEFAULT_RESULT_FLAG',
X_PROPERTY_VARCHAR2_VALUE      => X_DEFAULT_RESULT_FLAG,
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: 1321


         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                => 'NUM_ROWS_DISPLAY',
X_PROPERTY_VARCHAR2_VALUE      => NULL,
X_PROPERTY_NUMBER_VALUE        => X_NUM_ROWS_DISPLAYED,
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: 1338


         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                => 'SITE_ID',
X_PROPERTY_VARCHAR2_VALUE      => NULL,
X_PROPERTY_NUMBER_VALUE        => X_SITE_ID,
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: 1355


         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                => 'WEB_USER_ID',
X_PROPERTY_VARCHAR2_VALUE      => NULL,
X_PROPERTY_NUMBER_VALUE        => X_WEB_USER_ID,
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: 1372


        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                => 'CUSTOMIZATION_LEVEL_ID',
X_PROPERTY_VARCHAR2_VALUE      => NULL,
X_PROPERTY_NUMBER_VALUE        => X_CUSTOMIZATION_LEVEL_ID,
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: 1391


          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                => 'IMPORT_FLAG',
  X_PROPERTY_VARCHAR2_VALUE      => X_IMPORT_FLAG,
  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: 1408


          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                => 'DATA_LEVEL',
  X_PROPERTY_VARCHAR2_VALUE      => X_DATA_LEVEL,
  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: 1428


  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: 1476


  PROCEDURE update_result_format
  (
     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_DESCRIPTION                  IN     VARCHAR2,
     X_NUM_ROWS_DISPLAYED           IN     NUMBER,
     X_DEFAULT_RESULT_FLAG          IN     VARCHAR2,
     X_SITE_ID                      IN     NUMBER,
     X_WEB_USER_ID                  IN     NUMBER,
     X_CUSTOMIZATION_LEVEL_ID       IN     NUMBER,
     X_IMPORT_FLAG                  IN     VARCHAR2 DEFAULT NULL,
     X_DATA_LEVEL		    IN	   VARCHAR2 DEFAULT NULL,
     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: 1508


     select data_level_query.property_varchar2_value data_level
     from
     AK_CUSTOM_REGIONS_TL name_query ,
     AK_CUSTOM_REGIONS data_level_query
     where name_query.property_name = 'RESULT_NAME'
     and name_query.language = USERENV('LANG')
     and data_level_query.property_name (+) = 'DATA_LEVEL'
     and name_query.customization_application_id = data_level_query.customization_application_id(+)
     and name_query.customization_code = data_level_query.customization_code (+)
     and name_query.region_application_id = data_level_query.region_application_id(+)
     and name_query.region_code = data_level_query.region_code(+)
     and name_query.customization_code = x_customization_code
     and name_query.customization_application_id = x_customization_application_id
     and name_query.region_application_id = x_region_application_id
     and name_query.region_code = x_region_code;

Line: 1541


        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                => 'RESULT_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: 1555


        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                => 'RESULT_DESCRIPTION',
            X_PROPERTY_VARCHAR2_VALUE      => X_DESCRIPTION,
            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: 1578


     Update_Result_Format_Default
     (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_WEB_USER_ID,
       X_CUSTOMIZATION_LEVEL_ID,
       X_IMPORT_FLAG,
       X_CLASSIFICATION_1,
       X_CLASSIFICATION_2,
       X_CLASSIFICATION_3,
       l_data_level
     );

Line: 1595


        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                => 'DEFAULT_RESULT_FLAG',
            X_PROPERTY_VARCHAR2_VALUE      => X_DEFAULT_RESULT_FLAG,
            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: 1609


        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                => 'NUM_ROWS_DISPLAY',
            X_PROPERTY_VARCHAR2_VALUE      => NULL,
            X_PROPERTY_NUMBER_VALUE        => X_NUM_ROWS_DISPLAYED,
            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: 1623


        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                => 'SITE_ID',
            X_PROPERTY_VARCHAR2_VALUE      => NULL,
            X_PROPERTY_NUMBER_VALUE        => X_SITE_ID,
            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: 1637


        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                => 'WEB_USER_ID',
            X_PROPERTY_VARCHAR2_VALUE      => NULL,
            X_PROPERTY_NUMBER_VALUE        => X_WEB_USER_ID,
            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: 1651


        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                => 'CUSTOMIZATION_LEVEL_ID',
            X_PROPERTY_VARCHAR2_VALUE      => NULL,
            X_PROPERTY_NUMBER_VALUE        => X_CUSTOMIZATION_LEVEL_ID,
            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: 1665


    SELECT COUNT(*) INTO l_count
    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
      AND PROPERTY_NAME = 'IMPORT_FLAG';

Line: 1677


        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
        AND PROPERTY_NAME = 'IMPORT_FLAG';

Line: 1684


        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                => 'IMPORT_FLAG',
          X_PROPERTY_VARCHAR2_VALUE      => X_IMPORT_FLAG,
          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: 1703


        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                => 'IMPORT_FLAG',
            X_PROPERTY_VARCHAR2_VALUE      => X_IMPORT_FLAG,
            X_PROPERTY_NUMBER_VALUE        => NULL,
            X_CRITERIA_JOIN_CONDITION      => NULL,
            X_CREATED_BY                   => X_LAST_UPDATED_BY,
            X_CREATION_DATE                => X_LAST_UPDATE_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: 1729


	    SELECT COUNT(*) INTO l_count
	    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
	      AND PROPERTY_NAME = 'DATA_LEVEL';

Line: 1739


		  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                => 'DATA_LEVEL',
		  X_PROPERTY_VARCHAR2_VALUE      => X_DATA_LEVEL,
		  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: 1755


		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                => 'DATA_LEVEL',
		    X_PROPERTY_VARCHAR2_VALUE      => X_DATA_LEVEL,
		    X_PROPERTY_NUMBER_VALUE        => NULL,
		    X_CRITERIA_JOIN_CONDITION      => NULL,
		    X_CREATED_BY                   => X_LAST_UPDATED_BY,
		    X_CREATION_DATE                => X_LAST_UPDATE_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: 1792


END update_result_format;

Line: 1796


 PROCEDURE delete_result_format
  (
     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: 1827


  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: 1833


 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: 1839


  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: 1845


 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: 1851


 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: 1865


  END delete_result_format;

Line: 1873


    ,p_last_update_date              IN   VARCHAR2
    ,p_last_updated_by               IN   NUMBER
    ,p_name                          IN   VARCHAR2
    ,p_description                   IN   VARCHAR2
    ,x_return_status                 OUT  NOCOPY VARCHAR2
    ,x_msg_data                      OUT  NOCOPY VARCHAR2
  ) IS

    l_last_update_login     ak_customizations.last_update_login%TYPE;

Line: 1882


    l_last_update_date      ak_customizations.last_update_date%TYPE;

Line: 1883


    l_last_updated_by       ak_customizations.last_updated_by%TYPE;

Line: 1885


  CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS
  SELECT last_updated_by, last_update_date
  FROM   ak_custom_regions_tl
  WHERE  customization_application_id = p_customization_application_id
    AND  customization_code      =  p_customization_code
    AND  region_application_id   =  p_region_application_id
    AND  region_code             =  p_region_code
    AND  property_name           =  cp_property_name
    AND  USERENV('LANG') IN (language, source_lang);

Line: 1897


    l_last_update_login := FND_GLOBAL.Login_Id;

Line: 1899


    OPEN c_get_last_update_info (cp_property_name => 'RESULT_NAME');

Line: 1900


    FETCH c_get_last_update_info
    INTO l_last_updated_by, l_last_update_date;

Line: 1902


    CLOSE c_get_last_update_info;

Line: 1904


    IF (fnd_load_util.upload_test(p_last_updated_by
                                 ,p_last_update_date
                                 ,l_last_updated_by
                                 ,l_last_update_date
                                 ,NULL)) THEN

      AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
          X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
          X_CUSTOMIZATION_CODE           => p_customization_code,
          X_REGION_APPLICATION_ID        => p_region_application_id,
          X_REGION_CODE                  => p_region_code,
          X_PROPERTY_NAME                => 'RESULT_NAME',
          X_PROPERTY_VARCHAR2_VALUE      => p_name,
          X_PROPERTY_NUMBER_VALUE        => NULL,
          X_CRITERIA_JOIN_CONDITION      => NULL,
          X_LAST_UPDATED_BY              => p_last_updated_by,
          X_LAST_UPDATE_DATE             => SYSDATE,
          X_LAST_UPDATE_LOGIN            => l_last_update_login
          );

Line: 1925


    OPEN c_get_last_update_info (cp_property_name => 'RESULT_DESCRIPTION');

Line: 1926


    FETCH c_get_last_update_info
    INTO l_last_updated_by, l_last_update_date;

Line: 1928


    CLOSE c_get_last_update_info;

Line: 1930


    IF (fnd_load_util.upload_test(p_last_updated_by
                                 ,p_last_update_date
                                 ,l_last_updated_by
                                 ,l_last_update_date
                                 ,NULL)) THEN
      AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
          X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
          X_CUSTOMIZATION_CODE           => p_customization_code,
          X_REGION_APPLICATION_ID        => p_region_application_id,
          X_REGION_CODE                  => p_region_code,
          X_PROPERTY_NAME                => 'RESULT_DESCRIPTION',
          X_PROPERTY_VARCHAR2_VALUE      => p_description,
          X_PROPERTY_NUMBER_VALUE        => NULL,
          X_CRITERIA_JOIN_CONDITION      => NULL,
          X_LAST_UPDATED_BY              => p_last_updated_by,
          X_LAST_UPDATE_DATE             => SYSDATE,
          X_LAST_UPDATE_LOGIN            => l_last_update_login
          );

Line: 1974


     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: 1992


  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: 2013


    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: 2036


   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: 2058


   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: 2080


   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: 2110


  PROCEDURE update_result_column
  (
     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: 2142


   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: 2158


  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: 2174


      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: 2188


      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: 2206


       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: 2230


  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: 2246


      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: 2260


      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: 2278


       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: 2301


  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: 2317


      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: 2331


      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: 2349


       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: 2372


  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: 2388


      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: 2402


      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: 2420


       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: 2448


  END update_result_column;

Line: 2452


 PROCEDURE delete_result_column
  (
     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: 2472


 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: 2480


 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: 2492


  END delete_result_column;

Line: 2495


 PROCEDURE insert_criterion
  (
     X_ROWID                        IN OUT NOCOPY VARCHAR2,
     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_SEQUENCE_NUMBER              IN     NUMBER,
     X_OPERATION                    IN     VARCHAR2,
     X_VALUE_VARCHAR2               IN     VARCHAR2,
     X_SECOND_VALUE_VARCHAR2        IN     VARCHAR2,
     X_VALUE_NUMBER                 IN     NUMBER,
     X_SECOND_VALUE_NUMBER          IN     NUMBER,
     X_VALUE_DATE                   IN     DATE,
     X_SECOND_VALUE_DATE            IN     DATE,
     X_CREATED_BY                   IN     NUMBER,
     X_CREATION_DATE                IN     DATE,
     X_LAST_UPDATED_BY              IN     NUMBER,
     X_LAST_UPDATE_DATE             IN     DATE,
     X_LAST_UPDATE_LOGIN            IN     NUMBER,
     X_START_DATE_ACTIVE            IN     DATE,
     X_END_DATE_ACTIVE              IN     DATE,
     X_USE_KEYWORD_SEARCH           IN     VARCHAR2 := 'Y',
     X_MATCH_CONDITION              IN     VARCHAR2 := 'ALL',
     X_FUZZY                        IN     VARCHAR2 := 'N',
     X_STEMMING                     IN     VARCHAR2 := 'N',
     X_SYNONYMS                     IN     VARCHAR2 := 'N',
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE
  )
  IS

  BEGIN

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

Line: 2534


    AK_CRITERIA_PKG.insert_row
    (
       X_ROWID,
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_ATTRIBUTE_APPLICATION_ID,
       X_ATTRIBUTE_CODE,
       X_SEQUENCE_NUMBER,
       X_OPERATION,
       X_VALUE_VARCHAR2,
       X_VALUE_NUMBER,
       X_VALUE_DATE,
       X_CREATED_BY,
       X_CREATION_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATE_LOGIN,
       X_START_DATE_ACTIVE,
       X_END_DATE_ACTIVE
    );

Line: 2559


    AK_CRITERIA_PKG.insert_row
    (
       X_ROWID,
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_ATTRIBUTE_APPLICATION_ID,
       X_ATTRIBUTE_CODE,
       -1*X_SEQUENCE_NUMBER,
       X_OPERATION,
       X_SECOND_VALUE_VARCHAR2,
       X_SECOND_VALUE_NUMBER,
       X_SECOND_VALUE_DATE,
       X_CREATED_BY,
       X_CREATION_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATE_LOGIN,
       X_START_DATE_ACTIVE,
       X_END_DATE_ACTIVE
    );

Line: 2584


    INSERT INTO EGO_CRITERIA_EXT
     (
       CUSTOMIZATION_APPLICATION_ID,
       CUSTOMIZATION_CODE,
       REGION_APPLICATION_ID,
       REGION_CODE,
       ATTRIBUTE_APPLICATION_ID,
       ATTRIBUTE_CODE,
       SEQUENCE_NUMBER,
       USE_KEYWORD_SEARCH,
       MATCH_CONDITION,
       FUZZY,
       STEMMING,
       SYNONYMS,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATED_DATE,
       LAST_UPDATE_LOGIN
     )
    VALUES
     (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_ATTRIBUTE_APPLICATION_ID,
       X_ATTRIBUTE_CODE,
       X_SEQUENCE_NUMBER,
       X_USE_KEYWORD_SEARCH,
       X_MATCH_CONDITION,
       X_FUZZY,
       X_STEMMING,
       X_SYNONYMS,
       X_CREATED_BY,
       X_CREATION_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATE_LOGIN
      );

Line: 2626


  END insert_criterion;

Line: 2628


  PROCEDURE update_criterion
  (
     X_ROWID                        IN OUT NOCOPY VARCHAR2,
     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_SEQUENCE_NUMBER              IN NUMBER,
     X_OPERATION                    IN VARCHAR2,
     X_VALUE_VARCHAR2               IN VARCHAR2,
     X_SECOND_VALUE_VARCHAR2        IN VARCHAR2,
     X_VALUE_NUMBER                 IN NUMBER,
     X_SECOND_VALUE_NUMBER          IN NUMBER,
     X_VALUE_DATE                   IN DATE,
     X_SECOND_VALUE_DATE            IN DATE,
     X_LAST_UPDATED_BY              IN NUMBER,
     X_LAST_UPDATE_DATE             IN DATE,
     X_LAST_UPDATE_LOGIN            IN NUMBER,
     X_START_DATE_ACTIVE            IN DATE,
     X_END_DATE_ACTIVE              IN DATE,
     X_USE_KEYWORD_SEARCH           IN     VARCHAR2 := 'Y',
     X_MATCH_CONDITION              IN     VARCHAR2 := 'ALL',
     X_FUZZY                        IN     VARCHAR2 := 'N',
     X_STEMMING                     IN     VARCHAR2 := 'N',
     X_SYNONYMS                     IN     VARCHAR2 := 'N',
     X_INIT_MSG_LIST                IN     VARCHAR2   := FND_API.G_FALSE
  )
  IS

  l_count        NUMBER;

Line: 2667


    AK_CRITERIA_PKG.update_row
    (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_ATTRIBUTE_APPLICATION_ID,
       X_ATTRIBUTE_CODE,
       X_SEQUENCE_NUMBER,
       X_OPERATION,
       X_VALUE_VARCHAR2,
       X_VALUE_NUMBER,
       X_VALUE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATE_LOGIN,
       X_START_DATE_ACTIVE,
       X_END_DATE_ACTIVE
    );

Line: 2689


  SELECT
    COUNT(*) INTO l_count
  FROM
    AK_CRITERIA
  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 SEQUENCE_NUMBER = -1*X_SEQUENCE_NUMBER;

Line: 2708


        AK_CRITERIA_PKG.insert_row
        (
           X_ROWID,
           X_CUSTOMIZATION_APPLICATION_ID,
           X_CUSTOMIZATION_CODE,
           X_REGION_APPLICATION_ID,
           X_REGION_CODE,
           X_ATTRIBUTE_APPLICATION_ID,
           X_ATTRIBUTE_CODE,
           -1*X_SEQUENCE_NUMBER,
           X_OPERATION,
           X_SECOND_VALUE_VARCHAR2,
           X_SECOND_VALUE_NUMBER,
           X_SECOND_VALUE_DATE,
           X_LAST_UPDATED_BY,
           X_LAST_UPDATE_DATE,
           X_LAST_UPDATED_BY,
           X_LAST_UPDATE_DATE,
           X_LAST_UPDATE_LOGIN,
           X_START_DATE_ACTIVE,
           X_END_DATE_ACTIVE
        );

Line: 2733


        UPDATE
          AK_CRITERIA
        SET
          VALUE_VARCHAR2 = X_SECOND_VALUE_VARCHAR2,
          VALUE_NUMBER = X_SECOND_VALUE_NUMBER,
          VALUE_DATE = X_SECOND_VALUE_DATE
        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 SEQUENCE_NUMBER = -1*X_SEQUENCE_NUMBER;

Line: 2761


        DELETE FROM
          AK_CRITERIA
        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 SEQUENCE_NUMBER = -1*X_SEQUENCE_NUMBER;

Line: 2780


  UPDATE
    EGO_CRITERIA_EXT
  SET
    USE_KEYWORD_SEARCH = X_USE_KEYWORD_SEARCH,
    MATCH_CONDITION    = X_MATCH_CONDITION,
    FUZZY              = X_FUZZY,
    STEMMING           = X_STEMMING,
    SYNONYMS           = X_SYNONYMS
  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
    SEQUENCE_NUMBER               = X_SEQUENCE_NUMBER;

Line: 2799


    INSERT INTO EGO_CRITERIA_EXT
    (
       CUSTOMIZATION_APPLICATION_ID,
       CUSTOMIZATION_CODE,
       REGION_APPLICATION_ID,
       REGION_CODE,
       ATTRIBUTE_APPLICATION_ID,
       ATTRIBUTE_CODE,
       SEQUENCE_NUMBER,
       USE_KEYWORD_SEARCH,
       MATCH_CONDITION,
       FUZZY,
       STEMMING,
       SYNONYMS,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATED_DATE,
       LAST_UPDATE_LOGIN
     )
    VALUES
     (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_ATTRIBUTE_APPLICATION_ID,
       X_ATTRIBUTE_CODE,
       X_SEQUENCE_NUMBER,
       X_USE_KEYWORD_SEARCH,
       X_MATCH_CONDITION,
       X_FUZZY,
       X_STEMMING,
       X_SYNONYMS,
       X_LAST_UPDATED_BY,  -- X_CREATED_BY,
       X_LAST_UPDATE_DATE, -- X_CREATION_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATE_LOGIN
      );

Line: 2840


END update_criterion;

Line: 2842


  PROCEDURE delete_criterion
  (
     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_SEQUENCE_NUMBER              IN NUMBER,
     X_INIT_MSG_LIST                IN VARCHAR2   := FND_API.G_FALSE
  )
  IS

  l_count  NUMBER;

Line: 2863


    AK_CRITERIA_PKG.delete_row
    (
       X_CUSTOMIZATION_APPLICATION_ID,
       X_CUSTOMIZATION_CODE,
       X_REGION_APPLICATION_ID,
       X_REGION_CODE,
       X_ATTRIBUTE_APPLICATION_ID,
       X_ATTRIBUTE_CODE,
       X_SEQUENCE_NUMBER
    );

Line: 2874


    SELECT
      COUNT(*) INTO l_count
    FROM
      AK_CRITERIA
    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 SEQUENCE_NUMBER = -1*X_SEQUENCE_NUMBER;

Line: 2888


      AK_CRITERIA_PKG.delete_row
      (
         X_CUSTOMIZATION_APPLICATION_ID,
         X_CUSTOMIZATION_CODE,
         X_REGION_APPLICATION_ID,
         X_REGION_CODE,
         X_ATTRIBUTE_APPLICATION_ID,
         X_ATTRIBUTE_CODE,
         -1*X_SEQUENCE_NUMBER
      );

Line: 2901


  DELETE
    EGO_CRITERIA_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 AND
    ATTRIBUTE_APPLICATION_ID      = X_ATTRIBUTE_APPLICATION_ID AND
    ATTRIBUTE_CODE                = X_ATTRIBUTE_CODE AND
    SEQUENCE_NUMBER               = X_SEQUENCE_NUMBER;

Line: 2913


  END delete_criterion;

Line: 2926


     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: 2944


         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: 2973


  PROCEDURE update_result_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: 3000


  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: 3020


  END update_result_section;

Line: 3024


 PROCEDURE delete_result_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: 3044


 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: 3052


 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: 3064


  END delete_result_section;