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_CONDITION_USAGES

Line 167: AME_CONDITION_USAGES

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
171: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID 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 171: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and

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
175: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 174: ((sysdate between AME_CONDITION_USAGES.START_DATE 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,
178: AME_CONDITION_USAGES.START_DATE + (1/86400))));

Line 175: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

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,
178: AME_CONDITION_USAGES.START_DATE + (1/86400))));
179: if(TEMP_COUNT > 0) then

Line 176: (sysdate < AME_CONDITION_USAGES.START_DATE 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,
178: AME_CONDITION_USAGES.START_DATE + (1/86400))));
179: if(TEMP_COUNT > 0) then
180: NEW_USE_COUNT := NEW_USE_COUNT + 1;

Line 177: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,

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,
178: AME_CONDITION_USAGES.START_DATE + (1/86400))));
179: if(TEMP_COUNT > 0) then
180: NEW_USE_COUNT := NEW_USE_COUNT + 1;
181: else

Line 178: AME_CONDITION_USAGES.START_DATE + (1/86400))));

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,
178: AME_CONDITION_USAGES.START_DATE + (1/86400))));
179: if(TEMP_COUNT > 0) then
180: NEW_USE_COUNT := NEW_USE_COUNT + 1;
181: else
182: if(TEMPRULE.ACTION_ID is null) then

Line 247: AME_CONDITION_USAGES

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
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and

Line 251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and

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
254: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
255: ((sysdate between AME_CONDITION_USAGES.START_DATE 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 255: ((sysdate between AME_CONDITION_USAGES.START_DATE 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,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))

Line 256: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

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,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union

Line 257: (sysdate < AME_CONDITION_USAGES.START_DATE 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,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union
261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

Line 258: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,

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,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union
261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
262: from AME_MANDATORY_ATTRIBUTES,

Line 259: AME_CONDITION_USAGES.START_DATE + (1/86400))))

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,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union
261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
262: from AME_MANDATORY_ATTRIBUTES,
263: AME_ACTION_USAGES,