APPS.AME_ACTION_USAGES_API2 dependencies on AME_ACTION_USAGES

Line 1: package BODY AME_ACTION_USAGES_API2 as

1: package BODY AME_ACTION_USAGES_API2 as
2: /* $Header: ameasapi.pkb 120.5 2006/08/23 14:07:40 pvelugul noship $ */
3: procedure KEY_TO_IDS
4: (X_RULE_KEY in varchar2
5: ,X_ACTION_TYPE_NAME in varchar2

Line 91: procedure CHANGE_RULE_ATTR_USE_COUNT(X_RULE_ID ame_action_usages.rule_id%type) as

87: end;
88: end if;
89: end FORMAT_ROW;
90:
91: procedure CHANGE_RULE_ATTR_USE_COUNT(X_RULE_ID ame_action_usages.rule_id%type) as
92: CURSOR CSR_GET_ITEM_IDS
93: (
94: X_RULE_ID in integer
95: ) is

Line 127: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID

123: X_LOCK_HANDLE varchar2(500);
124: X_RETURN_VALUE number;
125: begin
126: DBMS_LOCK.ALLOCATE_UNIQUE
127: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
128: ,LOCKHANDLE => X_LOCK_HANDLE
129: );
130: X_RETURN_VALUE := DBMS_LOCK.REQUEST
131: (LOCKHANDLE => X_LOCK_HANDLE

Line 136: insert into AME_ACTION_USAGES

132: ,TIMEOUT => 0
133: ,RELEASE_ON_COMMIT => true);
134:
135: if X_RETURN_VALUE = 0 then
136: insert into AME_ACTION_USAGES
137: (ACTION_ID
138: ,RULE_ID
139: ,START_DATE
140: ,END_DATE

Line 159: from AME_ACTION_USAGES

155: X_LAST_UPDATE_LOGIN,
156: X_OBJECT_VERSION_NUMBER
157: from dual
158: where not exists (select null
159: from AME_ACTION_USAGES
160: where RULE_ID = X_RULE_ID
161: and ACTION_ID = X_ACTION_ID
162: and sysdate between START_DATE and nvl(END_DATE - (1/86400), sysdate));
163: CHANGE_RULE_ATTR_USE_COUNT(X_RULE_ID => X_RULE_ID);

Line 183: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID

179: X_LOCK_HANDLE varchar2(500);
180: X_RETURN_VALUE number;
181: begin
182: DBMS_LOCK.ALLOCATE_UNIQUE
183: (LOCKNAME =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
184: ,LOCKHANDLE => X_LOCK_HANDLE
185: );
186: X_RETURN_VALUE := DBMS_LOCK.REQUEST
187: (LOCKHANDLE => X_LOCK_HANDLE

Line 193: update AME_ACTION_USAGES AAU

189: ,RELEASE_ON_COMMIT => true
190: );
191:
192: if X_RETURN_VALUE = 0 then
193: update AME_ACTION_USAGES AAU
194: set AAU.END_DATE = X_START_DATE
195: where AAU.ACTION_ID = X_ACTION_ID
196: and AAU.RULE_ID = X_RULE_ID
197: and sysdate between AAU.START_DATE and nvl(AAU.END_DATE - (1/86400),sysdate);

Line 199: insert into AME_ACTION_USAGES

195: where AAU.ACTION_ID = X_ACTION_ID
196: and AAU.RULE_ID = X_RULE_ID
197: and sysdate between AAU.START_DATE and nvl(AAU.END_DATE - (1/86400),sysdate);
198:
199: insert into AME_ACTION_USAGES
200: (ACTION_ID
201: ,RULE_ID
202: ,START_DATE
203: ,END_DATE

Line 238: update AME_ACTION_USAGES

234: X_END_DATE in DATE,
235: X_OBJECT_VERSION_NUMBER in NUMBER
236: ) is
237: begin
238: update AME_ACTION_USAGES
239: set CREATED_BY = X_CREATED_BY,
240: CREATION_DATE = X_CREATION_DATE,
241: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
242: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 307: from AME_ACTION_USAGES AAU

303: select nvl(AAU.OBJECT_VERSION_NUMBER,1),
304: ROWID
305: into L_OBJECT_VERSION_NUMBER,
306: L_ROWID
307: from AME_ACTION_USAGES AAU
308: where AAU.RULE_ID = L_RULE_ID
309: and AAU.ACTION_ID = L_ACTION_ID
310: and sysdate between AAU.START_DATE and nvl(AAU.END_DATE - (1/86400),sysdate);
311:

Line 384: AME_ACTION_USAGES AAU

380: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
381: from AME_ACTIONS ACT,
382: AME_ACTION_TYPES AAT,
383: AME_RULES ARU,
384: AME_ACTION_USAGES AAU
385: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
386: and ACT.ACTION_ID = AAU.ACTION_ID
387: and AAU.RULE_ID = ARU.RULE_ID
388: and AAT.NAME not in

Line 405: AME_ACTION_USAGES AAU,

401: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
402: from AME_ACTIONS ACT,
403: AME_ACTION_TYPES AAT,
404: AME_RULES ARU,
405: AME_ACTION_USAGES AAU,
406: AME_APPROVAL_GROUPS AAG
407: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
408: and ACT.ACTION_ID = AAU.ACTION_ID
409: and AAU.RULE_ID = ARU.RULE_ID

Line 471: end AME_ACTION_USAGES_API2;

467: );
468: end if;
469: end LOAD_SEED_ROW;
470:
471: end AME_ACTION_USAGES_API2;