APPS.EGO_IMPORT_BATCHES_PKG SQL Statements

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

Line: 4

  PROCEDURE INSERT_ROW (
    X_ROWID                  IN OUT NOCOPY VARCHAR2,
    X_BATCH_ID               IN NUMBER,
    X_ORGANIZATION_ID        IN NUMBER,
    X_SOURCE_SYSTEM_ID       IN NUMBER,
    X_BATCH_TYPE             IN VARCHAR2,
    X_ASSIGNEE               IN NUMBER,
    X_BATCH_STATUS           IN VARCHAR2,
    X_OBJECT_VERSION_NUMBER  IN NUMBER,
    X_NAME                   IN VARCHAR2,
    X_DESCRIPTION            IN VARCHAR2,
    X_CREATION_DATE          IN DATE,
    X_CREATED_BY             IN NUMBER,
    X_LAST_UPDATE_DATE       IN DATE,
    X_LAST_UPDATED_BY        IN NUMBER,
    X_LAST_UPDATE_LOGIN      IN NUMBER)
   IS
    CURSOR C IS
      SELECT ROWID FROM EGO_IMPORT_BATCHES_B
      WHERE BATCH_ID = X_BATCH_ID;

Line: 25

    INSERT into EGO_IMPORT_BATCHES_B (
      ORGANIZATION_ID,
      BATCH_ID,
      SOURCE_SYSTEM_ID,
      BATCH_TYPE,
      ASSIGNEE,
      BATCH_STATUS,
      OBJECT_VERSION_NUMBER,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN
    ) values (
      X_ORGANIZATION_ID,
      X_BATCH_ID,
      X_SOURCE_SYSTEM_ID,
      X_BATCH_TYPE,
      X_ASSIGNEE,
      X_BATCH_STATUS,
      X_OBJECT_VERSION_NUMBER,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 53

    INSERT into EGO_IMPORT_BATCHES_TL (
      BATCH_ID,
      NAME,
      DESCRIPTION,
      OBJECT_VERSION_NUMBER,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      LANGUAGE,
      SOURCE_LANG
    ) SELECT
      X_BATCH_ID,
      X_NAME,
      X_DESCRIPTION,
      X_OBJECT_VERSION_NUMBER,
      X_CREATED_BY,
      X_CREATION_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN,
      L.LANGUAGE_CODE,
      USERENV('LANG')
    FROM FND_LANGUAGES L
    WHERE L.INSTALLED_FLAG IN ('I', 'B')
    AND NOT EXISTS
      (SELECT NULL
      FROM EGO_IMPORT_BATCHES_TL T
      WHERE T.BATCH_ID = X_BATCH_ID
      AND T.LANGUAGE = L.LANGUAGE_CODE);

Line: 92

  END INSERT_ROW;

Line: 106

      SELECT
        ORGANIZATION_ID,
        SOURCE_SYSTEM_ID,
        BATCH_TYPE,
        ASSIGNEE,
        BATCH_STATUS,
        OBJECT_VERSION_NUMBER
      FROM EGO_IMPORT_BATCHES_B
      WHERE BATCH_ID = X_BATCH_ID
      FOR UPDATE OF BATCH_ID NOWAIT;

Line: 120

      SELECT
        NAME,
        DESCRIPTION,
        DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
      FROM EGO_IMPORT_BATCHES_TL
      WHERE BATCH_ID = X_BATCH_ID
      AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
      FOR UPDATE OF BATCH_ID NOWAIT;

Line: 133

      FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 167

  PROCEDURE UPDATE_ROW (
    X_BATCH_ID               IN NUMBER,
    X_ORGANIZATION_ID        IN NUMBER,
    X_SOURCE_SYSTEM_ID       IN NUMBER,
    X_BATCH_TYPE             IN VARCHAR2,
    X_ASSIGNEE               IN NUMBER,
    X_BATCH_STATUS           IN VARCHAR2,
    X_OBJECT_VERSION_NUMBER  IN NUMBER,
    X_NAME                   IN VARCHAR2,
    X_DESCRIPTION            IN VARCHAR2,
    X_LAST_UPDATE_DATE       IN DATE,
    X_LAST_UPDATED_BY        IN NUMBER,
    X_LAST_UPDATE_LOGIN      IN NUMBER
  ) IS
  BEGIN
    UPDATE EGO_IMPORT_BATCHES_B SET
      ORGANIZATION_ID = X_ORGANIZATION_ID,
      SOURCE_SYSTEM_ID = X_SOURCE_SYSTEM_ID,
      BATCH_TYPE = X_BATCH_TYPE,
      ASSIGNEE = X_ASSIGNEE,
      BATCH_STATUS = X_BATCH_STATUS,
      OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    WHERE BATCH_ID = X_BATCH_ID;

Line: 198

    UPDATE EGO_IMPORT_BATCHES_TL SET
      NAME = X_NAME,
      DESCRIPTION = X_DESCRIPTION,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      SOURCE_LANG = USERENV('LANG')
    WHERE BATCH_ID = X_BATCH_ID
    AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 211

  END UPDATE_ROW;

Line: 213

  PROCEDURE DELETE_ROW (
    X_BATCH_ID IN NUMBER
  ) IS
  BEGIN
    DELETE FROM EGO_IMPORT_BATCHES_TL
    WHERE BATCH_ID = X_BATCH_ID;

Line: 224

    DELETE FROM EGO_IMPORT_BATCHES_B
    WHERE BATCH_ID = X_BATCH_ID;

Line: 230

  END DELETE_ROW;

Line: 236

    DELETE FROM EGO_IMPORT_BATCHES_TL T
    WHERE NOT EXISTS
      (SELECT NULL
      FROM EGO_IMPORT_BATCHES_B B
      WHERE B.BATCH_ID = T.BATCH_ID
      );

Line: 243

    UPDATE EGO_IMPORT_BATCHES_TL T SET (
        NAME,
        DESCRIPTION
      ) = (SELECT
        B.NAME,
        B.DESCRIPTION
      FROM EGO_IMPORT_BATCHES_TL B
      WHERE B.BATCH_ID = T.BATCH_ID
      AND B.LANGUAGE = T.SOURCE_LANG)
    WHERE (
        T.BATCH_ID,
        T.LANGUAGE
    ) IN (SELECT
        SUBT.BATCH_ID,
        SUBT.LANGUAGE
      FROM EGO_IMPORT_BATCHES_TL SUBB, EGO_IMPORT_BATCHES_TL SUBT
      WHERE SUBB.BATCH_ID = SUBT.BATCH_ID
      AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
      AND (SUBB.NAME <> SUBT.NAME
        OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
        OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
        OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
    ));

Line: 267

    INSERT INTO EGO_IMPORT_BATCHES_TL (
      BATCH_ID,
      NAME,
      DESCRIPTION,
      OBJECT_VERSION_NUMBER,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      LANGUAGE,
      SOURCE_LANG
    ) SELECT /*+ ORDERED */
      B.BATCH_ID,
      B.NAME,
      B.DESCRIPTION,
      B.OBJECT_VERSION_NUMBER,
      B.CREATED_BY,
      B.CREATION_DATE,
      B.LAST_UPDATED_BY,
      B.LAST_UPDATE_DATE,
      B.LAST_UPDATE_LOGIN,
      L.LANGUAGE_CODE,
      B.SOURCE_LANG
    FROM EGO_IMPORT_BATCHES_TL B, FND_LANGUAGES L
    WHERE L.INSTALLED_FLAG IN ('I', 'B')
    AND B.LANGUAGE = USERENV('LANG')
    AND NOT EXISTS
      (SELECT NULL
      FROM EGO_IMPORT_BATCHES_TL T
      WHERE T.BATCH_ID = B.BATCH_ID
      AND T.LANGUAGE = L.LANGUAGE_CODE);