DBA Data[Home] [Help]

APPS.OKL_VLR_PVT SQL Statements

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

Line: 11

    DELETE FROM OKL_VALIDATION_RESULTS_TL T
    WHERE NOT EXISTS (SELECT NULL FROM OKL_VALIDATION_RESULTS_B B WHERE B.ID =T.ID);
Line: 14

    UPDATE OKL_VALIDATION_RESULTS_TL T
    SET (VALIDATION_TEXT) =
                     (SELECT
                      B.VALIDATION_TEXT
                      FROM
                      OKL_VALIDATION_RESULTS_TL B
                      WHERE
                      B.ID = T.ID
                      AND B.LANGUAGE = T.SOURCE_LANG)
    WHERE (T.ID, T.LANGUAGE) IN (SELECT
                                 SUBT.ID,
                                 SUBT.LANGUAGE
                                 FROM
                                 OKL_VALIDATION_RESULTS_TL SUBB,
                                 OKL_VALIDATION_RESULTS_TL SUBT
                                 WHERE
                                 SUBB.ID = SUBT.ID
                                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                                 AND (SUBB.VALIDATION_TEXT <> SUBT.VALIDATION_TEXT
                                      OR (SUBB.VALIDATION_TEXT IS NULL AND SUBT.VALIDATION_TEXT IS NOT NULL)
                                     )
                                );
Line: 37

    INSERT INTO OKL_VALIDATION_RESULTS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        VALIDATION_TEXT)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.VALIDATION_TEXT
        FROM OKL_VALIDATION_RESULTS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_VALIDATION_RESULTS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 167

    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,parent_object_code
      ,parent_object_id
      ,validation_id
      ,result_code
      ,validation_text
    INTO
      l_vlrv_rec.id
      ,l_vlrv_rec.object_version_number
      ,l_vlrv_rec.attribute_category
      ,l_vlrv_rec.attribute1
      ,l_vlrv_rec.attribute2
      ,l_vlrv_rec.attribute3
      ,l_vlrv_rec.attribute4
      ,l_vlrv_rec.attribute5
      ,l_vlrv_rec.attribute6
      ,l_vlrv_rec.attribute7
      ,l_vlrv_rec.attribute8
      ,l_vlrv_rec.attribute9
      ,l_vlrv_rec.attribute10
      ,l_vlrv_rec.attribute11
      ,l_vlrv_rec.attribute12
      ,l_vlrv_rec.attribute13
      ,l_vlrv_rec.attribute14
      ,l_vlrv_rec.attribute15
      ,l_vlrv_rec.parent_object_code
      ,l_vlrv_rec.parent_object_id
      ,l_vlrv_rec.validation_id
      ,l_vlrv_rec.result_code
      ,l_vlrv_rec.validation_text
    FROM okl_validation_results_v
    WHERE id = p_id;
Line: 423

  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_vlr_rec IN vlr_rec_type) IS

    l_prog_name  VARCHAR2(61);
Line: 429

    l_prog_name := G_PKG_NAME||'.insert_row (B)';
Line: 431

    INSERT INTO okl_validation_results_b (
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,created_by
      ,creation_date
      ,last_updated_by
      ,last_update_date
      ,last_update_login
      ,parent_object_code
      ,parent_object_id
      ,validation_id
      ,result_code
      )
    VALUES
      (
       p_vlr_rec.id
      ,p_vlr_rec.object_version_number
      ,p_vlr_rec.attribute_category
      ,p_vlr_rec.attribute1
      ,p_vlr_rec.attribute2
      ,p_vlr_rec.attribute3
      ,p_vlr_rec.attribute4
      ,p_vlr_rec.attribute5
      ,p_vlr_rec.attribute6
      ,p_vlr_rec.attribute7
      ,p_vlr_rec.attribute8
      ,p_vlr_rec.attribute9
      ,p_vlr_rec.attribute10
      ,p_vlr_rec.attribute11
      ,p_vlr_rec.attribute12
      ,p_vlr_rec.attribute13
      ,p_vlr_rec.attribute14
      ,p_vlr_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_vlr_rec.parent_object_code
      ,p_vlr_rec.parent_object_id
      ,p_vlr_rec.validation_id
      ,p_vlr_rec.result_code
    );
Line: 508

  END insert_row;
Line: 514

  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_vlrtl_rec IN vlrtl_rec_type) IS

    CURSOR get_languages IS
      SELECT language_code
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');
Line: 527

    l_prog_name := G_PKG_NAME||'.insert_row (TL)';
Line: 537

      INSERT INTO OKL_VALIDATION_RESULTS_TL (
        id
       ,language
       ,source_lang
       ,sfwt_flag
       ,created_by
       ,creation_date
       ,last_updated_by
       ,last_update_date
       ,last_update_login
       ,validation_text)
      VALUES (
        p_vlrtl_rec.id
       ,l_lang_rec.language_code
       ,USERENV('LANG')
       ,l_sfwt_flag
       ,G_USER_ID
       ,SYSDATE
       ,G_USER_ID
       ,SYSDATE
       ,G_LOGIN_ID
       ,p_vlrtl_rec.validation_text);
Line: 579

  END insert_row;
Line: 585

  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_vlrv_rec                     IN vlrv_rec_type,
    x_vlrv_rec                     OUT NOCOPY vlrv_rec_type) IS

    l_return_status                VARCHAR2(1);
Line: 600

    l_prog_name := G_PKG_NAME||'.insert_row (V)';
Line: 604

    SELECT okl_vlr_seq.nextval INTO l_vlrv_rec.ID FROM DUAL;
Line: 627

    insert_row (x_return_status => l_return_status, p_vlr_rec => l_vlr_rec);
Line: 635

    insert_row (x_return_status => l_return_status, p_vlrtl_rec => l_vlrtl_rec);
Line: 669

  END insert_row;
Line: 675

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vlrv_rec                     IN vlrv_rec_type,
    x_vlrv_rec                     OUT NOCOPY vlrv_rec_type) IS

    l_return_status              VARCHAR2(1);
Line: 690

    l_prog_name := G_PKG_NAME||'.insert_row (REC)';
Line: 696

    insert_row (x_return_status                => l_return_status,
                p_vlrv_rec                     => p_vlrv_rec,
                x_vlrv_rec                     => x_vlrv_rec);
Line: 731

  END insert_row;
Line: 737

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vlrv_tbl                     IN vlrv_tbl_type,
    x_vlrv_tbl                     OUT NOCOPY vlrv_tbl_type) IS

    l_return_status              VARCHAR2(1);
Line: 753

    l_prog_name := G_PKG_NAME||'.insert_row (TBL)';
Line: 764

          insert_row (x_return_status                => l_return_status,
                      p_vlrv_rec                     => p_vlrv_tbl(i),
                      x_vlrv_rec                     => x_vlrv_tbl(i));
Line: 812

  END insert_row;
Line: 825

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VALIDATION_RESULTS_B
     WHERE ID = p_vlr_rec.id
       AND OBJECT_VERSION_NUMBER = p_vlr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 832

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VALIDATION_RESULTS_B
     WHERE ID = p_vlr_rec.id;
Line: 919

  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_vlr_rec IN vlr_rec_type) IS

    l_return_status           VARCHAR2(1);
Line: 927

    l_prog_name := G_PKG_NAME||'.update_row (B)';
Line: 937

    UPDATE okl_validation_results_b
    SET
      object_version_number = p_vlr_rec.object_version_number+1
      ,attribute_category = p_vlr_rec.attribute_category
      ,attribute1 = p_vlr_rec.attribute1
      ,attribute2 = p_vlr_rec.attribute2
      ,attribute3 = p_vlr_rec.attribute3
      ,attribute4 = p_vlr_rec.attribute4
      ,attribute5 = p_vlr_rec.attribute5
      ,attribute6 = p_vlr_rec.attribute6
      ,attribute7 = p_vlr_rec.attribute7
      ,attribute8 = p_vlr_rec.attribute8
      ,attribute9 = p_vlr_rec.attribute9
      ,attribute10 = p_vlr_rec.attribute10
      ,attribute11 = p_vlr_rec.attribute11
      ,attribute12 = p_vlr_rec.attribute12
      ,attribute13 = p_vlr_rec.attribute13
      ,attribute14 = p_vlr_rec.attribute14
      ,attribute15 = p_vlr_rec.attribute15
      ,parent_object_code = p_vlr_rec.parent_object_code
      ,parent_object_id = p_vlr_rec.parent_object_id
      ,validation_id = p_vlr_rec.validation_id
      ,result_code = p_vlr_rec.result_code
    WHERE id = p_vlr_rec.id;
Line: 984

  END update_row;
Line: 990

  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_vlrtl_rec IN vlrtl_rec_type) IS

    l_prog_name               VARCHAR2(61);
Line: 996

    l_prog_name := G_PKG_NAME||'.update_row (TL)';
Line: 998

    UPDATE OKL_VALIDATION_RESULTS_TL
    SET
      source_lang = USERENV('LANG')
      ,sfwt_flag = 'Y'
      ,last_updated_by = G_USER_ID
      ,last_update_date = SYSDATE
      ,last_update_login = G_LOGIN_ID
      ,validation_text = p_vlrtl_rec.validation_text
    WHERE ID = p_vlrtl_rec.id;
Line: 1008

    UPDATE OKL_VALIDATION_RESULTS_TL
    SET SFWT_FLAG = 'N'
    WHERE ID = p_vlrtl_rec.id
    AND SOURCE_LANG = LANGUAGE;
Line: 1030

  END update_row;
Line: 1036

  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_vlrv_rec                     IN vlrv_rec_type,
    x_vlrv_rec                     OUT NOCOPY vlrv_rec_type) IS

    l_prog_name                    VARCHAR2(61);
Line: 1162

    l_prog_name := G_PKG_NAME||'.update_row (V)';
Line: 1191

    update_row (x_return_status => l_return_status, p_vlr_rec => l_vlr_rec);
Line: 1199

    update_row (x_return_status => l_return_status, p_vlrtl_rec => l_vlrtl_rec);
Line: 1233

  END update_row;
Line: 1239

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vlrv_rec                     IN vlrv_rec_type,
    x_vlrv_rec                     OUT NOCOPY vlrv_rec_type) IS

    l_return_status              VARCHAR2(1);
Line: 1254

    l_prog_name := G_PKG_NAME||'.update_row (REC)';
Line: 1260

    update_row (x_return_status                => l_return_status,
                p_vlrv_rec                     => p_vlrv_rec,
                x_vlrv_rec                     => x_vlrv_rec);
Line: 1295

  END update_row;
Line: 1301

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vlrv_tbl                     IN vlrv_tbl_type,
    x_vlrv_tbl                     OUT NOCOPY vlrv_tbl_type) IS

    l_return_status              VARCHAR2(1);
Line: 1316

    l_prog_name := G_PKG_NAME||'.update_row (TBL)';
Line: 1331

          update_row (x_return_status                => l_return_status,
                      p_vlrv_rec                     => p_vlrv_tbl(i),
                      x_vlrv_rec                     => x_vlrv_tbl(i));
Line: 1379

  END update_row;
Line: 1385

  PROCEDURE delete_row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_id                           IN NUMBER) IS

    l_prog_name                  VARCHAR2(61);
Line: 1393

    l_prog_name := G_PKG_NAME||'.delete_row (V)';
Line: 1395

    DELETE FROM OKL_VALIDATION_RESULTS_B WHERE id = p_id;
Line: 1396

    DELETE FROM OKL_VALIDATION_RESULTS_TL WHERE id = p_id;
Line: 1415

  END delete_row;
Line: 1421

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vlrv_rec                     IN vlrv_rec_type) IS

    l_return_status              VARCHAR2(1);
Line: 1435

    l_prog_name := G_PKG_NAME||'.delete_row (REC)';
Line: 1441

    delete_row (x_return_status                => l_return_status,
                p_id                           => p_vlrv_rec.id);
Line: 1475

  END delete_row;
Line: 1481

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vlrv_tbl                     IN vlrv_tbl_type) IS

    l_return_status                VARCHAR2(1);
Line: 1496

    l_prog_name := G_PKG_NAME||'.delete_row (TBL)';
Line: 1510

          delete_row (x_return_status                => l_return_status,
                      p_id                           => p_vlrv_tbl(i).id);
Line: 1549

  END delete_row;