APPS.BNE_QUERY_UTILS SQL Statements

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

Line: 60

  BNE_QUERIES_PKG.INSERT_ROW (
    X_ROWID                 => X_ROWID,
    X_APPLICATION_ID        => P_APPLICATION_ID,
    X_QUERY_CODE            => P_QUERY_CODE,
    X_OBJECT_VERSION_NUMBER => 1,
    X_QUERY_CLASS           => 'oracle.apps.bne.query.BneSimpleSQLQuery',
    X_USER_NAME             => P_USER_NAME,
    X_CREATION_DATE         => SYSDATE,
    X_CREATED_BY            => P_USER_ID,
    X_LAST_UPDATE_DATE      => SYSDATE,
    X_LAST_UPDATED_BY       => P_USER_ID,
    X_LAST_UPDATE_LOGIN     => 0);

Line: 76

  BNE_SIMPLE_QUERY_PKG.INSERT_ROW (
    X_ROWID                 => X_ROWID,
    X_APPLICATION_ID        => P_APPLICATION_ID,
    X_QUERY_CODE            => P_QUERY_CODE,
    X_OBJECT_VERSION_NUMBER => 1,
    X_ID_COL                => P_ID_COL,
    X_ID_COL_ALIAS          => P_ID_COL_ALIAS,
    X_MEANING_COL           => P_MEANING_COL,
    X_MEANING_COL_ALIAS     => P_MEANING_COL_ALIAS,
    X_DESCRIPTION_COL       => P_DESCRIPTION_COL,
    X_DESCRIPTION_COL_ALIAS => P_DESCRIPTION_COL_ALIAS,
    X_ADDITIONAL_COLS       => P_ADDITIONAL_COLS,
    X_OBJECT_NAME           => P_OBJECT_NAME,
    X_ADDITIONAL_WHERE_CLAUSE => X_ADDITIONAL_WHERE_CLAUSE,
    X_ORDER_BY_CLAUSE       => P_ORDER_BY_CLAUSE,
    X_CREATION_DATE         => SYSDATE,
    X_CREATED_BY            => P_USER_ID,
    X_LAST_UPDATE_DATE      => SYSDATE,
    X_LAST_UPDATED_BY       => P_USER_ID,
    X_LAST_UPDATE_LOGIN     => 0);

Line: 103

    BNE_RAW_QUERY_PKG.INSERT_ROW (
      X_ROWID                 => X_ROWID,
      X_APPLICATION_ID        => P_APPLICATION_ID,
      X_QUERY_CODE            => P_QUERY_CODE,
      X_SEQUENCE_NUM          => X_LOOP_CNT,
      X_OBJECT_VERSION_NUMBER => 1,
      X_QUERY                 => X_ADDITIONAL_WHERE_CLAUSE,
      X_CREATION_DATE         => SYSDATE,
      X_CREATED_BY            => P_USER_ID,
      X_LAST_UPDATE_DATE      => SYSDATE,
      X_LAST_UPDATED_BY       => P_USER_ID,
      X_LAST_UPDATE_LOGIN     => 0);

Line: 151

  BNE_QUERIES_PKG.INSERT_ROW (
    X_ROWID                 => X_ROWID,
    X_APPLICATION_ID        => P_APPLICATION_ID,
    X_QUERY_CODE            => P_QUERY_CODE,
    X_OBJECT_VERSION_NUMBER => 1,
    X_QUERY_CLASS           => 'oracle.apps.bne.query.BneRawSQLQuery',
    X_USER_NAME             => P_USER_NAME,
    X_CREATION_DATE         => SYSDATE,
    X_CREATED_BY            => P_USER_ID,
    X_LAST_UPDATE_DATE      => SYSDATE,
    X_LAST_UPDATED_BY       => P_USER_ID,
    X_LAST_UPDATE_LOGIN     => 0);

Line: 170

    BNE_RAW_QUERY_PKG.INSERT_ROW (
      X_ROWID                 => X_ROWID,
      X_APPLICATION_ID        => P_APPLICATION_ID,
      X_QUERY_CODE            => P_QUERY_CODE,
      X_SEQUENCE_NUM          => X_LOOP_CNT,
      X_OBJECT_VERSION_NUMBER => 1,
      X_QUERY                 => X_QUERY,
      X_CREATION_DATE         => SYSDATE,
      X_CREATED_BY            => P_USER_ID,
      X_LAST_UPDATE_DATE      => SYSDATE,
      X_LAST_UPDATED_BY       => P_USER_ID,
      X_LAST_UPDATE_LOGIN     => 0);

Line: 215

  BNE_QUERIES_PKG.INSERT_ROW (
    X_ROWID                 => X_ROWID,
    X_APPLICATION_ID        => P_APPLICATION_ID,
    X_QUERY_CODE            => P_QUERY_CODE,
    X_OBJECT_VERSION_NUMBER => 1,
    X_QUERY_CLASS           => P_QUERY_CLASS,
    X_USER_NAME             => P_USER_NAME,
    X_CREATION_DATE         => SYSDATE,
    X_CREATED_BY            => P_USER_ID,
    X_LAST_UPDATE_DATE      => SYSDATE,
    X_LAST_UPDATED_BY       => P_USER_ID,
    X_LAST_UPDATE_LOGIN     => 0);

Line: 244

PROCEDURE DELETE_QUERY
                  (P_APPLICATION_ID          IN NUMBER,
                   P_QUERY_CODE              IN VARCHAR2
                  )
IS
BEGIN
  VALIDATE_KEYS(P_APPLICATION_ID, P_QUERY_CODE);

Line: 252

  DELETE FROM BNE_QUERIES_B    WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;

Line: 253

  DELETE FROM BNE_QUERIES_TL   WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;

Line: 254

  DELETE FROM BNE_SIMPLE_QUERY WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;

Line: 255

  DELETE FROM BNE_RAW_QUERY    WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;

Line: 256

END DELETE_QUERY;