DBA Data[Home] [Help]

APPS.AME_RULE_USAGES_API2 dependencies on AME_UTIL

Line 234: ame_util.runtimeException('ame_attribute_usages_api2',

230: end loop;
231: return(NEW_USE_COUNT);
232: exception
233: when others then
234: ame_util.runtimeException('ame_attribute_usages_api2',
235: 'calculate_use_count',
236: sqlcode,
237: sqlerrm);
238: raise;

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

245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES
248: where
249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
253: (AME_CONDITIONS.START_DATE <= sysdate and

Line 250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and

246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES
248: where
249: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
250: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
251: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
252: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
253: (AME_CONDITIONS.START_DATE <= sysdate and
254: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and

Line 297: ATTRIBUTE_IDS_LIST ame_util.idList;

293: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,AME_RULES.START_DATE
294: + (1/86400)))) and
295: (AME_ACTIONS.START_DATE <= sysdate and
296: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE));
297: ATTRIBUTE_IDS_LIST ame_util.idList;
298: X_USE_COUNT ame_attribute_usages.use_count%type;
299: begin
300: for ATTRIBUTE_REC in GET_USED_ATTRIBUTES(X_RULE_ID => X_RULE_ID) loop
301: -- calculate use count

Line 531: ame_util.runtimeException('ame_rules_usages_api2',

527: end if;
528: end if;
529: exception
530: when others then
531: ame_util.runtimeException('ame_rules_usages_api2',
532: 'load_row',
533: sqlcode,
534: sqlerrm);
535: raise;