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_RULE_USAGES_API2 dependencies on AME_CONDITIONS

Line 166: from AME_CONDITIONS,

162: NEW_USE_COUNT := 0;
163: for TEMPRULE in RULE_CURSOR(X_APPLICATION_ID => X_APPLICATION_ID) loop
164: select count(*)
165: into TEMP_COUNT
166: from AME_CONDITIONS,
167: AME_CONDITION_USAGES
168: where
169: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
170: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and

Line 169: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

165: into TEMP_COUNT
166: from AME_CONDITIONS,
167: AME_CONDITION_USAGES
168: where
169: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
170: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
171: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
172: sysdate between AME_CONDITIONS.START_DATE and
173: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and

Line 170: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and

166: from AME_CONDITIONS,
167: AME_CONDITION_USAGES
168: where
169: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
170: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
171: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
172: sysdate between AME_CONDITIONS.START_DATE and
173: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
174: ((sysdate between AME_CONDITION_USAGES.START_DATE and

Line 172: sysdate between AME_CONDITIONS.START_DATE and

168: where
169: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
170: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
171: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
172: sysdate between AME_CONDITIONS.START_DATE and
173: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
174: ((sysdate between AME_CONDITION_USAGES.START_DATE and
175: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
176: (sysdate < AME_CONDITION_USAGES.START_DATE and

Line 173: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and

169: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
170: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
171: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
172: sysdate between AME_CONDITIONS.START_DATE and
173: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
174: ((sysdate between AME_CONDITION_USAGES.START_DATE and
175: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
176: (sysdate < AME_CONDITION_USAGES.START_DATE and
177: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,

Line 245: select AME_CONDITIONS.ATTRIBUTE_ID

241:
242: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
243: X_APPLICATION_ID ame_rule_usages.item_id%type) is
244: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES
248: where
249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,

Line 246: from AME_CONDITIONS,

242: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
243: X_APPLICATION_ID ame_rule_usages.item_id%type) is
244: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES
248: where
249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and

Line 249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,

245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES
248: where
249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
253: (AME_CONDITIONS.START_DATE <= sysdate and

Line 252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and

248: where
249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
253: (AME_CONDITIONS.START_DATE <= sysdate and
254: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
255: ((sysdate between AME_CONDITION_USAGES.START_DATE and
256: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 253: (AME_CONDITIONS.START_DATE <= sysdate and

249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
253: (AME_CONDITIONS.START_DATE <= sysdate and
254: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
255: ((sysdate between AME_CONDITION_USAGES.START_DATE and
256: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
257: (sysdate < AME_CONDITION_USAGES.START_DATE and

Line 254: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and

250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
253: (AME_CONDITIONS.START_DATE <= sysdate and
254: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
255: ((sysdate between AME_CONDITION_USAGES.START_DATE and
256: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
257: (sysdate < AME_CONDITION_USAGES.START_DATE and
258: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,