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_API dependencies on AME_CONDITION_USAGES

Line 94: AME_CONDITION_USAGES

90: for TEMPRULE in RULE_CURSOR(X_APPLICATION_ID => X_APPLICATION_ID) loop
91: select count(*)
92: into TEMP_COUNT
93: from AME_CONDITIONS,
94: AME_CONDITION_USAGES
95: where
96: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
97: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
98: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and

Line 97: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and

93: from AME_CONDITIONS,
94: AME_CONDITION_USAGES
95: where
96: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
97: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
98: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
99: sysdate between AME_CONDITIONS.START_DATE and
100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
101: ((sysdate between AME_CONDITION_USAGES.START_DATE and

Line 98: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and

94: AME_CONDITION_USAGES
95: where
96: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
97: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
98: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
99: sysdate between AME_CONDITIONS.START_DATE and
100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
101: ((sysdate between AME_CONDITION_USAGES.START_DATE and
102: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 101: ((sysdate between AME_CONDITION_USAGES.START_DATE and

97: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
98: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
99: sysdate between AME_CONDITIONS.START_DATE and
100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
101: ((sysdate between AME_CONDITION_USAGES.START_DATE and
102: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
103: (sysdate < AME_CONDITION_USAGES.START_DATE and
104: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
105: AME_CONDITION_USAGES.START_DATE + (1/86400))));

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

98: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
99: sysdate between AME_CONDITIONS.START_DATE and
100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
101: ((sysdate between AME_CONDITION_USAGES.START_DATE and
102: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
103: (sysdate < AME_CONDITION_USAGES.START_DATE and
104: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
105: AME_CONDITION_USAGES.START_DATE + (1/86400))));
106: if(TEMP_COUNT > 0) then

Line 103: (sysdate < AME_CONDITION_USAGES.START_DATE and

99: sysdate between AME_CONDITIONS.START_DATE and
100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
101: ((sysdate between AME_CONDITION_USAGES.START_DATE and
102: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
103: (sysdate < AME_CONDITION_USAGES.START_DATE and
104: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
105: AME_CONDITION_USAGES.START_DATE + (1/86400))));
106: if(TEMP_COUNT > 0) then
107: NEW_USE_COUNT := NEW_USE_COUNT + 1;

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

100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
101: ((sysdate between AME_CONDITION_USAGES.START_DATE and
102: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
103: (sysdate < AME_CONDITION_USAGES.START_DATE and
104: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
105: AME_CONDITION_USAGES.START_DATE + (1/86400))));
106: if(TEMP_COUNT > 0) then
107: NEW_USE_COUNT := NEW_USE_COUNT + 1;
108: else

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

101: ((sysdate between AME_CONDITION_USAGES.START_DATE and
102: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
103: (sysdate < AME_CONDITION_USAGES.START_DATE and
104: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
105: AME_CONDITION_USAGES.START_DATE + (1/86400))));
106: if(TEMP_COUNT > 0) then
107: NEW_USE_COUNT := NEW_USE_COUNT + 1;
108: else
109: if(TEMPRULE.ACTION_ID is null) then

Line 174: AME_CONDITION_USAGES

170: X_APPLICATION_ID ame_rule_usages.item_id%type) is
171: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
172: select AME_CONDITIONS.ATTRIBUTE_ID
173: from AME_CONDITIONS,
174: AME_CONDITION_USAGES
175: where
176: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
177: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
178: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and

Line 178: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and

174: AME_CONDITION_USAGES
175: where
176: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
177: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
178: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
179: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
180: (AME_CONDITIONS.START_DATE <= sysdate and
181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
182: ((sysdate between AME_CONDITION_USAGES.START_DATE and

Line 179: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and

175: where
176: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
177: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
178: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
179: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
180: (AME_CONDITIONS.START_DATE <= sysdate and
181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
182: ((sysdate between AME_CONDITION_USAGES.START_DATE and
183: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 182: ((sysdate between AME_CONDITION_USAGES.START_DATE and

178: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
179: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
180: (AME_CONDITIONS.START_DATE <= sysdate and
181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
182: ((sysdate between AME_CONDITION_USAGES.START_DATE and
183: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))

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

179: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
180: (AME_CONDITIONS.START_DATE <= sysdate and
181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
182: ((sysdate between AME_CONDITION_USAGES.START_DATE and
183: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union

Line 184: (sysdate < AME_CONDITION_USAGES.START_DATE and

180: (AME_CONDITIONS.START_DATE <= sysdate and
181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
182: ((sysdate between AME_CONDITION_USAGES.START_DATE and
183: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

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

181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
182: ((sysdate between AME_CONDITION_USAGES.START_DATE and
183: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
189: from AME_MANDATORY_ATTRIBUTES,

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

182: ((sysdate between AME_CONDITION_USAGES.START_DATE and
183: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,