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_CONDITIONS

Line 709: ame_conditions.parameter_one,

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,
713: ame_conditions.parameter_three

Line 710: ame_conditions.parameter_two,

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,
713: ame_conditions.parameter_three
714: into

Line 711: ame_conditions.include_lower_limit,

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,
713: ame_conditions.parameter_three
714: into
715: attributeNameOut,

Line 712: ame_conditions.include_upper_limit,

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,
713: ame_conditions.parameter_three
714: into
715: attributeNameOut,
716: attributeTypeOut,

Line 713: ame_conditions.parameter_three

709: ame_conditions.parameter_one,
710: ame_conditions.parameter_two,
711: ame_conditions.include_lower_limit,
712: ame_conditions.include_upper_limit,
713: ame_conditions.parameter_three
714: into
715: attributeNameOut,
716: attributeTypeOut,
717: attributeDescriptionOut,

Line 725: ame_conditions

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
729: sysdate between

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 728: ame_conditions.condition_id = conditionIdIn and

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
732: sysdate between

Line 733: ame_conditions.start_date 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
736: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdIn,
737: stringValueListOut => allowedValuesOut);

Line 734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

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
736: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdIn,
737: stringValueListOut => allowedValuesOut);
738: end if;

Line 2044: ame_conditions.condition_id,

2040: ame_actions.start_date and
2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
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)

Line 2045: ame_condition_pkg.getDescription(ame_conditions.condition_id),

2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
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

Line 2050: ame_conditions,

2046: decode(ame_attributes.attribute_type,
2047: ame_util.stringAttributeType, ame_util.booleanTrue,
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

Line 2055: ame_conditions.condition_id = ame_condition_usages.condition_id and

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
2057: sysdate between
2058: ame_condition_usages.start_date and
2059: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) 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 2061: ame_conditions.start_date 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
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);

Line 2062: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

2058: ame_condition_usages.start_date and
2059: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) 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