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_ACTIONS

Line 115: AME_ACTIONS,

111: select count(*)
112: into TEMP_COUNT
113: from
114: AME_MANDATORY_ATTRIBUTES,
115: AME_ACTIONS,
116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

115: AME_ACTIONS,
116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and

Line 124: sysdate between AME_ACTIONS.START_DATE and

120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and

Line 125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and

121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
128: (sysdate < AME_ACTION_USAGES.START_DATE and
129: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,

Line 136: AME_ACTIONS,

132: select count(*)
133: into TEMP_COUNT
134: from
135: AME_MANDATORY_ATTRIBUTES,
136: AME_ACTIONS,
137: AME_RULES
138: where
139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

136: AME_ACTIONS,
137: AME_RULES
138: where
139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and

137: AME_RULES
138: where
139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
145: sysdate between AME_ACTIONS.START_DATE and

Line 145: sysdate between AME_ACTIONS.START_DATE and

141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
145: sysdate between AME_ACTIONS.START_DATE and
146: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
147: ((sysdate between AME_RULES.START_DATE and
148: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
149: (sysdate < AME_RULES.START_DATE and

Line 146: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and

142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
145: sysdate between AME_ACTIONS.START_DATE and
146: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
147: ((sysdate between AME_RULES.START_DATE and
148: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
149: (sysdate < AME_RULES.START_DATE and
150: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,

Line 191: AME_ACTIONS

187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and

Line 193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

Line 194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and

190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
198: ((sysdate between AME_ACTION_USAGES.START_DATE and

Line 203: (AME_ACTIONS.START_DATE <= sysdate and

199: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
200: (sysdate < AME_ACTION_USAGES.START_DATE and
201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
202: + (1/86400)))) and
203: (AME_ACTIONS.START_DATE <= sysdate and
204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
205: union
206: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
207: from AME_MANDATORY_ATTRIBUTES,

Line 204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))

200: (sysdate < AME_ACTION_USAGES.START_DATE and
201: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE
202: + (1/86400)))) and
203: (AME_ACTIONS.START_DATE <= sysdate and
204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
205: union
206: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
207: from AME_MANDATORY_ATTRIBUTES,
208: AME_RULES,

Line 209: AME_ACTIONS

205: union
206: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
207: from AME_MANDATORY_ATTRIBUTES,
208: AME_RULES,
209: AME_ACTIONS
210: where
211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
213: AME_RULES.ACTION_ID is not null and

Line 211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

207: from AME_MANDATORY_ATTRIBUTES,
208: AME_RULES,
209: AME_ACTIONS
210: where
211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
213: AME_RULES.ACTION_ID is not null and
214: AME_RULES.RULE_ID = X_RULE_ID and
215: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

Line 212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and

208: AME_RULES,
209: AME_ACTIONS
210: where
211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
213: AME_RULES.ACTION_ID is not null and
214: AME_RULES.RULE_ID = X_RULE_ID and
215: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
216: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

Line 222: (AME_ACTIONS.START_DATE <= sysdate and

218: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
219: (sysdate < AME_RULES.START_DATE and
220: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,AME_RULES.START_DATE
221: + (1/86400)))) and
222: (AME_ACTIONS.START_DATE <= sysdate and
223: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE));
224: ATTRIBUTE_IDS_LIST ame_util.idList;
225: X_USE_COUNT ame_attribute_usages.use_count%type;
226: begin

Line 223: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE));

219: (sysdate < AME_RULES.START_DATE and
220: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,AME_RULES.START_DATE
221: + (1/86400)))) and
222: (AME_ACTIONS.START_DATE <= sysdate and
223: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE));
224: ATTRIBUTE_IDS_LIST ame_util.idList;
225: X_USE_COUNT ame_attribute_usages.use_count%type;
226: begin
227: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop

Line 308: ame_actions aa,

304: aat.name,
305: aa.parameter
306: from ame_rule_usages aru,
307: ame_action_usages aau,
308: ame_actions aa,
309: ame_action_types aat
310: where aru.rule_id = x_rule_id
311: and aru.item_id = x_application_id
312: and sysdate between aat.start_date and nvl(aat.end_date,sysdate)