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

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

Line: 101


    SELECT
            ID,
            BCL_ID,
            CLE_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            AVERAGE,
            AMOUNT,
            DATE_BILLED_FROM,
            DATE_BILLED_TO,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            SECURITY_GROUP_ID,
            DATE_TO_INTERFACE
      FROM Oks_Bsl_Pr
     WHERE oks_bsl_pr.id        = p_id;

Line: 148


              l_bsl_pr_rec.last_updated_by,
              l_bsl_pr_rec.last_update_date,
              l_bsl_pr_rec.average,
              l_bsl_pr_rec.amount,
              l_bsl_pr_rec.date_billed_from,
              l_bsl_pr_rec.date_billed_to,
              l_bsl_pr_rec.last_update_login,
              l_bsl_pr_rec.attribute_category,
              l_bsl_pr_rec.attribute1,
              l_bsl_pr_rec.attribute2,
              l_bsl_pr_rec.attribute3,
              l_bsl_pr_rec.attribute4,
              l_bsl_pr_rec.attribute5,
              l_bsl_pr_rec.attribute6,
              l_bsl_pr_rec.attribute7,
              l_bsl_pr_rec.attribute8,
              l_bsl_pr_rec.attribute9,
              l_bsl_pr_rec.attribute10,
              l_bsl_pr_rec.attribute11,
              l_bsl_pr_rec.attribute12,
              l_bsl_pr_rec.attribute13,
              l_bsl_pr_rec.attribute14,
              l_bsl_pr_rec.attribute15,
              l_bsl_pr_rec.security_group_id,
              l_bsl_pr_rec.date_to_interface;

Line: 231


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

Line: 234


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

Line: 249


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

Line: 645


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

Line: 651


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

Line: 721


    p_to.last_updated_by := p_from.last_updated_by;

Line: 722


    p_to.last_update_date := p_from.last_update_date;

Line: 727


    p_to.last_update_login := p_from.last_update_login;

Line: 759


    p_to.last_updated_by := p_from.last_updated_by;

Line: 760


    p_to.last_update_date := p_from.last_update_date;

Line: 765


    p_to.last_update_login := p_from.last_update_login;

Line: 1028


  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_bsl_pr_rec                   IN bsl_pr_rec_type,
    x_bsl_pr_rec                   OUT NOCOPY bsl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1038


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

Line: 1074


    INSERT INTO OKS_BSL_PR(
      id,
      bcl_id,
      cle_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      average,
      amount,
      date_billed_from,
      date_billed_to,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      security_group_id,
      date_to_interface)
    VALUES (
      l_bsl_pr_rec.id,
      l_bsl_pr_rec.bcl_id,
      l_bsl_pr_rec.cle_id,
      l_bsl_pr_rec.object_version_number,
      l_bsl_pr_rec.created_by,
      l_bsl_pr_rec.creation_date,
      l_bsl_pr_rec.last_updated_by,
      l_bsl_pr_rec.last_update_date,
      l_bsl_pr_rec.average,
      l_bsl_pr_rec.amount,
      l_bsl_pr_rec.date_billed_from,
      l_bsl_pr_rec.date_billed_to,
      l_bsl_pr_rec.last_update_login,
      l_bsl_pr_rec.attribute_category,
      l_bsl_pr_rec.attribute1,
      l_bsl_pr_rec.attribute2,
      l_bsl_pr_rec.attribute3,
      l_bsl_pr_rec.attribute4,
      l_bsl_pr_rec.attribute5,
      l_bsl_pr_rec.attribute6,
      l_bsl_pr_rec.attribute7,
      l_bsl_pr_rec.attribute8,
      l_bsl_pr_rec.attribute9,
      l_bsl_pr_rec.attribute10,
      l_bsl_pr_rec.attribute11,
      l_bsl_pr_rec.attribute12,
      l_bsl_pr_rec.attribute13,
      l_bsl_pr_rec.attribute14,
      l_bsl_pr_rec.attribute15,
      l_bsl_pr_rec.security_group_id,
      l_bsl_pr_rec.date_to_interface);

Line: 1173


  END insert_row;

Line: 1190


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BSL_PR
     WHERE ID = p_bsl_pr_rec.id
       AND OBJECT_VERSION_NUMBER = p_bsl_pr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1197


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BSL_PR
     WHERE ID = p_bsl_pr_rec.id;

Line: 1238


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1247


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1527


  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_bsl_pr_rec                   IN bsl_pr_rec_type,
    x_bsl_pr_rec                   OUT NOCOPY bsl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1536


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

Line: 1580


        IF (x_bsl_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_bsl_pr_rec.last_updated_by := l_bsl_pr_rec.last_updated_by;

Line: 1584


        IF (x_bsl_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_bsl_pr_rec.last_update_date := l_bsl_pr_rec.last_update_date;

Line: 1604


        IF (x_bsl_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_bsl_pr_rec.last_update_login := l_bsl_pr_rec.last_update_login;

Line: 1722


    UPDATE OKS_BSL_PR
    SET BCL_ID = l_def_bsl_pr_rec.bcl_id,
        CLE_ID = l_def_bsl_pr_rec.cle_id,
        OBJECT_VERSION_NUMBER = l_def_bsl_pr_rec.object_version_number,
        CREATED_BY = l_def_bsl_pr_rec.created_by,
        CREATION_DATE = l_def_bsl_pr_rec.creation_date,
        LAST_UPDATED_BY = l_def_bsl_pr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_bsl_pr_rec.last_update_date,
        AVERAGE = l_def_bsl_pr_rec.average,
        AMOUNT = l_def_bsl_pr_rec.amount,
        DATE_BILLED_FROM = l_def_bsl_pr_rec.date_billed_from,
        DATE_BILLED_TO = l_def_bsl_pr_rec.date_billed_to,
        LAST_UPDATE_LOGIN = l_def_bsl_pr_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_bsl_pr_rec.attribute_category,
        ATTRIBUTE1 = l_def_bsl_pr_rec.attribute1,
        ATTRIBUTE2 = l_def_bsl_pr_rec.attribute2,
        ATTRIBUTE3 = l_def_bsl_pr_rec.attribute3,
        ATTRIBUTE4 = l_def_bsl_pr_rec.attribute4,
        ATTRIBUTE5 = l_def_bsl_pr_rec.attribute5,
        ATTRIBUTE6 = l_def_bsl_pr_rec.attribute6,
        ATTRIBUTE7 = l_def_bsl_pr_rec.attribute7,
        ATTRIBUTE8 = l_def_bsl_pr_rec.attribute8,
        ATTRIBUTE9 = l_def_bsl_pr_rec.attribute9,
        ATTRIBUTE10 = l_def_bsl_pr_rec.attribute10,
        ATTRIBUTE11 = l_def_bsl_pr_rec.attribute11,
        ATTRIBUTE12 = l_def_bsl_pr_rec.attribute12,
        ATTRIBUTE13 = l_def_bsl_pr_rec.attribute13,
        ATTRIBUTE14 = l_def_bsl_pr_rec.attribute14,
        ATTRIBUTE15 = l_def_bsl_pr_rec.attribute15,
        SECURITY_GROUP_ID = l_def_bsl_pr_rec.security_group_id,
        DATE_TO_INTERFACE = l_def_bsl_pr_rec.date_to_interface
    WHERE ID = l_def_bsl_pr_rec.id;

Line: 1789


  END update_row;

Line: 1793


  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_bsl_pr_rec                   IN bsl_pr_rec_type,
    x_bsl_pr_rec                   OUT NOCOPY bsl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1803


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

Line: 1817


      l_bsl_pr_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1818


      l_bsl_pr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1819


      l_bsl_pr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1858


        IF (x_bsl_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_bsl_pr_rec.last_updated_by := l_db_bsl_pr_rec.last_updated_by;

Line: 1862


        IF (x_bsl_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_bsl_pr_rec.last_update_date := l_db_bsl_pr_rec.last_update_date;

Line: 1882


        IF (x_bsl_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_bsl_pr_rec.last_update_login := l_db_bsl_pr_rec.last_update_login;

Line: 2039


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_bsl_pr_rec,
      lx_bsl_pr_rec
    );

Line: 2087


  END update_row;

Line: 2091


  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_bsl_pr_tbl                   IN bsl_pr_tbl_type,
    x_bsl_pr_tbl                   OUT NOCOPY bsl_pr_tbl_type,
    px_error_tbl                   IN OUT NOCOPY ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2102


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

Line: 2116


          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_bsl_pr_rec                   => p_bsl_pr_tbl(i),
            x_bsl_pr_rec                   => x_bsl_pr_tbl(i));

Line: 2184


  END update_row;

Line: 2189


  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_bsl_pr_tbl                   IN bsl_pr_tbl_type,
    x_bsl_pr_tbl                   OUT NOCOPY bsl_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2199


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

Line: 2206


      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_bsl_pr_tbl                   => p_bsl_pr_tbl,
        x_bsl_pr_tbl                   => x_bsl_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2248


  END update_row;

Line: 2256


  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_bsl_pr_rec                   IN bsl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2264


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

Line: 2279


    DELETE FROM OKS_BSL_PR
     WHERE ID = p_bsl_pr_rec.id;

Line: 2315


  END delete_row;

Line: 2319


  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_bsl_pr_rec                   IN bsl_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2328


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

Line: 2351


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

Line: 2396


  END delete_row;

Line: 2400


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2410


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

Line: 2424


          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_bsl_pr_rec                   => p_bsl_pr_tbl(i));

Line: 2491


  END delete_row;

Line: 2496


  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_bsl_pr_tbl                   IN bsl_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2505


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

Line: 2512


      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_bsl_pr_tbl                   => p_bsl_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2553


  END delete_row;