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

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

Line: 101


    SELECT
            ID,
            CLE_ID,
            BTN_ID,
            DATE_BILLED_FROM,
            DATE_BILLED_TO,
            SENT_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            AMOUNT,
            BILL_ACTION,
            DATE_NEXT_INVOICE,
            CURRENCY_CODE,
            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_Bcl_Pr
     WHERE oks_bcl_pr.id        = p_id;

Line: 153


              l_bcl_pr_rec.last_updated_by,
              l_bcl_pr_rec.last_update_date,
              l_bcl_pr_rec.amount,
              l_bcl_pr_rec.bill_action,
              l_bcl_pr_rec.date_next_invoice,
              l_bcl_pr_rec.currency_code,
              l_bcl_pr_rec.last_update_login,
              l_bcl_pr_rec.attribute_category,
              l_bcl_pr_rec.attribute1,
              l_bcl_pr_rec.attribute2,
              l_bcl_pr_rec.attribute3,
              l_bcl_pr_rec.attribute4,
              l_bcl_pr_rec.attribute5,
              l_bcl_pr_rec.attribute6,
              l_bcl_pr_rec.attribute7,
              l_bcl_pr_rec.attribute8,
              l_bcl_pr_rec.attribute9,
              l_bcl_pr_rec.attribute10,
              l_bcl_pr_rec.attribute11,
              l_bcl_pr_rec.attribute12,
              l_bcl_pr_rec.attribute13,
              l_bcl_pr_rec.attribute14,
              l_bcl_pr_rec.attribute15,
              l_bcl_pr_rec.security_group_id;

Line: 244


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

Line: 247


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

Line: 262


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

Line: 655


      SELECT 'x'
        FROM Okc_K_Lines_B
       WHERE okc_k_lines_b.id     = p_id;

Line: 661


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

Line: 733


    p_to.last_updated_by := p_from.last_updated_by;

Line: 734


    p_to.last_update_date := p_from.last_update_date;

Line: 739


    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: 779


    p_to.last_update_login := p_from.last_update_login;

Line: 1041


  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_bcl_pr_rec                   IN bcl_pr_rec_type,
    x_bcl_pr_rec                   OUT NOCOPY bcl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1051


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

Line: 1087


    INSERT INTO OKS_BCL_PR(
      id,
      cle_id,
      btn_id,
      date_billed_from,
      date_billed_to,
      sent_yn,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      amount,
      bill_action,
      date_next_invoice,
      currency_code,
      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_bcl_pr_rec.id,
      l_bcl_pr_rec.cle_id,
      l_bcl_pr_rec.btn_id,
      l_bcl_pr_rec.date_billed_from,
      l_bcl_pr_rec.date_billed_to,
      l_bcl_pr_rec.sent_yn,
      l_bcl_pr_rec.object_version_number,
      l_bcl_pr_rec.created_by,
      l_bcl_pr_rec.creation_date,
      l_bcl_pr_rec.last_updated_by,
      l_bcl_pr_rec.last_update_date,
      l_bcl_pr_rec.amount,
      l_bcl_pr_rec.bill_action,
      l_bcl_pr_rec.date_next_invoice,
      l_bcl_pr_rec.currency_code,
      l_bcl_pr_rec.last_update_login,
      l_bcl_pr_rec.attribute_category,
      l_bcl_pr_rec.attribute1,
      l_bcl_pr_rec.attribute2,
      l_bcl_pr_rec.attribute3,
      l_bcl_pr_rec.attribute4,
      l_bcl_pr_rec.attribute5,
      l_bcl_pr_rec.attribute6,
      l_bcl_pr_rec.attribute7,
      l_bcl_pr_rec.attribute8,
      l_bcl_pr_rec.attribute9,
      l_bcl_pr_rec.attribute10,
      l_bcl_pr_rec.attribute11,
      l_bcl_pr_rec.attribute12,
      l_bcl_pr_rec.attribute13,
      l_bcl_pr_rec.attribute14,
      l_bcl_pr_rec.attribute15,
      l_bcl_pr_rec.security_group_id);

Line: 1190


  END insert_row;

Line: 1207


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BCL_PR
     WHERE ID = p_bcl_pr_rec.id
       AND OBJECT_VERSION_NUMBER = p_bcl_pr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1214


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BCL_PR
     WHERE ID = p_bcl_pr_rec.id;

Line: 1255


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1264


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1544


  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_bcl_pr_rec                   IN bcl_pr_rec_type,
    x_bcl_pr_rec                   OUT NOCOPY bcl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1553


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

Line: 1609


        IF (x_bcl_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_bcl_pr_rec.last_updated_by := l_bcl_pr_rec.last_updated_by;

Line: 1613


        IF (x_bcl_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_bcl_pr_rec.last_update_date := l_bcl_pr_rec.last_update_date;

Line: 1633


        IF (x_bcl_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_bcl_pr_rec.last_update_login := l_bcl_pr_rec.last_update_login;

Line: 1747


    UPDATE OKS_BCL_PR
    SET CLE_ID = l_def_bcl_pr_rec.cle_id,
        BTN_ID = l_def_bcl_pr_rec.btn_id,
        DATE_BILLED_FROM = l_def_bcl_pr_rec.date_billed_from,
        DATE_BILLED_TO = l_def_bcl_pr_rec.date_billed_to,
        SENT_YN = l_def_bcl_pr_rec.sent_yn,
        OBJECT_VERSION_NUMBER = l_def_bcl_pr_rec.object_version_number,
        CREATED_BY = l_def_bcl_pr_rec.created_by,
        CREATION_DATE = l_def_bcl_pr_rec.creation_date,
        LAST_UPDATED_BY = l_def_bcl_pr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_bcl_pr_rec.last_update_date,
        AMOUNT = l_def_bcl_pr_rec.amount,
        BILL_ACTION = l_def_bcl_pr_rec.bill_action,
        DATE_NEXT_INVOICE = l_def_bcl_pr_rec.date_next_invoice,
        CURRENCY_CODE = l_def_bcl_pr_rec.currency_code,
        LAST_UPDATE_LOGIN = l_def_bcl_pr_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_bcl_pr_rec.attribute_category,
        ATTRIBUTE1 = l_def_bcl_pr_rec.attribute1,
        ATTRIBUTE2 = l_def_bcl_pr_rec.attribute2,
        ATTRIBUTE3 = l_def_bcl_pr_rec.attribute3,
        ATTRIBUTE4 = l_def_bcl_pr_rec.attribute4,
        ATTRIBUTE5 = l_def_bcl_pr_rec.attribute5,
        ATTRIBUTE6 = l_def_bcl_pr_rec.attribute6,
        ATTRIBUTE7 = l_def_bcl_pr_rec.attribute7,
        ATTRIBUTE8 = l_def_bcl_pr_rec.attribute8,
        ATTRIBUTE9 = l_def_bcl_pr_rec.attribute9,
        ATTRIBUTE10 = l_def_bcl_pr_rec.attribute10,
        ATTRIBUTE11 = l_def_bcl_pr_rec.attribute11,
        ATTRIBUTE12 = l_def_bcl_pr_rec.attribute12,
        ATTRIBUTE13 = l_def_bcl_pr_rec.attribute13,
        ATTRIBUTE14 = l_def_bcl_pr_rec.attribute14,
        ATTRIBUTE15 = l_def_bcl_pr_rec.attribute15,
        SECURITY_GROUP_ID = l_def_bcl_pr_rec.security_group_id
    WHERE ID = l_def_bcl_pr_rec.id;

Line: 1816


  END update_row;

Line: 1820


  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_bcl_pr_rec                   IN bcl_pr_rec_type,
    x_bcl_pr_rec                   OUT NOCOPY bcl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1830


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

Line: 1844


      l_bcl_pr_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1845


      l_bcl_pr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1846


      l_bcl_pr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1897


        IF (x_bcl_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_bcl_pr_rec.last_updated_by := l_db_bcl_pr_rec.last_updated_by;

Line: 1901


        IF (x_bcl_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_bcl_pr_rec.last_update_date := l_db_bcl_pr_rec.last_update_date;

Line: 1921


        IF (x_bcl_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_bcl_pr_rec.last_update_login := l_db_bcl_pr_rec.last_update_login;

Line: 2074


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_bcl_pr_rec,
      lx_bcl_pr_rec
    );

Line: 2122


  END update_row;

Line: 2126


  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_bcl_pr_tbl                   IN bcl_pr_tbl_type,
    x_bcl_pr_tbl                   OUT NOCOPY bcl_pr_tbl_type,
    px_error_tbl                   IN OUT NOCOPY ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2137


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

Line: 2151


          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_bcl_pr_rec                   => p_bcl_pr_tbl(i),
            x_bcl_pr_rec                   => x_bcl_pr_tbl(i));

Line: 2219


  END update_row;

Line: 2224


  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_bcl_pr_tbl                   IN bcl_pr_tbl_type,
    x_bcl_pr_tbl                   OUT NOCOPY bcl_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2234


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

Line: 2241


      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_bcl_pr_tbl                   => p_bcl_pr_tbl,
        x_bcl_pr_tbl                   => x_bcl_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2283


  END update_row;

Line: 2291


  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_bcl_pr_rec                   IN bcl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2299


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

Line: 2314


    DELETE FROM OKS_BCL_PR
     WHERE ID = p_bcl_pr_rec.id;

Line: 2350


  END delete_row;

Line: 2354


  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_bcl_pr_rec                   IN bcl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2363


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

Line: 2386


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

Line: 2431


  END delete_row;

Line: 2435


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2445


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

Line: 2459


          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_bcl_pr_rec                   => p_bcl_pr_tbl(i));

Line: 2526


  END delete_row;

Line: 2531


  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_bcl_pr_tbl                   IN bcl_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2540


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

Line: 2547


      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_bcl_pr_tbl                   => p_bcl_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2588


  END delete_row;