APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_ATTRIBUTES

Line 142: from AME_ATTRIBUTES ATTR1,

138: and APPLICATION_ID = X_APPLICATION_ID
139: group by ATTRIBUTE_ID, APPLICATION_ID
140: having max(USE_COUNT) > 0)
141: and not exists (select null
142: from AME_ATTRIBUTES ATTR1,
143: AME_ATTRIBUTE_USAGES ATTRU1
144: where ATTR1.ATTRIBUTE_ID = X_ATTRIBUTE_ID
145: and ATTRU1.APPLICATION_ID = X_APPLICATION_ID
146: and ATTR1.ATTRIBUTE_ID = ATTRU1.ATTRIBUTE_ID

Line 169: IN PARAMETERS : X_ATTRIBUTE_ID -> To get 'line_item'(Y/N) value from ame_attributes table

165: return(false);
166: end IS_SEED_USG_RULE_MODIFIED;
167: /*******************************************************************************************
168: PROCEDURE: PRESERVE_LINE_ITEM_ID_LIST
169: IN PARAMETERS : X_ATTRIBUTE_ID -> To get 'line_item'(Y/N) value from ame_attributes table
170: X_IS_STATIC -> Procedure written for query_string modification
171: and query_string exists only for dynamic usages
172: X_LINE_ITEM_ID_QUERY -> Query from calling_apps table whose occurance in
173: X_QUERY_STRING_INOUT will be replaced by

Line 224: from ame_attributes

220: return;
221: end if;
222: select LINE_ITEM
223: into X_LINE_ITEM
224: from ame_attributes
225: where ATTRIBUTE_ID=X_ATTRIBUTE_ID
226: and SYSDATE between START_DATE
227: and nvl(END_DATE - (1/86400), sysdate);
228: --return if this attribute is not line_item or if it has a static usage

Line 422: from AME_ATTRIBUTES

418: (
419: X_ATTRIBUTE_NAME in VARCHAR2
420: ) is
421: select ATTRIBUTE_ID
422: from AME_ATTRIBUTES
423: where NAME = X_ATTRIBUTE_NAME
424: and sysdate between START_DATE
425: and nvl(END_DATE - (1/86400), sysdate);
426:

Line 716: X_LINE_ATTRIBUTE_NAME ame_attributes.name%type := null;

712: X_CALCULATED_USE_COUNT ame_attribute_usages.use_count%type;
713: X_CURRENT_USER_EDITABLE ame_attribute_usages.user_editable%type;
714: X_LAST_UPDATED_BY NUMBER;
715: X_LAST_UPDATE_LOGIN NUMBER;
716: X_LINE_ATTRIBUTE_NAME ame_attributes.name%type := null;
717: X_LINE_ITEM_ID_QUERY ame_attribute_usages.query_string%type;
718: X_QUERY_STRING_OUT ame_attribute_usages.query_string%type;
719: X_USAGES_ROWID ROWID;
720: X_VALUE_SET_ID NUMBER;