APPS.AME_MAN_ATTRIBUTES_API dependencies on AME_MANDATORY_ATTRIBUTES

Line 55: from AME_MANDATORY_ATTRIBUTES

51: is select ROWID,
52: LAST_UPDATED_BY,
53: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
54: nvl(OBJECT_VERSION_NUMBER,1)
55: from AME_MANDATORY_ATTRIBUTES
56: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
57: and ACTION_TYPE_ID = X_ACTION_TYPE_ID
58: and sysdate between START_DATE
59: and nvl(END_DATE - (1/86400), sysdate);

Line 125: update AME_MANDATORY_ATTRIBUTES

121: X_END_DATE in DATE,
122: X_OBJECT_VERSION_NUMBER in NUMBER
123: ) is
124: begin
125: update AME_MANDATORY_ATTRIBUTES
126: set CREATED_BY = X_CREATED_BY,
127: CREATION_DATE = X_CREATION_DATE,
128: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
129: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 153: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_MANDATORY_ATTRIBUTES.'||to_char(X_ATTRIBUTE_ID)

149: lockHandle varchar2(500);
150: returnValue integer;
151: begin
152:
153: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_MANDATORY_ATTRIBUTES.'||to_char(X_ATTRIBUTE_ID)
154: ||'.'||to_char(X_ACTION_TYPE_ID),lockhandle => lockHandle);
155: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
156: if returnValue = 0 then
157: insert into AME_MANDATORY_ATTRIBUTES

Line 157: insert into AME_MANDATORY_ATTRIBUTES

153: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_MANDATORY_ATTRIBUTES.'||to_char(X_ATTRIBUTE_ID)
154: ||'.'||to_char(X_ACTION_TYPE_ID),lockhandle => lockHandle);
155: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
156: if returnValue = 0 then
157: insert into AME_MANDATORY_ATTRIBUTES
158: (
159: ATTRIBUTE_ID,
160: ACTION_TYPE_ID,
161: CREATED_BY,

Line 188: update AME_MANDATORY_ATTRIBUTES set

184: X_MAN_ATTRIBUTE_ROWID in VARCHAR2,
185: X_END_DATE in DATE)
186: is
187: begin
188: update AME_MANDATORY_ATTRIBUTES set
189: END_DATE = X_END_DATE
190: where ROWID = X_MAN_ATTRIBUTE_ROWID;
191: end UPDATE_ROW;
192:

Line 198: delete from AME_MANDATORY_ATTRIBUTES

194: X_ATTRIBUTE_ID in NUMBER,
195: X_ACTION_TYPE_ID in NUMBER
196: ) is
197: begin
198: delete from AME_MANDATORY_ATTRIBUTES
199: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
200: and ACTION_TYPE_ID = X_ACTION_TYPE_ID;
201:
202: if (sql%notfound) then

Line 359: ame_util.runtimeException('ame_mandatory_attributes_api',

355: end if;
356:
357: exception
358: when others then
359: ame_util.runtimeException('ame_mandatory_attributes_api',
360: 'load_row',
361: sqlcode,
362: sqlerrm);
363: raise;