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

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

Line: 5


      SELECT CS_COVERAGES_S.nextval FROM SYS.DUAL;

Line: 44


    ELSIF p_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_coverage_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: 49


    ELSIF p_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_coverage_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: 86


      SELECT *
        FROM Cs_Coverages
       WHERE cs_coverages.coverage_id = p_coverage_id;

Line: 157


    p_to.last_update_date := p_from.last_update_date;

Line: 158


    p_to.last_updated_by := p_from.last_updated_by;

Line: 159


    p_to.last_update_login := p_from.last_update_login;

Line: 219


    p_to.last_update_date := p_from.last_update_date;

Line: 220


    p_to.last_updated_by := p_from.last_updated_by;

Line: 221


    p_to.last_update_login := p_from.last_update_login;

Line: 240


  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_rec                 IN Coverage_Rec_Type := G_MISS_COVERAGE_REC,
    x_coverage_id                  OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 306


    INSERT INTO CS_COVERAGES(
        coverage_id,
        coverage_template_id,
        name,
        description,
        template_flag,
        renewal_terms,
        termination_terms,
        max_support_coverage_amt,
        exception_coverage_id,
        time_billable_percent,
        max_time_billable_amount,
        material_billable_percent,
        max_material_billable_amount,
        expense_billable_percent,
        max_expense_billable_amount,
        max_coverage_amount,
        response_time_period_code,
        response_time_value,
        sunday_start_time,
        sunday_end_time,
        monday_start_time,
        monday_end_time,
        start_date_active,
        tuesday_start_time,
        tuesday_end_time,
        end_date_active,
        wednesday_start_time,
        wednesday_end_time,
        thursday_start_time,
        thursday_end_time,
        friday_start_time,
        friday_end_time,
        saturday_start_time,
        saturday_end_time,
        created_by,
        creation_date,
        last_update_date,
        last_updated_by,
        last_update_login,
        attribute3,
        attribute1,
        attribute2,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        context,
        object_version_number)
      VALUES (
        l_def_coverage_rec.coverage_id,
        l_def_coverage_rec.coverage_template_id,
        l_def_coverage_rec.name,
        l_def_coverage_rec.description,
        l_def_coverage_rec.template_flag,
        l_def_coverage_rec.renewal_terms,
        l_def_coverage_rec.termination_terms,
        l_def_coverage_rec.max_support_coverage_amt,
        l_def_coverage_rec.exception_coverage_id,
        l_def_coverage_rec.time_billable_percent,
        l_def_coverage_rec.max_time_billable_amount,
        l_def_coverage_rec.material_billable_percent,
        l_def_coverage_rec.max_material_billable_amount,
        l_def_coverage_rec.expense_billable_percent,
        l_def_coverage_rec.max_expense_billable_amount,
        l_def_coverage_rec.max_coverage_amount,
        l_def_coverage_rec.response_time_period_code,
        l_def_coverage_rec.response_time_value,
        l_def_coverage_rec.sunday_start_time,
        l_def_coverage_rec.sunday_end_time,
        l_def_coverage_rec.monday_start_time,
        l_def_coverage_rec.monday_end_time,
        l_def_coverage_rec.start_date_active,
        l_def_coverage_rec.tuesday_start_time,
        l_def_coverage_rec.tuesday_end_time,
        l_def_coverage_rec.end_date_active,
        l_def_coverage_rec.wednesday_start_time,
        l_def_coverage_rec.wednesday_end_time,
        l_def_coverage_rec.thursday_start_time,
        l_def_coverage_rec.thursday_end_time,
        l_def_coverage_rec.friday_start_time,
        l_def_coverage_rec.friday_end_time,
        l_def_coverage_rec.saturday_start_time,
        l_def_coverage_rec.saturday_end_time,
        l_def_coverage_rec.created_by,
        l_def_coverage_rec.creation_date,
        l_def_coverage_rec.last_update_date,
        l_def_coverage_rec.last_updated_by,
        l_def_coverage_rec.last_update_login,
        l_def_coverage_rec.attribute3,
        l_def_coverage_rec.attribute1,
        l_def_coverage_rec.attribute2,
        l_def_coverage_rec.attribute4,
        l_def_coverage_rec.attribute5,
        l_def_coverage_rec.attribute6,
        l_def_coverage_rec.attribute7,
        l_def_coverage_rec.attribute8,
        l_def_coverage_rec.attribute9,
        l_def_coverage_rec.attribute10,
        l_def_coverage_rec.attribute11,
        l_def_coverage_rec.attribute12,
        l_def_coverage_rec.attribute13,
        l_def_coverage_rec.attribute14,
        l_def_coverage_rec.attribute15,
        l_def_coverage_rec.context,
        l_def_coverage_rec.object_version_number);

Line: 458


  END insert_row;

Line: 459


  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_template_id         IN NUMBER := NULL,
    p_name                         IN CS_COVERAGES.NAME%TYPE := NULL,
    p_description                  IN CS_COVERAGES.DESCRIPTION%TYPE := NULL,
    p_template_flag                IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := NULL,
    p_renewal_terms                IN CS_COVERAGES.RENEWAL_TERMS%TYPE := NULL,
    p_termination_terms            IN CS_COVERAGES.TERMINATION_TERMS%TYPE := NULL,
    p_max_support_coverage_amt     IN NUMBER := NULL,
    p_exception_coverage_id        IN NUMBER := NULL,
    p_time_billable_percent        IN NUMBER := NULL,
    p_max_time_billable_amount     IN NUMBER := NULL,
    p_material_billable_percent    IN NUMBER := NULL,
    p_max_material_billable_amount  IN NUMBER := NULL,
    p_expense_billable_percent     IN NUMBER := NULL,
    p_max_expense_billable_amount  IN NUMBER := NULL,
    p_max_coverage_amount          IN NUMBER := NULL,
    p_response_time_period_code    IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := NULL,
    p_response_time_value          IN NUMBER := NULL,
    p_sunday_start_time            IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,
    p_sunday_end_time              IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,
    p_monday_start_time            IN CS_COVERAGES.MONDAY_START_TIME%TYPE := NULL,
    p_monday_end_time              IN CS_COVERAGES.MONDAY_END_TIME%TYPE := NULL,
    p_start_date_active            IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,
    p_tuesday_start_time           IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := NULL,
    p_tuesday_end_time             IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := NULL,
    p_end_date_active              IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := NULL,
    p_wednesday_start_time         IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := NULL,
    p_wednesday_end_time           IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := NULL,
    p_thursday_start_time          IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := NULL,
    p_thursday_end_time            IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := NULL,
    p_friday_start_time            IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := NULL,
    p_friday_end_time              IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := NULL,
    p_saturday_start_time          IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := NULL,
    p_saturday_end_time            IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_creation_date                IN CS_COVERAGES.CREATION_DATE%TYPE := NULL,
    p_last_update_date             IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_attribute3                   IN CS_COVERAGES.ATTRIBUTE3%TYPE := NULL,
    p_attribute1                   IN CS_COVERAGES.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_COVERAGES.ATTRIBUTE2%TYPE := NULL,
    p_attribute4                   IN CS_COVERAGES.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_COVERAGES.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_COVERAGES.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_COVERAGES.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_COVERAGES.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_COVERAGES.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_COVERAGES.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_COVERAGES.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_COVERAGES.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_COVERAGES.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_COVERAGES.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_COVERAGES.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_COVERAGES.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_coverage_id                  OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 577


    l_coverage_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 578


    l_coverage_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 579


    l_coverage_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 597


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_coverage_rec,
      x_coverage_id,
      x_object_version_number
    );

Line: 644


  END insert_row;

Line: 659


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COVERAGES
    WHERE
      COVERAGE_ID = p_coverage_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 667


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COVERAGES
    WHERE
      COVERAGE_ID = p_coverage_id
      ;

Line: 713


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 722


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 761


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

Line: 782


      SELECT *
        FROM Cs_Coverages
       WHERE cs_coverages.coverage_id = p_coverage_id;

Line: 942


      IF (x_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_coverage_rec.last_update_date := l_cc_pk.last_update_date;

Line: 946


      IF (x_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_coverage_rec.last_updated_by := l_cc_pk.last_updated_by;

Line: 950


      IF (x_coverage_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_coverage_rec.last_update_login := l_cc_pk.last_update_login;

Line: 1077


    UPDATE  CS_COVERAGES
    SET
        COVERAGE_ID = l_def_coverage_rec.coverage_id ,
        COVERAGE_TEMPLATE_ID = l_def_coverage_rec.coverage_template_id ,
        NAME = l_def_coverage_rec.name ,
        DESCRIPTION = l_def_coverage_rec.description ,
        TEMPLATE_FLAG = l_def_coverage_rec.template_flag ,
        RENEWAL_TERMS = l_def_coverage_rec.renewal_terms ,
        TERMINATION_TERMS = l_def_coverage_rec.termination_terms ,
        MAX_SUPPORT_COVERAGE_AMT = l_def_coverage_rec.max_support_coverage_amt ,
        EXCEPTION_COVERAGE_ID = l_def_coverage_rec.exception_coverage_id ,
        TIME_BILLABLE_PERCENT = l_def_coverage_rec.time_billable_percent ,
        MAX_TIME_BILLABLE_AMOUNT = l_def_coverage_rec.max_time_billable_amount ,
        MATERIAL_BILLABLE_PERCENT = l_def_coverage_rec.material_billable_percent ,
        MAX_MATERIAL_BILLABLE_AMOUNT = l_def_coverage_rec.max_material_billable_amount ,
        EXPENSE_BILLABLE_PERCENT = l_def_coverage_rec.expense_billable_percent ,
        MAX_EXPENSE_BILLABLE_AMOUNT = l_def_coverage_rec.max_expense_billable_amount ,
        MAX_COVERAGE_AMOUNT = l_def_coverage_rec.max_coverage_amount ,
        RESPONSE_TIME_PERIOD_CODE = l_def_coverage_rec.response_time_period_code ,
        RESPONSE_TIME_VALUE = l_def_coverage_rec.response_time_value ,
        SUNDAY_START_TIME = l_def_coverage_rec.sunday_start_time ,
        SUNDAY_END_TIME = l_def_coverage_rec.sunday_end_time ,
        MONDAY_START_TIME = l_def_coverage_rec.monday_start_time ,
        MONDAY_END_TIME = l_def_coverage_rec.monday_end_time ,
        START_DATE_ACTIVE = l_def_coverage_rec.start_date_active ,
        TUESDAY_START_TIME = l_def_coverage_rec.tuesday_start_time ,
        TUESDAY_END_TIME = l_def_coverage_rec.tuesday_end_time ,
        END_DATE_ACTIVE = l_def_coverage_rec.end_date_active ,
        WEDNESDAY_START_TIME = l_def_coverage_rec.wednesday_start_time ,
        WEDNESDAY_END_TIME = l_def_coverage_rec.wednesday_end_time ,
        THURSDAY_START_TIME = l_def_coverage_rec.thursday_start_time ,
        THURSDAY_END_TIME = l_def_coverage_rec.thursday_end_time ,
        FRIDAY_START_TIME = l_def_coverage_rec.friday_start_time ,
        FRIDAY_END_TIME = l_def_coverage_rec.friday_end_time ,
        SATURDAY_START_TIME = l_def_coverage_rec.saturday_start_time ,
        SATURDAY_END_TIME = l_def_coverage_rec.saturday_end_time ,
        CREATED_BY = l_def_coverage_rec.created_by ,
        CREATION_DATE = l_def_coverage_rec.creation_date ,
        LAST_UPDATE_DATE = l_def_coverage_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_coverage_rec.last_updated_by ,
        LAST_UPDATE_LOGIN = l_def_coverage_rec.last_update_login ,
        ATTRIBUTE3 = l_def_coverage_rec.attribute3 ,
        ATTRIBUTE1 = l_def_coverage_rec.attribute1 ,
        ATTRIBUTE2 = l_def_coverage_rec.attribute2 ,
        ATTRIBUTE4 = l_def_coverage_rec.attribute4 ,
        ATTRIBUTE5 = l_def_coverage_rec.attribute5 ,
        ATTRIBUTE6 = l_def_coverage_rec.attribute6 ,
        ATTRIBUTE7 = l_def_coverage_rec.attribute7 ,
        ATTRIBUTE8 = l_def_coverage_rec.attribute8 ,
        ATTRIBUTE9 = l_def_coverage_rec.attribute9 ,
        ATTRIBUTE10 = l_def_coverage_rec.attribute10 ,
        ATTRIBUTE11 = l_def_coverage_rec.attribute11 ,
        ATTRIBUTE12 = l_def_coverage_rec.attribute12 ,
        ATTRIBUTE13 = l_def_coverage_rec.attribute13 ,
        ATTRIBUTE14 = l_def_coverage_rec.attribute14 ,
        ATTRIBUTE15 = l_def_coverage_rec.attribute15 ,
        CONTEXT = l_def_coverage_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_coverage_rec.object_version_number
        WHERE
          COVERAGE_ID = l_def_coverage_rec.coverage_id
          ;

Line: 1174


  END update_row;

Line: 1175


  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_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_coverage_template_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_name                         IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_description                  IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_template_flag                IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_renewal_terms                IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_termination_terms            IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_max_support_coverage_amt     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_exception_coverage_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_time_billable_percent        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_max_time_billable_amount     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_material_billable_percent    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_max_material_billable_amount  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_expense_billable_percent     IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_max_expense_billable_amount  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_max_coverage_amount          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_response_time_period_code    IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_response_time_value          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_sunday_start_time            IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_sunday_end_time              IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_monday_start_time            IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_monday_end_time              IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_start_date_active            IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_tuesday_start_time           IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_tuesday_end_time             IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_end_date_active              IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_wednesday_start_time         IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_wednesday_end_time           IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_thursday_start_time          IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_thursday_end_time            IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_friday_start_time            IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_friday_end_time              IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_saturday_start_time          IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_saturday_end_time            IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_creation_date                IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_last_update_date             IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_attribute3                   IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute1                   IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COVERAGES.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: 1294


    l_coverage_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1295


    l_coverage_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1296


    l_coverage_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 1314


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

Line: 1360


  END update_row;

Line: 1361


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

Line: 1387


    DELETE  FROM CS_COVERAGES
    WHERE
      COVERAGE_ID = p_coverage_id
      ;

Line: 1426


  END delete_row;

Line: 1558


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


    l_coverage_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1632


    l_coverage_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1633


    l_coverage_rec.LAST_UPDATE_LOGIN := p_last_update_login;