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

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

Line: 43


    SELECT
            ID,
            BSL_ID,
            BSL_ID_AVERAGED,
            BSD_ID,
            BSD_ID_APPLIED,
            CCR_ID,
            CGR_ID,
            START_READING,
            END_READING,
            BASE_READING,
            ESTIMATED_QUANTITY,
            UNIT_OF_MEASURE,
            AMCV_YN,
            RESULT,
            AMOUNT,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            FIXED,
            ACTUAL,
            DEFAULT_DEFAULT,
            ADJUSTMENT_LEVEL,
            ADJUSTMENT_MINIMUM,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Oks_Bill_Sub_Line_Dtls
     WHERE oks_bill_sub_line_dtls.id = p_id;

Line: 113


              l_bsd_rec.LAST_UPDATED_BY,
              l_bsd_rec.LAST_UPDATE_DATE,
              l_bsd_rec.FIXED,
              l_bsd_rec.ACTUAL,
              l_bsd_rec.DEFAULT_DEFAULT,
              l_bsd_rec.ADJUSTMENT_LEVEL,
              l_bsd_rec.ADJUSTMENT_MINIMUM,
              l_bsd_rec.LAST_UPDATE_LOGIN,
              l_bsd_rec.ATTRIBUTE_CATEGORY,
              l_bsd_rec.ATTRIBUTE1,
              l_bsd_rec.ATTRIBUTE2,
              l_bsd_rec.ATTRIBUTE3,
              l_bsd_rec.ATTRIBUTE4,
              l_bsd_rec.ATTRIBUTE5,
              l_bsd_rec.ATTRIBUTE6,
              l_bsd_rec.ATTRIBUTE7,
              l_bsd_rec.ATTRIBUTE8,
              l_bsd_rec.ATTRIBUTE9,
              l_bsd_rec.ATTRIBUTE10,
              l_bsd_rec.ATTRIBUTE11,
              l_bsd_rec.ATTRIBUTE12,
              l_bsd_rec.ATTRIBUTE13,
              l_bsd_rec.ATTRIBUTE14,
              l_bsd_rec.ATTRIBUTE15;

Line: 157


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            BSL_ID,
            BSL_ID_AVERAGED,
            BSD_ID,
            BSD_ID_APPLIED,
            CCR_ID,
            CGR_ID,
            START_READING,
            END_READING,
            BASE_READING,
            ESTIMATED_QUANTITY,
            UNIT_OF_MEASURE,
            FIXED,
            ACTUAL,
            DEFAULT_DEFAULT,
            AMCV_YN,
            ADJUSTMENT_LEVEL,
            ADJUSTMENT_MINIMUM,
            RESULT,
            AMOUNT,
            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_Subline_Dtls_V
     WHERE oks_bill_subline_dtls_v.id = p_id;

Line: 248


              l_bsdv_rec.LAST_UPDATED_BY,
              l_bsdv_rec.LAST_UPDATE_DATE,
              l_bsdv_rec.LAST_UPDATE_LOGIN;

Line: 386


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

Line: 389


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

Line: 392


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

Line: 439


  	  select 'x'
	  from OKS_BILL_SUB_LINES_V
  	  where id = P_bsl_id;

Line: 2827


      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              BSL_ID,
              BSL_ID_AVERAGED,
              BSD_ID,
              BSD_ID_APPLIED,
              CCR_ID,
              CGR_ID,
              START_READING,
              END_READING,
              BASE_READING,
              ESTIMATED_QUANTITY,
              UNIT_OF_MEASURE,
              FIXED,
              ACTUAL,
              DEFAULT_DEFAULT,
              AMCV_YN,
              ADJUSTMENT_LEVEL,
              ADJUSTMENT_MINIMUM,
              RESULT,
              AMOUNT,
              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_Subline_Dtls_V
       WHERE oks_bill_subline_dtls_v.id = p_id;

Line: 2874


      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              BCL_ID,
              CLE_ID,
              AVERAGE,
              AMOUNT,
              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: 2906


      SELECT
              UNIT_OF_MEASURE,
              UOM_CODE,
              UOM_CLASS,
              DISABLE_DATE,
              DESCRIPTION
        FROM Okx_Units_Of_Measure_V
       WHERE okx_units_of_measure_v.unit_of_measure = p_unit_of_measure;

Line: 3013


    p_to.last_updated_by := p_from.last_updated_by;

Line: 3014


    p_to.last_update_date := p_from.last_update_date;

Line: 3020


    p_to.last_update_login := p_from.last_update_login;

Line: 3061


    p_to.last_updated_by := p_from.last_updated_by;

Line: 3062


    p_to.last_update_date := p_from.last_update_date;

Line: 3068


    p_to.last_update_login := p_from.last_update_login;

Line: 3237


  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_bsd_rec                      IN bsd_rec_type,
    x_bsd_rec                      OUT NOCOPY bsd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3246


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

Line: 3282


    INSERT INTO OKS_BILL_SUB_LINE_DTLS(
        id,
        bsl_id,
        bsl_id_averaged,
        bsd_id,
        bsd_id_applied,
        ccr_id,
        cgr_id,
        start_Reading,
        end_reading,
        base_reading,
        estimated_quantity,
        unit_of_measure,
        amcv_yn,
        result,
        amount,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        fixed,
        actual,
        default_default,
        adjustment_level,
        adjustment_minimum,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_bsd_rec.id,
        l_bsd_rec.bsl_id,
        l_bsd_rec.bsl_id_averaged,
        l_bsd_rec.bsd_id,
        l_bsd_rec.bsd_id_applied,
        l_bsd_rec.ccr_id,
        l_bsd_rec.cgr_id,
        l_bsd_rec.start_reading,
        l_bsd_rec.end_reading,
        l_bsd_rec.base_reading,
        l_bsd_rec.estimated_quantity,
        l_bsd_rec.unit_of_measure,
        l_bsd_rec.amcv_yn,
        l_bsd_rec.result,
        l_bsd_rec.amount,
        l_bsd_rec.object_version_number,
        l_bsd_rec.created_by,
        l_bsd_rec.creation_date,
        l_bsd_rec.last_updated_by,
        l_bsd_rec.last_update_date,
        l_bsd_rec.fixed,
        l_bsd_rec.actual,
        l_bsd_rec.default_default,
        l_bsd_rec.adjustment_level,
        l_bsd_rec.adjustment_minimum,
        l_bsd_rec.last_update_login,
        l_bsd_rec.attribute_category,
        l_bsd_rec.attribute1,
        l_bsd_rec.attribute2,
        l_bsd_rec.attribute3,
        l_bsd_rec.attribute4,
        l_bsd_rec.attribute5,
        l_bsd_rec.attribute6,
        l_bsd_rec.attribute7,
        l_bsd_rec.attribute8,
        l_bsd_rec.attribute9,
        l_bsd_rec.attribute10,
        l_bsd_rec.attribute11,
        l_bsd_rec.attribute12,
        l_bsd_rec.attribute13,
        l_bsd_rec.attribute14,
        l_bsd_rec.attribute15);

Line: 3402


  END insert_row;

Line: 3406


  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_bsdv_rec                     IN bsdv_rec_type,
    x_bsdv_rec                     OUT NOCOPY bsdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3416


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

Line: 3432


      l_bsdv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3433


      l_bsdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3434


      l_bsdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3498


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bsd_rec,
      lx_bsd_rec
    );

Line: 3546


  END insert_row;

Line: 3550


  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_bsdv_tbl                     IN bsdv_tbl_type,
    x_bsdv_tbl                     OUT NOCOPY bsdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3560


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

Line: 3569


        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_bsdv_rec                     => p_bsdv_tbl(i),
          x_bsdv_rec                     => x_bsdv_tbl(i));

Line: 3612


  END insert_row;

Line: 3630


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILL_SUB_LINE_DTLS
     WHERE ID = p_bsd_rec.id
       AND OBJECT_VERSION_NUMBER = p_bsd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 3637


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILL_SUB_LINE_DTLS
    WHERE ID = p_bsd_rec.id;

Line: 3678


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3687


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3874


  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_bsd_rec                      IN bsd_rec_type,
    x_bsd_rec                      OUT NOCOPY bsd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3883


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

Line: 3977


      IF (x_bsd_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_bsd_rec.last_updated_by := l_bsd_rec.last_updated_by;

Line: 3981


      IF (x_bsd_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_bsd_rec.last_update_date := l_bsd_rec.last_update_date;

Line: 4005


      IF (x_bsd_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_bsd_rec.last_update_login := l_bsd_rec.last_update_login;

Line: 4113


    UPDATE  OKS_BILL_SUB_LINE_DTLS
    SET BSL_ID = l_def_bsd_rec.bsl_id,
        BSL_ID_AVERAGED = l_def_bsd_rec.bsl_id_averaged,
        BSD_ID = l_def_bsd_rec.bsd_id,
        BSD_ID_APPLIED = l_def_bsd_rec.bsd_id_applied,
        CCR_ID         = l_def_bsd_rec.ccr_id,
        CGR_ID         = l_def_bsd_rec.cgr_id,
        START_READING         = l_def_bsd_rec.start_reading,
        END_READING         = l_def_bsd_rec.end_reading,
        BASE_READING         = l_def_bsd_rec.base_reading,
        ESTIMATED_QUANTITY         = l_def_bsd_rec.estimated_quantity,
        UNIT_OF_MEASURE = l_def_bsd_rec.unit_of_measure,
        AMCV_YN = l_def_bsd_rec.amcv_yn,
        RESULT = l_def_bsd_rec.result,
        AMOUNT = l_def_bsd_rec.amount,
        OBJECT_VERSION_NUMBER = l_def_bsd_rec.object_version_number,
        CREATED_BY = l_def_bsd_rec.created_by,
        CREATION_DATE = l_def_bsd_rec.creation_date,
        LAST_UPDATED_BY = l_def_bsd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_bsd_rec.last_update_date,
        FIXED = l_def_bsd_rec.fixed,
        ACTUAL = l_def_bsd_rec.actual,
        DEFAULT_DEFAULT = l_def_bsd_rec.default_default,
        ADJUSTMENT_LEVEL = l_def_bsd_rec.adjustment_level,
        ADJUSTMENT_MINIMUM = l_def_bsd_rec.adjustment_minimum,
        LAST_UPDATE_LOGIN = l_def_bsd_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_bsd_rec.attribute_category,
        ATTRIBUTE1 = l_def_bsd_rec.attribute1,
        ATTRIBUTE2 = l_def_bsd_rec.attribute2,
        ATTRIBUTE3 = l_def_bsd_rec.attribute3,
        ATTRIBUTE4 = l_def_bsd_rec.attribute4,
        ATTRIBUTE5 = l_def_bsd_rec.attribute5,
        ATTRIBUTE6 = l_def_bsd_rec.attribute6,
        ATTRIBUTE7 = l_def_bsd_rec.attribute7,
        ATTRIBUTE8 = l_def_bsd_rec.attribute8,
        ATTRIBUTE9 = l_def_bsd_rec.attribute9,
        ATTRIBUTE10 = l_def_bsd_rec.attribute10,
        ATTRIBUTE11 = l_def_bsd_rec.attribute11,
        ATTRIBUTE12 = l_def_bsd_rec.attribute12,
        ATTRIBUTE13 = l_def_bsd_rec.attribute13,
        ATTRIBUTE14 = l_def_bsd_rec.attribute14,
        ATTRIBUTE15 = l_def_bsd_rec.attribute15
    WHERE ID = l_def_bsd_rec.id;

Line: 4190


  END update_row;

Line: 4194


  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_bsdv_rec                     IN bsdv_rec_type,
    x_bsdv_rec                     OUT NOCOPY bsdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4204


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

Line: 4218


      l_bsdv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4219


      l_bsdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4220


      l_bsdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4396


      IF (x_bsdv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_bsdv_rec.last_updated_by := l_bsdv_rec.last_updated_by;

Line: 4400


      IF (x_bsdv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_bsdv_rec.last_update_date := l_bsdv_rec.last_update_date;

Line: 4404


      IF (x_bsdv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_bsdv_rec.last_update_login := l_bsdv_rec.last_update_login;

Line: 4475


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bsd_rec,
      lx_bsd_rec
    );

Line: 4522


  END update_row;

Line: 4526


  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_bsdv_tbl                     IN bsdv_tbl_type,
    x_bsdv_tbl                     OUT NOCOPY bsdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4536


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

Line: 4545


        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_bsdv_rec                     => p_bsdv_tbl(i),
          x_bsdv_rec                     => x_bsdv_tbl(i));

Line: 4588


  END update_row;

Line: 4596


  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_bsd_rec                      IN bsd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4604


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

Line: 4618


    DELETE FROM OKS_BILL_SUB_LINE_DTLS
     WHERE ID = l_bsd_rec.id;

Line: 4653


  END delete_row;

Line: 4657


  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_bsdv_rec                     IN bsdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4666


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

Line: 4690


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

Line: 4734


  END delete_row;

Line: 4738


  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_bsdv_tbl                     IN bsdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4747


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

Line: 4756


        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_bsdv_rec                     => p_bsdv_tbl(i));

Line: 4798


  END delete_row;