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

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

Line: 101


    SELECT
            ID,
            BTN_ID,
            BSL_ID,
            BCL_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            BILL_INSTANCE_NUMBER,
            TRX_LINE_AMOUNT,
            TRX_LINE_TAX_AMOUNT,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            SECURITY_GROUP_ID
      FROM Oks_Btl_Pr
     WHERE oks_btl_pr.id        = p_id;

Line: 148


              l_btl_pr_rec.last_updated_by,
              l_btl_pr_rec.last_update_date,
              l_btl_pr_rec.bill_instance_number,
              l_btl_pr_rec.trx_line_amount,
              l_btl_pr_rec.trx_line_tax_amount,
              l_btl_pr_rec.last_update_login,
              l_btl_pr_rec.attribute_category,
              l_btl_pr_rec.attribute1,
              l_btl_pr_rec.attribute2,
              l_btl_pr_rec.attribute3,
              l_btl_pr_rec.attribute4,
              l_btl_pr_rec.attribute5,
              l_btl_pr_rec.attribute6,
              l_btl_pr_rec.attribute7,
              l_btl_pr_rec.attribute8,
              l_btl_pr_rec.attribute9,
              l_btl_pr_rec.attribute10,
              l_btl_pr_rec.attribute11,
              l_btl_pr_rec.attribute12,
              l_btl_pr_rec.attribute13,
              l_btl_pr_rec.attribute14,
              l_btl_pr_rec.attribute15,
              l_btl_pr_rec.security_group_id;

Line: 232


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

Line: 235


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

Line: 247


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

Line: 640


      SELECT 'x'
        FROM Oks_Btn_Pr
       WHERE oks_btn_pr.id        = p_id;

Line: 646


      SELECT 'x'
        FROM Oks_Bcl_Pr
       WHERE oks_bcl_pr.id        = p_id;

Line: 652


      SELECT 'x'
        FROM Oks_Bsl_Pr
       WHERE oks_bsl_pr.id        = p_id;

Line: 736


    p_to.last_updated_by := p_from.last_updated_by;

Line: 737


    p_to.last_update_date := p_from.last_update_date;

Line: 741


    p_to.last_update_login := p_from.last_update_login;

Line: 773


    p_to.last_updated_by := p_from.last_updated_by;

Line: 774


    p_to.last_update_date := p_from.last_update_date;

Line: 778


    p_to.last_update_login := p_from.last_update_login;

Line: 1040


  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_btl_pr_rec                   IN btl_pr_rec_type,
    x_btl_pr_rec                   OUT NOCOPY btl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1050


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

Line: 1086


    INSERT INTO OKS_BTL_PR(
      id,
      btn_id,
      bsl_id,
      bcl_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      bill_instance_number,
      trx_line_amount,
      trx_line_tax_amount,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      security_group_id)
    VALUES (
      l_btl_pr_rec.id,
      l_btl_pr_rec.btn_id,
      l_btl_pr_rec.bsl_id,
      l_btl_pr_rec.bcl_id,
      l_btl_pr_rec.object_version_number,
      l_btl_pr_rec.created_by,
      l_btl_pr_rec.creation_date,
      l_btl_pr_rec.last_updated_by,
      l_btl_pr_rec.last_update_date,
      l_btl_pr_rec.bill_instance_number,
      l_btl_pr_rec.trx_line_amount,
      l_btl_pr_rec.trx_line_tax_amount,
      l_btl_pr_rec.last_update_login,
      l_btl_pr_rec.attribute_category,
      l_btl_pr_rec.attribute1,
      l_btl_pr_rec.attribute2,
      l_btl_pr_rec.attribute3,
      l_btl_pr_rec.attribute4,
      l_btl_pr_rec.attribute5,
      l_btl_pr_rec.attribute6,
      l_btl_pr_rec.attribute7,
      l_btl_pr_rec.attribute8,
      l_btl_pr_rec.attribute9,
      l_btl_pr_rec.attribute10,
      l_btl_pr_rec.attribute11,
      l_btl_pr_rec.attribute12,
      l_btl_pr_rec.attribute13,
      l_btl_pr_rec.attribute14,
      l_btl_pr_rec.attribute15,
      l_btl_pr_rec.security_group_id);

Line: 1183


  END insert_row;

Line: 1200


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BTL_PR
     WHERE ID = p_btl_pr_rec.id
       AND OBJECT_VERSION_NUMBER = p_btl_pr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1207


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BTL_PR
     WHERE ID = p_btl_pr_rec.id;

Line: 1248


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1257


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1537


  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_btl_pr_rec                   IN btl_pr_rec_type,
    x_btl_pr_rec                   OUT NOCOPY btl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1546


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

Line: 1594


        IF (x_btl_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_btl_pr_rec.last_updated_by := l_btl_pr_rec.last_updated_by;

Line: 1598


        IF (x_btl_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_btl_pr_rec.last_update_date := l_btl_pr_rec.last_update_date;

Line: 1614


        IF (x_btl_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_btl_pr_rec.last_update_login := l_btl_pr_rec.last_update_login;

Line: 1728


    UPDATE OKS_BTL_PR
    SET BTN_ID = l_def_btl_pr_rec.btn_id,
        BSL_ID = l_def_btl_pr_rec.bsl_id,
        BCL_ID = l_def_btl_pr_rec.bcl_id,
        OBJECT_VERSION_NUMBER = l_def_btl_pr_rec.object_version_number,
        CREATED_BY = l_def_btl_pr_rec.created_by,
        CREATION_DATE = l_def_btl_pr_rec.creation_date,
        LAST_UPDATED_BY = l_def_btl_pr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_btl_pr_rec.last_update_date,
        BILL_INSTANCE_NUMBER = l_def_btl_pr_rec.bill_instance_number,
        TRX_LINE_AMOUNT = l_def_btl_pr_rec.trx_line_amount,
        TRX_LINE_TAX_AMOUNT = l_def_btl_pr_rec.trx_line_tax_amount,
        LAST_UPDATE_LOGIN = l_def_btl_pr_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_btl_pr_rec.attribute_category,
        ATTRIBUTE1 = l_def_btl_pr_rec.attribute1,
        ATTRIBUTE2 = l_def_btl_pr_rec.attribute2,
        ATTRIBUTE3 = l_def_btl_pr_rec.attribute3,
        ATTRIBUTE4 = l_def_btl_pr_rec.attribute4,
        ATTRIBUTE5 = l_def_btl_pr_rec.attribute5,
        ATTRIBUTE6 = l_def_btl_pr_rec.attribute6,
        ATTRIBUTE7 = l_def_btl_pr_rec.attribute7,
        ATTRIBUTE8 = l_def_btl_pr_rec.attribute8,
        ATTRIBUTE9 = l_def_btl_pr_rec.attribute9,
        ATTRIBUTE10 = l_def_btl_pr_rec.attribute10,
        ATTRIBUTE11 = l_def_btl_pr_rec.attribute11,
        ATTRIBUTE12 = l_def_btl_pr_rec.attribute12,
        ATTRIBUTE13 = l_def_btl_pr_rec.attribute13,
        ATTRIBUTE14 = l_def_btl_pr_rec.attribute14,
        ATTRIBUTE15 = l_def_btl_pr_rec.attribute15,
        SECURITY_GROUP_ID = l_def_btl_pr_rec.security_group_id
    WHERE ID = l_def_btl_pr_rec.id;

Line: 1794


  END update_row;

Line: 1798


  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_btl_pr_rec                   IN btl_pr_rec_type,
    x_btl_pr_rec                   OUT NOCOPY btl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1808


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

Line: 1822


      l_btl_pr_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1823


      l_btl_pr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1824


      l_btl_pr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1867


        IF (x_btl_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_btl_pr_rec.last_updated_by := l_db_btl_pr_rec.last_updated_by;

Line: 1871


        IF (x_btl_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_btl_pr_rec.last_update_date := l_db_btl_pr_rec.last_update_date;

Line: 1887


        IF (x_btl_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_btl_pr_rec.last_update_login := l_db_btl_pr_rec.last_update_login;

Line: 2040


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_btl_pr_rec,
      lx_btl_pr_rec
    );

Line: 2088


  END update_row;

Line: 2092


  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_btl_pr_tbl                   IN btl_pr_tbl_type,
    x_btl_pr_tbl                   OUT NOCOPY btl_pr_tbl_type,
    px_error_tbl                   IN OUT NOCOPY ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2103


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

Line: 2117


          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_btl_pr_rec                   => p_btl_pr_tbl(i),
            x_btl_pr_rec                   => x_btl_pr_tbl(i));

Line: 2185


  END update_row;

Line: 2190


  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_btl_pr_tbl                   IN btl_pr_tbl_type,
    x_btl_pr_tbl                   OUT NOCOPY btl_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2200


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

Line: 2207


      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_btl_pr_tbl                   => p_btl_pr_tbl,
        x_btl_pr_tbl                   => x_btl_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2249


  END update_row;

Line: 2257


  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_btl_pr_rec                   IN btl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2265


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

Line: 2280


    DELETE FROM OKS_BTL_PR
     WHERE ID = p_btl_pr_rec.id;

Line: 2316


  END delete_row;

Line: 2320


  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_btl_pr_rec                   IN btl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2329


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

Line: 2353


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

Line: 2398


  END delete_row;

Line: 2402


  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_btl_pr_tbl                   IN btl_pr_tbl_type,
    px_error_tbl                   IN OUT NOCOPY ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2412


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

Line: 2426


          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_btl_pr_rec                   => p_btl_pr_tbl(i));

Line: 2493


  END delete_row;

Line: 2498


  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_btl_pr_tbl                   IN btl_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2507


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

Line: 2514


      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_btl_pr_tbl                   => p_btl_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2555


  END delete_row;