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

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

Line: 5


      SELECT CS_CONTRACT_TYPES_S.nextval FROM SYS.DUAL;

Line: 29


    ELSIF p_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_contracttype_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: 34


    ELSIF p_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_contracttype_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: 81


      SELECT *
        FROM Ra_Cust_Trx_Types
       WHERE ra_cust_trx_types.cust_trx_type_id = p_cust_trx_type_id;

Line: 120


    p_to.last_update_date := p_from.last_update_date;

Line: 121


    p_to.last_updated_by := p_from.last_updated_by;

Line: 124


    p_to.last_update_login := p_from.last_update_login;

Line: 154


    p_to.last_update_date := p_from.last_update_date;

Line: 155


    p_to.last_updated_by := p_from.last_updated_by;

Line: 158


    p_to.last_update_login := p_from.last_update_login;

Line: 179


  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_contracttype_rec             IN ContractType_Rec_Type := G_MISS_CONTRACTTYPE_REC,
    x_contract_type_id             OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 245


    INSERT INTO CS_CONTRACT_TYPES(
        contract_type_id,
        name,
        description,
        cust_trx_type_id,
        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_contracttype_rec.contract_type_id,
        l_def_contracttype_rec.name,
        l_def_contracttype_rec.description,
        l_def_contracttype_rec.cust_trx_type_id,
        l_def_contracttype_rec.last_update_date,
        l_def_contracttype_rec.last_updated_by,
        l_def_contracttype_rec.creation_date,
        l_def_contracttype_rec.created_by,
        l_def_contracttype_rec.last_update_login,
        l_def_contracttype_rec.start_date_active,
        l_def_contracttype_rec.end_date_active,
        l_def_contracttype_rec.attribute1,
        l_def_contracttype_rec.attribute2,
        l_def_contracttype_rec.attribute3,
        l_def_contracttype_rec.attribute4,
        l_def_contracttype_rec.attribute5,
        l_def_contracttype_rec.attribute6,
        l_def_contracttype_rec.attribute7,
        l_def_contracttype_rec.attribute8,
        l_def_contracttype_rec.attribute9,
        l_def_contracttype_rec.attribute10,
        l_def_contracttype_rec.attribute11,
        l_def_contracttype_rec.attribute12,
        l_def_contracttype_rec.attribute13,
        l_def_contracttype_rec.attribute14,
        l_def_contracttype_rec.attribute15,
        l_def_contracttype_rec.context,
        l_def_contracttype_rec.object_version_number);

Line: 341


  END insert_row;

Line: 342


  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_TYPES.NAME%TYPE := NULL,
    p_description                  IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := NULL,
    p_cust_trx_type_id             IN NUMBER := NULL,
    p_last_update_date             IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_start_date_active            IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
    p_end_date_active              IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
    p_attribute1                   IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_contract_type_id             OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 400


    l_contracttype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 401


    l_contracttype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 404


    l_contracttype_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 424


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_contracttype_rec,
      x_contract_type_id,
      x_object_version_number
    );

Line: 471


  END insert_row;

Line: 486


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_TYPES
    WHERE
      CONTRACT_TYPE_ID = p_contract_type_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 494


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_TYPES
    WHERE
      CONTRACT_TYPE_ID = p_contract_type_id
      ;

Line: 540


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 549


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 588


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

Line: 609


      SELECT *
        FROM Cs_Contract_Types
       WHERE cs_contract_types.contract_type_id = p_contract_type_id;

Line: 641


      IF (x_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;

Line: 645


      IF (x_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;

Line: 657


      IF (x_contracttype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;

Line: 792


    UPDATE  CS_CONTRACT_TYPES
    SET
        CONTRACT_TYPE_ID = l_def_contracttype_rec.contract_type_id ,
        NAME = l_def_contracttype_rec.name ,
        DESCRIPTION = l_def_contracttype_rec.description ,
        CUST_TRX_TYPE_ID = l_def_contracttype_rec.cust_trx_type_id ,
        LAST_UPDATE_DATE = l_def_contracttype_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_contracttype_rec.last_updated_by ,
        CREATION_DATE = l_def_contracttype_rec.creation_date ,
        CREATED_BY = l_def_contracttype_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_contracttype_rec.last_update_login ,
        START_DATE_ACTIVE = l_def_contracttype_rec.start_date_active ,
        END_DATE_ACTIVE = l_def_contracttype_rec.end_date_active ,
        ATTRIBUTE1 = l_def_contracttype_rec.attribute1 ,
        ATTRIBUTE2 = l_def_contracttype_rec.attribute2 ,
        ATTRIBUTE3 = l_def_contracttype_rec.attribute3 ,
        ATTRIBUTE4 = l_def_contracttype_rec.attribute4 ,
        ATTRIBUTE5 = l_def_contracttype_rec.attribute5 ,
        ATTRIBUTE6 = l_def_contracttype_rec.attribute6 ,
        ATTRIBUTE7 = l_def_contracttype_rec.attribute7 ,
        ATTRIBUTE8 = l_def_contracttype_rec.attribute8 ,
        ATTRIBUTE9 = l_def_contracttype_rec.attribute9 ,
        ATTRIBUTE10 = l_def_contracttype_rec.attribute10 ,
        ATTRIBUTE11 = l_def_contracttype_rec.attribute11 ,
        ATTRIBUTE12 = l_def_contracttype_rec.attribute12 ,
        ATTRIBUTE13 = l_def_contracttype_rec.attribute13 ,
        ATTRIBUTE14 = l_def_contracttype_rec.attribute14 ,
        ATTRIBUTE15 = l_def_contracttype_rec.attribute15 ,
        CONTEXT = l_def_contracttype_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_contracttype_rec.object_version_number
        WHERE
          CONTRACT_TYPE_ID = l_def_contracttype_rec.contract_type_id
          ;

Line: 861


  END update_row;

Line: 862


  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_type_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_name                         IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_description                  IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_cust_trx_type_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_CONTRACT_TYPES.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_TYPES.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_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_attribute1                   IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_TYPES.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: 921


    l_contracttype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 922


    l_contracttype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 925


    l_contracttype_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 945


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

Line: 991


  END update_row;

Line: 992


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

Line: 1018


    DELETE  FROM CS_CONTRACT_TYPES
    WHERE
      CONTRACT_TYPE_ID = p_contract_type_id
      ;

Line: 1057


  END delete_row;

Line: 1157


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


    l_contracttype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1203


    l_contracttype_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1206


    l_contracttype_rec.LAST_UPDATE_LOGIN := p_last_update_login;