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

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

Line: 5


      SELECT CS_CONTRACT_STATUSES_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_contractstats_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_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_contractstats_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


    p_to.update_allowed := p_from.update_allowed;

Line: 99


    p_to.delete_allowed := p_from.delete_allowed;

Line: 100


    p_to.last_update_date := p_from.last_update_date;

Line: 101


    p_to.last_updated_by := p_from.last_updated_by;

Line: 104


    p_to.last_update_login := p_from.last_update_login;

Line: 136


    p_to.update_allowed := p_from.update_allowed;

Line: 139


    p_to.delete_allowed := p_from.delete_allowed;

Line: 140


    p_to.last_update_date := p_from.last_update_date;

Line: 141


    p_to.last_updated_by := p_from.last_updated_by;

Line: 144


    p_to.last_update_login := p_from.last_update_login;

Line: 165


  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_contractstats_rec            IN ContractStats_Rec_Type := G_MISS_CONTRACTSTATS_REC,
    x_contract_status_id           OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 231


    INSERT INTO CS_CONTRACT_STATUSES(
        contract_status_id,
        name,
        description,
        validate_contract,
        status_level,
        eligible_for_invoicing,
        update_allowed,
        eligible_for_entitlements,
        terminated_flag,
        delete_allowed,
        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_contractstats_rec.contract_status_id,
        l_def_contractstats_rec.name,
        l_def_contractstats_rec.description,
        l_def_contractstats_rec.validate_contract,
        l_def_contractstats_rec.status_level,
        l_def_contractstats_rec.eligible_for_invoicing,
        l_def_contractstats_rec.update_allowed,
        l_def_contractstats_rec.eligible_for_entitlements,
        l_def_contractstats_rec.terminated_flag,
        l_def_contractstats_rec.delete_allowed,
        l_def_contractstats_rec.last_update_date,
        l_def_contractstats_rec.last_updated_by,
        l_def_contractstats_rec.creation_date,
        l_def_contractstats_rec.created_by,
        l_def_contractstats_rec.last_update_login,
        l_def_contractstats_rec.start_date_active,
        l_def_contractstats_rec.end_date_active,
        l_def_contractstats_rec.attribute1,
        l_def_contractstats_rec.attribute2,
        l_def_contractstats_rec.attribute3,
        l_def_contractstats_rec.attribute4,
        l_def_contractstats_rec.attribute5,
        l_def_contractstats_rec.attribute6,
        l_def_contractstats_rec.attribute7,
        l_def_contractstats_rec.attribute8,
        l_def_contractstats_rec.attribute9,
        l_def_contractstats_rec.attribute10,
        l_def_contractstats_rec.attribute11,
        l_def_contractstats_rec.attribute12,
        l_def_contractstats_rec.attribute13,
        l_def_contractstats_rec.attribute14,
        l_def_contractstats_rec.attribute15,
        l_def_contractstats_rec.context,
        l_def_contractstats_rec.object_version_number);

Line: 339


  END insert_row;

Line: 340


  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_STATUSES.NAME%TYPE := NULL,
    p_description                  IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
    p_validate_contract            IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
    p_status_level                 IN NUMBER := NULL,
    p_eligible_for_invoicing       IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
    p_update_allowed               IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
    p_eligible_for_entitlements    IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
    p_terminated_flag              IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
    p_delete_allowed               IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
    p_last_update_date             IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_start_date_active            IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
    p_end_date_active              IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
    p_attribute1                   IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_contract_status_id           OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 406


    l_contractstats_rec.UPDATE_ALLOWED := p_update_allowed;

Line: 409


    l_contractstats_rec.DELETE_ALLOWED := p_delete_allowed;

Line: 410


    l_contractstats_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 411


    l_contractstats_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 414


    l_contractstats_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 434


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contractstats_rec,
      x_contract_status_id,
      x_object_version_number
    );

Line: 481


  END insert_row;

Line: 496


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_STATUSES
    WHERE
      CONTRACT_STATUS_ID = p_contract_status_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 504


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_STATUSES
    WHERE
      CONTRACT_STATUS_ID = p_contract_status_id
      ;

Line: 550


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 559


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 598


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

Line: 619


      SELECT *
        FROM Cs_Contract_Statuses
       WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;

Line: 659


      IF (x_contractstats_rec.update_allowed = TAPI_DEV_KIT.G_MISS_CHAR)
      THEN
        x_contractstats_rec.update_allowed := l_cs_contracts_statuses_pk.update_allowed;

Line: 671


      IF (x_contractstats_rec.delete_allowed = TAPI_DEV_KIT.G_MISS_CHAR)
      THEN
        x_contractstats_rec.delete_allowed := l_cs_contracts_statuses_pk.delete_allowed;

Line: 675


      IF (x_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_contractstats_rec.last_update_date := l_cs_contracts_statuses_pk.last_update_date;

Line: 679


      IF (x_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contractstats_rec.last_updated_by := l_cs_contracts_statuses_pk.last_updated_by;

Line: 691


      IF (x_contractstats_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contractstats_rec.last_update_login := l_cs_contracts_statuses_pk.last_update_login;

Line: 826


    UPDATE  CS_CONTRACT_STATUSES
    SET
        CONTRACT_STATUS_ID = l_def_contractstats_rec.contract_status_id ,
        NAME = l_def_contractstats_rec.name ,
        DESCRIPTION = l_def_contractstats_rec.description ,
        VALIDATE_CONTRACT = l_def_contractstats_rec.validate_contract ,
        STATUS_LEVEL = l_def_contractstats_rec.status_level ,
        ELIGIBLE_FOR_INVOICING = l_def_contractstats_rec.eligible_for_invoicing ,
        UPDATE_ALLOWED = l_def_contractstats_rec.update_allowed ,
        ELIGIBLE_FOR_ENTITLEMENTS = l_def_contractstats_rec.eligible_for_entitlements ,
        TERMINATED_FLAG = l_def_contractstats_rec.terminated_flag ,
        DELETE_ALLOWED = l_def_contractstats_rec.delete_allowed ,
        LAST_UPDATE_DATE = l_def_contractstats_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_contractstats_rec.last_updated_by ,
        CREATION_DATE = l_def_contractstats_rec.creation_date ,
        CREATED_BY = l_def_contractstats_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_contractstats_rec.last_update_login ,
        START_DATE_ACTIVE = l_def_contractstats_rec.start_date_active ,
        END_DATE_ACTIVE = l_def_contractstats_rec.end_date_active ,
        ATTRIBUTE1 = l_def_contractstats_rec.attribute1 ,
        ATTRIBUTE2 = l_def_contractstats_rec.attribute2 ,
        ATTRIBUTE3 = l_def_contractstats_rec.attribute3 ,
        ATTRIBUTE4 = l_def_contractstats_rec.attribute4 ,
        ATTRIBUTE5 = l_def_contractstats_rec.attribute5 ,
        ATTRIBUTE6 = l_def_contractstats_rec.attribute6 ,
        ATTRIBUTE7 = l_def_contractstats_rec.attribute7 ,
        ATTRIBUTE8 = l_def_contractstats_rec.attribute8 ,
        ATTRIBUTE9 = l_def_contractstats_rec.attribute9 ,
        ATTRIBUTE10 = l_def_contractstats_rec.attribute10 ,
        ATTRIBUTE11 = l_def_contractstats_rec.attribute11 ,
        ATTRIBUTE12 = l_def_contractstats_rec.attribute12 ,
        ATTRIBUTE13 = l_def_contractstats_rec.attribute13 ,
        ATTRIBUTE14 = l_def_contractstats_rec.attribute14 ,
        ATTRIBUTE15 = l_def_contractstats_rec.attribute15 ,
        CONTEXT = l_def_contractstats_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_contractstats_rec.object_version_number
        WHERE
          CONTRACT_STATUS_ID = l_def_contractstats_rec.contract_status_id
          ;

Line: 901


  END update_row;

Line: 902


  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_status_id           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_name                         IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_description                  IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_validate_contract            IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_status_level                 IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_eligible_for_invoicing       IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_update_allowed               IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_eligible_for_entitlements    IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_terminated_flag              IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_delete_allowed               IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_date             IN CS_CONTRACT_STATUSES.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_STATUSES.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_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_attribute1                   IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_STATUSES.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: 969


    l_contractstats_rec.UPDATE_ALLOWED := p_update_allowed;

Line: 972


    l_contractstats_rec.DELETE_ALLOWED := p_delete_allowed;

Line: 973


    l_contractstats_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 974


    l_contractstats_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 977


    l_contractstats_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 997


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

Line: 1043


  END update_row;

Line: 1044


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

Line: 1070


    DELETE  FROM CS_CONTRACT_STATUSES
    WHERE
      CONTRACT_STATUS_ID = p_contract_status_id
      ;

Line: 1109


  END delete_row;

Line: 1211


    p_update_allowed               IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_eligible_for_entitlements    IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_terminated_flag              IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_delete_allowed               IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_date             IN CS_CONTRACT_STATUSES.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_STATUSES.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_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_attribute1                   IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_STATUSES.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: 1262


    l_contractstats_rec.UPDATE_ALLOWED := p_update_allowed;

Line: 1265


    l_contractstats_rec.DELETE_ALLOWED := p_delete_allowed;

Line: 1266


    l_contractstats_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1267


    l_contractstats_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1270


    l_contractstats_rec.LAST_UPDATE_LOGIN := p_last_update_login;