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_ATTRIBUTE_API dependencies on AME_RULE_USAGES

Line 804: from ame_rule_usages

800: function calculateUseCount(attributeIdIn in integer,
801: applicationIdIn in integer) return integer as
802: cursor ruleCursor(applicationIdIn in integer) is
803: select rule_id
804: from ame_rule_usages
805: where
806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 806: ame_rule_usages.item_id = applicationIdIn and

802: cursor ruleCursor(applicationIdIn in integer) is
803: select rule_id
804: from ame_rule_usages
805: where
806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

Line 807: ((sysdate between ame_rule_usages.start_date and

803: select rule_id
804: from ame_rule_usages
805: where
806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));

Line 808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

804: from ame_rule_usages
805: where
806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));
812: ruleCount integer;

Line 809: (sysdate < ame_rule_usages.start_date and

805: where
806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));
812: ruleCount integer;
813: tempCount integer;

Line 810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

806: ame_rule_usages.item_id = applicationIdIn and
807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));
812: ruleCount integer;
813: tempCount integer;
814: useCount integer;

Line 811: ame_rule_usages.start_date + ame_util.oneSecond)));

807: ((sysdate between ame_rule_usages.start_date and
808: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
809: (sysdate < ame_rule_usages.start_date and
810: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
811: ame_rule_usages.start_date + ame_util.oneSecond)));
812: ruleCount integer;
813: tempCount integer;
814: useCount integer;
815: begin