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_ACTIONS

Line 1719: ame_actions.description

1715: cursor actionCursor is
1716: select
1717: ame_action_types.name,
1718: ame_action_types.description,
1719: ame_actions.description
1720: from
1721: ame_action_usages,
1722: ame_action_types,
1723: ame_actions

Line 1723: ame_actions

1719: ame_actions.description
1720: from
1721: ame_action_usages,
1722: ame_action_types,
1723: ame_actions
1724: where
1725: ame_action_usages.rule_id = ruleIdIn and
1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and

Line 1726: ame_actions.action_id = ame_action_usages.action_id and

1722: ame_action_types,
1723: ame_actions
1724: where
1725: ame_action_usages.rule_id = ruleIdIn and
1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1727: ame_action_types.action_type_id = ame_actions.action_type_id and

1723: ame_actions
1724: where
1725: ame_action_usages.rule_id = ruleIdIn and
1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1731: sysdate between

Line 1735: ame_actions.start_date and

1731: sysdate between
1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1734: sysdate between
1735: ame_actions.start_date and
1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1737: cursor conditionCursor(ruleIdIn in integer) is
1738: select condition_id
1739: from ame_condition_usages

Line 1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1734: sysdate between
1735: ame_actions.start_date and
1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1737: cursor conditionCursor(ruleIdIn in integer) is
1738: select condition_id
1739: from ame_condition_usages
1740: where

Line 1792: ame_actions.description

1788: cursor actionCursor is
1789: select
1790: ame_action_types.name,
1791: ame_action_types.description,
1792: ame_actions.description
1793: from
1794: ame_action_usages,
1795: ame_action_types,
1796: ame_actions

Line 1796: ame_actions

1792: ame_actions.description
1793: from
1794: ame_action_usages,
1795: ame_action_types,
1796: ame_actions
1797: where
1798: ame_action_usages.rule_id = ruleIdIn and
1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and

Line 1799: ame_actions.action_id = ame_action_usages.action_id and

1795: ame_action_types,
1796: ame_actions
1797: where
1798: ame_action_usages.rule_id = ruleIdIn and
1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1800: ame_action_types.action_type_id = ame_actions.action_type_id and

1796: ame_actions
1797: where
1798: ame_action_usages.rule_id = ruleIdIn and
1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1804: sysdate between

Line 1808: ame_actions.start_date and

1804: sysdate between
1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1807: sysdate between
1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages

Line 1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1807: sysdate between
1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages
1813: where

Line 1867: ame_actions.description

1863: cursor actionCursor is
1864: select
1865: ame_action_types.name,
1866: ame_action_types.description,
1867: ame_actions.description
1868: from
1869: ame_action_usages,
1870: ame_action_types,
1871: ame_actions

Line 1871: ame_actions

1867: ame_actions.description
1868: from
1869: ame_action_usages,
1870: ame_action_types,
1871: ame_actions
1872: where
1873: ame_action_usages.rule_id = ruleIdIn and
1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and

Line 1874: ame_actions.action_id = ame_action_usages.action_id and

1870: ame_action_types,
1871: ame_actions
1872: where
1873: ame_action_usages.rule_id = ruleIdIn and
1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1875: ame_action_types.action_type_id = ame_actions.action_type_id and

1871: ame_actions
1872: where
1873: ame_action_usages.rule_id = ruleIdIn and
1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1879: sysdate between

Line 1883: ame_actions.start_date and

1879: sysdate between
1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1882: sysdate between
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,

Line 1884: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1882: sysdate between
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),