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 1887: ame_conditions.condition_id,

1883: ame_actions.start_date and
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)

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

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

Line 1893: ame_conditions,

1889: decode(ame_attributes.attribute_type,
1890: ame_util.stringAttributeType, ame_util.booleanTrue,
1891: /* default */ ame_util.booleanFalse)
1892: from
1893: ame_conditions,
1894: ame_condition_usages,
1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and

Line 1898: ame_conditions.condition_id = ame_condition_usages.condition_id and

1894: ame_condition_usages,
1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1899: ame_attributes.attribute_id = ame_conditions.attribute_id and

1895: ame_attributes
1896: where
1897: ame_condition_usages.rule_id = ruleIdIn and
1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between

Line 1904: ame_conditions.start_date and

1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between
1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

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

1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between
1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is