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

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

Line: 5


      SELECT CS_CP_SERVICE_TRANSACTIONS_S.nextval FROM SYS.DUAL;

Line: 24


    IF p_servicetran_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
       p_servicetran_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: 29


    ELSIF p_servicetran_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_servicetran_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: 90


      SELECT *
        FROM Cs_Cp_Services_All
       WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;

Line: 126


    p_to.last_update_date := p_from.last_update_date;

Line: 127


    p_to.last_updated_by := p_from.last_updated_by;

Line: 130


    p_to.last_update_login := p_from.last_update_login;

Line: 204


    p_to.last_update_date := p_from.last_update_date;

Line: 205


    p_to.last_updated_by := p_from.last_updated_by;

Line: 208


    p_to.last_update_login := p_from.last_update_login;

Line: 276


  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_servicetran_rec              IN ServiceTran_Rec_Type := G_MISS_SERVICETRAN_REC,
    x_cp_service_transaction_id    OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 341


    INSERT INTO CS_CP_SERVICE_TRANSACTIONS(
        cp_service_transaction_id,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        cp_service_id,
        transaction_type_code,
        resulting_status_code,
        effective_start_date,
        effective_end_date,
        current_end_date,
        terminated_transaction_id,
        reason_code,
        reason_comments,
        service_selling_price,
        currency_code,
        conversion_type,
        conversion_rate,
        conversion_date,
        invoicing_rule_id,
        accounting_rule_id,
        payment_terms_id,
        service_order_line_id,
        service_order_number,
        service_order_date,
        service_order_type,
        invoice_flag,
        coverage_schedule_id,
        duration_quantity,
        unit_of_measure_code,
        starting_delay,
        bill_to_site_use_id,
        bill_to_contact_id,
        prorate_flag,
        ra_interface_status,
        invoice_count,
        price_list_id,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        pricing_attribute1,
        pricing_attribute2,
        pricing_attribute3,
        pricing_attribute4,
        pricing_attribute5,
        pricing_attribute6,
        pricing_attribute7,
        pricing_attribute8,
        pricing_attribute9,
        pricing_attribute10,
        pricing_attribute11,
        pricing_attribute12,
        pricing_attribute13,
        pricing_attribute14,
        pricing_attribute15,
        pricing_context,
        credit_amount,
        purchase_order_num)
      VALUES (
        l_def_servicetran_rec.cp_service_transaction_id,
        l_def_servicetran_rec.last_update_date,
        l_def_servicetran_rec.last_updated_by,
        l_def_servicetran_rec.creation_date,
        l_def_servicetran_rec.created_by,
        l_def_servicetran_rec.last_update_login,
        l_def_servicetran_rec.cp_service_id,
        l_def_servicetran_rec.transaction_type_code,
        l_def_servicetran_rec.resulting_status_code,
        l_def_servicetran_rec.effective_start_date,
        l_def_servicetran_rec.effective_end_date,
        l_def_servicetran_rec.current_end_date,
        l_def_servicetran_rec.terminated_transaction_id,
        l_def_servicetran_rec.reason_code,
        l_def_servicetran_rec.reason_comments,
        l_def_servicetran_rec.service_selling_price,
        l_def_servicetran_rec.currency_code,
        l_def_servicetran_rec.conversion_type,
        l_def_servicetran_rec.conversion_rate,
        l_def_servicetran_rec.conversion_date,
        l_def_servicetran_rec.invoicing_rule_id,
        l_def_servicetran_rec.accounting_rule_id,
        l_def_servicetran_rec.payment_terms_id,
        l_def_servicetran_rec.service_order_line_id,
        l_def_servicetran_rec.service_order_number,
        l_def_servicetran_rec.service_order_date,
        l_def_servicetran_rec.service_order_type,
        l_def_servicetran_rec.invoice_flag,
        l_def_servicetran_rec.coverage_schedule_id,
        l_def_servicetran_rec.duration_quantity,
        l_def_servicetran_rec.unit_of_measure_code,
        l_def_servicetran_rec.starting_delay,
        l_def_servicetran_rec.bill_to_site_use_id,
        l_def_servicetran_rec.bill_to_contact_id,
        l_def_servicetran_rec.prorate_flag,
        l_def_servicetran_rec.ra_interface_status,
        l_def_servicetran_rec.invoice_count,
        l_def_servicetran_rec.price_list_id,
        l_def_servicetran_rec.attribute1,
        l_def_servicetran_rec.attribute2,
        l_def_servicetran_rec.attribute3,
        l_def_servicetran_rec.attribute4,
        l_def_servicetran_rec.attribute5,
        l_def_servicetran_rec.attribute6,
        l_def_servicetran_rec.attribute7,
        l_def_servicetran_rec.attribute8,
        l_def_servicetran_rec.attribute9,
        l_def_servicetran_rec.attribute10,
        l_def_servicetran_rec.attribute11,
        l_def_servicetran_rec.attribute12,
        l_def_servicetran_rec.attribute13,
        l_def_servicetran_rec.attribute14,
        l_def_servicetran_rec.attribute15,
        l_def_servicetran_rec.context,
        l_def_servicetran_rec.pricing_attribute1,
        l_def_servicetran_rec.pricing_attribute2,
        l_def_servicetran_rec.pricing_attribute3,
        l_def_servicetran_rec.pricing_attribute4,
        l_def_servicetran_rec.pricing_attribute5,
        l_def_servicetran_rec.pricing_attribute6,
        l_def_servicetran_rec.pricing_attribute7,
        l_def_servicetran_rec.pricing_attribute8,
        l_def_servicetran_rec.pricing_attribute9,
        l_def_servicetran_rec.pricing_attribute10,
        l_def_servicetran_rec.pricing_attribute11,
        l_def_servicetran_rec.pricing_attribute12,
        l_def_servicetran_rec.pricing_attribute13,
        l_def_servicetran_rec.pricing_attribute14,
        l_def_servicetran_rec.pricing_attribute15,
        l_def_servicetran_rec.pricing_context,
        l_def_servicetran_rec.credit_amount,
        l_def_servicetran_rec.purchase_order_num);

Line: 524


  END insert_row;

Line: 525


  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_last_update_date             IN CS_CP_SERVICE_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_CP_SERVICE_TRANSACTIONS.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_cp_service_id                IN NUMBER := NULL,
    p_transaction_type_code        IN CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := NULL,
    p_resulting_status_code        IN CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := NULL,
    p_effective_start_date         IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := NULL,
    p_effective_end_date           IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := NULL,
    p_current_end_date             IN CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := NULL,
    p_terminated_transaction_id    IN NUMBER := NULL,
    p_reason_code                  IN CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := NULL,
    p_reason_comments              IN CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := NULL,
    p_service_selling_price        IN NUMBER := NULL,
    p_currency_code                IN CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := NULL,
    p_conversion_type              IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := NULL,
    p_conversion_rate              IN NUMBER := NULL,
    p_conversion_date              IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := NULL,
    p_invoicing_rule_id            IN NUMBER := NULL,
    p_accounting_rule_id           IN NUMBER := NULL,
    p_payment_terms_id             IN NUMBER := NULL,
    p_service_order_line_id        IN NUMBER := NULL,
    p_service_order_number         IN NUMBER := NULL,
    p_service_order_date           IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := NULL,
    p_service_order_type           IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := NULL,
    p_invoice_flag                 IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := NULL,
    p_coverage_schedule_id         IN NUMBER := NULL,
    p_duration_quantity            IN NUMBER := NULL,
    p_unit_of_measure_code         IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
    p_starting_delay               IN NUMBER := NULL,
    p_bill_to_site_use_id          IN NUMBER := NULL,
    p_bill_to_contact_id           IN NUMBER := NULL,
    p_prorate_flag                 IN CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := NULL,
    p_ra_interface_status          IN CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := NULL,
    p_invoice_count                IN NUMBER := NULL,
    p_price_list_id                IN NUMBER := NULL,
    p_attribute1                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := NULL,
    p_pricing_attribute1           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := NULL,
    p_pricing_attribute2           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := NULL,
    p_pricing_attribute3           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := NULL,
    p_pricing_attribute4           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := NULL,
    p_pricing_attribute5           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := NULL,
    p_pricing_attribute6           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := NULL,
    p_pricing_attribute7           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := NULL,
    p_pricing_attribute8           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := NULL,
    p_pricing_attribute9           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := NULL,
    p_pricing_attribute10          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := NULL,
    p_pricing_attribute11          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := NULL,
    p_pricing_attribute12          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := NULL,
    p_pricing_attribute13          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := NULL,
    p_pricing_attribute14          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := NULL,
    p_pricing_attribute15          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := NULL,
    p_pricing_context              IN CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := NULL,
    p_credit_amount                IN NUMBER := NULL,
    p_purchase_order_num           IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := NULL,
    x_cp_service_transaction_id    OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 623


    l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 624


    l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 627


    l_servicetran_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 694


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_servicetran_rec,
      x_cp_service_transaction_id
    );

Line: 740


  END insert_row;

Line: 751


    p_last_update_date             IN DATE,
    p_last_updated_by              IN NUMBER,
    p_creation_date                IN DATE,
    p_created_by                   IN NUMBER,
    p_last_update_login            IN NUMBER,
    p_cp_service_id                IN NUMBER,
    p_transaction_type_code        IN VARCHAR2,
    p_resulting_status_code        IN VARCHAR2,
    p_effective_start_date         IN DATE,
    p_effective_end_date           IN DATE,
    p_current_end_date             IN DATE,
    p_terminated_transaction_id    IN NUMBER,
    p_reason_code                  IN VARCHAR2,
    p_reason_comments              IN VARCHAR2,
    p_service_selling_price        IN NUMBER,
    p_currency_code                IN VARCHAR2,
    p_conversion_type              IN VARCHAR2,
    p_conversion_rate              IN NUMBER,
    p_conversion_date              IN DATE,
    p_invoicing_rule_id            IN NUMBER,
    p_accounting_rule_id           IN NUMBER,
    p_payment_terms_id             IN NUMBER,
    p_service_order_line_id        IN NUMBER,
    p_service_order_number         IN NUMBER,
    p_service_order_date           IN DATE,
    p_service_order_type           IN VARCHAR2,
    p_invoice_flag                 IN VARCHAR2,
    p_coverage_schedule_id         IN NUMBER,
    p_duration_quantity            IN NUMBER,
    p_unit_of_measure_code         IN VARCHAR2,
    p_starting_delay               IN NUMBER,
    p_bill_to_site_use_id          IN NUMBER,
    p_bill_to_contact_id           IN NUMBER,
    p_prorate_flag                 IN VARCHAR2,
    p_ra_interface_status          IN VARCHAR2,
    p_invoice_count                IN NUMBER,
    p_price_list_id                IN NUMBER,
    p_attribute1                   IN VARCHAR2,
    p_attribute2                   IN VARCHAR2,
    p_attribute3                   IN VARCHAR2,
    p_attribute4                   IN VARCHAR2,
    p_attribute5                   IN VARCHAR2,
    p_attribute6                   IN VARCHAR2,
    p_attribute7                   IN VARCHAR2,
    p_attribute8                   IN VARCHAR2,
    p_attribute9                   IN VARCHAR2,
    p_attribute10                  IN VARCHAR2,
    p_attribute11                  IN VARCHAR2,
    p_attribute12                  IN VARCHAR2,
    p_attribute13                  IN VARCHAR2,
    p_attribute14                  IN VARCHAR2,
    p_attribute15                  IN VARCHAR2,
    p_context                      IN VARCHAR2,
    p_pricing_attribute1           IN VARCHAR2,
    p_pricing_attribute2           IN VARCHAR2,
    p_pricing_attribute3           IN VARCHAR2,
    p_pricing_attribute4           IN VARCHAR2,
    p_pricing_attribute5           IN VARCHAR2,
    p_pricing_attribute6           IN VARCHAR2,
    p_pricing_attribute7           IN VARCHAR2,
    p_pricing_attribute8           IN VARCHAR2,
    p_pricing_attribute9           IN VARCHAR2,
    p_pricing_attribute10          IN VARCHAR2,
    p_pricing_attribute11          IN VARCHAR2,
    p_pricing_attribute12          IN VARCHAR2,
    p_pricing_attribute13          IN VARCHAR2,
    p_pricing_attribute14          IN VARCHAR2,
    p_pricing_attribute15          IN VARCHAR2,
    p_pricing_context              IN VARCHAR2,
    p_credit_amount                IN NUMBER,
    p_purchase_order_num           IN VARCHAR2) IS
    E_Resource_Busy               EXCEPTION;

Line: 825


    SELECT *
     FROM CS_CP_SERVICE_TRANSACTIONS
    WHERE
      CP_SERVICE_TRANSACTION_ID = p_cp_service_transaction_id
    FOR UPDATE NOWAIT;

Line: 865


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 872


      IF (l_object_version_number.LAST_UPDATE_DATE <> p_last_update_date) THEN
        TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 876


      IF (l_object_version_number.LAST_UPDATED_BY <> p_last_updated_by) THEN
        TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 888


      IF (l_object_version_number.LAST_UPDATE_LOGIN <> p_last_update_login) THEN
        TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1193


  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_servicetran_val_rec          IN ServiceTran_Val_Rec_Type := G_MISS_SERVICETRAN_VAL_REC) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 1213


      SELECT *
        FROM Cs_Cp_Service_Transactions
       WHERE cs_cp_service_transactions.cp_service_transaction_id = p_cp_service_transaction_id;

Line: 1233


      IF (x_servicetran_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_servicetran_rec.last_update_date := l_cs_cp_service_transa1.last_update_date;

Line: 1237


      IF (x_servicetran_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_servicetran_rec.last_updated_by := l_cs_cp_service_transa1.last_updated_by;

Line: 1249


      IF (x_servicetran_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_servicetran_rec.last_update_login := l_cs_cp_service_transa1.last_update_login;

Line: 1572


    UPDATE  CS_CP_SERVICE_TRANSACTIONS
    SET
        CP_SERVICE_TRANSACTION_ID = l_def_servicetran_rec.cp_service_transaction_id ,
        LAST_UPDATE_DATE = l_def_servicetran_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_servicetran_rec.last_updated_by ,
        CREATION_DATE = l_def_servicetran_rec.creation_date ,
        CREATED_BY = l_def_servicetran_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_servicetran_rec.last_update_login ,
        CP_SERVICE_ID = l_def_servicetran_rec.cp_service_id ,
        TRANSACTION_TYPE_CODE = l_def_servicetran_rec.transaction_type_code ,
        RESULTING_STATUS_CODE = l_def_servicetran_rec.resulting_status_code ,
        EFFECTIVE_START_DATE = l_def_servicetran_rec.effective_start_date ,
        EFFECTIVE_END_DATE = l_def_servicetran_rec.effective_end_date ,
        CURRENT_END_DATE = l_def_servicetran_rec.current_end_date ,
        TERMINATED_TRANSACTION_ID = l_def_servicetran_rec.terminated_transaction_id ,
        REASON_CODE = l_def_servicetran_rec.reason_code ,
        REASON_COMMENTS = l_def_servicetran_rec.reason_comments ,
        SERVICE_SELLING_PRICE = l_def_servicetran_rec.service_selling_price ,
        CURRENCY_CODE = l_def_servicetran_rec.currency_code ,
        CONVERSION_TYPE = l_def_servicetran_rec.conversion_type ,
        CONVERSION_RATE = l_def_servicetran_rec.conversion_rate ,
        CONVERSION_DATE = l_def_servicetran_rec.conversion_date ,
        INVOICING_RULE_ID = l_def_servicetran_rec.invoicing_rule_id ,
        ACCOUNTING_RULE_ID = l_def_servicetran_rec.accounting_rule_id ,
        PAYMENT_TERMS_ID = l_def_servicetran_rec.payment_terms_id ,
        SERVICE_ORDER_LINE_ID = l_def_servicetran_rec.service_order_line_id ,
        SERVICE_ORDER_NUMBER = l_def_servicetran_rec.service_order_number ,
        SERVICE_ORDER_DATE = l_def_servicetran_rec.service_order_date ,
        SERVICE_ORDER_TYPE = l_def_servicetran_rec.service_order_type ,
        INVOICE_FLAG = l_def_servicetran_rec.invoice_flag ,
        COVERAGE_SCHEDULE_ID = l_def_servicetran_rec.coverage_schedule_id ,
        DURATION_QUANTITY = l_def_servicetran_rec.duration_quantity ,
        UNIT_OF_MEASURE_CODE = l_def_servicetran_rec.unit_of_measure_code ,
        STARTING_DELAY = l_def_servicetran_rec.starting_delay ,
        BILL_TO_SITE_USE_ID = l_def_servicetran_rec.bill_to_site_use_id ,
        BILL_TO_CONTACT_ID = l_def_servicetran_rec.bill_to_contact_id ,
        PRORATE_FLAG = l_def_servicetran_rec.prorate_flag ,
        RA_INTERFACE_STATUS = l_def_servicetran_rec.ra_interface_status ,
        INVOICE_COUNT = l_def_servicetran_rec.invoice_count ,
        PRICE_LIST_ID = l_def_servicetran_rec.price_list_id ,
        ATTRIBUTE1 = l_def_servicetran_rec.attribute1 ,
        ATTRIBUTE2 = l_def_servicetran_rec.attribute2 ,
        ATTRIBUTE3 = l_def_servicetran_rec.attribute3 ,
        ATTRIBUTE4 = l_def_servicetran_rec.attribute4 ,
        ATTRIBUTE5 = l_def_servicetran_rec.attribute5 ,
        ATTRIBUTE6 = l_def_servicetran_rec.attribute6 ,
        ATTRIBUTE7 = l_def_servicetran_rec.attribute7 ,
        ATTRIBUTE8 = l_def_servicetran_rec.attribute8 ,
        ATTRIBUTE9 = l_def_servicetran_rec.attribute9 ,
        ATTRIBUTE10 = l_def_servicetran_rec.attribute10 ,
        ATTRIBUTE11 = l_def_servicetran_rec.attribute11 ,
        ATTRIBUTE12 = l_def_servicetran_rec.attribute12 ,
        ATTRIBUTE13 = l_def_servicetran_rec.attribute13 ,
        ATTRIBUTE14 = l_def_servicetran_rec.attribute14 ,
        ATTRIBUTE15 = l_def_servicetran_rec.attribute15 ,
        CONTEXT = l_def_servicetran_rec.context ,
        PRICING_ATTRIBUTE1 = l_def_servicetran_rec.pricing_attribute1 ,
        PRICING_ATTRIBUTE2 = l_def_servicetran_rec.pricing_attribute2 ,
        PRICING_ATTRIBUTE3 = l_def_servicetran_rec.pricing_attribute3 ,
        PRICING_ATTRIBUTE4 = l_def_servicetran_rec.pricing_attribute4 ,
        PRICING_ATTRIBUTE5 = l_def_servicetran_rec.pricing_attribute5 ,
        PRICING_ATTRIBUTE6 = l_def_servicetran_rec.pricing_attribute6 ,
        PRICING_ATTRIBUTE7 = l_def_servicetran_rec.pricing_attribute7 ,
        PRICING_ATTRIBUTE8 = l_def_servicetran_rec.pricing_attribute8 ,
        PRICING_ATTRIBUTE9 = l_def_servicetran_rec.pricing_attribute9 ,
        PRICING_ATTRIBUTE10 = l_def_servicetran_rec.pricing_attribute10 ,
        PRICING_ATTRIBUTE11 = l_def_servicetran_rec.pricing_attribute11 ,
        PRICING_ATTRIBUTE12 = l_def_servicetran_rec.pricing_attribute12 ,
        PRICING_ATTRIBUTE13 = l_def_servicetran_rec.pricing_attribute13 ,
        PRICING_ATTRIBUTE14 = l_def_servicetran_rec.pricing_attribute14 ,
        PRICING_ATTRIBUTE15 = l_def_servicetran_rec.pricing_attribute15 ,
        PRICING_CONTEXT = l_def_servicetran_rec.pricing_context ,
        CREDIT_AMOUNT = l_def_servicetran_rec.credit_amount ,
        PURCHASE_ORDER_NUM = l_def_servicetran_rec.purchase_order_num
        WHERE
          CP_SERVICE_TRANSACTION_ID = l_def_servicetran_rec.cp_service_transaction_id
          ;

Line: 1684


  END update_row;

Line: 1685


  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_cp_service_transaction_id    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_CP_SERVICE_TRANSACTIONS.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_CP_SERVICE_TRANSACTIONS.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_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_transaction_type_code        IN CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_resulting_status_code        IN CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_effective_start_date         IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_effective_end_date           IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_current_end_date             IN CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_terminated_transaction_id    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_reason_code                  IN CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_reason_comments              IN CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_service_selling_price        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_currency_code                IN CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_conversion_type              IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_conversion_rate              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_conversion_date              IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_invoicing_rule_id            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_accounting_rule_id           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_payment_terms_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_order_line_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_order_number         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_order_date           IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_service_order_type           IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_invoice_flag                 IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_coverage_schedule_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_duration_quantity            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_unit_of_measure_code         IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_starting_delay               IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_bill_to_site_use_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_bill_to_contact_id           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_prorate_flag                 IN CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_ra_interface_status          IN CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_invoice_count                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_price_list_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute1                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute1           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute2           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute3           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute4           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute5           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute6           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute7           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute8           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute9           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute10          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute11          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute12          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute13          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute14          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute15          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_context              IN CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_credit_amount                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_purchase_order_num           IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';

Line: 1784


    l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1785


    l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1788


    l_servicetran_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 1855


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

Line: 1900


  END update_row;

Line: 1901


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

Line: 1927


    DELETE  FROM CS_CP_SERVICE_TRANSACTIONS
    WHERE
      CP_SERVICE_TRANSACTION_ID = p_cp_service_transaction_id
      ;

Line: 1966


  END delete_row;

Line: 2063


    p_last_update_date             IN CS_CP_SERVICE_TRANSACTIONS.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_CP_SERVICE_TRANSACTIONS.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_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_transaction_type_code        IN CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_resulting_status_code        IN CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_effective_start_date         IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_effective_end_date           IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_current_end_date             IN CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_terminated_transaction_id    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_reason_code                  IN CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_reason_comments              IN CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_service_selling_price        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_currency_code                IN CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_conversion_type              IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_conversion_rate              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_conversion_date              IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_invoicing_rule_id            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_accounting_rule_id           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_payment_terms_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_order_line_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_order_number         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_order_date           IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_service_order_type           IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_invoice_flag                 IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_coverage_schedule_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_duration_quantity            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_unit_of_measure_code         IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_starting_delay               IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_bill_to_site_use_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_bill_to_contact_id           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_prorate_flag                 IN CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_ra_interface_status          IN CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_invoice_count                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_price_list_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute1                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute1           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute2           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute3           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute4           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute5           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute6           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute7           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute8           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute9           IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute10          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute11          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute12          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute13          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute14          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_attribute15          IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_pricing_context              IN CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_credit_amount                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_purchase_order_num           IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'validate_row';

Line: 2152


    l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 2153


    l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 2156


    l_servicetran_rec.LAST_UPDATE_LOGIN := p_last_update_login;