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_CONDITIONS

Line 93: from AME_CONDITIONS,

89: NEW_USE_COUNT := 0;
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

Line 96: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

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
99: sysdate between AME_CONDITIONS.START_DATE and
100: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) 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 99: sysdate between AME_CONDITIONS.START_DATE and

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
103: (sysdate < AME_CONDITION_USAGES.START_DATE and

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

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
103: (sysdate < AME_CONDITION_USAGES.START_DATE and
104: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,

Line 172: select AME_CONDITIONS.ATTRIBUTE_ID

168:
169: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
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,

Line 173: from AME_CONDITIONS,

169: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
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

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

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
179: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
180: (AME_CONDITIONS.START_DATE <= sysdate 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 180: (AME_CONDITIONS.START_DATE <= sysdate and

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
184: (sysdate < AME_CONDITION_USAGES.START_DATE and

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

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
184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,