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

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

Line: 5


      SELECT CS_COVERAGE_TXN_GROUPS_S.nextval FROM SYS.DUAL;

Line: 34


    ELSIF p_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_txngrp_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_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_txngrp_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: 91


      SELECT *
        FROM Cs_Business_Processes
       WHERE cs_business_processes.business_process_id = p_business_process_id;

Line: 96


      SELECT *
        FROM Cs_Time_Zones
       WHERE cs_time_zones.time_zone_id = p_time_zone_id;

Line: 181


    p_to.last_update_date := p_from.last_update_date;

Line: 182


    p_to.last_updated_by := p_from.last_updated_by;

Line: 185


    p_to.last_update_login := p_from.last_update_login;

Line: 237


    p_to.last_update_date := p_from.last_update_date;

Line: 238


    p_to.last_updated_by := p_from.last_updated_by;

Line: 241


    p_to.last_update_login := p_from.last_update_login;

Line: 260


  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_txngrp_rec                   IN TxnGrp_Rec_Type := G_MISS_TXNGRP_REC,
    x_coverage_txn_group_id        OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 326


    INSERT INTO CS_COVERAGE_TXN_GROUPS(
        coverage_txn_group_id,
        offset_duration,
        offset_period,
        coverage_start_date,
        coverage_end_date,
        price_list_id,
        manufacturing_org_id,
        subinventory_code,
        coverage_id,
        discount_id,
        business_process_id,
        sunday_end_time,
        sunday_start_time,
        monday_start_time,
        monday_end_time,
        tuesday_start_time,
        tuesday_end_time,
        wednesday_start_time,
        wednesday_end_time,
        thursday_start_time,
        thursday_end_time,
        friday_start_time,
        friday_end_time,
        saturday_start_time,
        saturday_end_time,
        preferred_engineer1,
        time_zone_id,
        preferred_engineer2,
        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_txngrp_rec.coverage_txn_group_id,
        l_def_txngrp_rec.offset_duration,
        l_def_txngrp_rec.offset_period,
        l_def_txngrp_rec.coverage_start_date,
        l_def_txngrp_rec.coverage_end_date,
        l_def_txngrp_rec.price_list_id,
        l_def_txngrp_rec.manufacturing_org_id,
        l_def_txngrp_rec.subinventory_code,
        l_def_txngrp_rec.coverage_id,
        l_def_txngrp_rec.discount_id,
        l_def_txngrp_rec.business_process_id,
        l_def_txngrp_rec.sunday_end_time,
        l_def_txngrp_rec.sunday_start_time,
        l_def_txngrp_rec.monday_start_time,
        l_def_txngrp_rec.monday_end_time,
        l_def_txngrp_rec.tuesday_start_time,
        l_def_txngrp_rec.tuesday_end_time,
        l_def_txngrp_rec.wednesday_start_time,
        l_def_txngrp_rec.wednesday_end_time,
        l_def_txngrp_rec.thursday_start_time,
        l_def_txngrp_rec.thursday_end_time,
        l_def_txngrp_rec.friday_start_time,
        l_def_txngrp_rec.friday_end_time,
        l_def_txngrp_rec.saturday_start_time,
        l_def_txngrp_rec.saturday_end_time,
        l_def_txngrp_rec.preferred_engineer1,
        l_def_txngrp_rec.time_zone_id,
        l_def_txngrp_rec.preferred_engineer2,
        l_def_txngrp_rec.last_update_date,
        l_def_txngrp_rec.last_updated_by,
        l_def_txngrp_rec.creation_date,
        l_def_txngrp_rec.created_by,
        l_def_txngrp_rec.last_update_login,
        l_def_txngrp_rec.attribute1,
        l_def_txngrp_rec.attribute2,
        l_def_txngrp_rec.attribute3,
        l_def_txngrp_rec.attribute4,
        l_def_txngrp_rec.attribute5,
        l_def_txngrp_rec.attribute6,
        l_def_txngrp_rec.attribute7,
        l_def_txngrp_rec.attribute8,
        l_def_txngrp_rec.attribute9,
        l_def_txngrp_rec.attribute10,
        l_def_txngrp_rec.attribute11,
        l_def_txngrp_rec.attribute12,
        l_def_txngrp_rec.attribute13,
        l_def_txngrp_rec.attribute14,
        l_def_txngrp_rec.attribute15,
        l_def_txngrp_rec.context,
        l_def_txngrp_rec.object_version_number);

Line: 466


  END insert_row;

Line: 467


  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_offset_duration              IN NUMBER := NULL,
    p_offset_period                IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := NULL,
    p_coverage_start_date          IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := NULL,
    p_coverage_end_date            IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := NULL,
    p_price_list_id                IN NUMBER := NULL,
    p_manufacturing_org_id         IN NUMBER := NULL,
    p_subinventory_code            IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := NULL,
    p_coverage_id                  IN NUMBER := NULL,
    p_discount_id                  IN NUMBER := NULL,
    p_business_process_id          IN NUMBER := NULL,
    p_sunday_end_time              IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := NULL,
    p_sunday_start_time            IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := NULL,
    p_monday_start_time            IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := NULL,
    p_monday_end_time              IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := NULL,
    p_tuesday_start_time           IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := NULL,
    p_tuesday_end_time             IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := NULL,
    p_wednesday_start_time         IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
    p_wednesday_end_time           IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := NULL,
    p_thursday_start_time          IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := NULL,
    p_thursday_end_time            IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := NULL,
    p_friday_start_time            IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := NULL,
    p_friday_end_time              IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := NULL,
    p_saturday_start_time          IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := NULL,
    p_saturday_end_time            IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := NULL,
    p_preferred_engineer1          IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := NULL,
    p_time_zone_id                 IN NUMBER := NULL,
    p_preferred_engineer2          IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := NULL,
    p_last_update_date             IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_attribute1                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_coverage_txn_group_id        OUT NUMBER,
    x_object_version_number        OUT NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';

Line: 571


    l_txngrp_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 572


    l_txngrp_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 575


    l_txngrp_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 593


    insert_row(
      p_api_version,
      p_init_msg_list,
      p_validation_level,
      p_commit,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_txngrp_rec,
      x_coverage_txn_group_id,
      x_object_version_number
    );

Line: 640


  END insert_row;

Line: 655


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COVERAGE_TXN_GROUPS
    WHERE
      COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 663


    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COVERAGE_TXN_GROUPS
    WHERE
      COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
      ;

Line: 709


      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 718


      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 757


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

Line: 778


      SELECT *
        FROM Cs_Coverage_Txn_Groups
       WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;

Line: 906


      IF (x_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;

Line: 910


      IF (x_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;

Line: 922


      IF (x_txngrp_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;

Line: 1049


    UPDATE  CS_COVERAGE_TXN_GROUPS
    SET
        COVERAGE_TXN_GROUP_ID = l_def_txngrp_rec.coverage_txn_group_id ,
        OFFSET_DURATION = l_def_txngrp_rec.offset_duration ,
        OFFSET_PERIOD = l_def_txngrp_rec.offset_period ,
        COVERAGE_START_DATE = l_def_txngrp_rec.coverage_start_date ,
        COVERAGE_END_DATE = l_def_txngrp_rec.coverage_end_date ,
        PRICE_LIST_ID = l_def_txngrp_rec.price_list_id ,
        MANUFACTURING_ORG_ID = l_def_txngrp_rec.manufacturing_org_id ,
        SUBINVENTORY_CODE = l_def_txngrp_rec.subinventory_code ,
        COVERAGE_ID = l_def_txngrp_rec.coverage_id ,
        DISCOUNT_ID = l_def_txngrp_rec.discount_id ,
        BUSINESS_PROCESS_ID = l_def_txngrp_rec.business_process_id ,
        SUNDAY_END_TIME = l_def_txngrp_rec.sunday_end_time ,
        SUNDAY_START_TIME = l_def_txngrp_rec.sunday_start_time ,
        MONDAY_START_TIME = l_def_txngrp_rec.monday_start_time ,
        MONDAY_END_TIME = l_def_txngrp_rec.monday_end_time ,
        TUESDAY_START_TIME = l_def_txngrp_rec.tuesday_start_time ,
        TUESDAY_END_TIME = l_def_txngrp_rec.tuesday_end_time ,
        WEDNESDAY_START_TIME = l_def_txngrp_rec.wednesday_start_time ,
        WEDNESDAY_END_TIME = l_def_txngrp_rec.wednesday_end_time ,
        THURSDAY_START_TIME = l_def_txngrp_rec.thursday_start_time ,
        THURSDAY_END_TIME = l_def_txngrp_rec.thursday_end_time ,
        FRIDAY_START_TIME = l_def_txngrp_rec.friday_start_time ,
        FRIDAY_END_TIME = l_def_txngrp_rec.friday_end_time ,
        SATURDAY_START_TIME = l_def_txngrp_rec.saturday_start_time ,
        SATURDAY_END_TIME = l_def_txngrp_rec.saturday_end_time ,
        PREFERRED_ENGINEER1 = l_def_txngrp_rec.preferred_engineer1 ,
        TIME_ZONE_ID = l_def_txngrp_rec.time_zone_id ,
        PREFERRED_ENGINEER2 = l_def_txngrp_rec.preferred_engineer2 ,
        LAST_UPDATE_DATE = l_def_txngrp_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_txngrp_rec.last_updated_by ,
        CREATION_DATE = l_def_txngrp_rec.creation_date ,
        CREATED_BY = l_def_txngrp_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_txngrp_rec.last_update_login ,
        ATTRIBUTE1 = l_def_txngrp_rec.attribute1 ,
        ATTRIBUTE2 = l_def_txngrp_rec.attribute2 ,
        ATTRIBUTE3 = l_def_txngrp_rec.attribute3 ,
        ATTRIBUTE4 = l_def_txngrp_rec.attribute4 ,
        ATTRIBUTE5 = l_def_txngrp_rec.attribute5 ,
        ATTRIBUTE6 = l_def_txngrp_rec.attribute6 ,
        ATTRIBUTE7 = l_def_txngrp_rec.attribute7 ,
        ATTRIBUTE8 = l_def_txngrp_rec.attribute8 ,
        ATTRIBUTE9 = l_def_txngrp_rec.attribute9 ,
        ATTRIBUTE10 = l_def_txngrp_rec.attribute10 ,
        ATTRIBUTE11 = l_def_txngrp_rec.attribute11 ,
        ATTRIBUTE12 = l_def_txngrp_rec.attribute12 ,
        ATTRIBUTE13 = l_def_txngrp_rec.attribute13 ,
        ATTRIBUTE14 = l_def_txngrp_rec.attribute14 ,
        ATTRIBUTE15 = l_def_txngrp_rec.attribute15 ,
        CONTEXT = l_def_txngrp_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_txngrp_rec.object_version_number
        WHERE
          COVERAGE_TXN_GROUP_ID = l_def_txngrp_rec.coverage_txn_group_id
          ;

Line: 1140


  END update_row;

Line: 1141


  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_txn_group_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_offset_duration              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_offset_period                IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_coverage_start_date          IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_coverage_end_date            IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_price_list_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_manufacturing_org_id         IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_subinventory_code            IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_coverage_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_discount_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_business_process_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_sunday_end_time              IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_sunday_start_time            IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_monday_start_time            IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_monday_end_time              IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_tuesday_start_time           IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_tuesday_end_time             IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_wednesday_start_time         IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_wednesday_end_time           IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_thursday_start_time          IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_thursday_end_time            IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_friday_start_time            IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_friday_end_time              IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_saturday_start_time          IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_saturday_end_time            IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
    p_preferred_engineer1          IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_time_zone_id                 IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_preferred_engineer2          IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_date             IN CS_COVERAGE_TXN_GROUPS.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_COVERAGE_TXN_GROUPS.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_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COVERAGE_TXN_GROUPS.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: 1246


    l_txngrp_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1247


    l_txngrp_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1250


    l_txngrp_rec.LAST_UPDATE_LOGIN := p_last_update_login;

Line: 1268


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

Line: 1314


  END update_row;

Line: 1315


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

Line: 1341


    DELETE  FROM CS_COVERAGE_TXN_GROUPS
    WHERE
      COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
      ;

Line: 1380


  END delete_row;

Line: 1504


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


    l_txngrp_rec.LAST_UPDATE_DATE := p_last_update_date;

Line: 1572


    l_txngrp_rec.LAST_UPDATED_BY := p_last_updated_by;

Line: 1575


    l_txngrp_rec.LAST_UPDATE_LOGIN := p_last_update_login;