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

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

Line: 5


      SELECT CS_CONTRACT_TEMPLATES_S.nextval FROM SYS.DUAL;

Line: 59


    ELSIF p_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_contracttmpl_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: 64


    ELSIF p_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_contracttmpl_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: 121


      SELECT *
        FROM Cs_Contract_Types
       WHERE cs_contract_types.contract_type_id = p_contract_type_id;

Line: 179


    p_to.last_update_date := p_from.last_update_date;

Line: 180


    p_to.last_updated_by := p_from.last_updated_by;

Line: 184


    p_to.last_update_login := p_from.last_update_login;

Line: 233


    p_to.last_update_date := p_from.last_update_date;

Line: 234


    p_to.last_updated_by := p_from.last_updated_by;

Line: 238


    p_to.last_update_login := p_from.last_update_login;

Line: 259


  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_contracttmpl_rec             IN ContractTmpl_Rec_Type := G_MISS_CONTRACTTMPL_REC,
    x_contract_template_id         OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 325


    INSERT INTO CS_CONTRACT_TEMPLATES(
        contract_template_id,
        name,
        contract_type_id,
        duration,
        period_code,
        workflow,
        price_list_id,
        currency_code,
        conversion_type_code,
        conversion_rate,
        conversion_date,
        invoicing_rule_id,
        accounting_rule_id,
        billing_frequency_period,
        create_sales_order,
        renewal_rule,
        termination_rule,
        terms_id,
        tax_handling,
        tax_exempt_num,
        tax_exempt_reason_code,
        contract_amount,
        discount_id,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        auto_renewal_flag,
        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_contracttmpl_rec.contract_template_id,
        l_def_contracttmpl_rec.name,
        l_def_contracttmpl_rec.contract_type_id,
        l_def_contracttmpl_rec.duration,
        l_def_contracttmpl_rec.period_code,
        l_def_contracttmpl_rec.workflow,
        l_def_contracttmpl_rec.price_list_id,
        l_def_contracttmpl_rec.currency_code,
        l_def_contracttmpl_rec.conversion_type_code,
        l_def_contracttmpl_rec.conversion_rate,
        l_def_contracttmpl_rec.conversion_date,
        l_def_contracttmpl_rec.invoicing_rule_id,
        l_def_contracttmpl_rec.accounting_rule_id,
        l_def_contracttmpl_rec.billing_frequency_period,
        l_def_contracttmpl_rec.create_sales_order,
        l_def_contracttmpl_rec.renewal_rule,
        l_def_contracttmpl_rec.termination_rule,
        l_def_contracttmpl_rec.terms_id,
        l_def_contracttmpl_rec.tax_handling,
        l_def_contracttmpl_rec.tax_exempt_num,
        l_def_contracttmpl_rec.tax_exempt_reason_code,
        l_def_contracttmpl_rec.contract_amount,
        l_def_contracttmpl_rec.discount_id,
        l_def_contracttmpl_rec.last_update_date,
        l_def_contracttmpl_rec.last_updated_by,
        l_def_contracttmpl_rec.creation_date,
        l_def_contracttmpl_rec.created_by,
        l_def_contracttmpl_rec.auto_renewal_flag,
        l_def_contracttmpl_rec.last_update_login,
        l_def_contracttmpl_rec.start_date_active,
        l_def_contracttmpl_rec.end_date_active,
        l_def_contracttmpl_rec.attribute1,
        l_def_contracttmpl_rec.attribute2,
        l_def_contracttmpl_rec.attribute3,
        l_def_contracttmpl_rec.attribute4,
        l_def_contracttmpl_rec.attribute5,
        l_def_contracttmpl_rec.attribute6,
        l_def_contracttmpl_rec.attribute7,
        l_def_contracttmpl_rec.attribute8,
        l_def_contracttmpl_rec.attribute9,
        l_def_contracttmpl_rec.attribute10,
        l_def_contracttmpl_rec.attribute11,
        l_def_contracttmpl_rec.attribute12,
        l_def_contracttmpl_rec.attribute13,
        l_def_contracttmpl_rec.attribute14,
        l_def_contracttmpl_rec.attribute15,
        l_def_contracttmpl_rec.context,
        l_def_contracttmpl_rec.object_version_number);

Line: 461


  END insert_row;

Line: 462


  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_name                         IN CS_CONTRACT_TEMPLATES.NAME%TYPE := NULL,
    p_contract_type_id             IN NUMBER := NULL,
    p_duration                     IN NUMBER := NULL,
    p_period_code                  IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := NULL,
    p_workflow                     IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := NULL,
    p_price_list_id                IN NUMBER := NULL,
    p_currency_code                IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := NULL,
    p_conversion_type_code         IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := NULL,
    p_conversion_rate              IN NUMBER := NULL,
    p_conversion_date              IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := NULL,
    p_invoicing_rule_id            IN NUMBER := NULL,
    p_accounting_rule_id           IN NUMBER := NULL,
    p_billing_frequency_period     IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
    p_create_sales_order           IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := NULL,
    p_renewal_rule                 IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := NULL,
    p_termination_rule             IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := NULL,
    p_terms_id                     IN NUMBER := NULL,
    p_tax_handling                 IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := NULL,
    p_tax_exempt_num               IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := NULL,
    p_tax_exempt_reason_code       IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := NULL,
    p_contract_amount              IN NUMBER := NULL,
    p_discount_id                  IN NUMBER := NULL,
    p_last_update_date             IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_auto_renewal_flag            IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_start_date_active            IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := NULL,
    p_end_date_active              IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := NULL,
    p_attribute1                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_contract_template_id         OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 559


    l_contracttmpl_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 560


    l_contracttmpl_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 564


    l_contracttmpl_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 584


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contracttmpl_rec,
      x_contract_template_id,
      x_object_version_number
    );

Line: 631


  END insert_row;

Line: 646


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_TEMPLATES
    WHERE
      CONTRACT_TEMPLATE_ID = p_contract_template_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 654


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_TEMPLATES
    WHERE
      CONTRACT_TEMPLATE_ID = p_contract_template_id
      ;

Line: 700


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 709


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 748


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

Line: 769


      SELECT *
        FROM Cs_Contract_Templates
       WHERE cs_contract_templates.contract_template_id = p_contract_template_id;

Line: 877


      IF (x_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_contracttmpl_rec.last_update_date := l_cs_contract_templates_pk.last_update_date;

Line: 881


      IF (x_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contracttmpl_rec.last_updated_by := l_cs_contract_templates_pk.last_updated_by;

Line: 897


      IF (x_contracttmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contracttmpl_rec.last_update_login := l_cs_contract_templates_pk.last_update_login;

Line: 1032


    UPDATE  CS_CONTRACT_TEMPLATES
    SET
        CONTRACT_TEMPLATE_ID = l_def_contracttmpl_rec.contract_template_id ,
        NAME = l_def_contracttmpl_rec.name ,
        CONTRACT_TYPE_ID = l_def_contracttmpl_rec.contract_type_id ,
        DURATION = l_def_contracttmpl_rec.duration ,
        PERIOD_CODE = l_def_contracttmpl_rec.period_code ,
        WORKFLOW = l_def_contracttmpl_rec.workflow ,
        PRICE_LIST_ID = l_def_contracttmpl_rec.price_list_id ,
        CURRENCY_CODE = l_def_contracttmpl_rec.currency_code ,
        CONVERSION_TYPE_CODE = l_def_contracttmpl_rec.conversion_type_code ,
        CONVERSION_RATE = l_def_contracttmpl_rec.conversion_rate ,
        CONVERSION_DATE = l_def_contracttmpl_rec.conversion_date ,
        INVOICING_RULE_ID = l_def_contracttmpl_rec.invoicing_rule_id ,
        ACCOUNTING_RULE_ID = l_def_contracttmpl_rec.accounting_rule_id ,
        BILLING_FREQUENCY_PERIOD = l_def_contracttmpl_rec.billing_frequency_period ,
        CREATE_SALES_ORDER = l_def_contracttmpl_rec.create_sales_order ,
        RENEWAL_RULE = l_def_contracttmpl_rec.renewal_rule ,
        TERMINATION_RULE = l_def_contracttmpl_rec.termination_rule ,
        TERMS_ID = l_def_contracttmpl_rec.terms_id ,
        TAX_HANDLING = l_def_contracttmpl_rec.tax_handling ,
        TAX_EXEMPT_NUM = l_def_contracttmpl_rec.tax_exempt_num ,
        TAX_EXEMPT_REASON_CODE = l_def_contracttmpl_rec.tax_exempt_reason_code ,
        CONTRACT_AMOUNT = l_def_contracttmpl_rec.contract_amount ,
        DISCOUNT_ID = l_def_contracttmpl_rec.discount_id ,
        LAST_UPDATE_DATE = l_def_contracttmpl_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_contracttmpl_rec.last_updated_by ,
        CREATION_DATE = l_def_contracttmpl_rec.creation_date ,
        CREATED_BY = l_def_contracttmpl_rec.created_by ,
        AUTO_RENEWAL_FLAG = l_def_contracttmpl_rec.auto_renewal_flag ,
        LAST_UPDATE_LOGIN = l_def_contracttmpl_rec.last_update_login ,
        START_DATE_ACTIVE = l_def_contracttmpl_rec.start_date_active ,
        END_DATE_ACTIVE = l_def_contracttmpl_rec.end_date_active ,
        ATTRIBUTE1 = l_def_contracttmpl_rec.attribute1 ,
        ATTRIBUTE2 = l_def_contracttmpl_rec.attribute2 ,
        ATTRIBUTE3 = l_def_contracttmpl_rec.attribute3 ,
        ATTRIBUTE4 = l_def_contracttmpl_rec.attribute4 ,
        ATTRIBUTE5 = l_def_contracttmpl_rec.attribute5 ,
        ATTRIBUTE6 = l_def_contracttmpl_rec.attribute6 ,
        ATTRIBUTE7 = l_def_contracttmpl_rec.attribute7 ,
        ATTRIBUTE8 = l_def_contracttmpl_rec.attribute8 ,
        ATTRIBUTE9 = l_def_contracttmpl_rec.attribute9 ,
        ATTRIBUTE10 = l_def_contracttmpl_rec.attribute10 ,
        ATTRIBUTE11 = l_def_contracttmpl_rec.attribute11 ,
        ATTRIBUTE12 = l_def_contracttmpl_rec.attribute12 ,
        ATTRIBUTE13 = l_def_contracttmpl_rec.attribute13 ,
        ATTRIBUTE14 = l_def_contracttmpl_rec.attribute14 ,
        ATTRIBUTE15 = l_def_contracttmpl_rec.attribute15 ,
        CONTEXT = l_def_contracttmpl_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_contracttmpl_rec.object_version_number
        WHERE
          CONTRACT_TEMPLATE_ID = l_def_contracttmpl_rec.contract_template_id
          ;

Line: 1121


  END update_row;

Line: 1122


  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_template_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_name                         IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_contract_type_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_duration                     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_period_code                  IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_workflow                     IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_price_list_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_currency_code                IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_conversion_type_code         IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_conversion_rate              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_conversion_date              IN CS_CONTRACT_TEMPLATES.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_billing_frequency_period     IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_create_sales_order           IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_renewal_rule                 IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_termination_rule             IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_terms_id                     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_tax_handling                 IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_tax_exempt_num               IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_tax_exempt_reason_code       IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_contract_amount              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_discount_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_CONTRACT_TEMPLATES.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_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_auto_renewal_flag            IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_start_date_active            IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_attribute1                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_TEMPLATES.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: 1220


    l_contracttmpl_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1221


    l_contracttmpl_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1225


    l_contracttmpl_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 1245


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

Line: 1291


  END update_row;

Line: 1292


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

Line: 1318


    DELETE  FROM CS_CONTRACT_TEMPLATES
    WHERE
      CONTRACT_TEMPLATE_ID = p_contract_template_id
      ;

Line: 1357


  END delete_row;

Line: 1476


    p_last_update_date             IN CS_CONTRACT_TEMPLATES.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_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_auto_renewal_flag            IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_start_date_active            IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_attribute1                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_TEMPLATES.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: 1541


    l_contracttmpl_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1542


    l_contracttmpl_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1546


    l_contracttmpl_rec.LAST_UPDATE_LOGIN := p_last_update_login;