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_ATTRIBUTES

Line 403: from ame_attributes,

399: atrCount number;
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

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

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

Line 410: and sysdate between ame_attributes.start_date and

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';
414: end if;

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

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';
414: end if;
415: return retValue;

Line 580: ame_attributes.attribute_id,

576: approverTypeIdOut out nocopy ame_util.idList) as
577: cursor attributeCursor(applicationIdIn in integer,
578: headerItemClassIdIn in integer) is
579: select
580: ame_attributes.attribute_id,
581: ame_attributes.name,
582: ame_attributes.attribute_type,
583: ame_attributes.approver_type_id
584: from

Line 581: ame_attributes.name,

577: cursor attributeCursor(applicationIdIn in integer,
578: headerItemClassIdIn in integer) is
579: select
580: ame_attributes.attribute_id,
581: ame_attributes.name,
582: ame_attributes.attribute_type,
583: ame_attributes.approver_type_id
584: from
585: ame_attributes,

Line 582: ame_attributes.attribute_type,

578: headerItemClassIdIn in integer) is
579: select
580: ame_attributes.attribute_id,
581: ame_attributes.name,
582: ame_attributes.attribute_type,
583: ame_attributes.approver_type_id
584: from
585: ame_attributes,
586: ame_attribute_usages,

Line 583: ame_attributes.approver_type_id

579: select
580: ame_attributes.attribute_id,
581: ame_attributes.name,
582: ame_attributes.attribute_type,
583: ame_attributes.approver_type_id
584: from
585: ame_attributes,
586: ame_attribute_usages,
587: ame_item_classes

Line 585: ame_attributes,

581: ame_attributes.name,
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

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 590: ame_attributes.item_class_id = ame_item_classes.item_class_id and

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
594: ame_attributes.attribute_id not in

Line 593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and

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
597: sysdate between ame_mandatory_attributes.start_date and

Line 594: ame_attributes.attribute_id not in

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
597: sysdate between ame_mandatory_attributes.start_date and
598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and

Line 599: sysdate between ame_attributes.start_date and

595: (select attribute_id from ame_mandatory_attributes
596: where action_type_id = -1 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

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

596: where action_type_id = -1 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)

Line 605: order by ame_attributes.name;

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;
607: begin
608: tempIndex := 1;
609: for tempAttributeUsage in attributeCursor(applicationIdIn => applicationIdIn,

Line 640: from ame_attributes atr

636: select atr.attribute_id
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