27: (
28: X_ATTRIBUTE_NAME in VARCHAR2
29: ) is
30: select ATTRIBUTE_ID
31: from AME_ATTRIBUTES
32: where NAME = X_ATTRIBUTE_NAME
33: and sysdate between START_DATE
34: and nvl(END_DATE - (1/86400), sysdate);
35:
219: X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);
220: X_CURRENT_OWNER NUMBER;
221: X_LAST_UPDATED_BY NUMBER;
222: X_LAST_UPDATE_LOGIN NUMBER;
223: X_LINE_ATTRIBUTE_NAME ame_attributes.name%type := null;
224: X_CURRENT_OVN NUMBER;
225: begin
226: --detect if ame full patch has been applied
227: X_AME_INSTALLATION_LEVEL:=fnd_profile.value('AME_INSTALLATION_LEVEL');