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

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

Line: 5


      SELECT CS_COVERED_PRODUCTS_S.nextval FROM SYS.DUAL;

Line: 39


    ELSIF p_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_coveredprd_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: 44


    ELSIF p_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_coveredprd_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: 91


      SELECT *
        FROM Cs_Contract_Cov_Levels
       WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;

Line: 96


      SELECT *
        FROM Cs_Customer_Products_All
       WHERE cs_customer_products_all.customer_product_id = p_customer_product_id;

Line: 147


    p_to.last_update_date := p_from.last_update_date;

Line: 148


    p_to.last_updated_by := p_from.last_updated_by;

Line: 151


    p_to.last_update_login := p_from.last_update_login;

Line: 180


    p_to.last_update_date := p_from.last_update_date;

Line: 181


    p_to.last_updated_by := p_from.last_updated_by;

Line: 184


    p_to.last_update_login := p_from.last_update_login;

Line: 203


  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_coveredprd_rec               IN CoveredPrd_Rec_Type := G_MISS_COVEREDPRD_REC,
    x_covered_product_id           OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 269


    INSERT INTO CS_COVERED_PRODUCTS(
        customer_product_id,
        covered_product_id,
        contract_amount,
        list_price,
        coverage_level_id,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        object_version_number)
      VALUES (
        l_def_coveredprd_rec.customer_product_id,
        l_def_coveredprd_rec.covered_product_id,
        l_def_coveredprd_rec.contract_amount,
        l_def_coveredprd_rec.list_price,
        l_def_coveredprd_rec.coverage_level_id,
        l_def_coveredprd_rec.last_update_date,
        l_def_coveredprd_rec.last_updated_by,
        l_def_coveredprd_rec.creation_date,
        l_def_coveredprd_rec.created_by,
        l_def_coveredprd_rec.last_update_login,
        l_def_coveredprd_rec.attribute1,
        l_def_coveredprd_rec.attribute2,
        l_def_coveredprd_rec.attribute3,
        l_def_coveredprd_rec.attribute4,
        l_def_coveredprd_rec.attribute5,
        l_def_coveredprd_rec.attribute6,
        l_def_coveredprd_rec.attribute7,
        l_def_coveredprd_rec.attribute8,
        l_def_coveredprd_rec.attribute9,
        l_def_coveredprd_rec.attribute10,
        l_def_coveredprd_rec.attribute11,
        l_def_coveredprd_rec.attribute12,
        l_def_coveredprd_rec.attribute13,
        l_def_coveredprd_rec.attribute14,
        l_def_coveredprd_rec.attribute15,
        l_def_coveredprd_rec.context,
        l_def_coveredprd_rec.object_version_number);

Line: 363


  END insert_row;

Line: 364


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

Line: 422


    l_coveredprd_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 423


    l_coveredprd_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 426


    l_coveredprd_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 444


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_coveredprd_rec,
      x_covered_product_id,
      x_object_version_number
    );

Line: 491


  END insert_row;

Line: 506


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COVERED_PRODUCTS
    WHERE
      COVERED_PRODUCT_ID = p_covered_product_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 514


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COVERED_PRODUCTS
    WHERE
      COVERED_PRODUCT_ID = p_covered_product_id
      ;

Line: 560


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 569


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 608


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

Line: 629


      SELECT *
        FROM Cs_Covered_Products
       WHERE cs_covered_products.covered_product_id = p_covered_product_id;

Line: 665


      IF (x_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;

Line: 669


      IF (x_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;

Line: 681


      IF (x_coveredprd_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;

Line: 808


    UPDATE  CS_COVERED_PRODUCTS
    SET
        CUSTOMER_PRODUCT_ID = l_def_coveredprd_rec.customer_product_id ,
        COVERED_PRODUCT_ID = l_def_coveredprd_rec.covered_product_id ,
        CONTRACT_AMOUNT = l_def_coveredprd_rec.contract_amount ,
        LIST_PRICE = l_def_coveredprd_rec.list_price ,
        COVERAGE_LEVEL_ID = l_def_coveredprd_rec.coverage_level_id ,
        LAST_UPDATE_DATE = l_def_coveredprd_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_coveredprd_rec.last_updated_by ,
        CREATION_DATE = l_def_coveredprd_rec.creation_date ,
        CREATED_BY = l_def_coveredprd_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_coveredprd_rec.last_update_login ,
        ATTRIBUTE1 = l_def_coveredprd_rec.attribute1 ,
        ATTRIBUTE2 = l_def_coveredprd_rec.attribute2 ,
        ATTRIBUTE3 = l_def_coveredprd_rec.attribute3 ,
        ATTRIBUTE4 = l_def_coveredprd_rec.attribute4 ,
        ATTRIBUTE5 = l_def_coveredprd_rec.attribute5 ,
        ATTRIBUTE6 = l_def_coveredprd_rec.attribute6 ,
        ATTRIBUTE7 = l_def_coveredprd_rec.attribute7 ,
        ATTRIBUTE8 = l_def_coveredprd_rec.attribute8 ,
        ATTRIBUTE9 = l_def_coveredprd_rec.attribute9 ,
        ATTRIBUTE10 = l_def_coveredprd_rec.attribute10 ,
        ATTRIBUTE11 = l_def_coveredprd_rec.attribute11 ,
        ATTRIBUTE12 = l_def_coveredprd_rec.attribute12 ,
        ATTRIBUTE13 = l_def_coveredprd_rec.attribute13 ,
        ATTRIBUTE14 = l_def_coveredprd_rec.attribute14 ,
        ATTRIBUTE15 = l_def_coveredprd_rec.attribute15 ,
        CONTEXT = l_def_coveredprd_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_coveredprd_rec.object_version_number
        WHERE
          COVERED_PRODUCT_ID = l_def_coveredprd_rec.covered_product_id
          ;

Line: 876


  END update_row;

Line: 877


  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_customer_product_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_covered_product_id           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_contract_amount              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_list_price                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_coverage_level_id            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_COVERED_PRODUCTS.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_COVERED_PRODUCTS.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_attribute1                   IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COVERED_PRODUCTS.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: 936


    l_coveredprd_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 937


    l_coveredprd_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 940


    l_coveredprd_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 958


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

Line: 1004


  END update_row;

Line: 1005


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

Line: 1031


    DELETE  FROM CS_COVERED_PRODUCTS
    WHERE
      COVERED_PRODUCT_ID = p_covered_product_id
      ;

Line: 1070


  END delete_row;

Line: 1171


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


    l_coveredprd_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1216


    l_coveredprd_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1219


    l_coveredprd_rec.LAST_UPDATE_LOGIN := p_last_update_login;