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

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

Line: 5


      SELECT CS_CONTRACTS_BILLING_S.nextval FROM SYS.DUAL;

Line: 44


    ELSIF p_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_contractbilling_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: 49


    ELSIF p_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_contractbilling_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: 96


      SELECT *
        FROM Cs_Contracts_All
       WHERE cs_contracts_all.contract_id = p_contract_id;

Line: 101


      SELECT *
        FROM Cs_Cp_Services_All
       WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;

Line: 160


    p_to.last_update_date := p_from.last_update_date;

Line: 161


    p_to.last_updated_by := p_from.last_updated_by;

Line: 164


    p_to.last_update_login := p_from.last_update_login;

Line: 202


    p_to.last_update_date := p_from.last_update_date;

Line: 203


    p_to.last_updated_by := p_from.last_updated_by;

Line: 206


    p_to.last_update_login := p_from.last_update_login;

Line: 226


  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_contractbilling_rec          IN ContractBilling_Rec_Type := G_MISS_CONTRACTBILLING_REC,
    x_contract_billing_id          OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 292


    INSERT INTO CS_CONTRACTS_BILLING(
        contract_billing_id,
        header_id,
        order_number,
        line_id,
        cp_service_id,
        contract_id,
        cust_trx_type_id,
        trx_date,
        trx_number,
        trx_amount,
        trx_class,
        billed_until_date,
        currency_code,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        trx_pre_tax_amount,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        object_version_number)
      VALUES (
        l_def_contractbilling_rec.contract_billing_id,
        l_def_contractbilling_rec.header_id,
        l_def_contractbilling_rec.order_number,
        l_def_contractbilling_rec.line_id,
        l_def_contractbilling_rec.cp_service_id,
        l_def_contractbilling_rec.contract_id,
        l_def_contractbilling_rec.cust_trx_type_id,
        l_def_contractbilling_rec.trx_date,
        l_def_contractbilling_rec.trx_number,
        l_def_contractbilling_rec.trx_amount,
        l_def_contractbilling_rec.trx_class,
        l_def_contractbilling_rec.billed_until_date,
        l_def_contractbilling_rec.currency_code,
        l_def_contractbilling_rec.last_update_date,
        l_def_contractbilling_rec.last_updated_by,
        l_def_contractbilling_rec.creation_date,
        l_def_contractbilling_rec.created_by,
        l_def_contractbilling_rec.last_update_login,
        l_def_contractbilling_rec.trx_pre_tax_amount,
        l_def_contractbilling_rec.attribute1,
        l_def_contractbilling_rec.attribute2,
        l_def_contractbilling_rec.attribute3,
        l_def_contractbilling_rec.attribute4,
        l_def_contractbilling_rec.attribute5,
        l_def_contractbilling_rec.attribute6,
        l_def_contractbilling_rec.attribute7,
        l_def_contractbilling_rec.attribute8,
        l_def_contractbilling_rec.attribute9,
        l_def_contractbilling_rec.attribute10,
        l_def_contractbilling_rec.attribute11,
        l_def_contractbilling_rec.attribute12,
        l_def_contractbilling_rec.attribute13,
        l_def_contractbilling_rec.attribute14,
        l_def_contractbilling_rec.attribute15,
        l_def_contractbilling_rec.context,
        l_def_contractbilling_rec.object_version_number);

Line: 404


  END insert_row;

Line: 405


  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_header_id                    IN NUMBER := NULL,
    p_order_number                 IN NUMBER := NULL,
    p_line_id                      IN NUMBER := NULL,
    p_cp_service_id                IN NUMBER := NULL,
    p_contract_id                  IN NUMBER := NULL,
    p_cust_trx_type_id             IN NUMBER := NULL,
    p_trx_date                     IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,
    p_trx_number                   IN NUMBER := NULL,
    p_trx_amount                   IN NUMBER := NULL,
    p_trx_class                    IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
    p_billed_until_date            IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
    p_currency_code                IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
    p_last_update_date             IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_trx_pre_tax_amount           IN NUMBER := NULL,
    p_attribute1                   IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_contract_billing_id          OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 480


    l_contractbilling_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 481


    l_contractbilling_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 484


    l_contractbilling_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 503


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contractbilling_rec,
      x_contract_billing_id,
      x_object_version_number
    );

Line: 550


  END insert_row;

Line: 565


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACTS_BILLING
    WHERE
      CONTRACT_BILLING_ID = p_contract_billing_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 573


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACTS_BILLING
    WHERE
      CONTRACT_BILLING_ID = p_contract_billing_id
      ;

Line: 619


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 628


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 667


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

Line: 688


      SELECT *
        FROM Cs_Contracts_Billing
       WHERE cs_contracts_billing.contract_billing_id = p_contract_billing_id;

Line: 756


      IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;

Line: 760


      IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;

Line: 772


      IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;

Line: 903


    UPDATE  CS_CONTRACTS_BILLING
    SET
        CONTRACT_BILLING_ID = l_def_contractbilling_rec.contract_billing_id ,
        HEADER_ID = l_def_contractbilling_rec.header_id ,
        ORDER_NUMBER = l_def_contractbilling_rec.order_number ,
        LINE_ID = l_def_contractbilling_rec.line_id ,
        CP_SERVICE_ID = l_def_contractbilling_rec.cp_service_id ,
        CONTRACT_ID = l_def_contractbilling_rec.contract_id ,
        CUST_TRX_TYPE_ID = l_def_contractbilling_rec.cust_trx_type_id ,
        TRX_DATE = l_def_contractbilling_rec.trx_date ,
        TRX_NUMBER = l_def_contractbilling_rec.trx_number ,
        TRX_AMOUNT = l_def_contractbilling_rec.trx_amount ,
        TRX_CLASS = l_def_contractbilling_rec.trx_class ,
        BILLED_UNTIL_DATE = l_def_contractbilling_rec.billed_until_date ,
        CURRENCY_CODE = l_def_contractbilling_rec.currency_code ,
        LAST_UPDATE_DATE = l_def_contractbilling_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_contractbilling_rec.last_updated_by ,
        CREATION_DATE = l_def_contractbilling_rec.creation_date ,
        CREATED_BY = l_def_contractbilling_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_contractbilling_rec.last_update_login ,
        TRX_PRE_TAX_AMOUNT = l_def_contractbilling_rec.trx_pre_tax_amount ,
        ATTRIBUTE1 = l_def_contractbilling_rec.attribute1 ,
        ATTRIBUTE2 = l_def_contractbilling_rec.attribute2 ,
        ATTRIBUTE3 = l_def_contractbilling_rec.attribute3 ,
        ATTRIBUTE4 = l_def_contractbilling_rec.attribute4 ,
        ATTRIBUTE5 = l_def_contractbilling_rec.attribute5 ,
        ATTRIBUTE6 = l_def_contractbilling_rec.attribute6 ,
        ATTRIBUTE7 = l_def_contractbilling_rec.attribute7 ,
        ATTRIBUTE8 = l_def_contractbilling_rec.attribute8 ,
        ATTRIBUTE9 = l_def_contractbilling_rec.attribute9 ,
        ATTRIBUTE10 = l_def_contractbilling_rec.attribute10 ,
        ATTRIBUTE11 = l_def_contractbilling_rec.attribute11 ,
        ATTRIBUTE12 = l_def_contractbilling_rec.attribute12 ,
        ATTRIBUTE13 = l_def_contractbilling_rec.attribute13 ,
        ATTRIBUTE14 = l_def_contractbilling_rec.attribute14 ,
        ATTRIBUTE15 = l_def_contractbilling_rec.attribute15 ,
        CONTEXT = l_def_contractbilling_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_contractbilling_rec.object_version_number
        WHERE
          CONTRACT_BILLING_ID = l_def_contractbilling_rec.contract_billing_id
          ;

Line: 980


  END update_row;

Line: 981


  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_contract_billing_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_header_id                    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_order_number                 IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_line_id                      IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_contract_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_cust_trx_type_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_trx_date                     IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_trx_number                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_trx_amount                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_trx_class                    IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_billed_until_date            IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_currency_code                IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_date             IN CS_CONTRACTS_BILLING.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_CONTRACTS_BILLING.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_trx_pre_tax_amount           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute1                   IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACTS_BILLING.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: 1057


    l_contractbilling_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1058


    l_contractbilling_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1061


    l_contractbilling_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 1080


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

Line: 1126


  END update_row;

Line: 1127


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

Line: 1153


    DELETE  FROM CS_CONTRACTS_BILLING
    WHERE
      CONTRACT_BILLING_ID = p_contract_billing_id
      ;

Line: 1192


  END delete_row;

Line: 1301


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


    l_contractbilling_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1355


    l_contractbilling_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1358


    l_contractbilling_rec.LAST_UPDATE_LOGIN := p_last_update_login;