APPS.AME_RULES_API dependencies on AME_ACTION_USAGES

Line 56: from AME_ACTION_USAGES

52: select ROWID,
53: LAST_UPDATED_BY,
54: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
55: nvl(OBJECT_VERSION_NUMBER,1)
56: from AME_ACTION_USAGES
57: where RULE_ID = X_RULE_ID
58: and ACTION_ID = X_ACTION_ID
59: and sysdate between START_DATE
60: and nvl(END_DATE - (1/86400), sysdate);

Line 257: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID

253: is
254: lockHandle varchar2(500);
255: returnValue integer;
256: begin
257: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
258: ,lockhandle => lockHandle);
259: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
260: ,release_on_commit => true);
261: if returnValue = 0 then

Line 262: insert into AME_ACTION_USAGES

258: ,lockhandle => lockHandle);
259: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
260: ,release_on_commit => true);
261: if returnValue = 0 then
262: insert into AME_ACTION_USAGES
263: (
264: RULE_ID,
265: ACTION_ID,
266: CREATED_BY,

Line 287: from AME_ACTION_USAGES

283: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
284: X_OBJECT_VERSION_NUMBER
285: from sys.dual
286: where not exists (select NULL
287: from AME_ACTION_USAGES
288: where RULE_ID = X_RULE_ID
289: and ACTION_ID = X_ACTION_ID
290: and sysdate between START_DATE
291: and nvl(END_DATE - (1/86400), sysdate));

Line 312: update AME_ACTION_USAGES set

308: X_ACTION_USAGE_ROWID in VARCHAR2,
309: X_END_DATE in DATE)
310: is
311: begin
312: update AME_ACTION_USAGES set
313: END_DATE = X_END_DATE
314: where ROWID = X_ACTION_USAGE_ROWID;
315: end UPDATE_USAGE_ROW;
316:

Line 436: -- when target database is at AME11510, populate ame_action_usages table

432: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
433: X_DESCRIPTION,
434: X_ITEM_CLASS_ID,
435: 1);
436: -- when target database is at AME11510, populate ame_action_usages table
437: if X_AME_INSTALLATION_LEVEL is not null then
438: -- insert an ame_action_usages row
439: if X_USAGE_ROWID is null then
440: INSERT_USAGE_ROW (

Line 438: -- insert an ame_action_usages row

434: X_ITEM_CLASS_ID,
435: 1);
436: -- when target database is at AME11510, populate ame_action_usages table
437: if X_AME_INSTALLATION_LEVEL is not null then
438: -- insert an ame_action_usages row
439: if X_USAGE_ROWID is null then
440: INSERT_USAGE_ROW (
441: X_RULE_ID,
442: X_ACTION_ID,