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_RULE_PKG dependencies on AME_ACTION_TYPE_USAGES

Line 1355: from ame_action_type_usages

1351: function hasATUsageForRuleType(ruleTypeIn in integer,
1352: actionTypeIdsIn in ame_util.idList) return boolean as
1353: cursor actionTypeUsagesCur(actionTypeIdIn in integer) is
1354: select rule_type
1355: from ame_action_type_usages
1356: where
1357: action_type_id = actionTypeIdIn and
1358: sysdate between start_date and
1359: nvl(end_date - ame_util.oneSecond, sysdate);

Line 1382: select ame_action_type_usages.rule_type

1378: end hasATUsageForRuleType;
1379: function hasATUsageForRuleType2(ruleTypeIn in integer,
1380: actionIdsIn in ame_util.idList) return boolean as
1381: cursor actionTypeUsagesCur(actionIdIn in integer) is
1382: select ame_action_type_usages.rule_type
1383: from ame_action_type_usages,
1384: ame_action_types,
1385: ame_actions
1386: where

Line 1383: from ame_action_type_usages,

1379: function hasATUsageForRuleType2(ruleTypeIn in integer,
1380: actionIdsIn in ame_util.idList) return boolean as
1381: cursor actionTypeUsagesCur(actionIdIn in integer) is
1382: select ame_action_type_usages.rule_type
1383: from ame_action_type_usages,
1384: ame_action_types,
1385: ame_actions
1386: where
1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

Line 1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

1383: from ame_action_type_usages,
1384: ame_action_types,
1385: ame_actions
1386: where
1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
1388: ame_action_types.action_type_id = ame_actions.action_type_id and
1389: ame_actions.action_id = actionIdIn and
1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1390: sysdate between ame_action_type_usages.start_date and

1386: where
1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
1388: ame_action_types.action_type_id = ame_actions.action_type_id and
1389: ame_actions.action_id = actionIdIn and
1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1392: sysdate between ame_action_types.start_date and
1393: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1394: sysdate between ame_actions.start_date and

Line 1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and

1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
1388: ame_action_types.action_type_id = ame_actions.action_type_id and
1389: ame_actions.action_id = actionIdIn and
1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1392: sysdate between ame_action_types.start_date and
1393: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1394: sysdate between ame_actions.start_date and
1395: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

Line 1546: ame_action_type_usages

1542: into subOrListModActionCount
1543: from ame_action_usages,
1544: ame_actions,
1545: ame_action_types,
1546: ame_action_type_usages
1547: where ame_action_usages.rule_id = ruleIdIn and
1548: ame_action_usages.action_id = ame_actions.action_id and
1549: ame_action_types.action_type_id = ame_actions.action_type_id and
1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and

Line 1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and

1546: ame_action_type_usages
1547: where ame_action_usages.rule_id = ruleIdIn and
1548: ame_action_usages.action_id = ame_actions.action_id and
1549: ame_action_types.action_type_id = ame_actions.action_type_id and
1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,
1552: ame_util.listModRuleType) and
1553: sysdate between ame_action_usages.start_date and
1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,

1547: where ame_action_usages.rule_id = ruleIdIn and
1548: ame_action_usages.action_id = ame_actions.action_id and
1549: ame_action_types.action_type_id = ame_actions.action_type_id and
1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,
1552: ame_util.listModRuleType) and
1553: sysdate between ame_action_usages.start_date and
1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1555: sysdate between ame_action_type_usages.start_date and

Line 1555: sysdate between ame_action_type_usages.start_date and

1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,
1552: ame_util.listModRuleType) and
1553: sysdate between ame_action_usages.start_date and
1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1555: sysdate between ame_action_type_usages.start_date and
1556: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1557: sysdate between ame_action_types.start_date and
1558: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1559: sysdate between ame_actions.start_date and

Line 1556: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and

1552: ame_util.listModRuleType) and
1553: sysdate between ame_action_usages.start_date and
1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1555: sysdate between ame_action_type_usages.start_date and
1556: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1557: sysdate between ame_action_types.start_date and
1558: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1559: sysdate between ame_actions.start_date and
1560: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);