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

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

Line: 5


      SELECT CS_COV_BILL_RATES_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_billrate_rec.last_update_date IS NULL
    THEN
      TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');

Line: 39


    ELSIF p_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_billrate_rec.last_updated_by IS NULL
    THEN
      TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');

Line: 86


      SELECT *
        FROM Cs_Cov_Billing_Types
       WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;

Line: 127


    p_to.last_update_date := p_from.last_update_date;

Line: 128


    p_to.last_updated_by := p_from.last_updated_by;

Line: 131


    p_to.last_update_login := p_from.last_update_login;

Line: 161


    p_to.last_update_date := p_from.last_update_date;

Line: 162


    p_to.last_updated_by := p_from.last_updated_by;

Line: 165


    p_to.last_update_login := p_from.last_update_login;

Line: 184


  PROCEDURE insert_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_billrate_rec                 IN BillRate_Rec_Type := G_MISS_BILLRATE_REC,
    x_coverage_bill_rate_id        OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 250


    INSERT INTO CS_COV_BILL_RATES(
        coverage_bill_rate_id,
        coverage_billing_type_id,
        rate_type_code,
        unit_of_measure_code,
        flat_rate,
        percent_rate,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        object_version_number)
      VALUES (
        l_def_billrate_rec.coverage_bill_rate_id,
        l_def_billrate_rec.coverage_billing_type_id,
        l_def_billrate_rec.rate_type_code,
        l_def_billrate_rec.unit_of_measure_code,
        l_def_billrate_rec.flat_rate,
        l_def_billrate_rec.percent_rate,
        l_def_billrate_rec.last_update_date,
        l_def_billrate_rec.last_updated_by,
        l_def_billrate_rec.creation_date,
        l_def_billrate_rec.created_by,
        l_def_billrate_rec.last_update_login,
        l_def_billrate_rec.attribute1,
        l_def_billrate_rec.attribute2,
        l_def_billrate_rec.attribute3,
        l_def_billrate_rec.attribute4,
        l_def_billrate_rec.attribute5,
        l_def_billrate_rec.attribute6,
        l_def_billrate_rec.attribute7,
        l_def_billrate_rec.attribute8,
        l_def_billrate_rec.attribute9,
        l_def_billrate_rec.attribute10,
        l_def_billrate_rec.attribute11,
        l_def_billrate_rec.attribute12,
        l_def_billrate_rec.attribute13,
        l_def_billrate_rec.attribute14,
        l_def_billrate_rec.attribute15,
        l_def_billrate_rec.context,
        l_def_billrate_rec.object_version_number);

Line: 346


  END insert_row;

Line: 347


  PROCEDURE insert_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_coverage_billing_type_id     IN NUMBER := NULL,
    p_rate_type_code               IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,
    p_unit_of_measure_code         IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
    p_flat_rate                    IN NUMBER := NULL,
    p_percent_rate                 IN NUMBER := NULL,
    p_last_update_date             IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_attribute1                   IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_coverage_bill_rate_id        OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 407


    l_billrate_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 408


    l_billrate_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 411


    l_billrate_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 429


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_billrate_rec,
      x_coverage_bill_rate_id,
      x_object_version_number
    );

Line: 476


  END insert_row;

Line: 491


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COV_BILL_RATES
    WHERE
      COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 499


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COV_BILL_RATES
    WHERE
      COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
      ;

Line: 545


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 554


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 593


  Procedure update_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_billrate_val_rec             IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 614


      SELECT *
        FROM Cs_Cov_Bill_Rates
       WHERE cs_cov_bill_rates.coverage_bill_rate_id = p_coverage_bill_rate_id;

Line: 654


      IF (x_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_billrate_rec.last_update_date := l_cs_coverage_bill_rates_pk.last_update_date;

Line: 658


      IF (x_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_billrate_rec.last_updated_by := l_cs_coverage_bill_rates_pk.last_updated_by;

Line: 670


      IF (x_billrate_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_billrate_rec.last_update_login := l_cs_coverage_bill_rates_pk.last_update_login;

Line: 797


    UPDATE  CS_COV_BILL_RATES
    SET
        COVERAGE_BILL_RATE_ID = l_def_billrate_rec.coverage_bill_rate_id ,
        COVERAGE_BILLING_TYPE_ID = l_def_billrate_rec.coverage_billing_type_id ,
        RATE_TYPE_CODE = l_def_billrate_rec.rate_type_code ,
        UNIT_OF_MEASURE_CODE = l_def_billrate_rec.unit_of_measure_code ,
        FLAT_RATE = l_def_billrate_rec.flat_rate ,
        PERCENT_RATE = l_def_billrate_rec.percent_rate ,
        LAST_UPDATE_DATE = l_def_billrate_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_billrate_rec.last_updated_by ,
        CREATION_DATE = l_def_billrate_rec.creation_date ,
        CREATED_BY = l_def_billrate_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_billrate_rec.last_update_login ,
        ATTRIBUTE1 = l_def_billrate_rec.attribute1 ,
        ATTRIBUTE2 = l_def_billrate_rec.attribute2 ,
        ATTRIBUTE3 = l_def_billrate_rec.attribute3 ,
        ATTRIBUTE4 = l_def_billrate_rec.attribute4 ,
        ATTRIBUTE5 = l_def_billrate_rec.attribute5 ,
        ATTRIBUTE6 = l_def_billrate_rec.attribute6 ,
        ATTRIBUTE7 = l_def_billrate_rec.attribute7 ,
        ATTRIBUTE8 = l_def_billrate_rec.attribute8 ,
        ATTRIBUTE9 = l_def_billrate_rec.attribute9 ,
        ATTRIBUTE10 = l_def_billrate_rec.attribute10 ,
        ATTRIBUTE11 = l_def_billrate_rec.attribute11 ,
        ATTRIBUTE12 = l_def_billrate_rec.attribute12 ,
        ATTRIBUTE13 = l_def_billrate_rec.attribute13 ,
        ATTRIBUTE14 = l_def_billrate_rec.attribute14 ,
        ATTRIBUTE15 = l_def_billrate_rec.attribute15 ,
        CONTEXT = l_def_billrate_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_billrate_rec.object_version_number
        WHERE
          COVERAGE_BILL_RATE_ID = l_def_billrate_rec.coverage_bill_rate_id
          ;

Line: 866


  END update_row;

Line: 867


  Procedure update_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_coverage_bill_rate_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_coverage_billing_type_id     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_rate_type_code               IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_unit_of_measure_code         IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_flat_rate                    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_percent_rate                 IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_creation_date                IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute1                   IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 928


    l_billrate_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 929


    l_billrate_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 932


    l_billrate_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 950


    update_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_billrate_rec,
      x_object_version_number
    );

Line: 996


  END update_row;

Line: 997


  Procedure delete_row
  (
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    p_validation_level             IN NUMBER,
    p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
    x_return_status                OUT VARCHAR2,
    x_msg_count                    OUT NUMBER,
    x_msg_data                     OUT VARCHAR2,
    p_coverage_bill_rate_id        IN NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row';

Line: 1023


    DELETE  FROM CS_COV_BILL_RATES
    WHERE
      COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
      ;

Line: 1062


  END delete_row;

Line: 1164


    p_last_update_date             IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_creation_date                IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute1                   IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'validate_row';

Line: 1209


    l_billrate_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1210


    l_billrate_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1213


    l_billrate_rec.LAST_UPDATE_LOGIN := p_last_update_login;