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_ADMIN_PKG dependencies on AME_ATTRIBUTE_USAGES

Line 687: ame_attribute_usages,

683: begin
684: select count(*)
685: into lineItemCount
686: from
687: ame_attribute_usages,
688: ame_attributes
689: where
690: ame_attributes.line_item = ame_util.booleanTrue and
691: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

Line 691: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

687: ame_attribute_usages,
688: ame_attributes
689: where
690: ame_attributes.line_item = ame_util.booleanTrue and
691: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
692: ame_attribute_usages.application_id = applicationIdIn and
693: sysdate between ame_attribute_usages.start_date and
694: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
695: sysdate between ame_attributes.start_date and

Line 692: ame_attribute_usages.application_id = applicationIdIn and

688: ame_attributes
689: where
690: ame_attributes.line_item = ame_util.booleanTrue and
691: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
692: ame_attribute_usages.application_id = applicationIdIn and
693: sysdate between ame_attribute_usages.start_date and
694: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
695: sysdate between ame_attributes.start_date and
696: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;

Line 693: sysdate between ame_attribute_usages.start_date and

689: where
690: ame_attributes.line_item = ame_util.booleanTrue and
691: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
692: ame_attribute_usages.application_id = applicationIdIn and
693: sysdate between ame_attribute_usages.start_date and
694: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
695: sysdate between ame_attributes.start_date and
696: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
697: if(lineItemCount > 0) then

Line 694: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

690: ame_attributes.line_item = ame_util.booleanTrue and
691: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
692: ame_attribute_usages.application_id = applicationIdIn and
693: sysdate between ame_attribute_usages.start_date and
694: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
695: sysdate between ame_attributes.start_date and
696: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;
697: if(lineItemCount > 0) then
698: return(true);

Line 745: ame_attribute_usages,

741: begin
742: select count(*)
743: into attributeUsageCount
744: from
745: ame_attribute_usages,
746: ame_attributes
747: where
748: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
749: ame_attribute_usages.application_id = applicationIdIn and

Line 748: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and

744: from
745: ame_attribute_usages,
746: ame_attributes
747: where
748: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
749: ame_attribute_usages.application_id = applicationIdIn and
750: ame_attributes.item_class_id = itemClassIdIn and
751: sysdate between ame_attribute_usages.start_date and
752: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

Line 749: ame_attribute_usages.application_id = applicationIdIn and

745: ame_attribute_usages,
746: ame_attributes
747: where
748: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
749: ame_attribute_usages.application_id = applicationIdIn and
750: ame_attributes.item_class_id = itemClassIdIn and
751: sysdate between ame_attribute_usages.start_date and
752: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
753: sysdate between ame_attributes.start_date and

Line 751: sysdate between ame_attribute_usages.start_date and

747: where
748: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
749: ame_attribute_usages.application_id = applicationIdIn and
750: ame_attributes.item_class_id = itemClassIdIn and
751: sysdate between ame_attribute_usages.start_date and
752: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
753: sysdate between ame_attributes.start_date and
754: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
755: if(attributeUsageCount > 0) then

Line 752: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and

748: ame_attribute_usages.attribute_id = ame_attributes.attribute_id and
749: ame_attribute_usages.application_id = applicationIdIn and
750: ame_attributes.item_class_id = itemClassIdIn and
751: sysdate between ame_attribute_usages.start_date and
752: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
753: sysdate between ame_attributes.start_date and
754: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
755: if(attributeUsageCount > 0) then
756: return(true);

Line 1468: from ame_attribute_usages

1464: */
1465: /*
1466: select count(*)
1467: into tempIndex
1468: from ame_attribute_usages
1469: where
1470: attribute_id = attributeIdIn and
1471: application_id = applicationIdIn and
1472: is_striping_attribute = ame_util.booleanTrue and

Line 1540: from ame_attribute_usages

1536: /* Determine whether this is the first striping attribute. */
1537: /*
1538: select count(*)
1539: into stripingAttributeCount
1540: from ame_attribute_usages
1541: where
1542: application_id = applicationIdIn and
1543: is_striping_attribute = ame_util.booleanTrue and
1544: (start_date <= sysdate and

Line 4530: evalQueryString ame_attribute_usages.query_string%type;

4526: errorMessage ame_util.longestStringType;
4527: evalAttributeId ame_attributes.attribute_id%type;
4528: evalPrioritiesPerItemAttId integer;
4529: evalPriorityStartDate ame_util.stringType;
4530: evalQueryString ame_attribute_usages.query_string%type;
4531: evalStaticUsage ame_attribute_usages.is_static%type;
4532: finalize boolean;
4533: found number;
4534: groupList ame_util.idList;

Line 4531: evalStaticUsage ame_attribute_usages.is_static%type;

4527: evalAttributeId ame_attributes.attribute_id%type;
4528: evalPrioritiesPerItemAttId integer;
4529: evalPriorityStartDate ame_util.stringType;
4530: evalQueryString ame_attribute_usages.query_string%type;
4531: evalStaticUsage ame_attribute_usages.is_static%type;
4532: finalize boolean;
4533: found number;
4534: groupList ame_util.idList;
4535: orderNumber integer;

Line 4540: staticUsage ame_attribute_usages.is_static%type;

4536: queryStrings ame_util.longestStringList;
4537: ruleType integer;
4538: ruleTypes ame_util.idList;
4539: startDate ame_util.stringType;
4540: staticUsage ame_attribute_usages.is_static%type;
4541: staticUsages ame_util.stringList;
4542: tempIndex integer;
4543: tempIndex2 integer;
4544: useRestrItemEvalAttId integer;

Line 5588: queryString ame_attribute_usages.query_string%type;

5584: attributeCount integer;
5585: endDate date;
5586: lineItemAttribute ame_attributes.line_item%type;
5587: newStartDate date;
5588: queryString ame_attribute_usages.query_string%type;
5589: staticUsage ame_attribute_usages.is_static%type;
5590: stripingAttributeIds ame_util.idList;
5591: stripingAttributeNames ame_util.stringList;
5592: begin

Line 5589: staticUsage ame_attribute_usages.is_static%type;

5585: endDate date;
5586: lineItemAttribute ame_attributes.line_item%type;
5587: newStartDate date;
5588: queryString ame_attribute_usages.query_string%type;
5589: staticUsage ame_attribute_usages.is_static%type;
5590: stripingAttributeIds ame_util.idList;
5591: stripingAttributeNames ame_util.stringList;
5592: begin
5593: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then