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.AME_CONDITION_PKG dependencies on AME_ATTRIBUTES

Line 28: attributeName ame_attributes.name%type;

24: raise;
25: return(null);
26: end getAttributeId;
27: function getAttributeName(conditionIdIn in integer) return varchar2 as
28: attributeName ame_attributes.name%type;
29: begin
30: select ame_attributes.name
31: into attributeName
32: from

Line 30: select ame_attributes.name

26: end getAttributeId;
27: function getAttributeName(conditionIdIn in integer) return varchar2 as
28: attributeName ame_attributes.name%type;
29: begin
30: select ame_attributes.name
31: into attributeName
32: from
33: ame_attributes,
34: ame_conditions

Line 33: ame_attributes,

29: begin
30: select ame_attributes.name
31: into attributeName
32: from
33: ame_attributes,
34: ame_conditions
35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 37: ame_conditions.attribute_id = ame_attributes.attribute_id and

33: ame_attributes,
34: ame_conditions
35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line 38: sysdate between ame_attributes.start_date and

34: ame_conditions
35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
42: return(attributeName);

Line 39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

35: where
36: ame_conditions.condition_id = conditionIdIn and
37: ame_conditions.attribute_id = ame_attributes.attribute_id and
38: sysdate between ame_attributes.start_date and
39: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
40: sysdate between ame_conditions.start_date and
41: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
42: return(attributeName);
43: exception

Line 57: attributeType ame_attributes.attribute_type%type;

53: raise;
54: return(null);
55: end getAttributeName;
56: function getAttributeType(conditionIdIn in integer) return varchar2 as
57: attributeType ame_attributes.attribute_type%type;
58: begin
59: select attribute_type
60: into attributeType
61: from

Line 62: ame_attributes,

58: begin
59: select attribute_type
60: into attributeType
61: from
62: ame_attributes,
63: ame_conditions
64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 66: ame_attributes.attribute_id = ame_conditions.attribute_id and

62: ame_attributes,
63: ame_conditions
64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

Line 67: sysdate between ame_attributes.start_date and

63: ame_conditions
64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
71: return(attributeType);

Line 68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

64: where
65: ame_conditions.condition_id = conditionIdIn and
66: ame_attributes.attribute_id = ame_conditions.attribute_id and
67: sysdate between ame_attributes.start_date and
68: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
69: sysdate between ame_conditions.start_date and
70: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
71: return(attributeType);
72: exception

Line 236: approverTypeId ame_attributes.approver_type_id%type;

232: description varchar2(500);
233: approverDescription ame_util.longStringType;
234: approverName ame_conditions.parameter_two%type;
235: approverType ame_conditions.parameter_one%type;
236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;

Line 237: attributeId ame_attributes.attribute_id%type;

233: approverDescription ame_util.longStringType;
234: approverName ame_conditions.parameter_two%type;
235: approverType ame_conditions.parameter_one%type;
236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;

Line 238: attributeName ame_attributes.name%type;

234: approverName ame_conditions.parameter_two%type;
235: approverType ame_conditions.parameter_one%type;
236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;
242: includeUpperLimit ame_conditions.include_upper_limit%type;

Line 239: attributeType ame_attributes.attribute_type%type;

235: approverType ame_conditions.parameter_one%type;
236: approverTypeId ame_attributes.approver_type_id%type;
237: attributeId ame_attributes.attribute_id%type;
238: attributeName ame_attributes.name%type;
239: attributeType ame_attributes.attribute_type%type;
240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;
242: includeUpperLimit ame_conditions.include_upper_limit%type;
243: lastName per_all_people_f.last_name%type;

Line 244: lineItem ame_attributes.line_item%type;

240: conditionType ame_conditions.condition_type%type;
241: includeLowerLimit ame_conditions.include_lower_limit%type;
242: includeUpperLimit ame_conditions.include_upper_limit%type;
243: lastName per_all_people_f.last_name%type;
244: lineItem ame_attributes.line_item%type;
245: lineItemLabel varchar2(15);
246: origSystem wf_roles.orig_system%type;
247: parameterOne ame_conditions.parameter_one%type;
248: parameterOneDateString varchar2(500);

Line 523: attributeType ame_attributes.attribute_type%type;

519: raise;
520: return(null);
521: end getIncludeUpperLimit;
522: function isStringAttributeType(conditionIdIn in integer) return boolean as
523: attributeType ame_attributes.attribute_type%type;
524: begin
525: select attribute_type
526: into attributeType
527: from

Line 528: ame_attributes,

524: begin
525: select attribute_type
526: into attributeType
527: from
528: ame_attributes,
529: ame_conditions
530: where
531: ame_conditions.condition_id = conditionIdIn and
532: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 532: ame_attributes.attribute_id = ame_conditions.attribute_id and

528: ame_attributes,
529: ame_conditions
530: where
531: ame_conditions.condition_id = conditionIdIn and
532: ame_attributes.attribute_id = ame_conditions.attribute_id and
533: sysdate between ame_conditions.start_date and
534: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
535: sysdate between ame_attributes.start_date and
536: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;

Line 535: sysdate between ame_attributes.start_date and

531: ame_conditions.condition_id = conditionIdIn and
532: ame_attributes.attribute_id = ame_conditions.attribute_id and
533: sysdate between ame_conditions.start_date and
534: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
535: sysdate between ame_attributes.start_date and
536: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
537: if attributeType = ame_util.stringAttributeType then
538: return(true);
539: end if;

Line 536: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;

532: ame_attributes.attribute_id = ame_conditions.attribute_id and
533: sysdate between ame_conditions.start_date and
534: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
535: sysdate between ame_attributes.start_date and
536: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
537: if attributeType = ame_util.stringAttributeType then
538: return(true);
539: end if;
540: return(false);

Line 812: ame_attributes,

808: select count(*)
809: into lineItemCount
810: from
811: ame_attribute_usages,
812: ame_attributes,
813: ame_conditions
814: where
815: ame_attributes.attribute_id = ame_conditions.attribute_id and
816: ame_conditions.condition_type = conditionTypeIn and

Line 815: ame_attributes.attribute_id = ame_conditions.attribute_id and

811: ame_attribute_usages,
812: ame_attributes,
813: ame_conditions
814: where
815: ame_attributes.attribute_id = ame_conditions.attribute_id and
816: ame_conditions.condition_type = conditionTypeIn and
817: ame_attributes.line_item = ame_util.booleanTrue and
818: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
819: ame_attribute_usages.application_id = applicationIdIn and

Line 817: ame_attributes.line_item = ame_util.booleanTrue and

813: ame_conditions
814: where
815: ame_attributes.attribute_id = ame_conditions.attribute_id and
816: ame_conditions.condition_type = conditionTypeIn and
817: ame_attributes.line_item = ame_util.booleanTrue and
818: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
819: ame_attribute_usages.application_id = applicationIdIn and
820: ((sysdate between ame_attribute_usages.start_date and
821: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 818: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

814: where
815: ame_attributes.attribute_id = ame_conditions.attribute_id and
816: ame_conditions.condition_type = conditionTypeIn and
817: ame_attributes.line_item = ame_util.booleanTrue and
818: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
819: ame_attribute_usages.application_id = applicationIdIn and
820: ((sysdate between ame_attribute_usages.start_date and
821: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
822: (sysdate < ame_attribute_usages.start_date and

Line 825: sysdate between ame_attributes.start_date and

821: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)) or
822: (sysdate < ame_attribute_usages.start_date and
823: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
824: ame_attribute_usages.start_date + ame_util.oneSecond))) and
825: sysdate between ame_attributes.start_date and
826: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;
829: if(lineItemCount > 0) then

Line 826: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

822: (sysdate < ame_attribute_usages.start_date and
823: ame_attribute_usages.start_date < nvl(ame_attribute_usages.end_date,
824: ame_attribute_usages.start_date + ame_util.oneSecond))) and
825: sysdate between ame_attributes.start_date and
826: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) ;
829: if(lineItemCount > 0) then
830: return(true);

Line 864: attributeType ame_attributes.attribute_type%type;

860: where
861: attribute_id = attributeIdIn and
862: sysdate between start_date and
863: nvl(end_date - ame_util.oneSecond, sysdate) ;
864: attributeType ame_attributes.attribute_type%type;
865: conditionCount integer;
866: conditionExistsException exception;
867: conditionId integer;
868: condKeyLengthException exception;

Line 1479: attributeType ame_attributes.attribute_type%type;

1475: sysdate between start_date and
1476: nvl(end_date - ame_util.oneSecond, sysdate)
1477: for update;
1478: attributeId integer;
1479: attributeType ame_attributes.attribute_type%type;
1480: conditionId integer;
1481: conditionsExistsException exception;
1482: conditionKey ame_conditions.condition_key%type;
1483: conditionType ame_conditions.condition_type%type;

Line 1724: ame_attributes.attribute_id,

1720: itemClassIdIn in integer) is
1721: select
1722: ame_conditions.condition_id id,
1723: ame_conditions.condition_type,
1724: ame_attributes.attribute_id,
1725: ame_attributes.name,
1726: ame_attributes.attribute_type
1727: from ame_conditions,
1728: ame_attributes,

Line 1725: ame_attributes.name,

1721: select
1722: ame_conditions.condition_id id,
1723: ame_conditions.condition_type,
1724: ame_attributes.attribute_id,
1725: ame_attributes.name,
1726: ame_attributes.attribute_type
1727: from ame_conditions,
1728: ame_attributes,
1729: ame_attribute_usages,

Line 1726: ame_attributes.attribute_type

1722: ame_conditions.condition_id id,
1723: ame_conditions.condition_type,
1724: ame_attributes.attribute_id,
1725: ame_attributes.name,
1726: ame_attributes.attribute_type
1727: from ame_conditions,
1728: ame_attributes,
1729: ame_attribute_usages,
1730: ame_item_class_usages

Line 1728: ame_attributes,

1724: ame_attributes.attribute_id,
1725: ame_attributes.name,
1726: ame_attributes.attribute_type
1727: from ame_conditions,
1728: ame_attributes,
1729: ame_attribute_usages,
1730: ame_item_class_usages
1731: where
1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and

Line 1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

1732: ame_attribute_usages.application_id = ame_item_class_usages.application_id and
1733: ame_item_class_usages.application_id = applicationIdIn and
1734: ame_item_class_usages.item_class_id = itemClassIdIn and
1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1737: ame_attributes.item_class_id = itemClassIdIn and
1738: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1739: sysdate between ame_conditions.start_date and
1740: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 1737: ame_attributes.item_class_id = itemClassIdIn and

1733: ame_item_class_usages.application_id = applicationIdIn and
1734: ame_item_class_usages.item_class_id = itemClassIdIn and
1735: ame_conditions.attribute_id = ame_attribute_usages.attribute_id and
1736: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1737: ame_attributes.item_class_id = itemClassIdIn and
1738: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1739: sysdate between ame_conditions.start_date and
1740: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1741: sysdate between ame_attributes.start_date and

Line 1741: sysdate between ame_attributes.start_date and

1737: ame_attributes.item_class_id = itemClassIdIn and
1738: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1739: sysdate between ame_conditions.start_date and
1740: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1741: sysdate between ame_attributes.start_date and
1742: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1743: sysdate between ame_attribute_usages.start_date and
1744: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
1745: sysdate between ame_item_class_usages.start_date and

Line 1742: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1738: ame_conditions.condition_type in (ame_util.ordinaryConditionType,ame_util.exceptionConditionType) and
1739: sysdate between ame_conditions.start_date and
1740: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1741: sysdate between ame_attributes.start_date and
1742: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1743: sysdate between ame_attribute_usages.start_date and
1744: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
1745: sysdate between ame_item_class_usages.start_date and
1746: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)

Line 1748: ame_attributes.attribute_type,

1744: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
1745: sysdate between ame_item_class_usages.start_date and
1746: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
1747: order by ame_conditions.condition_type,
1748: ame_attributes.attribute_type,
1749: ame_attributes.name;
1750: tempOutputIndex integer;
1751: conditionId integer;
1752: conditionType ame_conditions.condition_type%type;

Line 1749: ame_attributes.name;

1745: sysdate between ame_item_class_usages.start_date and
1746: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate)
1747: order by ame_conditions.condition_type,
1748: ame_attributes.attribute_type,
1749: ame_attributes.name;
1750: tempOutputIndex integer;
1751: conditionId integer;
1752: conditionType ame_conditions.condition_type%type;
1753: attributeId integer;

Line 1754: attributeName ame_attributes.name%type;

1750: tempOutputIndex integer;
1751: conditionId integer;
1752: conditionType ame_conditions.condition_type%type;
1753: attributeId integer;
1754: attributeName ame_attributes.name%type;
1755: attributeType ame_attributes.attribute_type%type;
1756: begin
1757: tempOutputIndex := 1;
1758: open conditionCursor(applicationIdIn => applicationIdIn,

Line 1755: attributeType ame_attributes.attribute_type%type;

1751: conditionId integer;
1752: conditionType ame_conditions.condition_type%type;
1753: attributeId integer;
1754: attributeName ame_attributes.name%type;
1755: attributeType ame_attributes.attribute_type%type;
1756: begin
1757: tempOutputIndex := 1;
1758: open conditionCursor(applicationIdIn => applicationIdIn,
1759: itemClassIdIn => itemClassIdIn);

Line 1809: ame_attributes

1805: select
1806: condition_id id,
1807: ame_condition_pkg.getDescription(condition_id) description
1808: from ame_conditions,
1809: ame_attributes
1810: where
1811: ame_conditions.attribute_id = ame_attributes.attribute_id and
1812: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1813: ame_attributes.attribute_id = attributeIdIn and

Line 1811: ame_conditions.attribute_id = ame_attributes.attribute_id and

1807: ame_condition_pkg.getDescription(condition_id) description
1808: from ame_conditions,
1809: ame_attributes
1810: where
1811: ame_conditions.attribute_id = ame_attributes.attribute_id and
1812: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1813: ame_attributes.attribute_id = attributeIdIn and
1814: condition_type = conditionTypeIn and
1815: sysdate between ame_conditions.start_date and

Line 1812: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

1808: from ame_conditions,
1809: ame_attributes
1810: where
1811: ame_conditions.attribute_id = ame_attributes.attribute_id and
1812: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1813: ame_attributes.attribute_id = attributeIdIn and
1814: condition_type = conditionTypeIn and
1815: sysdate between ame_conditions.start_date and
1816: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 1813: ame_attributes.attribute_id = attributeIdIn and

1809: ame_attributes
1810: where
1811: ame_conditions.attribute_id = ame_attributes.attribute_id and
1812: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1813: ame_attributes.attribute_id = attributeIdIn and
1814: condition_type = conditionTypeIn and
1815: sysdate between ame_conditions.start_date and
1816: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1817: sysdate between ame_attributes.start_date and

Line 1817: sysdate between ame_attributes.start_date and

1813: ame_attributes.attribute_id = attributeIdIn and
1814: condition_type = conditionTypeIn and
1815: sysdate between ame_conditions.start_date and
1816: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1817: sysdate between ame_attributes.start_date and
1818: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1819: order by description;
1820: tempOutputIndex integer;
1821: upperLimit integer;

Line 1818: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

1814: condition_type = conditionTypeIn and
1815: sysdate between ame_conditions.start_date and
1816: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1817: sysdate between ame_attributes.start_date and
1818: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1819: order by description;
1820: tempOutputIndex integer;
1821: upperLimit integer;
1822: begin

Line 1859: ame_attributes

1855: select
1856: ame_conditions.condition_id id,
1857: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1858: from ame_conditions,
1859: ame_attributes
1860: where
1861: ame_conditions.attribute_id = ame_attributes.attribute_id and
1862: ame_attributes.attribute_id = attributeIdIn and
1863: condition_type = conditionTypeIn and

Line 1861: ame_conditions.attribute_id = ame_attributes.attribute_id and

1857: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1858: from ame_conditions,
1859: ame_attributes
1860: where
1861: ame_conditions.attribute_id = ame_attributes.attribute_id and
1862: ame_attributes.attribute_id = attributeIdIn and
1863: condition_type = conditionTypeIn and
1864: ame_attributes.item_class_id = itemClassIdIn and
1865: sysdate between ame_conditions.start_date and

Line 1862: ame_attributes.attribute_id = attributeIdIn and

1858: from ame_conditions,
1859: ame_attributes
1860: where
1861: ame_conditions.attribute_id = ame_attributes.attribute_id and
1862: ame_attributes.attribute_id = attributeIdIn and
1863: condition_type = conditionTypeIn and
1864: ame_attributes.item_class_id = itemClassIdIn and
1865: sysdate between ame_conditions.start_date and
1866: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 1864: ame_attributes.item_class_id = itemClassIdIn and

1860: where
1861: ame_conditions.attribute_id = ame_attributes.attribute_id and
1862: ame_attributes.attribute_id = attributeIdIn and
1863: condition_type = conditionTypeIn and
1864: ame_attributes.item_class_id = itemClassIdIn and
1865: sysdate between ame_conditions.start_date and
1866: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1867: sysdate between ame_attributes.start_date and
1868: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

Line 1867: sysdate between ame_attributes.start_date and

1863: condition_type = conditionTypeIn and
1864: ame_attributes.item_class_id = itemClassIdIn and
1865: sysdate between ame_conditions.start_date and
1866: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1867: sysdate between ame_attributes.start_date and
1868: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1869: order by description;
1870: tempOutputIndex integer;
1871: upperLimit integer;

Line 1868: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

1864: ame_attributes.item_class_id = itemClassIdIn and
1865: sysdate between ame_conditions.start_date and
1866: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1867: sysdate between ame_attributes.start_date and
1868: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1869: order by description;
1870: tempOutputIndex integer;
1871: upperLimit integer;
1872: begin

Line 1913: ame_attributes

1909: select
1910: condition_id id,
1911: ame_condition_pkg.getDescription(condition_id) description
1912: from ame_conditions,
1913: ame_attributes
1914: where
1915: ame_conditions.attribute_id = ame_attributes.attribute_id and
1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1917: ame_attributes.attribute_id = attributeIdIn and

Line 1915: ame_conditions.attribute_id = ame_attributes.attribute_id and

1911: ame_condition_pkg.getDescription(condition_id) description
1912: from ame_conditions,
1913: ame_attributes
1914: where
1915: ame_conditions.attribute_id = ame_attributes.attribute_id and
1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1917: ame_attributes.attribute_id = attributeIdIn and
1918: ame_attributes.item_class_id = itemClassIdIn and
1919: condition_type = conditionTypeIn and

Line 1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

1912: from ame_conditions,
1913: ame_attributes
1914: where
1915: ame_conditions.attribute_id = ame_attributes.attribute_id and
1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1917: ame_attributes.attribute_id = attributeIdIn and
1918: ame_attributes.item_class_id = itemClassIdIn and
1919: condition_type = conditionTypeIn and
1920: sysdate between ame_conditions.start_date and

Line 1917: ame_attributes.attribute_id = attributeIdIn and

1913: ame_attributes
1914: where
1915: ame_conditions.attribute_id = ame_attributes.attribute_id and
1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1917: ame_attributes.attribute_id = attributeIdIn and
1918: ame_attributes.item_class_id = itemClassIdIn and
1919: condition_type = conditionTypeIn and
1920: sysdate between ame_conditions.start_date and
1921: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 1918: ame_attributes.item_class_id = itemClassIdIn and

1914: where
1915: ame_conditions.attribute_id = ame_attributes.attribute_id and
1916: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
1917: ame_attributes.attribute_id = attributeIdIn and
1918: ame_attributes.item_class_id = itemClassIdIn and
1919: condition_type = conditionTypeIn and
1920: sysdate between ame_conditions.start_date and
1921: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1922: sysdate between ame_attributes.start_date and

Line 1922: sysdate between ame_attributes.start_date and

1918: ame_attributes.item_class_id = itemClassIdIn and
1919: condition_type = conditionTypeIn and
1920: sysdate between ame_conditions.start_date and
1921: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1922: sysdate between ame_attributes.start_date and
1923: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1924: order by description;
1925: tempOutputIndex integer;
1926: upperLimit integer;

Line 1923: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

1919: condition_type = conditionTypeIn and
1920: sysdate between ame_conditions.start_date and
1921: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1922: sysdate between ame_attributes.start_date and
1923: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
1924: order by description;
1925: tempOutputIndex integer;
1926: upperLimit integer;
1927: begin

Line 2288: attributeType ame_attributes.attribute_type%type;

2284: condition_id = conditionIdIn and
2285: sysdate between start_date and
2286: nvl(end_date - ame_util.oneSecond, sysdate)
2287: for update;
2288: attributeType ame_attributes.attribute_type%type;
2289: conditionType ame_conditions.condition_type%type;
2290: currentUserId integer;
2291: errorCode integer;
2292: errorMessage ame_util.longestStringType;