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_SEED_UTILITY dependencies on AME_RULE_USAGES

Line 112: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID

108:
109: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type
110: ,X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
111: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
112: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
113: from AME_RULES, AME_RULE_USAGES
114: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
115: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
116: and ((sysdate between AME_RULES.START_DATE

Line 113: from AME_RULES, AME_RULE_USAGES

109: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type
110: ,X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
111: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
112: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
113: from AME_RULES, AME_RULE_USAGES
114: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
115: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
116: and ((sysdate between AME_RULES.START_DATE
117: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))

Line 114: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID

110: ,X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
111: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
112: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
113: from AME_RULES, AME_RULE_USAGES
114: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
115: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
116: and ((sysdate between AME_RULES.START_DATE
117: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
118: or (sysdate < AME_RULES.START_DATE

Line 115: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID

111: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
112: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
113: from AME_RULES, AME_RULE_USAGES
114: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
115: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
116: and ((sysdate between AME_RULES.START_DATE
117: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
118: or (sysdate < AME_RULES.START_DATE
119: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,

Line 121: and ((sysdate between AME_RULE_USAGES.START_DATE

117: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
118: or (sysdate < AME_RULES.START_DATE
119: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
120: AME_RULES.START_DATE + (1/86400))))
121: and ((sysdate between AME_RULE_USAGES.START_DATE
122: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
123: or (sysdate < AME_RULE_USAGES.START_DATE
124: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
125: AME_RULE_USAGES.START_DATE + (1/86400))));

Line 122: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))

118: or (sysdate < AME_RULES.START_DATE
119: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
120: AME_RULES.START_DATE + (1/86400))))
121: and ((sysdate between AME_RULE_USAGES.START_DATE
122: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
123: or (sysdate < AME_RULE_USAGES.START_DATE
124: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
125: AME_RULE_USAGES.START_DATE + (1/86400))));
126: RULE_COUNT integer;

Line 123: or (sysdate < AME_RULE_USAGES.START_DATE

119: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
120: AME_RULES.START_DATE + (1/86400))))
121: and ((sysdate between AME_RULE_USAGES.START_DATE
122: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
123: or (sysdate < AME_RULE_USAGES.START_DATE
124: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
125: AME_RULE_USAGES.START_DATE + (1/86400))));
126: RULE_COUNT integer;
127: TEMP_COUNT integer;

Line 124: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,

120: AME_RULES.START_DATE + (1/86400))))
121: and ((sysdate between AME_RULE_USAGES.START_DATE
122: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
123: or (sysdate < AME_RULE_USAGES.START_DATE
124: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
125: AME_RULE_USAGES.START_DATE + (1/86400))));
126: RULE_COUNT integer;
127: TEMP_COUNT integer;
128: NEW_USE_COUNT integer;

Line 125: AME_RULE_USAGES.START_DATE + (1/86400))));

121: and ((sysdate between AME_RULE_USAGES.START_DATE
122: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
123: or (sysdate < AME_RULE_USAGES.START_DATE
124: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
125: AME_RULE_USAGES.START_DATE + (1/86400))));
126: RULE_COUNT integer;
127: TEMP_COUNT integer;
128: NEW_USE_COUNT integer;
129: begin

Line 225: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type

221: begin
222: return FND_LOAD_UTIL.OWNER_ID(P_NAME => SEED_USER_NAME);
223: end;
224:
225: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type
226: ,X_APPLICATION_ID ame_rule_usages.item_id%type) is
227: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,

Line 226: ,X_APPLICATION_ID ame_rule_usages.item_id%type) is

222: return FND_LOAD_UTIL.OWNER_ID(P_NAME => SEED_USER_NAME);
223: end;
224:
225: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type
226: ,X_APPLICATION_ID ame_rule_usages.item_id%type) is
227: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES

Line 227: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is

223: end;
224:
225: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type
226: ,X_APPLICATION_ID ame_rule_usages.item_id%type) is
227: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES
231: where

Line 320: AME_RULE_USAGES ARU,

316: ACA.CREATED_BY,
317: ACA.CREATION_DATE
318: FROM AME_CALLING_APPS ACA,
319: AME_RULES AR,
320: AME_RULE_USAGES ARU,
321: AME_ACTION_USAGES AAU
322: WHERE ACA.APPLICATION_ID = ARU.ITEM_ID
323: AND ARU.RULE_ID = AR.RULE_ID
324: AND AR.RULE_ID = AAU.RULE_ID