APPS.AME_ACTION_USAGES_API dependencies on AME_ACTION_USAGES

Line 1: PACKAGE BODY AME_ACTION_USAGES_API AS

1: PACKAGE BODY AME_ACTION_USAGES_API AS
2: /* $Header: ameusapi.pkb 120.5 2006/08/23 13:35:07 pvelugul noship $ */
3: X_AME_INSTALLATION_LEVEL varchar2(255);
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 65: from AME_ACTION_USAGES

61: ) is select ROWID,
62: LAST_UPDATED_BY,
63: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
64: nvl(OBJECT_VERSION_NUMBER,1)
65: from AME_ACTION_USAGES
66: where RULE_ID = X_RULE_ID
67: and ACTION_ID = X_ACTION_ID
68: and sysdate between START_DATE
69: and nvl(END_DATE - (1/86400), sysdate);

Line 192: ame_util.runtimeException(packageNameIn => 'ame_action_usages',

188: exception
189: when invalidRuleTypeException then
190: errorCode := -20001;
191: errorMessage := 'AME is attempting to upload usages for an invalid rule type. ';
192: ame_util.runtimeException(packageNameIn => 'ame_action_usages',
193: routineNameIn => 'validate_rule_type',
194: exceptionNumberIn => errorCode,
195: exceptionStringIn => errorMessage);
196: raise_application_error(errorCode,

Line 199: ame_util.runtimeException('ame_action_usages',

195: exceptionStringIn => errorMessage);
196: raise_application_error(errorCode,
197: errorMessage);
198: when others then
199: ame_util.runtimeException('ame_action_usages',
200: 'validate_rule_type',
201: sqlcode,
202: sqlerrm);
203: raise;

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

216: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
217: ,X_CUSTOM_MODE => X_CUSTOM_MODE
218: );
219: end DO_UPDATE_INSERT;
220: procedure CHANGE_RULE_ATTR_USE_COUNT(X_RULE_ID ame_action_usages.rule_id%type) as
221: CURSOR CSR_GET_ITEM_IDS
222: (
223: X_RULE_ID in integer
224: ) is

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

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

Line 258: insert into AME_ACTION_USAGES

254: ,lockhandle => lockHandle);
255: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
256: ,release_on_commit => true);
257: if returnValue = 0 then
258: insert into AME_ACTION_USAGES
259: (
260: RULE_ID,
261: ACTION_ID,
262: CREATED_BY,

Line 283: from AME_ACTION_USAGES

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

Line 297: update AME_ACTION_USAGES set

293: X_ACTION_USAGE_ROWID in VARCHAR2,
294: X_END_DATE in DATE)
295: is
296: begin
297: update AME_ACTION_USAGES set
298: END_DATE = X_END_DATE
299: where ROWID = X_ACTION_USAGE_ROWID;
300: end UPDATE_ROW;
301: procedure DELETE_ROW (

Line 306: delete from AME_ACTION_USAGES

302: X_RULE_ID in NUMBER,
303: X_ACTION_ID in NUMBER
304: ) is
305: begin
306: delete from AME_ACTION_USAGES
307: where RULE_ID = X_RULE_ID
308: and ACTION_ID = X_ACTION_ID;
309: if (sql%notfound) then
310: raise no_data_found;

Line 325: update AME_ACTION_USAGES

321: X_END_DATE in DATE,
322: X_OBJECT_VERSION_NUMBER in NUMBER
323: ) is
324: begin
325: update AME_ACTION_USAGES
326: set CREATED_BY = X_CREATED_BY,
327: CREATION_DATE = X_CREATION_DATE,
328: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
329: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 429: ame_util.runtimeException('ame_action_usages_api',

425: end if;
426: end;
427: exception
428: when others then
429: ame_util.runtimeException('ame_action_usages_api',
430: 'load_row',
431: sqlcode,
432: sqlerrm);
433: raise;

Line 436: END AME_ACTION_USAGES_API;

432: sqlerrm);
433: raise;
434: end LOAD_ROW;
435:
436: END AME_ACTION_USAGES_API;