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

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

Line: 43


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

Line: 90


              l_bsl_rec.LAST_UPDATED_BY,
              l_bsl_rec.LAST_UPDATE_DATE,
              l_bsl_rec.AVERAGE,
              l_bsl_rec.AMOUNT,
              l_bsl_rec.MANUAL_CREDIT,
              l_bsl_rec.DATE_BILLED_FROM,
              l_bsl_rec.DATE_BILLED_TO,
              l_bsl_rec.DATE_TO_INTERFACE,
              l_bsl_rec.LAST_UPDATE_LOGIN,
              l_bsl_rec.ATTRIBUTE_CATEGORY,
              l_bsl_rec.ATTRIBUTE1,
              l_bsl_rec.ATTRIBUTE2,
              l_bsl_rec.ATTRIBUTE3,
              l_bsl_rec.ATTRIBUTE4,
              l_bsl_rec.ATTRIBUTE5,
              l_bsl_rec.ATTRIBUTE6,
              l_bsl_rec.ATTRIBUTE7,
              l_bsl_rec.ATTRIBUTE8,
              l_bsl_rec.ATTRIBUTE9,
              l_bsl_rec.ATTRIBUTE10,
              l_bsl_rec.ATTRIBUTE11,
              l_bsl_rec.ATTRIBUTE12,
              l_bsl_rec.ATTRIBUTE13,
              l_bsl_rec.ATTRIBUTE14,
              l_bsl_rec.ATTRIBUTE15;

Line: 135


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            BCL_ID,
            CLE_ID,
            AVERAGE,
            AMOUNT,
            MANUAL_CREDIT,
            DATE_BILLED_FROM,
            DATE_BILLED_TO,
            DATE_TO_INTERFACE,
            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 Oks_Bill_Sub_Lines_V
     WHERE oks_bill_sub_lines_v.id = p_id;

Line: 204


              l_bslv_rec.LAST_UPDATED_BY,
              l_bslv_rec.LAST_UPDATE_DATE,
              l_bslv_rec.LAST_UPDATE_LOGIN;

Line: 309


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

Line: 312


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

Line: 315


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

Line: 388


  	  select 'x'
	  from OKC_K_LINES_V
  	  where id = P_cle_id;

Line: 1964


      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              CLE_ID,
              BTN_ID,
              DATE_BILLED_FROM,
              DATE_BILLED_TO,
              DATE_NEXT_INVOICE,
              AMOUNT,
              BILL_ACTION,
              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 Oks_Bill_Cont_Lines_V
       WHERE oks_bill_cont_lines_v.id = p_id;

Line: 1999


      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              CHR_ID,
              CLE_ID,
              LSE_ID,
              LINE_NUMBER,
              STS_CODE,
              DISPLAY_SEQUENCE,
              TRN_CODE,
              DNZ_CHR_ID,
              COMMENTS,
              ITEM_DESCRIPTION,
              HIDDEN_IND,
              PRICE_UNIT,
              PRICE_UNIT_PERCENT,
              PRICE_NEGOTIATED,
              PRICE_LEVEL_IND,
              INVOICE_LINE_LEVEL_IND,
              DPAS_RATING,
              BLOCK23TEXT,
              EXCEPTION_YN,
              TEMPLATE_USED,
              DATE_TERMINATED,
              NAME,
              START_DATE,
              END_DATE,
              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,
              PRICE_TYPE,
              --UOM_CODE,
              CURRENCY_CODE,
              LAST_UPDATE_LOGIN
        FROM Okc_K_Lines_V
       WHERE okc_k_lines_v.id     = p_id;

Line: 2104


    p_to.last_updated_by := p_from.last_updated_by;

Line: 2105


    p_to.last_update_date := p_from.last_update_date;

Line: 2112


    p_to.last_update_login := p_from.last_update_login;

Line: 2141


    p_to.last_updated_by := p_from.last_updated_by;

Line: 2142


    p_to.last_update_date := p_from.last_update_date;

Line: 2148


    p_to.last_update_login := p_from.last_update_login;

Line: 2317


  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_bsl_rec                      IN bsl_rec_type,
    x_bsl_rec                      OUT NOCOPY bsl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2326


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

Line: 2362


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

Line: 2460


  END insert_row;

Line: 2464


  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_bslv_rec                     IN bslv_rec_type,
    x_bslv_rec                     OUT NOCOPY bslv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2474


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

Line: 2490


      l_bslv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2491


      l_bslv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2492


      l_bslv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2556


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bsl_rec,
      lx_bsl_rec
    );

Line: 2604


  END insert_row;

Line: 2608


  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_bslv_tbl                     IN bslv_tbl_type,
    x_bslv_tbl                     OUT NOCOPY bslv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2618


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

Line: 2627


        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_bslv_rec                     => p_bslv_tbl(i),
          x_bslv_rec                     => x_bslv_tbl(i));

Line: 2670


  END insert_row;

Line: 2688


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILL_SUB_LINES
     WHERE ID = p_bsl_rec.id
       AND OBJECT_VERSION_NUMBER = p_bsl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2695


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILL_SUB_LINES
    WHERE ID = p_bsl_rec.id;

Line: 2736


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2745


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2932


  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_rec                      IN bsl_rec_type,
    x_bsl_rec                      OUT NOCOPY bsl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2941


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

Line: 2987


      IF (x_bsl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_bsl_rec.last_updated_by := l_bsl_rec.last_updated_by;

Line: 2991


      IF (x_bsl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_bsl_rec.last_update_date := l_bsl_rec.last_update_date;

Line: 3019


      IF (x_bsl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_bsl_rec.last_update_login := l_bsl_rec.last_update_login;

Line: 3127


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

Line: 3193


  END update_row;

Line: 3197


  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_bslv_rec                     IN bslv_rec_type,
    x_bslv_rec                     OUT NOCOPY bslv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3207


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

Line: 3221


      l_bslv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3222


      l_bslv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3223


      l_bslv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3355


      IF (x_bslv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_bslv_rec.last_updated_by := l_bslv_rec.last_updated_by;

Line: 3359


      IF (x_bslv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_bslv_rec.last_update_date := l_bslv_rec.last_update_date;

Line: 3363


      IF (x_bslv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_bslv_rec.last_update_login := l_bslv_rec.last_update_login;

Line: 3434


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bsl_rec,
      lx_bsl_rec
    );

Line: 3481


  END update_row;

Line: 3485


  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_bslv_tbl                     IN bslv_tbl_type,
    x_bslv_tbl                     OUT NOCOPY bslv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3495


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

Line: 3504


        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_bslv_rec                     => p_bslv_tbl(i),
          x_bslv_rec                     => x_bslv_tbl(i));

Line: 3547


  END update_row;

Line: 3555


  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_rec                      IN bsl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3563


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

Line: 3577


    DELETE FROM OKS_BILL_SUB_LINES
     WHERE ID = l_bsl_rec.id;

Line: 3612


  END delete_row;

Line: 3616


  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_bslv_rec                     IN bslv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3625


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

Line: 3649


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

Line: 3693


  END delete_row;

Line: 3697


  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_bslv_tbl                     IN bslv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3706


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

Line: 3715


        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_bslv_rec                     => p_bslv_tbl(i));

Line: 3757


  END delete_row;