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

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

Line: 5


      SELECT CS_CONTRACT_COV_LEVELS_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_coveragelevel_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_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_coveragelevel_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_Cp_Services_All
       WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;

Line: 129


    p_to.last_update_date := p_from.last_update_date;

Line: 130


    p_to.last_updated_by := p_from.last_updated_by;

Line: 133


    p_to.last_update_login := p_from.last_update_login;

Line: 161


    p_to.last_update_date := p_from.last_update_date;

Line: 162


    p_to.last_updated_by := p_from.last_updated_by;

Line: 165


    p_to.last_update_login := p_from.last_update_login;

Line: 185


  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_coveragelevel_rec            IN CoverageLevel_Rec_Type := G_MISS_COVERAGELEVEL_REC,
    x_coverage_level_id            OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 251


    INSERT INTO CS_CONTRACT_COV_LEVELS(
        coverage_level_id,
        coverage_level_code,
        coverage_level_value,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        cp_service_id,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        object_version_number)
      VALUES (
        l_def_coveragelevel_rec.coverage_level_id,
        l_def_coveragelevel_rec.coverage_level_code,
        l_def_coveragelevel_rec.coverage_level_value,
        l_def_coveragelevel_rec.last_update_date,
        l_def_coveragelevel_rec.last_updated_by,
        l_def_coveragelevel_rec.creation_date,
        l_def_coveragelevel_rec.created_by,
        l_def_coveragelevel_rec.last_update_login,
        l_def_coveragelevel_rec.cp_service_id,
        l_def_coveragelevel_rec.attribute1,
        l_def_coveragelevel_rec.attribute2,
        l_def_coveragelevel_rec.attribute3,
        l_def_coveragelevel_rec.attribute4,
        l_def_coveragelevel_rec.attribute5,
        l_def_coveragelevel_rec.attribute6,
        l_def_coveragelevel_rec.attribute7,
        l_def_coveragelevel_rec.attribute8,
        l_def_coveragelevel_rec.attribute9,
        l_def_coveragelevel_rec.attribute10,
        l_def_coveragelevel_rec.attribute11,
        l_def_coveragelevel_rec.attribute12,
        l_def_coveragelevel_rec.attribute13,
        l_def_coveragelevel_rec.attribute14,
        l_def_coveragelevel_rec.attribute15,
        l_def_coveragelevel_rec.context,
        l_def_coveragelevel_rec.object_version_number);

Line: 343


  END insert_row;

Line: 344


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

Line: 399


    l_coveragelevel_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 400


    l_coveragelevel_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 403


    l_coveragelevel_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 422


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_coveragelevel_rec,
      x_coverage_level_id,
      x_object_version_number
    );

Line: 469


  END insert_row;

Line: 484


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_COV_LEVELS
    WHERE
      COVERAGE_LEVEL_ID = p_coverage_level_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 492


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_CONTRACT_COV_LEVELS
    WHERE
      COVERAGE_LEVEL_ID = p_coverage_level_id
      ;

Line: 538


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 547


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 586


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

Line: 607


      SELECT *
        FROM Cs_Contract_Cov_Levels
       WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;

Line: 635


      IF (x_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_coveragelevel_rec.last_update_date := l_cs_contract_coverage1.last_update_date;

Line: 639


      IF (x_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_coveragelevel_rec.last_updated_by := l_cs_contract_coverage1.last_updated_by;

Line: 651


      IF (x_coveragelevel_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_coveragelevel_rec.last_update_login := l_cs_contract_coverage1.last_update_login;

Line: 782


    UPDATE  CS_CONTRACT_COV_LEVELS
    SET
        COVERAGE_LEVEL_ID = l_def_coveragelevel_rec.coverage_level_id ,
        COVERAGE_LEVEL_CODE = l_def_coveragelevel_rec.coverage_level_code ,
        COVERAGE_LEVEL_VALUE = l_def_coveragelevel_rec.coverage_level_value ,
        LAST_UPDATE_DATE = l_def_coveragelevel_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_coveragelevel_rec.last_updated_by ,
        CREATION_DATE = l_def_coveragelevel_rec.creation_date ,
        CREATED_BY = l_def_coveragelevel_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_coveragelevel_rec.last_update_login ,
        CP_SERVICE_ID = l_def_coveragelevel_rec.cp_service_id ,
        ATTRIBUTE1 = l_def_coveragelevel_rec.attribute1 ,
        ATTRIBUTE2 = l_def_coveragelevel_rec.attribute2 ,
        ATTRIBUTE3 = l_def_coveragelevel_rec.attribute3 ,
        ATTRIBUTE4 = l_def_coveragelevel_rec.attribute4 ,
        ATTRIBUTE5 = l_def_coveragelevel_rec.attribute5 ,
        ATTRIBUTE6 = l_def_coveragelevel_rec.attribute6 ,
        ATTRIBUTE7 = l_def_coveragelevel_rec.attribute7 ,
        ATTRIBUTE8 = l_def_coveragelevel_rec.attribute8 ,
        ATTRIBUTE9 = l_def_coveragelevel_rec.attribute9 ,
        ATTRIBUTE10 = l_def_coveragelevel_rec.attribute10 ,
        ATTRIBUTE11 = l_def_coveragelevel_rec.attribute11 ,
        ATTRIBUTE12 = l_def_coveragelevel_rec.attribute12 ,
        ATTRIBUTE13 = l_def_coveragelevel_rec.attribute13 ,
        ATTRIBUTE14 = l_def_coveragelevel_rec.attribute14 ,
        ATTRIBUTE15 = l_def_coveragelevel_rec.attribute15 ,
        CONTEXT = l_def_coveragelevel_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_coveragelevel_rec.object_version_number
        WHERE
          COVERAGE_LEVEL_ID = l_def_coveragelevel_rec.coverage_level_id
          ;

Line: 849


  END update_row;

Line: 850


  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_coverage_level_id            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_coverage_level_code          IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_coverage_level_value         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_date             IN CS_CONTRACT_COV_LEVELS.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_COV_LEVELS.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_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute1                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_CONTRACT_COV_LEVELS.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: 906


    l_coveragelevel_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 907


    l_coveragelevel_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 910


    l_coveragelevel_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 929


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

Line: 975


  END update_row;

Line: 976


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

Line: 1002


    DELETE  FROM CS_CONTRACT_COV_LEVELS
    WHERE
      COVERAGE_LEVEL_ID = p_coverage_level_id
      ;

Line: 1041


  END delete_row;

Line: 1140


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


    l_coveragelevel_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1184


    l_coveragelevel_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1187


    l_coveragelevel_rec.LAST_UPDATE_LOGIN := p_last_update_login;