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

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

Line: 101


    SELECT
            ID,
            QUOTE_ID,
            CREDIT_REQ_NUMBER,
            CREDIT_REQ_ID,
            CREDIT_AMOUNT,
            REQUESTED_BY,
            REQUESTED_DATE,
            APPROVED_BY,
            APPROVED_DATE,
            STATUS,
            CREDIT_KHR_ID,
            CURRENCY_CODE,
            OBJECT_VERSION_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_CREDIT_REQUESTS
     WHERE OKL_CREDIT_REQUESTS.id = p_id;

Line: 178


              l_crqv_rec.last_updated_by,
              l_crqv_rec.last_update_date,
              l_crqv_rec.last_update_login;

Line: 222


    SELECT
            ID,
            QUOTE_ID,
            CREDIT_REQ_NUMBER,
            CREDIT_REQ_ID,
            CREDIT_AMOUNT,
            REQUESTED_BY,
            REQUESTED_DATE,
            APPROVED_BY,
            APPROVED_DATE,
            STATUS,
            CREDIT_KHR_ID,
            CURRENCY_CODE,
            OBJECT_VERSION_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Credit_Requests
     WHERE okl_credit_requests.id = p_id;

Line: 299


              l_crq_rec.last_updated_by,
              l_crq_rec.last_update_date,
              l_crq_rec.last_update_login;

Line: 439


    IF (l_crqv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_crqv_rec.last_updated_by := NULL;

Line: 442


    IF (l_crqv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_crqv_rec.last_update_date := NULL;

Line: 445


    IF (l_crqv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_crqv_rec.last_update_login := NULL;

Line: 643


      SELECT 'x'
        FROM Okc_K_Headers_V
       WHERE okc_k_headers_v.id   = p_id;

Line: 725


    p_to.last_updated_by := p_from.last_updated_by;

Line: 726


    p_to.last_update_date := p_from.last_update_date;

Line: 727


    p_to.last_update_login := p_from.last_update_login;

Line: 766


    p_to.last_updated_by := p_from.last_updated_by;

Line: 767


    p_to.last_update_date := p_from.last_update_date;

Line: 768


    p_to.last_update_login := p_from.last_update_login;

Line: 1014


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crq_rec                      IN crq_rec_type,
    x_crq_rec                      OUT NOCOPY crq_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1023


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';

Line: 1059


    INSERT INTO OKL_CREDIT_REQUESTS(
      id,
      quote_id,
      credit_req_number,
      credit_req_id,
      credit_amount,
      requested_by,
      requested_date,
      approved_by,
      approved_date,
      status,
      credit_khr_id,
      currency_code,
      object_version_number,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      org_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_crq_rec.id,
      l_crq_rec.quote_id,
      l_crq_rec.credit_req_number,
      l_crq_rec.credit_req_id,
      l_crq_rec.credit_amount,
      l_crq_rec.requested_by,
      l_crq_rec.requested_date,
      l_crq_rec.approved_by,
      l_crq_rec.approved_date,
      l_crq_rec.status,
      l_crq_rec.credit_khr_id,
      l_crq_rec.currency_code,
      l_crq_rec.object_version_number,
      l_crq_rec.attribute_category,
      l_crq_rec.attribute1,
      l_crq_rec.attribute2,
      l_crq_rec.attribute3,
      l_crq_rec.attribute4,
      l_crq_rec.attribute5,
      l_crq_rec.attribute6,
      l_crq_rec.attribute7,
      l_crq_rec.attribute8,
      l_crq_rec.attribute9,
      l_crq_rec.attribute10,
      l_crq_rec.attribute11,
      l_crq_rec.attribute12,
      l_crq_rec.attribute13,
      l_crq_rec.attribute14,
      l_crq_rec.attribute15,
      l_crq_rec.org_id,
      l_crq_rec.created_by,
      l_crq_rec.creation_date,
      l_crq_rec.last_updated_by,
      l_crq_rec.last_update_date,
      l_crq_rec.last_update_login);

Line: 1166


  END insert_row;

Line: 1170


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_rec                     IN crqv_rec_type,
    x_crqv_rec                     OUT NOCOPY crqv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1180


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 1196


      l_crqv_rec.LAST_UPDATE_DATE := l_crqv_rec.CREATION_DATE;

Line: 1197


      l_crqv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1198


      l_crqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1262


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crq_rec,
      lx_crq_rec
    );

Line: 1311


  END insert_row;

Line: 1315


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_tbl                     IN crqv_tbl_type,
    x_crqv_tbl                     OUT NOCOPY crqv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1326


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';

Line: 1340


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_crqv_rec                     => p_crqv_tbl(i),
            x_crqv_rec                     => x_crqv_tbl(i));

Line: 1408


  END insert_row;

Line: 1413


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_tbl                     IN crqv_tbl_type,
    x_crqv_tbl                     OUT NOCOPY crqv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1423


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1430


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_crqv_tbl                     => p_crqv_tbl,
        x_crqv_tbl                     => x_crqv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1472


  END insert_row;

Line: 1490


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CREDIT_REQUESTS
     WHERE ID = p_crq_rec.id
       AND OBJECT_VERSION_NUMBER = p_crq_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1497


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CREDIT_REQUESTS
     WHERE ID = p_crq_rec.id;

Line: 1538


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1547


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1827


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crq_rec                      IN crq_rec_type,
    x_crq_rec                      OUT NOCOPY crq_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1836


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';

Line: 1984


        IF (x_crq_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_crq_rec.last_updated_by := l_crq_rec.last_updated_by;

Line: 1988


        IF (x_crq_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_crq_rec.last_update_date := l_crq_rec.last_update_date;

Line: 1992


        IF (x_crq_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_crq_rec.last_update_login := l_crq_rec.last_update_login;

Line: 2038


    UPDATE OKL_CREDIT_REQUESTS
    SET QUOTE_ID = l_def_crq_rec.quote_id,
        CREDIT_REQ_NUMBER = l_def_crq_rec.credit_req_number,
        CREDIT_REQ_ID = l_def_crq_rec.credit_req_id,
        CREDIT_AMOUNT = l_def_crq_rec.credit_amount,
        REQUESTED_BY = l_def_crq_rec.requested_by,
        REQUESTED_DATE = l_def_crq_rec.requested_date,
        APPROVED_BY = l_def_crq_rec.approved_by,
        APPROVED_DATE = l_def_crq_rec.approved_date,
        STATUS = l_def_crq_rec.status,
        CREDIT_KHR_ID = l_def_crq_rec.credit_khr_id,
        CURRENCY_CODE = l_def_crq_rec.currency_code,
        OBJECT_VERSION_NUMBER = l_def_crq_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_crq_rec.attribute_category,
        ATTRIBUTE1 = l_def_crq_rec.attribute1,
        ATTRIBUTE2 = l_def_crq_rec.attribute2,
        ATTRIBUTE3 = l_def_crq_rec.attribute3,
        ATTRIBUTE4 = l_def_crq_rec.attribute4,
        ATTRIBUTE5 = l_def_crq_rec.attribute5,
        ATTRIBUTE6 = l_def_crq_rec.attribute6,
        ATTRIBUTE7 = l_def_crq_rec.attribute7,
        ATTRIBUTE8 = l_def_crq_rec.attribute8,
        ATTRIBUTE9 = l_def_crq_rec.attribute9,
        ATTRIBUTE10 = l_def_crq_rec.attribute10,
        ATTRIBUTE11 = l_def_crq_rec.attribute11,
        ATTRIBUTE12 = l_def_crq_rec.attribute12,
        ATTRIBUTE13 = l_def_crq_rec.attribute13,
        ATTRIBUTE14 = l_def_crq_rec.attribute14,
        ATTRIBUTE15 = l_def_crq_rec.attribute15,
        ORG_ID = l_def_crq_rec.org_id,
        CREATED_BY = l_def_crq_rec.created_by,
        CREATION_DATE = l_def_crq_rec.creation_date,
        LAST_UPDATED_BY = l_def_crq_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_crq_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_crq_rec.last_update_login
    WHERE ID = l_def_crq_rec.id;

Line: 2109


  END update_row;

Line: 2113


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_rec                     IN crqv_rec_type,
    x_crqv_rec                     OUT NOCOPY crqv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2123


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 2138


      l_crqv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2139


      l_crqv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2140


      l_crqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2283


        IF (x_crqv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_crqv_rec.last_updated_by := l_db_crqv_rec.last_updated_by;

Line: 2287


        IF (x_crqv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_crqv_rec.last_update_date := l_db_crqv_rec.last_update_date;

Line: 2291


        IF (x_crqv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_crqv_rec.last_update_login := l_db_crqv_rec.last_update_login;

Line: 2376


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crq_rec,
      lx_crq_rec
    );

Line: 2424


  END update_row;

Line: 2428


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_tbl                     IN crqv_tbl_type,
    x_crqv_tbl                     OUT NOCOPY crqv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2439


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';

Line: 2453


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_crqv_rec                     => p_crqv_tbl(i),
            x_crqv_rec                     => x_crqv_tbl(i));

Line: 2521


  END update_row;

Line: 2526


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_tbl                     IN crqv_tbl_type,
    x_crqv_tbl                     OUT NOCOPY crqv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2536


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 2543


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_crqv_tbl                     => p_crqv_tbl,
        x_crqv_tbl                     => x_crqv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2585


  END update_row;

Line: 2593


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crq_rec                      IN crq_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2601


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';

Line: 2616


    DELETE FROM OKL_CREDIT_REQUESTS
     WHERE ID = p_crq_rec.id;

Line: 2652


  END delete_row;

Line: 2656


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_rec                     IN crqv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2665


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2689


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crq_rec
    );

Line: 2734


  END delete_row;

Line: 2738


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_tbl                     IN crqv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2748


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';

Line: 2762


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_crqv_rec                     => p_crqv_tbl(i));

Line: 2829


  END delete_row;

Line: 2834


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crqv_tbl                     IN crqv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2843


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2850


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_crqv_tbl                     => p_crqv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2891


  END delete_row;