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

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

Line: 5


      SELECT CS_TXN_BILLING_TYPES_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_txnbtype_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_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_txnbtype_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_Lookups
       WHERE cs_lookups.lookup_code = p_lookup_code;

Line: 91


      SELECT *
        FROM Cs_Transaction_Types
       WHERE cs_transaction_types.transaction_type_id = p_transaction_type_id;

Line: 140


    p_to.last_update_date := p_from.last_update_date;

Line: 141


    p_to.last_updated_by := p_from.last_updated_by;

Line: 144


    p_to.last_update_login := p_from.last_update_login;

Line: 171


    p_to.last_update_date := p_from.last_update_date;

Line: 172


    p_to.last_updated_by := p_from.last_updated_by;

Line: 175


    p_to.last_update_login := p_from.last_update_login;

Line: 194


  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_txnbtype_rec                 IN TxnBType_Rec_Type := G_MISS_TXNBTYPE_REC,
    x_txn_billing_type_id          OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 260


    INSERT INTO CS_TXN_BILLING_TYPES(
        txn_billing_type_id,
        billing_type,
        transaction_type_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_txnbtype_rec.txn_billing_type_id,
        l_def_txnbtype_rec.billing_type,
        l_def_txnbtype_rec.transaction_type_id,
        l_def_txnbtype_rec.last_update_date,
        l_def_txnbtype_rec.last_updated_by,
        l_def_txnbtype_rec.creation_date,
        l_def_txnbtype_rec.created_by,
        l_def_txnbtype_rec.last_update_login,
        l_def_txnbtype_rec.attribute1,
        l_def_txnbtype_rec.attribute2,
        l_def_txnbtype_rec.attribute3,
        l_def_txnbtype_rec.attribute4,
        l_def_txnbtype_rec.attribute5,
        l_def_txnbtype_rec.attribute6,
        l_def_txnbtype_rec.attribute7,
        l_def_txnbtype_rec.attribute8,
        l_def_txnbtype_rec.attribute9,
        l_def_txnbtype_rec.attribute10,
        l_def_txnbtype_rec.attribute11,
        l_def_txnbtype_rec.attribute12,
        l_def_txnbtype_rec.attribute13,
        l_def_txnbtype_rec.attribute14,
        l_def_txnbtype_rec.attribute15,
        l_def_txnbtype_rec.context,
        l_def_txnbtype_rec.object_version_number);

Line: 350


  END insert_row;

Line: 351


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

Line: 405


    l_txnbtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 406


    l_txnbtype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 409


    l_txnbtype_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 427


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_txnbtype_rec,
      x_txn_billing_type_id,
      x_object_version_number
    );

Line: 474


  END insert_row;

Line: 489


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_TXN_BILLING_TYPES
    WHERE
      TXN_BILLING_TYPE_ID = p_txn_billing_type_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 497


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_TXN_BILLING_TYPES
    WHERE
      TXN_BILLING_TYPE_ID = p_txn_billing_type_id
      ;

Line: 543


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 552


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 591


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

Line: 612


      SELECT *
        FROM Cs_Txn_Billing_Types
       WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;

Line: 640


      IF (x_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_txnbtype_rec.last_update_date := l_cs_txn_billing_types_pk.last_update_date;

Line: 644


      IF (x_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_txnbtype_rec.last_updated_by := l_cs_txn_billing_types_pk.last_updated_by;

Line: 656


      IF (x_txnbtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_txnbtype_rec.last_update_login := l_cs_txn_billing_types_pk.last_update_login;

Line: 783


    UPDATE  CS_TXN_BILLING_TYPES
    SET
        TXN_BILLING_TYPE_ID = l_def_txnbtype_rec.txn_billing_type_id ,
        BILLING_TYPE = l_def_txnbtype_rec.billing_type ,
        TRANSACTION_TYPE_ID = l_def_txnbtype_rec.transaction_type_id ,
        LAST_UPDATE_DATE = l_def_txnbtype_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_txnbtype_rec.last_updated_by ,
        CREATION_DATE = l_def_txnbtype_rec.creation_date ,
        CREATED_BY = l_def_txnbtype_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_txnbtype_rec.last_update_login ,
        ATTRIBUTE1 = l_def_txnbtype_rec.attribute1 ,
        ATTRIBUTE2 = l_def_txnbtype_rec.attribute2 ,
        ATTRIBUTE3 = l_def_txnbtype_rec.attribute3 ,
        ATTRIBUTE4 = l_def_txnbtype_rec.attribute4 ,
        ATTRIBUTE5 = l_def_txnbtype_rec.attribute5 ,
        ATTRIBUTE6 = l_def_txnbtype_rec.attribute6 ,
        ATTRIBUTE7 = l_def_txnbtype_rec.attribute7 ,
        ATTRIBUTE8 = l_def_txnbtype_rec.attribute8 ,
        ATTRIBUTE9 = l_def_txnbtype_rec.attribute9 ,
        ATTRIBUTE10 = l_def_txnbtype_rec.attribute10 ,
        ATTRIBUTE11 = l_def_txnbtype_rec.attribute11 ,
        ATTRIBUTE12 = l_def_txnbtype_rec.attribute12 ,
        ATTRIBUTE13 = l_def_txnbtype_rec.attribute13 ,
        ATTRIBUTE14 = l_def_txnbtype_rec.attribute14 ,
        ATTRIBUTE15 = l_def_txnbtype_rec.attribute15 ,
        CONTEXT = l_def_txnbtype_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_txnbtype_rec.object_version_number
        WHERE
          TXN_BILLING_TYPE_ID = l_def_txnbtype_rec.txn_billing_type_id
          ;

Line: 849


  END update_row;

Line: 850


  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_txn_billing_type_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_billing_type                 IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_transaction_type_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_TXN_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_TXN_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_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_TXN_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_TXN_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_TXN_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_TXN_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_TXN_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_TXN_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_TXN_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_TXN_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: 905


    l_txnbtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 906


    l_txnbtype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 909


    l_txnbtype_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 927


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

Line: 973


  END update_row;

Line: 974


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

Line: 1000


    DELETE  FROM CS_TXN_BILLING_TYPES
    WHERE
      TXN_BILLING_TYPE_ID = p_txn_billing_type_id
      ;

Line: 1039


  END delete_row;

Line: 1138


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


    l_txnbtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1181


    l_txnbtype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1184


    l_txnbtype_rec.LAST_UPDATE_LOGIN := p_last_update_login;