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_API3 dependencies on AME_ATTRIBUTES

Line 706: ame_attributes.name,

702: currencyCodeOut out nocopy varchar2,
703: allowedValuesOut out nocopy ame_util.longestStringList) as
704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,
708: ame_attributes.description,
709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,

Line 707: ame_attributes.attribute_type,

703: allowedValuesOut out nocopy ame_util.longestStringList) as
704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,
708: ame_attributes.description,
709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,
711: ame_conditions.include_lower_limit,

Line 708: ame_attributes.description,

704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,
708: ame_attributes.description,
709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,
711: ame_conditions.include_lower_limit,
712: ame_conditions.include_upper_limit,

Line 724: ame_attributes,

720: includeLowerLimitOut,
721: includeUpperLimitOut,
722: currencyCodeOut
723: from
724: ame_attributes,
725: ame_conditions
726: where
727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and

Line 727: ame_attributes.attribute_id = ame_conditions.attribute_id and

723: from
724: ame_attributes,
725: ame_conditions
726: where
727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 730: ame_attributes.start_date and

726: where
727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

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

727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
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

Line 2046: decode(ame_attributes.attribute_type,

2042: cursor conditionCursor(ruleIdIn in integer) is
2043: select
2044: ame_conditions.condition_id,
2045: ame_condition_pkg.getDescription(ame_conditions.condition_id),
2046: decode(ame_attributes.attribute_type,
2047: ame_util.stringAttributeType, ame_util.booleanTrue,
2048: /* default */ ame_util.booleanFalse)
2049: from
2050: ame_conditions,

Line 2052: ame_attributes

2048: /* default */ ame_util.booleanFalse)
2049: from
2050: ame_conditions,
2051: ame_condition_usages,
2052: ame_attributes
2053: where
2054: ame_condition_usages.rule_id = ruleIdIn and
2055: ame_conditions.condition_id = ame_condition_usages.condition_id and
2056: ame_attributes.attribute_id = ame_conditions.attribute_id and

Line 2056: ame_attributes.attribute_id = ame_conditions.attribute_id and

2052: ame_attributes
2053: where
2054: ame_condition_usages.rule_id = ruleIdIn and
2055: ame_conditions.condition_id = ame_condition_usages.condition_id and
2056: ame_attributes.attribute_id = ame_conditions.attribute_id and
2057: sysdate between
2058: ame_condition_usages.start_date and
2059: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
2060: sysdate between

Line 2064: ame_attributes.start_date and

2060: sysdate between
2061: ame_conditions.start_date and
2062: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
2063: sysdate between
2064: ame_attributes.start_date and
2065: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
2066: cursor ruleCursor is
2067: select
2068: ame_rules.rule_type,

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

2061: ame_conditions.start_date and
2062: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
2063: sysdate between
2064: ame_attributes.start_date and
2065: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
2066: cursor ruleCursor is
2067: select
2068: ame_rules.rule_type,
2069: ame_rules.description