eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_CONDITIONS_API dependencies on AME_CONDITIONS

Line 1: PACKAGE BODY AME_CONDITIONS_API AS

1: PACKAGE BODY AME_CONDITIONS_API AS
2: /* $Header: amecoapi.pkb 120.3 2006/03/15 01:23 pvelugul noship $ */
3:
4: X_AME_INSTALLATION_LEVEL varchar2(255);
5: procedure OWNER_TO_WHO (

Line 49: from AME_CONDITIONS

45: (
46: X_CONDITION_ID in VARCHAR2
47: ) is
48: select COUNT(*)
49: from AME_CONDITIONS
50: where CONDITION_ID = X_CONDITION_ID;
51: X_CREATED_BY NUMBER;
52: begin
53: open CSR_GET_ATTRIBUTE(

Line 215: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',

211: when invalidConditionTypeException then
212: errorMessage :=
213: 'OAM is attempting to upload an invalid condition type.';
214: errorCode := -20001;
215: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',
216: routineNameIn => 'validate_condition',
217: exceptionNumberIn => errorCode,
218: exceptionStringIn => errorMessage);
219: raise_application_error(errorCode,

Line 223: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',

219: raise_application_error(errorCode,
220: errorMessage);
221: when invalidCondAttrTypeException then
222: errorCode := -20001;
223: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',
224: routineNameIn => 'validate_condition',
225: exceptionNumberIn => errorCode,
226: exceptionStringIn => errorMessage);
227: raise_application_error(errorCode,

Line 233: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',

229: when invalid_number then
230: errorMessage :=
231: 'OAM is attempting to upload an invalid number or currency attribute condition.';
232: errorCode := -20001;
233: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',
234: routineNameIn => 'validate_condition',
235: exceptionNumberIn => errorCode,
236: exceptionStringIn => errorMessage);
237: raise_application_error(errorCode,

Line 241: ame_util.runtimeException('ame_conditions_api',

237: raise_application_error(errorCode,
238: errorMessage);
239:
240: when others then
241: ame_util.runtimeException('ame_conditions_api',
242: 'validate_condition',
243: sqlcode,
244: sqlerrm);
245: raise;

Line 271: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);

267: returnValue integer;
268:
269: begin
270: if X_AME_INSTALLATION_LEVEL is not null then
271: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
272: else
273: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
274: end if;
275: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);

Line 273: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);

269: begin
270: if X_AME_INSTALLATION_LEVEL is not null then
271: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
272: else
273: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
274: end if;
275: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
276: if returnValue = 0 then
277: insert into AME_CONDITIONS

Line 277: insert into AME_CONDITIONS

273: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
274: end if;
275: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
276: if returnValue = 0 then
277: insert into AME_CONDITIONS
278: (
279: CONDITION_ID,
280: CONDITION_KEY,
281: CONDITION_TYPE,

Line 316: from AME_CONDITIONS

312: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
313: X_OBJECT_VERSION_NUMBER
314: from sys.dual
315: where not exists (select NULL
316: from AME_CONDITIONS
317: where ((CONDITION_ID = X_CONDITION_ID
318: and sysdate < nvl(END_DATE - (1/86400), sysdate + (1/86400)))
319: or (X_AME_INSTALLATION_LEVEL is not null and CONDITION_KEY = X_CONDITION_KEY))
320: );

Line 328: delete from AME_CONDITIONS

324: procedure DELETE_ROW (
325: X_CONDITION_ID in NUMBER
326: ) is
327: begin
328: delete from AME_CONDITIONS
329: where CONDITION_ID = X_CONDITION_ID;
330: if (sql%notfound) then
331: raise no_data_found;
332: end if;

Line 342: X_NEW_CONDITION_KEY AME_CONDITIONS.CONDITION_KEY%TYPE;

338: from V$DATABASE DB,
339: V$INSTANCE INSTANCE
340: where upper(DB.NAME) = upper(INSTANCE.INSTANCE_NAME);
341: X_DATABASE_ID VARCHAR2(50);
342: X_NEW_CONDITION_KEY AME_CONDITIONS.CONDITION_KEY%TYPE;
343: X_CONDITION_COUNT NUMBER;
344: X_CONDITION_KEY_ID NUMBER;
345: begin
346: open GET_DBID_CURSOR;

Line 360: from AME_CONDITIONS

356: select AME_CONDITION_KEYS_S.NEXTVAL into X_CONDITION_KEY_ID from dual;
357: X_NEW_CONDITION_KEY := X_DATABASE_ID ||':'|| X_CONDITION_KEY_ID;
358: select count(*)
359: into X_CONDITION_COUNT
360: from AME_CONDITIONS
361: where upper(CONDITION_KEY) = upper(X_NEW_CONDITION_KEY)
362: and rownum < 2;
363: if X_CONDITION_COUNT = 0 then
364: exit;

Line 370: ame_util.runtimeException('ame_conditions_api',

366: end loop;
367: return(X_NEW_CONDITION_KEY);
368: exception
369: when others then
370: ame_util.runtimeException('ame_conditions_api',
371: 'create_condition_key',
372: sqlcode,
373: sqlerrm);
374: raise;

Line 451: ame_util.runtimeException('ame_conditions_api',

447: -- do not update or insert.
448: end;
449: exception
450: when others then
451: ame_util.runtimeException('ame_conditions_api',
452: 'load_row',
453: sqlcode,
454: sqlerrm);
455: raise;

Line 458: END AME_CONDITIONS_API;

454: sqlerrm);
455: raise;
456: end LOAD_ROW;
457: --
458: END AME_CONDITIONS_API;