APPS.AME_CONDITION_PKG SQL Statements

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

Line: 6

      select attribute_id
        into attributeId
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate);

Line: 30

      select ame_attributes.name
        into attributeName
        from
          ame_attributes,
          ame_conditions
        where
          ame_conditions.condition_id = conditionIdIn and
          ame_conditions.attribute_id = ame_attributes.attribute_id and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line: 59

      select attribute_type
        into attributeType
        from
          ame_attributes,
          ame_conditions
        where
          ame_conditions.condition_id = conditionIdIn and
          ame_attributes.attribute_id = ame_conditions.attribute_id and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line: 88

      select condition_type
        into conditionType
        from
          ame_conditions
        where
          ame_conditions.condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate);

Line: 115

        select condition_key
          into conditionKey
          from ame_conditions
          where
               condition_id = conditionIdIn and
            ((sysdate between start_date and
               nvl(end_date - ame_util.oneSecond, sysdate)) or
             (sysdate < start_date and
               start_date < nvl(end_date,start_date +ame_util.oneSecond)));

Line: 125

        select condition_key
          into conditionKey
          from ame_conditions
          where
               condition_id = conditionIdIn and
            (processingDateIn between start_date and
               nvl(end_date - ame_util.oneSecond, processingDateIn)) ;

Line: 150

      select count(*)
      into conditionCount
      from ame_conditions
      where upper(condition_key) = upper(conditionKeyIn) and
        rownum < 2;

Line: 175

      select to_char(db.dbid)
      from   v$database db, v$instance instance
      where  upper(db.name) = upper(instance.instance_name);

Line: 198

        select ame_condition_keys_s.nextval into conditionKeyId from dual;

Line: 225

      select string_value
        from ame_string_values
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate)
        order by string_value;

Line: 281

        select parameter_one
         into parameterOne
         from ame_conditions
         where
           condition_id = conditionIdIn and
           sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 307

       select
         condition_type,
         parameter_one,
         parameter_two,
         include_lower_limit,
         include_upper_limit
       into
         conditionType,
         parameterOne,
         parameterTwo,
         includeLowerLimit,
         includeUpperLimit
       from
         ame_conditions
       where
         condition_id = conditionIdIn and
         sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 410

       select
         condition_type,
         parameter_one,
         parameter_two,
         parameter_three,
         include_lower_limit,
         include_upper_limit
       into
         conditionType,
         parameterOne,
         parameterTwo,
         parameterThree,
         includeLowerLimit,
         includeUpperLimit
       from
         ame_conditions
       where
         condition_id = conditionIdIn and
         sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 474

      select include_lower_limit
        into includeLowerLimit
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 498

      select include_upper_limit
        into includeUpperLimit
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 522

      select attribute_type
        into attributeType
        from
          ame_attributes,
          ame_conditions
        where
          ame_conditions.condition_id = conditionIdIn and
          ame_attributes.attribute_id = ame_conditions.attribute_id and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;

Line: 557

      select parameter_one
        into parameterOne
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 581

      select parameter_two
        into parameterTwo
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 605

      select parameter_three
        into parameterThree
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 629

      select start_date
        into startDate
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 653

      select condition_type
        into conditionType
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 678

      select start_date
        into startDate
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 704

      select count(*)
        into useCount
        from
          ame_condition_usages
        where
          condition_id = conditionIdIn and
          rule_id = ruleIdIn and
          ((sysdate between start_date and
            nvl(end_date - ame_util.oneSecond, sysdate)) or
         (sysdate < start_date and
            start_date < nvl(end_date,start_date + ame_util.oneSecond))) ;

Line: 736

      select count(*)
        into useCount
        from
          ame_rule_usages,
          ame_condition_usages
        where
          ame_rule_usages.rule_id = ame_condition_usages.rule_id and
          ame_rule_usages.item_id <> applicationIdIn and
          ame_condition_usages.condition_id = conditionIdIn and
          ((sysdate between ame_rule_usages.start_date and
            nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
         (sysdate < ame_rule_usages.start_date and
            ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
              ame_rule_usages.start_date + ame_util.oneSecond))) and
          ((sysdate between ame_condition_usages.start_date and
            nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
         (sysdate < ame_condition_usages.start_date and
            ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
              ame_condition_usages.start_date + ame_util.oneSecond))) ;

Line: 775

      select count(*)
        into useCount
        from ame_condition_usages
        where
          condition_id = conditionIdIn and
          ((sysdate between start_date and
            nvl(end_date - ame_util.oneSecond, sysdate)) or
         (sysdate < start_date and
            start_date < nvl(end_date,start_date + ame_util.oneSecond))) ;

Line: 805

      select count(*)
        into lineItemCount
        from
              ame_attribute_usages,
              ame_attributes,
              ame_conditions
        where
              ame_attributes.attribute_id = ame_conditions.attribute_id and
              ame_conditions.condition_type = conditionTypeIn and
              ame_attributes.line_item = ame_util.booleanTrue and
              ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
              ame_attribute_usages.application_id = applicationIdIn and
              ((sysdate between ame_attribute_usages.start_date and
            nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
         (sysdate < ame_attribute_usages.start_date and
            ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
                 ame_attribute_usages.start_date + ame_util.oneSecond)))  and
              sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
              sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;

Line: 855

      select condition_id
        from ame_conditions
        where
          attribute_id = attributeIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 939

        select count(*)
          into tempCount
          from ame_conditions
          where
            condition_type = typeIn and
            attribute_id = attributeIdIn and
            ((parameterOneIn is null and parameter_one is null) or
             upper(parameter_one) = upper(parameterOneIn)) and
            ((parameterTwoIn is null and parameter_two is null) or
             upper(parameter_two) = upper(parameterTwoIn)) and
            ((parameterThreeIn is null and parameter_three is null) or
             upper(parameter_three) = upper(parameterThreeIn)) and
            ((include_lower_limit is null and includeLowerLimitIn is null) or
             upper(include_lower_limit) = upper(includeLowerLimitIn)) and
            ((include_upper_limit is null and includeUpperLimitIn is null) or
             upper(include_upper_limit) = upper(includeUpperLimitIn)) and
            processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate) ;

Line: 997

          select count(*)
            into conditionCount
            from ame_conditions
            where
              processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate) ;

Line: 1006

            select min(condition_id) - 1
              into conditionId
              from ame_conditions
              where
                processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate);

Line: 1017

          select ame_conditions_s.nextval into conditionId from dual;

Line: 1021

        select count(*)
          into tempCount2
          from ame_conditions
            where
              condition_id = conditionId and
              created_by = ame_util.seededDataCreatedById;

Line: 1033

      insert into ame_conditions(condition_id,
                                 condition_key,
                                 condition_type,
                                 attribute_id,
                                 parameter_one,
                                 parameter_two,
                                 parameter_three,
                                 include_lower_limit,
                                 include_upper_limit,
                                 created_by,
                                 creation_date,
                                 last_updated_by,
                                 last_update_date,
                                 last_update_login,
                                 start_date,
                                 end_date)
        values(conditionId,
               conditionKeyIn,
               typeIn,
               attributeIdIn,
               parameterOneIn,
               parameterTwoIn,
               parameterThreeIn,
               includeLowerLimitIn,
               includeUpperLimitIn,
               createdBy,
               processingDate,
               currentUserId,
               processingDate,
               currentUserId,
               nvl(newStartDateIn, processingDate),
               null);

Line: 1068

          insert into ame_string_values(condition_id,
                                        string_value,
                                        created_by,
                                        creation_date,
                                        last_updated_by,
                                        last_update_date,
                                        last_update_login,
                                        start_date,
                                        end_date)
            values(conditionId,
                   stringValueList(i),
                   createdBy,
                   processingDate,
                   currentUserId,
                   processingDate,
                   currentUserId,
                   nvl(newStartDateIn, processingDate),
                   null);

Line: 1280

      select count(*)
        into useCount
        from ame_condition_usages
        where
          condition_id = conditionIdIn and
          rule_id = ruleIdIn and
          ((sysdate between start_date and
          nvl(end_date - ame_util.oneSecond, sysdate)) or
       (sysdate < start_date and
          start_date < nvl(end_date,start_date + ame_util.oneSecond))) ;

Line: 1294

      select count(*)
       into tempCount
       from ame_condition_usages
         where
           condition_id = conditionIdIn and
           rule_id = ruleIdIn and
           created_by = ame_util.seededDataCreatedById;

Line: 1306

      insert into ame_condition_usages(rule_id,
                                       condition_id,
                                       created_by,
                                       creation_date,
                                       last_updated_by,
                                       last_update_date,
                                       last_update_login,
                                       start_date,
                                       end_date)
        values(ruleIdIn,
               conditionIdIn,
               createdBy,
               processingDate,
               currentUserId,
               processingDate,
               currentUserId,
               processingDate,
               null);

Line: 1367

      select count(*)
        into useCount
        from ame_string_values
        where
          condition_id = conditionIdIn and
          /* string values are case sensitive */
          string_value = valueIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 1385

      insert into ame_string_values(condition_id,
                                    string_value,
                                    created_by,
                                    creation_date,
                                    last_updated_by,
                                    last_update_date,
                                    last_update_login,
                                    start_date,
                                    end_date)
        values(conditionIdIn,
               valueIn,
               currentUserId,
               processingDate,
               currentUserId,
               processingDate,
               currentUserId,
               processingDate,
               null);

Line: 1450

      select condition_id
        from ame_conditions
        where
          attribute_id = attributeIdIn and
          condition_type = typeIn and
          ((parameter_one is null and parameterOneIn is null) or
           (parameter_one = parameterOneIn)) and
          ((parameter_two is null and parameterTwoIn is null) or
           (parameter_two = parameterTwoIn)) and
          ((parameter_three is null and parameterThreeIn is null) or
           (parameter_three = parameterThreeIn)) and
          ((include_lower_limit is null and includeLowerLimitIn is null) or
           (include_lower_limit = includeLowerLimitIn)) and
          ((include_upper_limit is null and includeUpperLimitIn is null) or
           (include_upper_limit = includeUpperLimitIn)) and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 1468

      select start_date
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate)
        for update;

Line: 1511

        select count(*)
          into tempCount
          from ame_conditions
          where
            condition_type = typeIn and
            attribute_id = attributeIdIn and
            ((parameter_one is null and parameterOneIn is null) or
             (parameter_one = parameterOneIn)) and
            ((parameter_two is null and parameterTwoIn is null) or
             (parameter_two = parameterTwoIn)) and
            ((parameter_three is null and parameterThreeIn is null) or
             (parameter_three = parameterThreeIn)) and
            ((include_lower_limit is null and includeLowerLimitIn is null) or
             (include_lower_limit = includeLowerLimitIn)) and
            ((include_upper_limit is null and includeUpperLimitIn is null) or
             (include_upper_limit = includeUpperLimitIn)) and
             sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 1565

          update ame_conditions
            set
              last_updated_by = currentUserId,
              last_update_date = endDate,
              last_update_login = currentUserId,
              end_date = endDate
            where
              condition_id = conditionIdIn and
              sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 1577

              delete from ame_string_values where condition_id = conditionIdIn;

Line: 1622

            messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');

Line: 1665

      select
        condition_type,
        condition_key,
        attribute_id,
        parameter_one,
        parameter_two,
        parameter_three,
        include_lower_limit,
        include_upper_limit
        into
          conditionTypeOut,
          conditionKeyOut,
          attributeIdOut,
          parameterOneOut,
          parameterTwoOut,
          parameterThreeOut,
          includeLowerLimitOut,
          includeUpperLimitOut
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 1718

      select
        ame_conditions.condition_id id,
        ame_conditions.condition_type,
        ame_attributes.attribute_id,
        ame_attributes.name,
        ame_attributes.attribute_type
        from ame_conditions,
             ame_attributes,
             ame_attribute_usages,
             ame_item_class_usages
        where
          ame_attribute_usages.application_id = ame_item_class_usages.application_id and
          ame_item_class_usages.application_id = applicationIdIn and
          ame_item_class_usages.item_class_id = itemClassIdIn and
          ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
          ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
          ame_attributes.item_class_id = itemClassIdIn and
          ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_attribute_usages.start_date and
                 nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_item_class_usages.start_date and
                 nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
        order by ame_conditions.condition_type,
                 ame_attributes.attribute_type,
                 ame_attributes.name;

Line: 1802

      select
        condition_id id,
        ame_condition_pkg.getDescription(condition_id) description
        from ame_conditions,
             ame_attributes
        where
          ame_conditions.attribute_id = ame_attributes.attribute_id and
          nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
          ame_attributes.attribute_id = attributeIdIn and
          condition_type = conditionTypeIn and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
        order by description;

Line: 1852

      select
        ame_conditions.condition_id id,
        ame_condition_pkg.getDescription(ame_conditions.condition_id) description
        from ame_conditions,
             ame_attributes
        where
          ame_conditions.attribute_id = ame_attributes.attribute_id and
          ame_attributes.attribute_id = attributeIdIn and
          condition_type = conditionTypeIn and
          ame_attributes.item_class_id = itemClassIdIn and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
        order by description;

Line: 1906

      select
        condition_id id,
        ame_condition_pkg.getDescription(condition_id) description
        from ame_conditions,
             ame_attributes
        where
          ame_conditions.attribute_id = ame_attributes.attribute_id and
          nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
          ame_attributes.attribute_id = attributeIdIn and
          ame_attributes.item_class_id = itemClassIdIn and
          condition_type = conditionTypeIn and
          sysdate between ame_conditions.start_date and
                 nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
          sysdate between ame_attributes.start_date and
                 nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
        order by description;

Line: 1955

      select distinct ame_calling_apps.application_name
        from
          ame_rules,
          ame_rule_usages,
          ame_calling_apps,
          ame_condition_usages
        where
          ame_rules.rule_id = ame_rule_usages.rule_id and
          ame_rules.rule_id = ame_condition_usages.rule_id and
          ame_rule_usages.item_id = ame_calling_apps.application_id and
          ame_rule_usages.item_id <> applicationIdIn and
          ame_condition_usages.condition_id = conditionIdIn and
          ((sysdate between ame_rules.start_date and
              nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
           (sysdate < ame_rules.start_date and
              ame_rules.start_date < nvl(ame_rules.end_date,
                               ame_rules.start_date + ame_util.oneSecond))) and
          ((sysdate between ame_rule_usages.start_date and
                 nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
              (sysdate < ame_rule_usages.start_date and
                 ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
                     ame_rule_usages.start_date + ame_util.oneSecond))) and
          ((sysdate between ame_condition_usages.start_date and
            nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
           (sysdate < ame_condition_usages.start_date and
            ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
              ame_condition_usages.start_date + ame_util.oneSecond))) and
          sysdate between ame_calling_apps.start_date and
               nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
          order by ame_calling_apps.application_name;

Line: 2059

      select
        condition_id,
        parameter_one,
        parameter_two
        from ame_conditions
        where
          condition_type = ame_util.listModConditionType and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate) ;

Line: 2092

    select
      condition_id,
      parameter_one,
      parameter_two
      from
        ame_conditions
      where
        condition_type = ame_util.listModConditionType and
        sysdate between start_date and
          nvl(end_date - ame_util.oneSecond, sysdate);

Line: 2136

      select
        ame_conditions.condition_id condition_id,
        ame_conditions.parameter_one parameter_one,
        ame_conditions.parameter_two parameter_two
        from
          ame_conditions
        where
          ame_conditions.condition_type = ame_util.listModConditionType and
          sysdate between ame_conditions.start_date and
            nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line: 2183

      select
        ame_conditions.condition_id condition_id,
        ame_conditions.parameter_two parameter_two
        from
          ame_conditions
        where
          ame_conditions.condition_type = ame_util.listModConditionType and
          ame_conditions.parameter_one = lmApproverTypeIn and
          sysdate between ame_conditions.start_date and
            nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line: 2229

      select string_value
        from ame_string_values
        where condition_id = conditionIdIn and
              sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate)
        order by string_value asc;

Line: 2278

    select start_date
      from ame_conditions
      where
        condition_id = conditionIdIn and
        sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate)
       for update;

Line: 2314

              update ame_string_values
                set
                  last_updated_by = currentUserId,
                  last_update_date = processingDate,
                  last_update_login = currentUserId,
                  end_date = processingDate
                where
                  condition_id = conditionIdIn and
                  processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate) ;

Line: 2326

          update ame_conditions
            set
              last_updated_by = currentUserId,
              last_update_date = processingDate,
              last_update_login = currentUserId,
              end_date = processingDate
            where
              condition_id = conditionIdIn and
                  processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate) ;

Line: 2366

            messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');

Line: 2420

      update ame_condition_usages
        set
          last_updated_by = currentUserId,
          last_update_date = processingDate,
          last_update_login = currentUserId,
          end_date = processingDate
        where
          condition_id = conditionIdIn and
          rule_id = ruleIdIn and
          ((processingDate between start_date and
            nvl(end_date - ame_util.oneSecond, processingDate)) or
         (processingDate < start_date and
            start_date < nvl(end_date,start_date + ame_util.oneSecond))) ;

Line: 2481

      select start_date
        from ame_conditions
        where
          condition_id = conditionIdIn and
          sysdate between start_date and
                 nvl(end_date - ame_util.oneSecond, sysdate)
        for update;

Line: 2519

            update ame_string_values
              set
                last_updated_by = currentUserId,
                last_update_date = processingDate,
                last_update_login = currentUserId,
                end_date = processingDate
              where
                condition_id = conditionIdIn and
                string_value = stringValueListIn(i) and
                processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate) ;

Line: 2539

          update ame_conditions
            set
              last_updated_by = currentUserId,
              last_update_date = processingDate,
              last_update_login = currentUserId,
              end_date = processingDate
            where
              condition_id = conditionIdIn and
              processingDate between start_date and
                 nvl(end_date - ame_util.oneSecond, processingDate) ;

Line: 2587

            messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');