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

Line 404: ame_attribute_usages

400: begin
401: select count(1)
402: into atrCount
403: from ame_attributes,
404: ame_attribute_usages
405: where ame_attribute_usages.attribute_id = ame_attributes.attribute_id
406: and ame_attribute_usages.application_id = applicationIdIn
407: and ame_attributes.item_class_id = itemClassIdIn
408: and sysdate between ame_attribute_usages.start_date and

Line 405: where ame_attribute_usages.attribute_id = ame_attributes.attribute_id

401: select count(1)
402: into atrCount
403: from ame_attributes,
404: ame_attribute_usages
405: where ame_attribute_usages.attribute_id = ame_attributes.attribute_id
406: and ame_attribute_usages.application_id = applicationIdIn
407: and ame_attributes.item_class_id = itemClassIdIn
408: and sysdate between ame_attribute_usages.start_date and
409: nvl(ame_attribute_usages.end_date - ame_util.oneSecond,sysdate)

Line 406: and ame_attribute_usages.application_id = applicationIdIn

402: into atrCount
403: from ame_attributes,
404: ame_attribute_usages
405: where ame_attribute_usages.attribute_id = ame_attributes.attribute_id
406: and ame_attribute_usages.application_id = applicationIdIn
407: and ame_attributes.item_class_id = itemClassIdIn
408: and sysdate between ame_attribute_usages.start_date and
409: nvl(ame_attribute_usages.end_date - ame_util.oneSecond,sysdate)
410: and sysdate between ame_attributes.start_date and

Line 408: and sysdate between ame_attribute_usages.start_date and

404: ame_attribute_usages
405: where ame_attribute_usages.attribute_id = ame_attributes.attribute_id
406: and ame_attribute_usages.application_id = applicationIdIn
407: and ame_attributes.item_class_id = itemClassIdIn
408: and sysdate between ame_attribute_usages.start_date and
409: nvl(ame_attribute_usages.end_date - ame_util.oneSecond,sysdate)
410: and sysdate between ame_attributes.start_date and
411: nvl(ame_attributes.end_date - ame_util.oneSecond,sysdate);
412: if(atrCount > 0) then

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

405: where ame_attribute_usages.attribute_id = ame_attributes.attribute_id
406: and ame_attribute_usages.application_id = applicationIdIn
407: and ame_attributes.item_class_id = itemClassIdIn
408: and sysdate between ame_attribute_usages.start_date and
409: nvl(ame_attribute_usages.end_date - ame_util.oneSecond,sysdate)
410: and sysdate between ame_attributes.start_date and
411: nvl(ame_attributes.end_date - ame_util.oneSecond,sysdate);
412: if(atrCount > 0) then
413: retValue := 'Enabled';

Line 586: ame_attribute_usages,

582: ame_attributes.attribute_type,
583: ame_attributes.approver_type_id
584: from
585: ame_attributes,
586: ame_attribute_usages,
587: ame_item_classes
588: where
589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
590: ame_attributes.item_class_id = ame_item_classes.item_class_id and

Line 589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

585: ame_attributes,
586: ame_attribute_usages,
587: ame_item_classes
588: where
589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
590: ame_attributes.item_class_id = ame_item_classes.item_class_id and
591: ame_item_classes.item_class_id = headerItemClassIdIn and
592: ame_attribute_usages.application_id = applicationIdIn and
593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and

Line 592: ame_attribute_usages.application_id = applicationIdIn and

588: where
589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
590: ame_attributes.item_class_id = ame_item_classes.item_class_id and
591: ame_item_classes.item_class_id = headerItemClassIdIn and
592: ame_attribute_usages.application_id = applicationIdIn and
593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
594: ame_attributes.attribute_id not in
595: (select attribute_id from ame_mandatory_attributes
596: where action_type_id = -1 and

Line 601: sysdate between ame_attribute_usages.start_date and

597: sysdate between ame_mandatory_attributes.start_date and
598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
599: sysdate between ame_attributes.start_date and
600: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
601: sysdate between ame_attribute_usages.start_date and
602: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
603: sysdate between ame_item_classes.start_date and
604: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
605: order by ame_attributes.name;

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

598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
599: sysdate between ame_attributes.start_date and
600: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
601: sysdate between ame_attribute_usages.start_date and
602: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
603: sysdate between ame_item_classes.start_date and
604: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
605: order by ame_attributes.name;
606: tempIndex integer;

Line 641: ,ame_attribute_usages atu

637: ,atr.name
638: ,atr.attribute_type
639: ,atr.approver_type_id
640: from ame_attributes atr
641: ,ame_attribute_usages atu
642: where atr.name in (ame_util.jobLevelStartingPointAttribute
643: ,ame_util.nonDefStartingPointPosAttr
644: ,ame_util.nonDefPosStructureAttr
645: ,ame_util.supStartingPointAttribute