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

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

Line: 66


    CURSOR c_pk_csr IS SELECT okl_disb_rule_vendor_sites_s.NEXTVAL FROM DUAL;

Line: 107


    SELECT
            DISB_RULE_VENDOR_SITE_ID,
            OBJECT_VERSION_NUMBER,
            DISB_RULE_ID,
            VENDOR_ID,
            VENDOR_SITE_ID,
            START_DATE,
            END_DATE,
            INVOICE_SEQ_START,
            INVOICE_SEQ_END,
            NEXT_INV_SEQ,
            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
      FROM Okl_Disb_Rule_Vendor_Sites
     WHERE okl_disb_rule_vendor_sites.disb_rule_vendor_site_id = p_disb_rule_vendor_site_id;

Line: 176


              l_drv_rec.last_updated_by,
              l_drv_rec.last_update_date,
              l_drv_rec.last_update_login;

Line: 304


    IF (l_drv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_drv_rec.last_updated_by := NULL;

Line: 307


    IF (l_drv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_drv_rec.last_update_date := NULL;

Line: 310


    IF (l_drv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_drv_rec.last_update_login := NULL;

Line: 784


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_rec                      IN drv_rec_type,
    x_drv_rec                      OUT NOCOPY drv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 794


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

Line: 808


      l_drv_rec.LAST_UPDATE_DATE := l_drv_rec.CREATION_DATE;

Line: 809


      l_drv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 810


      l_drv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 872


    INSERT INTO OKL_DISB_RULE_VENDOR_SITES(
      disb_rule_vendor_site_id,
      object_version_number,
      disb_rule_id,
      vendor_id,
      vendor_site_id,
      start_date,
      end_date,
      invoice_seq_start,
      invoice_seq_end,
      next_inv_seq,
      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)
    VALUES (
      l_def_drv_rec.disb_rule_vendor_site_id,
      l_def_drv_rec.object_version_number,
      l_def_drv_rec.disb_rule_id,
      l_def_drv_rec.vendor_id,
      l_def_drv_rec.vendor_site_id,
      l_def_drv_rec.start_date,
      l_def_drv_rec.end_date,
      l_def_drv_rec.invoice_seq_start,
      l_def_drv_rec.invoice_seq_end,
      l_def_drv_rec.next_inv_seq,
      l_def_drv_rec.attribute_category,
      l_def_drv_rec.attribute1,
      l_def_drv_rec.attribute2,
      l_def_drv_rec.attribute3,
      l_def_drv_rec.attribute4,
      l_def_drv_rec.attribute5,
      l_def_drv_rec.attribute6,
      l_def_drv_rec.attribute7,
      l_def_drv_rec.attribute8,
      l_def_drv_rec.attribute9,
      l_def_drv_rec.attribute10,
      l_def_drv_rec.attribute11,
      l_def_drv_rec.attribute12,
      l_def_drv_rec.attribute13,
      l_def_drv_rec.attribute14,
      l_def_drv_rec.attribute15,
      l_def_drv_rec.created_by,
      l_def_drv_rec.creation_date,
      l_def_drv_rec.last_updated_by,
      l_def_drv_rec.last_update_date,
      l_def_drv_rec.last_update_login);

Line: 971


  END insert_row;

Line: 975


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_tbl                      IN drv_tbl_type,
    x_drv_tbl                      OUT NOCOPY drv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 986


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

Line: 1000


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_drv_rec                      => p_drv_tbl(i),
            x_drv_rec                      => x_drv_tbl(i));

Line: 1068


  END insert_row;

Line: 1073


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_tbl                      IN drv_tbl_type,
    x_drv_tbl                      OUT NOCOPY drv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1083


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

Line: 1090


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_drv_tbl                      => p_drv_tbl,
        x_drv_tbl                      => x_drv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1132


  END insert_row;

Line: 1149


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_DISB_RULE_VENDOR_SITES
     WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id
       AND OBJECT_VERSION_NUMBER = p_drv_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1156


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_DISB_RULE_VENDOR_SITES
     WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id;

Line: 1200


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1209


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1488


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_rec                      IN drv_rec_type,
    x_drv_rec                      OUT NOCOPY drv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1497


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

Line: 1606


        IF x_drv_rec.last_updated_by IS NULL THEN
          x_drv_rec.last_updated_by := l_drv_rec.last_updated_by;

Line: 1609


        IF x_drv_rec.last_update_date IS NULL THEN
          x_drv_rec.last_update_date := l_drv_rec.last_update_date;

Line: 1612


        IF x_drv_rec.last_update_login IS NULL THEN
          x_drv_rec.last_update_login := l_drv_rec.last_update_login;

Line: 1667


    UPDATE OKL_DISB_RULE_VENDOR_SITES
    SET OBJECT_VERSION_NUMBER = l_def_drv_rec.object_version_number,
        DISB_RULE_ID = l_def_drv_rec.disb_rule_id,
        VENDOR_ID = l_def_drv_rec.vendor_id,
        VENDOR_SITE_ID = l_def_drv_rec.vendor_site_id,
        START_DATE = l_def_drv_rec.start_date,
        END_DATE = l_def_drv_rec.end_date,
        INVOICE_SEQ_START = l_def_drv_rec.invoice_seq_start,
        INVOICE_SEQ_END = l_def_drv_rec.invoice_seq_end,
        NEXT_INV_SEQ = l_def_drv_rec.next_inv_seq,
        ATTRIBUTE_CATEGORY = l_def_drv_rec.attribute_category,
        ATTRIBUTE1 = l_def_drv_rec.attribute1,
        ATTRIBUTE2 = l_def_drv_rec.attribute2,
        ATTRIBUTE3 = l_def_drv_rec.attribute3,
        ATTRIBUTE4 = l_def_drv_rec.attribute4,
        ATTRIBUTE5 = l_def_drv_rec.attribute5,
        ATTRIBUTE6 = l_def_drv_rec.attribute6,
        ATTRIBUTE7 = l_def_drv_rec.attribute7,
        ATTRIBUTE8 = l_def_drv_rec.attribute8,
        ATTRIBUTE9 = l_def_drv_rec.attribute9,
        ATTRIBUTE10 = l_def_drv_rec.attribute10,
        ATTRIBUTE11 = l_def_drv_rec.attribute11,
        ATTRIBUTE12 = l_def_drv_rec.attribute12,
        ATTRIBUTE13 = l_def_drv_rec.attribute13,
        ATTRIBUTE14 = l_def_drv_rec.attribute14,
        ATTRIBUTE15 = l_def_drv_rec.attribute15,
        CREATED_BY = l_def_drv_rec.created_by,
        CREATION_DATE = l_def_drv_rec.creation_date,
        LAST_UPDATED_BY = l_def_drv_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_drv_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_drv_rec.last_update_login
    WHERE DISB_RULE_VENDOR_SITE_ID = l_def_drv_rec.disb_rule_vendor_site_id;

Line: 1734


  END update_row;

Line: 1738


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_rec                      IN drv_rec_type,
    x_drv_rec                      OUT NOCOPY drv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1748


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

Line: 1762


      l_drv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1763


      l_drv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1764


      l_drv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1870


        IF x_drv_rec.last_updated_by IS NULL THEN
          x_drv_rec.last_updated_by := l_db_drv_rec.last_updated_by;

Line: 1873


        IF x_drv_rec.last_update_date IS NULL THEN
          x_drv_rec.last_update_date := l_db_drv_rec.last_update_date;

Line: 1876


        IF x_drv_rec.last_update_login IS NULL THEN
          x_drv_rec.last_update_login := l_db_drv_rec.last_update_login;

Line: 2022


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_def_drv_rec,
      lx_drv_rec
    );

Line: 2069


  END update_row;

Line: 2073


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_tbl                      IN drv_tbl_type,
    x_drv_tbl                      OUT NOCOPY drv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2084


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

Line: 2098


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_drv_rec                      => p_drv_tbl(i),
            x_drv_rec                      => x_drv_tbl(i));

Line: 2166


  END update_row;

Line: 2171


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_tbl                      IN drv_tbl_type,
    x_drv_tbl                      OUT NOCOPY drv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2181


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

Line: 2188


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_drv_tbl                      => p_drv_tbl,
        x_drv_tbl                      => x_drv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2230


  END update_row;

Line: 2238


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_rec                      IN drv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2246


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

Line: 2261


    DELETE FROM OKL_DISB_RULE_VENDOR_SITES
     WHERE DISB_RULE_VENDOR_SITE_ID = p_drv_rec.disb_rule_vendor_site_id;

Line: 2297


  END delete_row;

Line: 2301


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_rec                      IN drv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2310


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

Line: 2332


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

Line: 2377


  END delete_row;

Line: 2381


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_tbl                      IN drv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2391


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

Line: 2405


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_drv_rec                      => p_drv_tbl(i));

Line: 2472


  END delete_row;

Line: 2477


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_drv_tbl                      IN drv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2486


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

Line: 2493


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

Line: 2534


  END delete_row;