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_XLR_PVT SQL Statements

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

Line: 44


    SELECT
            ID,
            IRN_ID,
            IMR_ID,
            XHR_ID_DETAILS,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            QUANTITY,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            LAST_UPDATE_LOGIN
      FROM Okl_Xtl_Fund_Rqns_B
     WHERE okl_xtl_fund_rqns_b.id = p_id;

Line: 93


              l_xlr_rec.LAST_UPDATED_BY,
              l_xlr_rec.LAST_UPDATE_DATE,
              l_xlr_rec.QUANTITY,
              l_xlr_rec.ORG_ID,
              l_xlr_rec.REQUEST_ID,
              l_xlr_rec.PROGRAM_APPLICATION_ID,
              l_xlr_rec.PROGRAM_ID,
              l_xlr_rec.PROGRAM_UPDATE_DATE,
              l_xlr_rec.ATTRIBUTE_CATEGORY,
              l_xlr_rec.ATTRIBUTE1,
              l_xlr_rec.ATTRIBUTE2,
              l_xlr_rec.ATTRIBUTE3,
              l_xlr_rec.ATTRIBUTE4,
              l_xlr_rec.ATTRIBUTE5,
              l_xlr_rec.ATTRIBUTE6,
              l_xlr_rec.ATTRIBUTE7,
              l_xlr_rec.ATTRIBUTE8,
              l_xlr_rec.ATTRIBUTE9,
              l_xlr_rec.ATTRIBUTE10,
              l_xlr_rec.ATTRIBUTE11,
              l_xlr_rec.ATTRIBUTE12,
              l_xlr_rec.ATTRIBUTE13,
              l_xlr_rec.ATTRIBUTE14,
              l_xlr_rec.ATTRIBUTE15,
              l_xlr_rec.LAST_UPDATE_LOGIN;

Line: 138


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            IRN_ID,
            IMR_ID,
            XHR_ID_DETAILS,
            QUANTITY,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Xtl_Fund_Rqns_V
     WHERE okl_xtl_fund_rqns_v.id = p_id;

Line: 206


              l_xlrv_rec.PROGRAM_UPDATE_DATE,
              l_xlrv_rec.CREATED_BY,
              l_xlrv_rec.CREATION_DATE,
              l_xlrv_rec.LAST_UPDATED_BY,
              l_xlrv_rec.LAST_UPDATE_DATE,
              l_xlrv_rec.LAST_UPDATE_LOGIN;

Line: 308


    IF (l_xlrv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
      l_xlrv_rec.program_update_date := NULL;

Line: 317


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

Line: 320


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

Line: 323


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

Line: 387


    p_to.last_updated_by := p_from.last_updated_by;

Line: 388


    p_to.last_update_date := p_from.last_update_date;

Line: 394


    p_to.program_update_date := p_from.program_update_date;

Line: 411


    p_to.last_update_login := p_from.last_update_login;

Line: 425


    p_to.last_updated_by := p_from.last_updated_by;

Line: 426


    p_to.last_update_date := p_from.last_update_date;

Line: 432


    p_to.program_update_date := p_from.program_update_date;

Line: 449


    p_to.last_update_login := p_from.last_update_login;

Line: 602


  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_xlr_rec                      IN xlr_rec_type,
    x_xlr_rec                      OUT NOCOPY xlr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 611


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

Line: 647


    INSERT INTO OKL_XTL_FUND_RQNS_B(
        id,
        irn_id,
        imr_id,
        xhr_id_details,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        quantity,
        org_id,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        last_update_login)
      VALUES (
        l_xlr_rec.id,
        l_xlr_rec.irn_id,
        l_xlr_rec.imr_id,
        l_xlr_rec.xhr_id_details,
        l_xlr_rec.object_version_number,
        l_xlr_rec.created_by,
        l_xlr_rec.creation_date,
        l_xlr_rec.last_updated_by,
        l_xlr_rec.last_update_date,
        l_xlr_rec.quantity,
        l_xlr_rec.org_id,
        l_xlr_rec.request_id,
        l_xlr_rec.program_application_id,
        l_xlr_rec.program_id,
        l_xlr_rec.program_update_date,
        l_xlr_rec.attribute_category,
        l_xlr_rec.attribute1,
        l_xlr_rec.attribute2,
        l_xlr_rec.attribute3,
        l_xlr_rec.attribute4,
        l_xlr_rec.attribute5,
        l_xlr_rec.attribute6,
        l_xlr_rec.attribute7,
        l_xlr_rec.attribute8,
        l_xlr_rec.attribute9,
        l_xlr_rec.attribute10,
        l_xlr_rec.attribute11,
        l_xlr_rec.attribute12,
        l_xlr_rec.attribute13,
        l_xlr_rec.attribute14,
        l_xlr_rec.attribute15,
        l_xlr_rec.last_update_login);

Line: 747


  END insert_row;

Line: 751


  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_xlrv_rec                     IN xlrv_rec_type,
    x_xlrv_rec                     OUT NOCOPY xlrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 761


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

Line: 777


      l_xlrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 778


      l_xlrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 779


      l_xlrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 843


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_xlr_rec,
      lx_xlr_rec
    );

Line: 891


  END insert_row;

Line: 895


  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_xlrv_tbl                     IN xlrv_tbl_type,
    x_xlrv_tbl                     OUT NOCOPY xlrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 905


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

Line: 914


        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_xlrv_rec                     => p_xlrv_tbl(i),
          x_xlrv_rec                     => x_xlrv_tbl(i));

Line: 957


  END insert_row;

Line: 975


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_XTL_FUND_RQNS_B
     WHERE ID = p_xlr_rec.id
       AND OBJECT_VERSION_NUMBER = p_xlr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 982


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_XTL_FUND_RQNS_B
    WHERE ID = p_xlr_rec.id;

Line: 1023


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1032


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1219


  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_xlr_rec                      IN xlr_rec_type,
    x_xlr_rec                      OUT NOCOPY xlr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1228


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

Line: 1278


      IF (x_xlr_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_xlr_rec.last_updated_by := l_xlr_rec.last_updated_by;

Line: 1282


      IF (x_xlr_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_xlr_rec.last_update_date := l_xlr_rec.last_update_date;

Line: 1306


      IF (x_xlr_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_xlr_rec.program_update_date := l_xlr_rec.program_update_date;

Line: 1374


      IF (x_xlr_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_xlr_rec.last_update_login := l_xlr_rec.last_update_login;

Line: 1418


    UPDATE  OKL_XTL_FUND_RQNS_B
    SET IRN_ID = l_def_xlr_rec.irn_id,
        IMR_ID = l_def_xlr_rec.imr_id,
        XHR_ID_DETAILS = l_def_xlr_rec.xhr_id_details,
        OBJECT_VERSION_NUMBER = l_def_xlr_rec.object_version_number,
        CREATED_BY = l_def_xlr_rec.created_by,
        CREATION_DATE = l_def_xlr_rec.creation_date,
        LAST_UPDATED_BY = l_def_xlr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_xlr_rec.last_update_date,
        QUANTITY = l_def_xlr_rec.quantity,
        ORG_ID = l_def_xlr_rec.org_id,
        REQUEST_ID = l_def_xlr_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_xlr_rec.program_application_id,
        PROGRAM_ID = l_def_xlr_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_xlr_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_xlr_rec.attribute_category,
        ATTRIBUTE1 = l_def_xlr_rec.attribute1,
        ATTRIBUTE2 = l_def_xlr_rec.attribute2,
        ATTRIBUTE3 = l_def_xlr_rec.attribute3,
        ATTRIBUTE4 = l_def_xlr_rec.attribute4,
        ATTRIBUTE5 = l_def_xlr_rec.attribute5,
        ATTRIBUTE6 = l_def_xlr_rec.attribute6,
        ATTRIBUTE7 = l_def_xlr_rec.attribute7,
        ATTRIBUTE8 = l_def_xlr_rec.attribute8,
        ATTRIBUTE9 = l_def_xlr_rec.attribute9,
        ATTRIBUTE10 = l_def_xlr_rec.attribute10,
        ATTRIBUTE11 = l_def_xlr_rec.attribute11,
        ATTRIBUTE12 = l_def_xlr_rec.attribute12,
        ATTRIBUTE13 = l_def_xlr_rec.attribute13,
        ATTRIBUTE14 = l_def_xlr_rec.attribute14,
        ATTRIBUTE15 = l_def_xlr_rec.attribute15,
        LAST_UPDATE_LOGIN = l_def_xlr_rec.last_update_login
    WHERE ID = l_def_xlr_rec.id;

Line: 1485


  END update_row;

Line: 1489


  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_xlrv_rec                     IN xlrv_rec_type,
    x_xlrv_rec                     OUT NOCOPY xlrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1499


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

Line: 1513


      l_xlrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1514


      l_xlrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1515


      l_xlrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1639


      IF (x_xlrv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_xlrv_rec.program_update_date := l_xlrv_rec.program_update_date;

Line: 1651


      IF (x_xlrv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_xlrv_rec.last_updated_by := l_xlrv_rec.last_updated_by;

Line: 1655


      IF (x_xlrv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_xlrv_rec.last_update_date := l_xlrv_rec.last_update_date;

Line: 1659


      IF (x_xlrv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_xlrv_rec.last_update_login := l_xlrv_rec.last_update_login;

Line: 1730


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_xlr_rec,
      lx_xlr_rec
    );

Line: 1777


  END update_row;

Line: 1781


  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_xlrv_tbl                     IN xlrv_tbl_type,
    x_xlrv_tbl                     OUT NOCOPY xlrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1791


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

Line: 1800


        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_xlrv_rec                     => p_xlrv_tbl(i),
          x_xlrv_rec                     => x_xlrv_tbl(i));

Line: 1843


  END update_row;

Line: 1851


  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_xlr_rec                      IN xlr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1859


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

Line: 1873


    DELETE FROM OKL_XTL_FUND_RQNS_B
     WHERE ID = l_xlr_rec.id;

Line: 1908


  END delete_row;

Line: 1912


  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_xlrv_rec                     IN xlrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1921


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

Line: 1945


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_xlr_rec
    );

Line: 1989


  END delete_row;

Line: 1993


  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_xlrv_tbl                     IN xlrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2002


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

Line: 2011


        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_xlrv_rec                     => p_xlrv_tbl(i));

Line: 2053


  END delete_row;