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

Line 30: from AME_ATTRIBUTES

26: (
27: X_ATTRIBUTE_NAME in VARCHAR2
28: ) is
29: select ATTRIBUTE_ID
30: from AME_ATTRIBUTES
31: where NAME = X_ATTRIBUTE_NAME
32: and sysdate between START_DATE
33: and nvl(END_DATE-(1/86400), sysdate);
34: cursor CSR_GET_CONDITION_ID

Line 47: from AME_ATTRIBUTES C

43: (
44: X_ATTRIBUTE_ID in VARCHAR2
45: ) is
46: select C.CREATED_BY
47: from AME_ATTRIBUTES C
48: where C.START_DATE =
49: (select min(A.START_DATE) from AME_ATTRIBUTES A
50: where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
51: and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line 49: (select min(A.START_DATE) from AME_ATTRIBUTES A

45: ) is
46: select C.CREATED_BY
47: from AME_ATTRIBUTES C
48: where C.START_DATE =
49: (select min(A.START_DATE) from AME_ATTRIBUTES A
50: where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
51: and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;
52:
53: X_ATTR_CREATED_BY number;

Line 143: from AME_ATTRIBUTES C

139: (
140: X_ATTRIBUTE_ID in VARCHAR2
141: ) is
142: select C.CREATED_BY
143: from AME_ATTRIBUTES C
144: where C.START_DATE =
145: (select min(A.START_DATE) from AME_ATTRIBUTES A
146: where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
147: and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line 145: (select min(A.START_DATE) from AME_ATTRIBUTES A

141: ) is
142: select C.CREATED_BY
143: from AME_ATTRIBUTES C
144: where C.START_DATE =
145: (select min(A.START_DATE) from AME_ATTRIBUTES A
146: where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
147: and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;
148:
149: cursor CSR_GET_ATTRIBUTE

Line 154: from AME_ATTRIBUTES

150: (
151: X_ATTRIBUTE_NAME in VARCHAR2
152: ) is
153: select ATTRIBUTE_ID
154: from AME_ATTRIBUTES
155: where NAME = X_ATTRIBUTE_NAME
156: and ((START_DATE - (1/86400)) <= sysdate)
157: and (((END_DATE - (1/86400)) >= sysdate)
158: or (END_DATE is null));

Line 255: from AME_ATTRIBUTES

251: X_PARAMETER_TWO_NUMBER number;
252: begin
253: select ATTRIBUTE_TYPE
254: into X_ATTRIBUTE_TYPE
255: from AME_ATTRIBUTES
256: where NAME = X_ATTRIBUTE_NAME
257: and sysdate between START_DATE
258: and nvl(END_DATE-(1/86400), sysdate);
259: