732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
735: if(attributeTypeOut = ame_util.stringAttributeType) then
736: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdIn,
737: stringValueListOut => allowedValuesOut);
738: end if;
739: exception
740: when others then
1807: sysdate between
1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages
1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between
1884: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1885: cursor conditionCursor(ruleIdIn in integer) is
1886: select
1887: ame_conditions.condition_id,
1888: ame_condition_pkg.getDescription(ame_conditions.condition_id),
1889: decode(ame_attributes.attribute_type,
1890: ame_util.stringAttributeType, ame_util.booleanTrue,
1891: /* default */ ame_util.booleanFalse)
1892: from