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

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

Line: 5


      SELECT CS_CONTRACT_LINE_TPLTS_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_contractltmpl_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_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_contractltmpl_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_Coverages
       WHERE cs_coverages.coverage_id = p_coverage_id;

Line: 91


      SELECT *
        FROM Cs_Contract_Templates
       WHERE cs_contract_templates.contract_template_id = p_contract_template_id;

Line: 146


    p_to.last_update_date := p_from.last_update_date;

Line: 147


    p_to.last_updated_by := p_from.last_updated_by;

Line: 150


    p_to.last_update_login := p_from.last_update_login;

Line: 185


    p_to.last_update_date := p_from.last_update_date;

Line: 186


    p_to.last_updated_by := p_from.last_updated_by;

Line: 189


    p_to.last_update_login := p_from.last_update_login;

Line: 210


  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_contractltmpl_rec            IN ContractLTmpl_Rec_Type := G_MISS_CONTRACTLTMPL_REC,
    x_contract_line_template_id    OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 276


    INSERT INTO CS_CONTRACT_LINE_TPLTS(
        contract_line_template_id,
        contract_template_id,
        coverage_id,
        service_manufacturing_org_id,
        service_inventory_item_id,
        workflow,
        duration,
        unit_of_measure_code,
        original_system_reference,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        start_date_active,
        end_date_active,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        object_version_number)
      VALUES (
        l_def_contractltmpl_rec.contract_line_template_id,
        l_def_contractltmpl_rec.contract_template_id,
        l_def_contractltmpl_rec.coverage_id,
        l_def_contractltmpl_rec.service_manufacturing_org_id,
        l_def_contractltmpl_rec.service_inventory_item_id,
        l_def_contractltmpl_rec.workflow,
        l_def_contractltmpl_rec.duration,
        l_def_contractltmpl_rec.unit_of_measure_code,
        l_def_contractltmpl_rec.original_system_reference,
        l_def_contractltmpl_rec.last_update_date,
        l_def_contractltmpl_rec.last_updated_by,
        l_def_contractltmpl_rec.creation_date,
        l_def_contractltmpl_rec.created_by,
        l_def_contractltmpl_rec.last_update_login,
        l_def_contractltmpl_rec.start_date_active,
        l_def_contractltmpl_rec.end_date_active,
        l_def_contractltmpl_rec.attribute1,
        l_def_contractltmpl_rec.attribute2,
        l_def_contractltmpl_rec.attribute3,
        l_def_contractltmpl_rec.attribute4,
        l_def_contractltmpl_rec.attribute5,
        l_def_contractltmpl_rec.attribute6,
        l_def_contractltmpl_rec.attribute7,
        l_def_contractltmpl_rec.attribute8,
        l_def_contractltmpl_rec.attribute9,
        l_def_contractltmpl_rec.attribute10,
        l_def_contractltmpl_rec.attribute11,
        l_def_contractltmpl_rec.attribute12,
        l_def_contractltmpl_rec.attribute13,
        l_def_contractltmpl_rec.attribute14,
        l_def_contractltmpl_rec.attribute15,
        l_def_contractltmpl_rec.context,
        l_def_contractltmpl_rec.object_version_number);

Line: 382


  END insert_row;

Line: 383


  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_contract_template_id         IN NUMBER := NULL,
    p_coverage_id                  IN NUMBER := NULL,
    p_service_manufacturing_org_id  IN NUMBER := NULL,
    p_service_inventory_item_id    IN NUMBER := NULL,
    p_workflow                     IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
    p_duration                     IN NUMBER := NULL,
    p_unit_of_measure_code         IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
    p_original_system_reference    IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
    p_last_update_date             IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_start_date_active            IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
    p_end_date_active              IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
    p_attribute1                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_contract_line_template_id    OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 451


    l_contractltmpl_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 452


    l_contractltmpl_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 455


    l_contractltmpl_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 475


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contractltmpl_rec,
      x_contract_line_template_id,
      x_object_version_number
    );

Line: 522


  END insert_row;

Line: 537


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_LINE_TPLTS
    WHERE
      CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 545


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_LINE_TPLTS
    WHERE
      CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id
      ;

Line: 591


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 600


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 639


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

Line: 660


      SELECT *
        FROM Cs_Contract_Line_Tplts
       WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;

Line: 712


      IF (x_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_contractltmpl_rec.last_update_date := l_cs_contract_line_tem1.last_update_date;

Line: 716


      IF (x_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contractltmpl_rec.last_updated_by := l_cs_contract_line_tem1.last_updated_by;

Line: 728


      IF (x_contractltmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contractltmpl_rec.last_update_login := l_cs_contract_line_tem1.last_update_login;

Line: 863


    UPDATE  CS_CONTRACT_LINE_TPLTS
    SET
        CONTRACT_LINE_TEMPLATE_ID = l_def_contractltmpl_rec.contract_line_template_id ,
        CONTRACT_TEMPLATE_ID = l_def_contractltmpl_rec.contract_template_id ,
        COVERAGE_ID = l_def_contractltmpl_rec.coverage_id ,
        SERVICE_MANUFACTURING_ORG_ID = l_def_contractltmpl_rec.service_manufacturing_org_id ,
        SERVICE_INVENTORY_ITEM_ID = l_def_contractltmpl_rec.service_inventory_item_id ,
        WORKFLOW = l_def_contractltmpl_rec.workflow ,
        DURATION = l_def_contractltmpl_rec.duration ,
        UNIT_OF_MEASURE_CODE = l_def_contractltmpl_rec.unit_of_measure_code ,
        ORIGINAL_SYSTEM_REFERENCE = l_def_contractltmpl_rec.original_system_reference ,
        LAST_UPDATE_DATE = l_def_contractltmpl_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_contractltmpl_rec.last_updated_by ,
        CREATION_DATE = l_def_contractltmpl_rec.creation_date ,
        CREATED_BY = l_def_contractltmpl_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_contractltmpl_rec.last_update_login ,
        START_DATE_ACTIVE = l_def_contractltmpl_rec.start_date_active ,
        END_DATE_ACTIVE = l_def_contractltmpl_rec.end_date_active ,
        ATTRIBUTE1 = l_def_contractltmpl_rec.attribute1 ,
        ATTRIBUTE2 = l_def_contractltmpl_rec.attribute2 ,
        ATTRIBUTE3 = l_def_contractltmpl_rec.attribute3 ,
        ATTRIBUTE4 = l_def_contractltmpl_rec.attribute4 ,
        ATTRIBUTE5 = l_def_contractltmpl_rec.attribute5 ,
        ATTRIBUTE6 = l_def_contractltmpl_rec.attribute6 ,
        ATTRIBUTE7 = l_def_contractltmpl_rec.attribute7 ,
        ATTRIBUTE8 = l_def_contractltmpl_rec.attribute8 ,
        ATTRIBUTE9 = l_def_contractltmpl_rec.attribute9 ,
        ATTRIBUTE10 = l_def_contractltmpl_rec.attribute10 ,
        ATTRIBUTE11 = l_def_contractltmpl_rec.attribute11 ,
        ATTRIBUTE12 = l_def_contractltmpl_rec.attribute12 ,
        ATTRIBUTE13 = l_def_contractltmpl_rec.attribute13 ,
        ATTRIBUTE14 = l_def_contractltmpl_rec.attribute14 ,
        ATTRIBUTE15 = l_def_contractltmpl_rec.attribute15 ,
        CONTEXT = l_def_contractltmpl_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_contractltmpl_rec.object_version_number
        WHERE
          CONTRACT_LINE_TEMPLATE_ID = l_def_contractltmpl_rec.contract_line_template_id
          ;

Line: 937


  END update_row;

Line: 938


  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_line_template_id    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_contract_template_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_coverage_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_manufacturing_org_id  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_service_inventory_item_id    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_workflow                     IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_duration                     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_unit_of_measure_code         IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_original_system_reference    IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_date             IN CS_CONTRACT_LINE_TPLTS.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_CONTRACT_LINE_TPLTS.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_start_date_active            IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_attribute1                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_LINE_TPLTS.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: 1007


    l_contractltmpl_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1008


    l_contractltmpl_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1011


    l_contractltmpl_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 1031


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

Line: 1077


  END update_row;

Line: 1078


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

Line: 1104


    DELETE  FROM CS_CONTRACT_LINE_TPLTS
    WHERE
      CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id
      ;

Line: 1143


  END delete_row;

Line: 1248


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


    l_contractltmpl_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1299


    l_contractltmpl_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1302


    l_contractltmpl_rec.LAST_UPDATE_LOGIN := p_last_update_login;