DBA Data[Home] [Help]

APPS.CS_COUNTERFILTER_PVT SQL Statements

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

Line: 5

      SELECT CS_COUNTER_DER_FILTERS_S.nextval FROM SYS.DUAL;
Line: 39

    ELSIF p_counterfilter_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
          p_counterfilter_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_counterfilter_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
          p_counterfilter_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: 104

    p_to.last_update_date := p_from.last_update_date;
Line: 105

    p_to.last_updated_by := p_from.last_updated_by;
Line: 108

    p_to.last_update_login := p_from.last_update_login;
Line: 141

    p_to.last_update_date := p_from.last_update_date;
Line: 142

    p_to.last_updated_by := p_from.last_updated_by;
Line: 145

    p_to.last_update_login := p_from.last_update_login;
Line: 164

  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 NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_counterfilter_rec            IN CounterFilter_Rec_Type := G_MISS_COUNTERFILTER_REC,
    x_counter_der_filter_id        OUT NOCOPY NUMBER,
    x_object_version_number        OUT NOCOPY NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';
Line: 230

    INSERT INTO CS_COUNTER_DER_FILTERS(
        counter_der_filter_id,
        counter_id,
        seq_no,
        left_paren,
        counter_property_id,
        relational_operator,
        right_paren,
        right_value,
        logical_operator,
        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_counterfilter_rec.counter_der_filter_id,
        l_def_counterfilter_rec.counter_id,
        l_def_counterfilter_rec.seq_no,
        l_def_counterfilter_rec.left_paren,
        l_def_counterfilter_rec.counter_property_id,
        l_def_counterfilter_rec.relational_operator,
        l_def_counterfilter_rec.right_paren,
        l_def_counterfilter_rec.right_value,
        l_def_counterfilter_rec.logical_operator,
        l_def_counterfilter_rec.last_update_date,
        l_def_counterfilter_rec.last_updated_by,
        l_def_counterfilter_rec.creation_date,
        l_def_counterfilter_rec.created_by,
        l_def_counterfilter_rec.last_update_login,
        l_def_counterfilter_rec.attribute1,
        l_def_counterfilter_rec.attribute2,
        l_def_counterfilter_rec.attribute3,
        l_def_counterfilter_rec.attribute4,
        l_def_counterfilter_rec.attribute5,
        l_def_counterfilter_rec.attribute6,
        l_def_counterfilter_rec.attribute7,
        l_def_counterfilter_rec.attribute8,
        l_def_counterfilter_rec.attribute9,
        l_def_counterfilter_rec.attribute10,
        l_def_counterfilter_rec.attribute11,
        l_def_counterfilter_rec.attribute12,
        l_def_counterfilter_rec.attribute13,
        l_def_counterfilter_rec.attribute14,
        l_def_counterfilter_rec.attribute15,
        l_def_counterfilter_rec.context,
        l_def_counterfilter_rec.object_version_number);
Line: 332

  END insert_row;
Line: 333

  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 NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_counter_id                   IN NUMBER := NULL,
    p_seq_no                       IN NUMBER := NULL,
    p_left_paren                   IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
    p_counter_property_id          IN NUMBER := NULL,
    p_relational_operator          IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
    p_right_paren                  IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
    p_right_value                  IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
    p_logical_operator             IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
    p_last_update_date             IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
    p_last_updated_by              IN NUMBER := NULL,
    p_creation_date                IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
    p_created_by                   IN NUMBER := NULL,
    p_last_update_login            IN NUMBER := NULL,
    p_attribute1                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
    p_attribute2                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
    p_attribute3                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
    p_attribute4                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
    p_attribute5                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
    p_attribute6                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
    p_attribute7                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
    p_attribute8                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
    p_attribute9                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
    p_attribute10                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
    p_attribute11                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
    p_attribute12                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
    p_attribute13                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
    p_attribute14                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
    p_attribute15                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
    p_context                      IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
    p_object_version_number        IN NUMBER := NULL,
    x_counter_der_filter_id        OUT NOCOPY NUMBER,
    x_object_version_number        OUT NOCOPY NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';
Line: 399

    l_counterfilter_rec.LAST_UPDATE_DATE := p_last_update_date;
Line: 400

    l_counterfilter_rec.LAST_UPDATED_BY := p_last_updated_by;
Line: 403

    l_counterfilter_rec.LAST_UPDATE_LOGIN := p_last_update_login;
Line: 421

    insert_row(
      p_api_version,
      --p_init_msg_list,
	 FND_API.G_TRUE,
      p_validation_level,
      --p_commit,
	 FND_API.G_TRUE,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_counterfilter_rec,
      x_counter_der_filter_id,
      x_object_version_number
    );
Line: 470

  END insert_row;
Line: 485

    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COUNTER_DER_FILTERS
    WHERE
      COUNTER_DER_FILTER_ID = p_counter_der_filter_id AND
      OBJECT_VERSION_NUMBER = p_object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 493

    SELECT OBJECT_VERSION_NUMBER
     FROM CS_COUNTER_DER_FILTERS
    WHERE
      COUNTER_DER_FILTER_ID = p_counter_der_filter_id
      ;
Line: 539

      TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 548

      TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 587

  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 NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_counterfilter_val_rec        IN CounterFilter_Val_Rec_Type := G_MISS_COUNTERFILTER_VAL_REC,
    x_object_version_number        OUT NOCOPY NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';
Line: 608

      SELECT *
        FROM Cs_Counter_Der_Filters
       WHERE cs_counter_der_filters.counter_der_filter_id = p_counter_der_filter_id;
Line: 660

      IF (x_counterfilter_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
      THEN
        x_counterfilter_rec.last_update_date := l_ccd_pk.last_update_date;
Line: 664

      IF (x_counterfilter_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_counterfilter_rec.last_updated_by := l_ccd_pk.last_updated_by;
Line: 676

      IF (x_counterfilter_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
      THEN
        x_counterfilter_rec.last_update_login := l_ccd_pk.last_update_login;
Line: 803

    UPDATE  CS_COUNTER_DER_FILTERS
    SET
        COUNTER_DER_FILTER_ID = l_def_counterfilter_rec.counter_der_filter_id ,
        COUNTER_ID = l_def_counterfilter_rec.counter_id ,
        SEQ_NO = l_def_counterfilter_rec.seq_no ,
        LEFT_PAREN = l_def_counterfilter_rec.left_paren ,
        COUNTER_PROPERTY_ID = l_def_counterfilter_rec.counter_property_id ,
        RELATIONAL_OPERATOR = l_def_counterfilter_rec.relational_operator ,
        RIGHT_PAREN = l_def_counterfilter_rec.right_paren ,
        RIGHT_VALUE = l_def_counterfilter_rec.right_value ,
        LOGICAL_OPERATOR = l_def_counterfilter_rec.logical_operator ,
        LAST_UPDATE_DATE = l_def_counterfilter_rec.last_update_date ,
        LAST_UPDATED_BY = l_def_counterfilter_rec.last_updated_by ,
        CREATION_DATE = l_def_counterfilter_rec.creation_date ,
        CREATED_BY = l_def_counterfilter_rec.created_by ,
        LAST_UPDATE_LOGIN = l_def_counterfilter_rec.last_update_login ,
        ATTRIBUTE1 = l_def_counterfilter_rec.attribute1 ,
        ATTRIBUTE2 = l_def_counterfilter_rec.attribute2 ,
        ATTRIBUTE3 = l_def_counterfilter_rec.attribute3 ,
        ATTRIBUTE4 = l_def_counterfilter_rec.attribute4 ,
        ATTRIBUTE5 = l_def_counterfilter_rec.attribute5 ,
        ATTRIBUTE6 = l_def_counterfilter_rec.attribute6 ,
        ATTRIBUTE7 = l_def_counterfilter_rec.attribute7 ,
        ATTRIBUTE8 = l_def_counterfilter_rec.attribute8 ,
        ATTRIBUTE9 = l_def_counterfilter_rec.attribute9 ,
        ATTRIBUTE10 = l_def_counterfilter_rec.attribute10 ,
        ATTRIBUTE11 = l_def_counterfilter_rec.attribute11 ,
        ATTRIBUTE12 = l_def_counterfilter_rec.attribute12 ,
        ATTRIBUTE13 = l_def_counterfilter_rec.attribute13 ,
        ATTRIBUTE14 = l_def_counterfilter_rec.attribute14 ,
        ATTRIBUTE15 = l_def_counterfilter_rec.attribute15 ,
        CONTEXT = l_def_counterfilter_rec.context ,
        OBJECT_VERSION_NUMBER = l_def_counterfilter_rec.object_version_number
        WHERE
          COUNTER_DER_FILTER_ID = l_def_counterfilter_rec.counter_der_filter_id
          ;
Line: 875

  END update_row;
Line: 876

  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 NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_counter_der_filter_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_counter_id                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_seq_no                       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_left_paren                   IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_counter_property_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
    p_relational_operator          IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_right_paren                  IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_right_value                  IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_logical_operator             IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_last_update_date             IN CS_COUNTER_DER_FILTERS.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_COUNTER_DER_FILTERS.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_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute2                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute3                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute4                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute5                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute6                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute7                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute8                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute9                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute10                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute11                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute12                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute13                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute14                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_attribute15                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
    p_context                      IN CS_COUNTER_DER_FILTERS.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 NOCOPY NUMBER) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row';
Line: 943

    l_counterfilter_rec.LAST_UPDATE_DATE := p_last_update_date;
Line: 944

    l_counterfilter_rec.LAST_UPDATED_BY := p_last_updated_by;
Line: 947

    l_counterfilter_rec.LAST_UPDATE_LOGIN := p_last_update_login;
Line: 965

    update_row(
      p_api_version,
      FND_API.G_TRUE ,
      p_validation_level,
      FND_API.G_TRUE ,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_counterfilter_rec,
      x_object_version_number
    );
Line: 1011

  END update_row;
Line: 1012

  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 NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_counter_der_filter_id        IN NUMBER
    ) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row';
Line: 1039

    DELETE  FROM CS_COUNTER_DER_FILTERS
    WHERE
      COUNTER_DER_FILTER_ID = p_counter_der_filter_id
      ;
Line: 1078

  END delete_row;
Line: 1183

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

    l_counterfilter_rec.LAST_UPDATE_DATE := p_last_update_date;
Line: 1232

    l_counterfilter_rec.LAST_UPDATED_BY := p_last_updated_by;
Line: 1235

    l_counterfilter_rec.LAST_UPDATE_LOGIN := p_last_update_login;