[Home] [Help]
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;
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
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
181: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_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
228: -- calculate use count
375: X_OWNER in VARCHAR2,
376: X_LAST_UPDATE_DATE in VARCHAR2
377: )
378: is
379: X_APPROVER_CATEGORY varchar2(1) := ame_util.approvalApproverCategory;
380: X_ITEM_ID NUMBER;
381: X_CREATED_BY NUMBER;
382: X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);
383: X_CURRENT_OWNER VARCHAR2(100);
418: ,x_application_id => x_item_id);
419: end if;
420: exception
421: when others then
422: ame_util.runtimeException('ame_rules_usages_api',
423: 'load_row',
424: sqlcode,
425: sqlerrm);
426: raise;