APPS.AME_SEED_UTILITY dependencies on AME_ATTRIBUTE_USAGES

Line 109: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type

105: return null;
106: end if;
107: end GET_DEFAULT_END_DATE;
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

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

106: end if;
107: end GET_DEFAULT_END_DATE;
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

Line 281: X_USE_COUNT ame_attribute_usages.use_count%type;

277: + (1/86400)))) and
278: (AME_ACTIONS.START_DATE <= sysdate and
279: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE));
280: ATTRIBUTE_IDS_LIST ame_util.idList;
281: X_USE_COUNT ame_attribute_usages.use_count%type;
282: begin
283: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
284: -- calculate use count
285: X_USE_COUNT := CALCULATE_USE_COUNT(ATTRIBUTE_REC.ATTRIBUTE_ID, X_APPLICATION_ID);

Line 286: -- update ame_attribute_usages

282: begin
283: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
284: -- calculate use count
285: X_USE_COUNT := CALCULATE_USE_COUNT(ATTRIBUTE_REC.ATTRIBUTE_ID, X_APPLICATION_ID);
286: -- update ame_attribute_usages
287: update AME_ATTRIBUTE_USAGES
288: set USE_COUNT = X_USE_COUNT
289: where
290: ATTRIBUTE_ID = ATTRIBUTE_REC.ATTRIBUTE_ID and

Line 287: update AME_ATTRIBUTE_USAGES

283: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
284: -- calculate use count
285: X_USE_COUNT := CALCULATE_USE_COUNT(ATTRIBUTE_REC.ATTRIBUTE_ID, X_APPLICATION_ID);
286: -- update ame_attribute_usages
287: update AME_ATTRIBUTE_USAGES
288: set USE_COUNT = X_USE_COUNT
289: where
290: ATTRIBUTE_ID = ATTRIBUTE_REC.ATTRIBUTE_ID and
291: APPLICATION_ID = X_APPLICATION_ID and