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

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

Line: 5


      SELECT CS_COV_BILLING_TYPES_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_billingtype_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_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_billingtype_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_Coverage_Txn_Groups
       WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;

Line: 91


      SELECT *
        FROM Cs_Txn_Billing_Types
       WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;

Line: 142


    p_to.last_update_date := p_from.last_update_date;

Line: 143


    p_to.last_updated_by := p_from.last_updated_by;

Line: 146


    p_to.last_update_login := p_from.last_update_login;

Line: 175


    p_to.last_update_date := p_from.last_update_date;

Line: 176


    p_to.last_updated_by := p_from.last_updated_by;

Line: 179


    p_to.last_update_login := p_from.last_update_login;

Line: 198


  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_billingtype_rec              IN BillingType_Rec_Type := G_MISS_BILLINGTYPE_REC,
    x_coverage_billing_type_id     OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 264


    INSERT INTO CS_COV_BILLING_TYPES(
        coverage_billing_type_id,
        max_percent_per_use,
        max_amount_per_use,
        txn_billing_type_id,
        coverage_txn_group_id,
        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_billingtype_rec.coverage_billing_type_id,
        l_def_billingtype_rec.max_percent_per_use,
        l_def_billingtype_rec.max_amount_per_use,
        l_def_billingtype_rec.txn_billing_type_id,
        l_def_billingtype_rec.coverage_txn_group_id,
        l_def_billingtype_rec.last_update_date,
        l_def_billingtype_rec.last_updated_by,
        l_def_billingtype_rec.creation_date,
        l_def_billingtype_rec.created_by,
        l_def_billingtype_rec.last_update_login,
        l_def_billingtype_rec.attribute1,
        l_def_billingtype_rec.attribute2,
        l_def_billingtype_rec.attribute3,
        l_def_billingtype_rec.attribute4,
        l_def_billingtype_rec.attribute5,
        l_def_billingtype_rec.attribute6,
        l_def_billingtype_rec.attribute7,
        l_def_billingtype_rec.attribute8,
        l_def_billingtype_rec.attribute9,
        l_def_billingtype_rec.attribute10,
        l_def_billingtype_rec.attribute11,
        l_def_billingtype_rec.attribute12,
        l_def_billingtype_rec.attribute13,
        l_def_billingtype_rec.attribute14,
        l_def_billingtype_rec.attribute15,
        l_def_billingtype_rec.context,
        l_def_billingtype_rec.object_version_number);

Line: 358


  END insert_row;

Line: 359


  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_max_percent_per_use          IN NUMBER := NULL,
    p_max_amount_per_use           IN NUMBER := NULL,
    p_txn_billing_type_id          IN NUMBER := NULL,
    p_coverage_txn_group_id        IN NUMBER := NULL,
    p_last_update_date             IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_attribute1                   IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_coverage_billing_type_id     OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 417


    l_billingtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 418


    l_billingtype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 421


    l_billingtype_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 439


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_billingtype_rec,
      x_coverage_billing_type_id,
      x_object_version_number
    );

Line: 486


  END insert_row;

Line: 501


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COV_BILLING_TYPES
    WHERE
      COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 509


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COV_BILLING_TYPES
    WHERE
      COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id
      ;

Line: 555


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 564


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 603


  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_billingtype_val_rec          IN BillingType_Val_Rec_Type := G_MISS_BILLINGTYPE_VAL_REC,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 624


      SELECT *
        FROM Cs_Cov_Billing_Types
       WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;

Line: 660


      IF (x_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_billingtype_rec.last_update_date := l_cs_coverage_billing_types_pk.last_update_date;

Line: 664


      IF (x_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_billingtype_rec.last_updated_by := l_cs_coverage_billing_types_pk.last_updated_by;

Line: 676


      IF (x_billingtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_billingtype_rec.last_update_login := l_cs_coverage_billing_types_pk.last_update_login;

Line: 803


    UPDATE  CS_COV_BILLING_TYPES
    SET
        COVERAGE_BILLING_TYPE_ID = l_def_billingtype_rec.coverage_billing_type_id ,
        MAX_PERCENT_PER_USE = l_def_billingtype_rec.max_percent_per_use ,
        MAX_AMOUNT_PER_USE = l_def_billingtype_rec.max_amount_per_use ,
        TXN_BILLING_TYPE_ID = l_def_billingtype_rec.txn_billing_type_id ,
        COVERAGE_TXN_GROUP_ID = l_def_billingtype_rec.coverage_txn_group_id ,
        LAST_UPDATE_DATE = l_def_billingtype_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_billingtype_rec.last_updated_by ,
        CREATION_DATE = l_def_billingtype_rec.creation_date ,
        CREATED_BY = l_def_billingtype_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_billingtype_rec.last_update_login ,
        ATTRIBUTE1 = l_def_billingtype_rec.attribute1 ,
        ATTRIBUTE2 = l_def_billingtype_rec.attribute2 ,
        ATTRIBUTE3 = l_def_billingtype_rec.attribute3 ,
        ATTRIBUTE4 = l_def_billingtype_rec.attribute4 ,
        ATTRIBUTE5 = l_def_billingtype_rec.attribute5 ,
        ATTRIBUTE6 = l_def_billingtype_rec.attribute6 ,
        ATTRIBUTE7 = l_def_billingtype_rec.attribute7 ,
        ATTRIBUTE8 = l_def_billingtype_rec.attribute8 ,
        ATTRIBUTE9 = l_def_billingtype_rec.attribute9 ,
        ATTRIBUTE10 = l_def_billingtype_rec.attribute10 ,
        ATTRIBUTE11 = l_def_billingtype_rec.attribute11 ,
        ATTRIBUTE12 = l_def_billingtype_rec.attribute12 ,
        ATTRIBUTE13 = l_def_billingtype_rec.attribute13 ,
        ATTRIBUTE14 = l_def_billingtype_rec.attribute14 ,
        ATTRIBUTE15 = l_def_billingtype_rec.attribute15 ,
        CONTEXT = l_def_billingtype_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_billingtype_rec.object_version_number
        WHERE
          COVERAGE_BILLING_TYPE_ID = l_def_billingtype_rec.coverage_billing_type_id
          ;

Line: 871


  END update_row;

Line: 872


  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_billing_type_id     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_max_percent_per_use          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_max_amount_per_use           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_txn_billing_type_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_coverage_txn_group_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_COV_BILLING_TYPES.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_BILLING_TYPES.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_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COV_BILLING_TYPES.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: 931


    l_billingtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 932


    l_billingtype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 935


    l_billingtype_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 953


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

Line: 999


  END update_row;

Line: 1000


  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_billing_type_id     IN NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row';

Line: 1026


    DELETE  FROM CS_COV_BILLING_TYPES
    WHERE
      COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id
      ;

Line: 1065


  END delete_row;

Line: 1166


    p_last_update_date             IN CS_COV_BILLING_TYPES.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_BILLING_TYPES.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_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COV_BILLING_TYPES.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: 1210


    l_billingtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1211


    l_billingtype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1214


    l_billingtype_rec.LAST_UPDATE_LOGIN := p_last_update_login;