APPS.AME_RULE_USAGES_API dependencies on AME_ATTRIBUTE_USAGES

Line 68: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,

64: end if;
65:
66: end KEY_TO_IDS;
67:
68: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,
69: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
70: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
72: from AME_RULES, AME_RULE_USAGES

Line 69: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as

65:
66: end KEY_TO_IDS;
67:
68: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,
69: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
70: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
72: from AME_RULES, AME_RULE_USAGES
73: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID

Line 161: ame_util.runtimeException('ame_attribute_usages_api',

157: end loop;
158: return(NEW_USE_COUNT);
159: exception
160: when others then
161: ame_util.runtimeException('ame_attribute_usages_api',
162: 'calculate_use_count',
163: sqlcode,
164: sqlerrm);
165: raise;

Line 225: X_USE_COUNT ame_attribute_usages.use_count%type;

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
228: -- calculate use count
229: X_USE_COUNT := CALCULATE_USE_COUNT(ATTRIBUTE_REC.ATTRIBUTE_ID, X_APPLICATION_ID);

Line 230: -- update ame_attribute_usages

226: begin
227: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
228: -- calculate use count
229: X_USE_COUNT := CALCULATE_USE_COUNT(ATTRIBUTE_REC.ATTRIBUTE_ID, X_APPLICATION_ID);
230: -- update ame_attribute_usages
231: update AME_ATTRIBUTE_USAGES
232: set USE_COUNT = X_USE_COUNT
233: where
234: ATTRIBUTE_ID = ATTRIBUTE_REC.ATTRIBUTE_ID and

Line 231: update AME_ATTRIBUTE_USAGES

227: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
228: -- calculate use count
229: X_USE_COUNT := CALCULATE_USE_COUNT(ATTRIBUTE_REC.ATTRIBUTE_ID, X_APPLICATION_ID);
230: -- update ame_attribute_usages
231: update AME_ATTRIBUTE_USAGES
232: set USE_COUNT = X_USE_COUNT
233: where
234: ATTRIBUTE_ID = ATTRIBUTE_REC.ATTRIBUTE_ID and
235: APPLICATION_ID = X_APPLICATION_ID and