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_TRANS_TYPE_API dependencies on AME_ATTRIBUTES

Line 27: select ame_attributes.attribute_id,

23: --
24: -- Declare cursors and local variables
25: --
26: cursor getMandatoryAttributesCur is
27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id

Line 28: ame_attributes.attribute_type

24: -- Declare cursors and local variables
25: --
26: cursor getMandatoryAttributesCur is
27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1

Line 29: from ame_attributes,

25: --
26: cursor getMandatoryAttributesCur is
27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and

Line 31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id

27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and

Line 33: and sysdate between ame_attributes.start_date and

29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is

Line 34: nvl(ame_attributes.end_date - (1/86400), sysdate)

30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is
38: select item_class_id

Line 43: type attribTypeList is table of ame_attributes.attribute_type%type

39: from ame_item_classes
40: where name = ame_util.headerItemClassName
41: and sysdate between start_date and
42: nvl(end_date - (1/86400), sysdate);
43: type attribTypeList is table of ame_attributes.attribute_type%type
44: index by binary_integer;
45: l_proc varchar2(72) := g_package||'create_ame_transaction_type';
46: l_swi_pkg_name varchar2(72) := 'AME_TRANS_TYPE_SWI';
47: l_application_id number;

Line 381: ,ame_attributes att

377: cursor getAttributeUsageCur is
378: select atu.attribute_id,
379: atu.object_version_number
380: from ame_attribute_usages atu
381: ,ame_attributes att
382: where application_id = p_application_id
383: and att.attribute_id = atu.attribute_id
384: and sysdate between atu.start_date and
385: nvl(atu.end_date - ame_util.oneSecond, sysdate)