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 1874: ame_action_types.name,

1870: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1871: actionDescriptionsOut out nocopy ame_util.stringList) as
1872: cursor actionCursor is
1873: select
1874: ame_action_types.name,
1875: ame_action_types.description,
1876: ame_actions.description
1877: from
1878: ame_action_usages,

Line 1875: ame_action_types.description,

1871: actionDescriptionsOut out nocopy ame_util.stringList) as
1872: cursor actionCursor is
1873: select
1874: ame_action_types.name,
1875: ame_action_types.description,
1876: ame_actions.description
1877: from
1878: ame_action_usages,
1879: ame_action_types,

Line 1879: ame_action_types,

1875: ame_action_types.description,
1876: ame_actions.description
1877: from
1878: ame_action_usages,
1879: ame_action_types,
1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and

Line 1884: ame_action_types.action_type_id = ame_actions.action_type_id and

1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1888: sysdate between

Line 1889: ame_action_types.start_date and

1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1888: sysdate between
1889: ame_action_types.start_date and
1890: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1891: sysdate between
1892: ame_actions.start_date and
1893: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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

1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1888: sysdate between
1889: ame_action_types.start_date and
1890: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1891: sysdate between
1892: ame_actions.start_date and
1893: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1894: cursor conditionCursor(ruleIdIn in integer) is

Line 1947: ame_action_types.name,

1943: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1944: actionDescriptionsOut out nocopy ame_util.stringList) as
1945: cursor actionCursor is
1946: select
1947: ame_action_types.name,
1948: ame_action_types.description,
1949: ame_actions.description
1950: from
1951: ame_action_usages,

Line 1948: ame_action_types.description,

1944: actionDescriptionsOut out nocopy ame_util.stringList) as
1945: cursor actionCursor is
1946: select
1947: ame_action_types.name,
1948: ame_action_types.description,
1949: ame_actions.description
1950: from
1951: ame_action_usages,
1952: ame_action_types,

Line 1952: ame_action_types,

1948: ame_action_types.description,
1949: ame_actions.description
1950: from
1951: ame_action_usages,
1952: ame_action_types,
1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and

Line 1957: ame_action_types.action_type_id = ame_actions.action_type_id and

1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1961: sysdate between

Line 1962: ame_action_types.start_date and

1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1961: sysdate between
1962: ame_action_types.start_date and
1963: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1964: sysdate between
1965: ame_actions.start_date and
1966: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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

1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1961: sysdate between
1962: ame_action_types.start_date and
1963: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1964: sysdate between
1965: ame_actions.start_date and
1966: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1967: cursor conditionCursor(ruleIdIn in integer) is

Line 2022: ame_action_types.name,

2018: actionTypeDescriptionsOut out nocopy ame_util.stringList,
2019: actionDescriptionsOut out nocopy ame_util.stringList) as
2020: cursor actionCursor is
2021: select
2022: ame_action_types.name,
2023: ame_action_types.description,
2024: ame_actions.description
2025: from
2026: ame_action_usages,

Line 2023: ame_action_types.description,

2019: actionDescriptionsOut out nocopy ame_util.stringList) as
2020: cursor actionCursor is
2021: select
2022: ame_action_types.name,
2023: ame_action_types.description,
2024: ame_actions.description
2025: from
2026: ame_action_usages,
2027: ame_action_types,

Line 2027: ame_action_types,

2023: ame_action_types.description,
2024: ame_actions.description
2025: from
2026: ame_action_usages,
2027: ame_action_types,
2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and

Line 2032: ame_action_types.action_type_id = ame_actions.action_type_id and

2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2036: sysdate between

Line 2037: ame_action_types.start_date and

2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2036: sysdate between
2037: ame_action_types.start_date and
2038: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2039: sysdate between
2040: ame_actions.start_date and
2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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

2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2036: sysdate between
2037: ame_action_types.start_date and
2038: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2039: sysdate between
2040: ame_actions.start_date and
2041: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
2042: cursor conditionCursor(ruleIdIn in integer) is