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_ACTION_TYPES

Line 1717: ame_action_types.name,

1713: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1714: actionDescriptionsOut out nocopy ame_util.stringList) as
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,

Line 1718: ame_action_types.description,

1714: actionDescriptionsOut out nocopy ame_util.stringList) as
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,

Line 1722: ame_action_types,

1718: ame_action_types.description,
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

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 1732: ame_action_types.start_date 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
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);

Line 1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) 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

Line 1790: ame_action_types.name,

1786: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1787: actionDescriptionsOut out nocopy ame_util.stringList) as
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,

Line 1791: ame_action_types.description,

1787: actionDescriptionsOut out nocopy ame_util.stringList) as
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,

Line 1795: ame_action_types,

1791: ame_action_types.description,
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

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 1805: ame_action_types.start_date 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
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);

Line 1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) 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

Line 1865: ame_action_types.name,

1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1862: actionDescriptionsOut out nocopy ame_util.stringList) as
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,

Line 1866: ame_action_types.description,

1862: actionDescriptionsOut out nocopy ame_util.stringList) as
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,

Line 1870: ame_action_types,

1866: ame_action_types.description,
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

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 1880: ame_action_types.start_date 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
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);

Line 1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) 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