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 520: attributeType ame_attributes.attribute_type%type;

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

Line 525: ame_attributes,

521: begin
522: select attribute_type
523: into attributeType
524: from
525: ame_attributes,
526: ame_conditions
527: where
528: ame_conditions.condition_id = conditionIdIn and
529: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 529: ame_attributes.attribute_id = ame_conditions.attribute_id and

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

Line 532: sysdate between ame_attributes.start_date and

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

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

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

Line 809: ame_attributes,

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

Line 812: ame_attributes.attribute_id = ame_conditions.attribute_id and

808: ame_attribute_usages,
809: ame_attributes,
810: ame_conditions
811: where
812: ame_attributes.attribute_id = ame_conditions.attribute_id and
813: ame_conditions.condition_type = conditionTypeIn and
814: ame_attributes.line_item = ame_util.booleanTrue and
815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
816: ame_attribute_usages.application_id = applicationIdIn and

Line 814: ame_attributes.line_item = ame_util.booleanTrue and

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

Line 815: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

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

Line 822: sysdate between ame_attributes.start_date and

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

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

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

Line 861: attributeType ame_attributes.attribute_type%type;

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

Line 1476: attributeType ame_attributes.attribute_type%type;

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

Line 1721: ame_attributes.attribute_id,

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

Line 1722: ame_attributes.name,

1718: select
1719: ame_conditions.condition_id id,
1720: ame_conditions.condition_type,
1721: ame_attributes.attribute_id,
1722: ame_attributes.name,
1723: ame_attributes.attribute_type
1724: from ame_conditions,
1725: ame_attributes,
1726: ame_attribute_usages,

Line 1723: ame_attributes.attribute_type

1719: ame_conditions.condition_id id,
1720: ame_conditions.condition_type,
1721: ame_attributes.attribute_id,
1722: ame_attributes.name,
1723: ame_attributes.attribute_type
1724: from ame_conditions,
1725: ame_attributes,
1726: ame_attribute_usages,
1727: ame_item_class_usages

Line 1725: ame_attributes,

1721: ame_attributes.attribute_id,
1722: ame_attributes.name,
1723: ame_attributes.attribute_type
1724: from ame_conditions,
1725: ame_attributes,
1726: ame_attribute_usages,
1727: ame_item_class_usages
1728: where
1729: ame_attribute_usages.application_id = ame_item_class_usages.application_id and

Line 1733: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

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

Line 1734: ame_attributes.item_class_id = itemClassIdIn and

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

Line 1738: sysdate between ame_attributes.start_date and

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

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

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

Line 1745: ame_attributes.attribute_type,

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

Line 1746: ame_attributes.name;

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

Line 1751: attributeName ame_attributes.name%type;

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

Line 1752: attributeType ame_attributes.attribute_type%type;

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

Line 1806: ame_attributes

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

Line 1808: ame_conditions.attribute_id = ame_attributes.attribute_id and

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

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

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

Line 1810: ame_attributes.attribute_id = attributeIdIn and

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

Line 1814: sysdate between ame_attributes.start_date and

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

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

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

Line 1856: ame_attributes

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

Line 1858: ame_conditions.attribute_id = ame_attributes.attribute_id and

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

Line 1859: ame_attributes.attribute_id = attributeIdIn and

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

Line 1861: ame_attributes.item_class_id = itemClassIdIn and

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

Line 1864: sysdate between ame_attributes.start_date and

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

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

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

Line 1910: ame_attributes

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

Line 1912: ame_conditions.attribute_id = ame_attributes.attribute_id and

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

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

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

Line 1914: ame_attributes.attribute_id = attributeIdIn and

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

Line 1915: ame_attributes.item_class_id = itemClassIdIn and

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

Line 1919: sysdate between ame_attributes.start_date and

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

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

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

Line 2285: attributeType ame_attributes.attribute_type%type;

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