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_ATTRIBUTES

Line 688: ame_attributes

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
692: ame_attribute_usages.application_id = applicationIdIn and

Line 690: ame_attributes.line_item = ame_util.booleanTrue and

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
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

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 695: sysdate between ame_attributes.start_date 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);
699: end if;

Line 696: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) ;

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);
699: end if;
700: return(false);

Line 746: ame_attributes

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
750: ame_attributes.item_class_id = itemClassIdIn 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 750: ame_attributes.item_class_id = itemClassIdIn and

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
754: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

Line 753: sysdate between ame_attributes.start_date 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);
757: end if;

Line 754: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

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);
757: end if;
758: return(false);

Line 4506: to_char(ame_attributes.start_date) start_date

4502: staticUsagesIn in ame_util.stringList,
4503: versionStartDatesIn in ame_util.stringList) as
4504: cursor attributeCursor(attributeIdIn in integer) is
4505: select
4506: to_char(ame_attributes.start_date) start_date
4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where

Line 4508: ame_attributes,

4504: cursor attributeCursor(attributeIdIn in integer) is
4505: select
4506: to_char(ame_attributes.start_date) start_date
4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and

Line 4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 4512: ame_attributes.attribute_id = attributeIdIn and

4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and

Line 4514: sysdate between ame_attributes.start_date and

4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4518: for update;

Line 4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4518: for update;
4519: actionTypeIds ame_util.idList;

Line 4523: attributeName ame_attributes.name%type;

4519: actionTypeIds ame_util.idList;
4520: applicationId integer;
4521: attributeCount integer;
4522: attributeIds ame_util.stringList;
4523: attributeName ame_attributes.name%type;
4524: currentUserId integer;
4525: errorCode varchar2(10);
4526: errorMessage ame_util.longestStringType;
4527: evalAttributeId ame_attributes.attribute_id%type;

Line 4527: evalAttributeId ame_attributes.attribute_id%type;

4523: attributeName ame_attributes.name%type;
4524: currentUserId integer;
4525: errorCode varchar2(10);
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;

Line 5343: itemClassId ame_attributes.item_class_id%type;

5339: attributeIdsList ame_util.idList;
5340: currentUserId integer;
5341: errorCode integer;
5342: errorMessage ame_util.longestStringType;
5343: itemClassId ame_attributes.item_class_id%type;
5344: startDate date;
5345: tempIndex integer;
5346: versionStartDate date;
5347: childVersionStartDate date;

Line 5586: lineItemAttribute ame_attributes.line_item%type;

5582: AME_STRIPING
5583: procedure updateStripingAttUseCount(applicationIdIn in integer) as
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;