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

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

Line: 17


      SELECT  '1'
      FROM okl_trx_types_b
      WHERE id = p_id;

Line: 241


    SELECT
            ID,
            TRY_ID,
            REV_CCID,
            FREIGHT_CCID,
            REC_CCID,
            CLEARING_CCID,
            TAX_CCID,
            UNBILLED_CCID,
            UNEARNED_CCID,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            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,
/* Changes made by Kanti on 06.27.2001. This field is present in table but was missing from here */
            POST_TO_GL_YN
/* Changes End  */
      FROM Okl_Trx_Acct_Opts
     WHERE okl_trx_acct_opts.id = p_id;

Line: 315


              l_tao_rec.LAST_UPDATED_BY,
              l_tao_rec.LAST_UPDATE_DATE,
              l_tao_rec.LAST_UPDATE_LOGIN,
/* Changes made by Kanti on 06.27.2001. This field is present in table but was missing from here */
              l_tao_rec.POST_TO_GL_YN;

Line: 341


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TRY_ID,
             UNEARNED_CCID,
            REV_CCID,
            FREIGHT_CCID,
            REC_CCID,
            CLEARING_CCID,
            TAX_CCID,
            UNBILLED_CCID,
            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,
/* Changes made by Kanti on 06.27.2001. This field is present in table but was missing from here */
            POST_TO_GL_YN
/* Changes End  */
      FROM OKL_TRX_ACCT_OPTS
     WHERE OKL_TRX_ACCT_OPTS.id = p_id;

Line: 415


              l_taov_rec.LAST_UPDATED_BY,
              l_taov_rec.LAST_UPDATE_DATE,
              l_taov_rec.LAST_UPDATE_LOGIN,
/* Changes made by Kanti on 06.27.2001. This field is present in table but was missing from here */
              l_taov_rec.POST_TO_GL_YN;

Line: 526


    IF (l_taov_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
      l_taov_rec.last_updated_by := NULL;

Line: 529


    IF (l_taov_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
      l_taov_rec.last_update_date := NULL;

Line: 532


    IF (l_taov_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
      l_taov_rec.last_update_login := NULL;

Line: 648


    p_to.last_updated_by := p_from.last_updated_by;

Line: 649


    p_to.last_update_date := p_from.last_update_date;

Line: 650


    p_to.last_update_login := p_from.last_update_login;

Line: 690


    p_to.last_updated_by := p_from.last_updated_by;

Line: 691


    p_to.last_update_date := p_from.last_update_date;

Line: 692


    p_to.last_update_login := p_from.last_update_login;

Line: 855


  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_tao_rec                      IN tao_rec_type,
    x_tao_rec                      OUT NOCOPY tao_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 864


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

Line: 902


    INSERT INTO OKL_TRX_ACCT_OPTS(
        id,
        try_id,
        rev_CCID,
        freight_CCID,
        rec_CCID,
        clearing_CCID,
        tax_CCID,
        unbilled_CCID,
        unearned_CCID,
        object_version_number,
        org_id,
        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,
/* changes made by Kanti on 06/27/2001. this field was missing from TAPI  */
        post_to_gl_yn)
/* Changes End */
      VALUES (
        l_tao_rec.id,
        l_tao_rec.try_id,
        l_tao_rec.REV_CCID,
        l_tao_rec.freight_ccid,
        l_tao_rec.rec_ccid,
        l_tao_rec.clearing_ccid,
        l_tao_rec.tax_ccid,
        l_tao_rec.unbilled_ccid,
        l_tao_rec.unearned_ccid,
        l_tao_rec.object_version_number,
        l_tao_rec.org_id,
        l_tao_rec.attribute_category,
        l_tao_rec.attribute1,
        l_tao_rec.attribute2,
        l_tao_rec.attribute3,
        l_tao_rec.attribute4,
        l_tao_rec.attribute5,
        l_tao_rec.attribute6,
        l_tao_rec.attribute7,
        l_tao_rec.attribute8,
        l_tao_rec.attribute9,
        l_tao_rec.attribute10,
        l_tao_rec.attribute11,
        l_tao_rec.attribute12,
        l_tao_rec.attribute13,
        l_tao_rec.attribute14,
        l_tao_rec.attribute15,
        l_tao_rec.created_by,
        l_tao_rec.creation_date,
        l_tao_rec.last_updated_by,
        l_tao_rec.last_update_date,
        l_tao_rec.last_update_login,
/* changes made by Kanti on 06/27/2001. this field was missing from TAPI  */
        l_tao_rec.post_to_gl_yn
/* Changes End */
);

Line: 1009


  END insert_row;

Line: 1013


  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_taov_rec                     IN taov_rec_type,
    x_taov_rec                     OUT NOCOPY taov_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1023


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

Line: 1039


      l_taov_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1040


      l_taov_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1041


      l_taov_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1106


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tao_rec,
      lx_tao_rec
    );

Line: 1154


  END insert_row;

Line: 1158


  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_taov_tbl                     IN taov_tbl_type,
    x_taov_tbl                     OUT NOCOPY taov_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1168


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

Line: 1178


        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_taov_rec                     => p_taov_tbl(i),
          x_taov_rec                     => x_taov_tbl(i));

Line: 1227


  END insert_row;

Line: 1245


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_ACCT_OPTS
     WHERE ID = p_tao_rec.id
       AND OBJECT_VERSION_NUMBER = p_tao_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1252


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_ACCT_OPTS
    WHERE ID = p_tao_rec.id;

Line: 1293


      Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1302


      Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1496


  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_tao_rec                      IN tao_rec_type,
    x_tao_rec                      OUT NOCOPY tao_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1505


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

Line: 1643


      IF (x_tao_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_tao_rec.last_updated_by := l_tao_rec.last_updated_by;

Line: 1647


      IF (x_tao_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_tao_rec.last_update_date := l_tao_rec.last_update_date;

Line: 1651


      IF (x_tao_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_tao_rec.last_update_login := l_tao_rec.last_update_login;

Line: 1701


    UPDATE  OKL_TRX_ACCT_OPTS
    SET TRY_ID = l_def_tao_rec.try_id,
        REV_CCID = l_def_tao_rec.REV_CCID,
        FREIGHT_CCID = l_def_tao_rec.freight_ccid,
        REC_CCID = l_def_tao_rec.rec_ccid,
        CLEARING_CCID = l_def_tao_rec.clearing_ccid,
        TAX_CCID = l_def_tao_rec.tax_ccid,
        UNBILLED_CCID = l_def_tao_rec.unbilled_ccid,
        UNEARNED_CCID = l_def_tao_rec.unearned_ccid,
        OBJECT_VERSION_NUMBER = l_def_tao_rec.object_version_number,
        ORG_ID = l_def_tao_rec.org_id,
        ATTRIBUTE_CATEGORY = l_def_tao_rec.attribute_category,
        ATTRIBUTE1 = l_def_tao_rec.attribute1,
        ATTRIBUTE2 = l_def_tao_rec.attribute2,
        ATTRIBUTE3 = l_def_tao_rec.attribute3,
        ATTRIBUTE4 = l_def_tao_rec.attribute4,
        ATTRIBUTE5 = l_def_tao_rec.attribute5,
        ATTRIBUTE6 = l_def_tao_rec.attribute6,
        ATTRIBUTE7 = l_def_tao_rec.attribute7,
        ATTRIBUTE8 = l_def_tao_rec.attribute8,
        ATTRIBUTE9 = l_def_tao_rec.attribute9,
        ATTRIBUTE10 = l_def_tao_rec.attribute10,
        ATTRIBUTE11 = l_def_tao_rec.attribute11,
        ATTRIBUTE12 = l_def_tao_rec.attribute12,
        ATTRIBUTE13 = l_def_tao_rec.attribute13,
        ATTRIBUTE14 = l_def_tao_rec.attribute14,
        ATTRIBUTE15 = l_def_tao_rec.attribute15,
        CREATED_BY = l_def_tao_rec.created_by,
        CREATION_DATE = l_def_tao_rec.creation_date,
        LAST_UPDATED_BY = l_def_tao_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tao_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tao_rec.last_update_login,
/* changes made by Kanti on 06/27/2001. this field was missing from TAPI  */
        POST_TO_GL_YN     = l_def_tao_rec.post_to_gl_yn
/* Changes End */
    WHERE ID = l_def_tao_rec.id;

Line: 1771


  END update_row;

Line: 1775


  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_taov_rec                     IN taov_rec_type,
    x_taov_rec                     OUT NOCOPY taov_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1785


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

Line: 1799


      l_taov_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1800


      l_taov_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1801


      l_taov_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1937


      IF (x_taov_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_taov_rec.last_updated_by := l_taov_rec.last_updated_by;

Line: 1941


      IF (x_taov_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_taov_rec.last_update_date := l_taov_rec.last_update_date;

Line: 1945


      IF (x_taov_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_taov_rec.last_update_login := l_taov_rec.last_update_login;

Line: 2021


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tao_rec,
      lx_tao_rec
    );

Line: 2068


  END update_row;

Line: 2072


  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_taov_tbl                     IN taov_tbl_type,
    x_taov_tbl                     OUT NOCOPY taov_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2082


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

Line: 2092


        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_taov_rec                     => p_taov_tbl(i),
          x_taov_rec                     => x_taov_tbl(i));

Line: 2141


  END update_row;

Line: 2149


  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_tao_rec                      IN tao_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2157


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

Line: 2171


    DELETE FROM OKL_TRX_ACCT_OPTS
     WHERE ID = l_tao_rec.id;

Line: 2206


  END delete_row;

Line: 2210


  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_taov_rec                     IN taov_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2219


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

Line: 2243


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

Line: 2287


  END delete_row;

Line: 2291


  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_taov_tbl                     IN taov_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2300


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

Line: 2310


        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_taov_rec                     => p_taov_tbl(i));

Line: 2358


  END delete_row;