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_CONFIG_VARS_API dependencies on AME_CONFIG_VARS

Line 1: package BODY AME_CONFIG_VARS_API as

1: package BODY AME_CONFIG_VARS_API as
2: /* $Header: amecvapi.pkb 120.6 2005/11/14 06:03 sbadiger noship $ */
3: procedure KEY_TO_IDS
4: (X_APPLICATION_SHORT_NAME in varchar2
5: ,X_TRANSACTION_TYPE_ID in varchar2

Line 54: X_CURRENT_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;

50: (X_VARIABLE_NAME in varchar2
51: ,X_VARIABLE_VALUE in varchar2
52: ,X_APPLICATION_ID in number
53: ) return boolean as
54: X_CURRENT_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;
55: begin
56: select ACV.VARIABLE_VALUE
57: into X_CURRENT_VARIABLE_VALUE
58: from AME_CONFIG_VARS ACV

Line 58: from AME_CONFIG_VARS ACV

54: X_CURRENT_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;
55: begin
56: select ACV.VARIABLE_VALUE
57: into X_CURRENT_VARIABLE_VALUE
58: from AME_CONFIG_VARS ACV
59: where ACV.VARIABLE_NAME = X_VARIABLE_NAME
60: and ((ACV.APPLICATION_ID is null and X_APPLICATION_ID is null) or
61: ACV.APPLICATION_ID = X_APPLICATION_ID)
62: and sysdate between ACV.START_DATE and nvl(ACV.END_DATE - (1/86400),sysdate);

Line 107: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||X_APPLICATION_ID

103: X_LOCK_HANDLE varchar2(500);
104: X_RETURN_VALUE number;
105: begin
106: DBMS_LOCK.ALLOCATE_UNIQUE
107: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||X_APPLICATION_ID
108: ,LOCKHANDLE => X_LOCK_HANDLE
109: );
110: X_RETURN_VALUE := DBMS_LOCK.REQUEST
111: (LOCKHANDLE => X_LOCK_HANDLE

Line 116: insert into AME_CONFIG_VARS

112: ,TIMEOUT => 0
113: ,RELEASE_ON_COMMIT => true);
114:
115: if X_RETURN_VALUE = 0 then
116: insert into AME_CONFIG_VARS
117: (VARIABLE_NAME
118: ,VARIABLE_VALUE
119: ,DESCRIPTION
120: ,CREATED_BY

Line 142: from AME_CONFIG_VARS

138: X_END_DATE,
139: X_APPLICATION_ID,
140: X_OBJECT_VERSION_NUMBER
141: from dual where not exists (select null
142: from AME_CONFIG_VARS
143: where VARIABLE_NAME = X_VARIABLE_NAME
144: and (((APPLICATION_ID is null or APPLICATION_ID = 0)
145: and (X_APPLICATION_ID is null or X_APPLICATION_ID = 0))
146: or (APPLICATION_ID = X_APPLICATION_ID))

Line 153: insert into AME_CONFIG_VARS_TL

149: if not AME_SEED_UTILITY.MLS_ENABLED then
150: return;
151: end if;
152: if(X_APPLICATION_ID = 0 or X_APPLICATION_ID = null) then
153: insert into AME_CONFIG_VARS_TL
154: (VARIABLE_NAME
155: ,USER_CONFIG_VAR_NAME
156: ,DESCRIPTION
157: ,CREATED_BY

Line 177: from AME_CONFIG_VARS_TL T

173: userenv('LANG')
174: from FND_LANGUAGES L
175: where L.INSTALLED_FLAG in ('I', 'B')
176: and not exists (select null
177: from AME_CONFIG_VARS_TL T
178: where T.VARIABLE_NAME = X_VARIABLE_NAME
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180: end if;
181: end if;

Line 204: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||to_char(nvl(X_APPLICATION_ID,0))

200: X_RETURN_VALUE number;
201: begin
202:
203: DBMS_LOCK.ALLOCATE_UNIQUE
204: (LOCKNAME =>'AME_CONFIG_VARS.'||X_VARIABLE_NAME||to_char(nvl(X_APPLICATION_ID,0))
205: ,LOCKHANDLE => X_LOCK_HANDLE
206: );
207: X_RETURN_VALUE := DBMS_LOCK.REQUEST
208: (LOCKHANDLE => X_LOCK_HANDLE

Line 213: update AME_CONFIG_VARS ACV

209: ,TIMEOUT => 0
210: ,RELEASE_ON_COMMIT => true);
211:
212: if X_RETURN_VALUE = 0 then
213: update AME_CONFIG_VARS ACV
214: set ACV.END_DATE = X_START_DATE
215: where ACV.VARIABLE_NAME = X_VARIABLE_NAME
216: and ((ACV.APPLICATION_ID is null and X_APPLICATION_ID is null) or
217: ACV.APPLICATION_ID = X_APPLICATION_ID)

Line 220: insert into AME_CONFIG_VARS

216: and ((ACV.APPLICATION_ID is null and X_APPLICATION_ID is null) or
217: ACV.APPLICATION_ID = X_APPLICATION_ID)
218: and sysdate between ACV.START_DATE and nvl(ACV.END_DATE - (1/86400),sysdate);
219:
220: insert into AME_CONFIG_VARS
221: (VARIABLE_NAME
222: ,APPLICATION_ID
223: ,VARIABLE_VALUE
224: ,DESCRIPTION

Line 252: update AME_CONFIG_VARS_TL

248: if not AME_SEED_UTILITY.MLS_ENABLED then
249: return;
250: end if;
251: if(X_APPLICATION_ID = 0 or X_APPLICATION_ID = null) then
252: update AME_CONFIG_VARS_TL
253: set USER_CONFIG_VAR_NAME = nvl(X_USER_CONFIG_VAR_NAME,USER_CONFIG_VAR_NAME),
254: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
255: SOURCE_LANG = userenv('LANG'),
256: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 282: update AME_CONFIG_VARS

278: X_END_DATE in DATE,
279: X_OBJECT_VERSION_NUMBER in NUMBER
280: ) is
281: begin
282: update AME_CONFIG_VARS
283: set VARIABLE_VALUE = X_VARIABLE_VALUE,
284: DESCRIPTION = X_DESCRIPTION,
285: CREATED_BY = X_CREATED_BY,
286: CREATION_DATE = X_CREATION_DATE,

Line 299: update AME_CONFIG_VARS_TL

295: if not AME_SEED_UTILITY.MLS_ENABLED then
296: return;
297: end if;
298: if(X_APPLICATION_ID = 0 or X_APPLICATION_ID = null) then
299: update AME_CONFIG_VARS_TL
300: set USER_CONFIG_VAR_NAME = nvl(X_USER_CONFIG_VAR_NAME,USER_CONFIG_VAR_NAME),
301: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
302: SOURCE_LANG = userenv('LANG'),
303: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 322: L_VARIABLE_NAME AME_CONFIG_VARS.VARIABLE_NAME%TYPE;

318: ,X_OWNER in varchar2
319: ,X_LAST_UPDATE_DATE in varchar2
320: ,X_CUSTOM_MODE in varchar2
321: ) as
322: L_VARIABLE_NAME AME_CONFIG_VARS.VARIABLE_NAME%TYPE;
323: L_APPLICATION_SHORT_NAME FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
324: L_TRANSACTION_TYPE_ID AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
325: L_APPLICATION_ID number;
326: L_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;

Line 326: L_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;

322: L_VARIABLE_NAME AME_CONFIG_VARS.VARIABLE_NAME%TYPE;
323: L_APPLICATION_SHORT_NAME FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
324: L_TRANSACTION_TYPE_ID AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
325: L_APPLICATION_ID number;
326: L_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;
327: L_USER_CONFIG_VAR_NAME AME_CONFIG_VARS_TL.USER_CONFIG_VAR_NAME%TYPE;
328: L_DESCRIPTION AME_CONFIG_VARS_TL.DESCRIPTION%TYPE;
329: L_OWNER varchar2(100);
330: L_LAST_UPDATE_DATE varchar2(19);

Line 327: L_USER_CONFIG_VAR_NAME AME_CONFIG_VARS_TL.USER_CONFIG_VAR_NAME%TYPE;

323: L_APPLICATION_SHORT_NAME FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
324: L_TRANSACTION_TYPE_ID AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
325: L_APPLICATION_ID number;
326: L_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;
327: L_USER_CONFIG_VAR_NAME AME_CONFIG_VARS_TL.USER_CONFIG_VAR_NAME%TYPE;
328: L_DESCRIPTION AME_CONFIG_VARS_TL.DESCRIPTION%TYPE;
329: L_OWNER varchar2(100);
330: L_LAST_UPDATE_DATE varchar2(19);
331: L_END_DATE date;

Line 328: L_DESCRIPTION AME_CONFIG_VARS_TL.DESCRIPTION%TYPE;

324: L_TRANSACTION_TYPE_ID AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
325: L_APPLICATION_ID number;
326: L_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;
327: L_USER_CONFIG_VAR_NAME AME_CONFIG_VARS_TL.USER_CONFIG_VAR_NAME%TYPE;
328: L_DESCRIPTION AME_CONFIG_VARS_TL.DESCRIPTION%TYPE;
329: L_OWNER varchar2(100);
330: L_LAST_UPDATE_DATE varchar2(19);
331: L_END_DATE date;
332: L_DUMMY varchar2(1);

Line 360: from AME_CONFIG_VARS ACV

356: select nvl(ACV.OBJECT_VERSION_NUMBER,1),
357: ROWID
358: into L_OBJECT_VERSION_NUMBER,
359: L_ROWID
360: from AME_CONFIG_VARS ACV
361: where ACV.VARIABLE_NAME = L_VARIABLE_NAME
362: and ((ACV.APPLICATION_ID is null and L_APPLICATION_ID is null) or
363: ACV.APPLICATION_ID = L_APPLICATION_ID)
364: and sysdate between ACV.START_DATE and nvl(ACV.END_DATE - (1/86400),sysdate);

Line 440: from AME_CONFIG_VARS_TL ACVTL

436: end if;
437: begin
438: select null
439: into L_DUMMY
440: from AME_CONFIG_VARS_TL ACVTL
441: where ACVTL.VARIABLE_NAME = X_VARIABLE_NAME
442: and ACVTL.LANGUAGE = userenv('LANG');
443:
444: update AME_CONFIG_VARS_TL ACVTL

Line 444: update AME_CONFIG_VARS_TL ACVTL

440: from AME_CONFIG_VARS_TL ACVTL
441: where ACVTL.VARIABLE_NAME = X_VARIABLE_NAME
442: and ACVTL.LANGUAGE = userenv('LANG');
443:
444: update AME_CONFIG_VARS_TL ACVTL
445: set USER_CONFIG_VAR_NAME = nvl(X_USER_CONFIG_VAR_NAME,ACVTL.USER_CONFIG_VAR_NAME),
446: DESCRIPTION = nvl(X_DESCRIPTION,ACVTL.DESCRIPTION),
447: SOURCE_LANG = userenv('LANG'),
448: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),

Line 480: from AME_CONFIG_VARS_TL ACVTL

476: AME_SEED_UTILITY.OWNER_AS_STRING(ACVTL.CREATED_BY)
477: into X_CURRENT_OWNER,
478: X_CURRENT_LAST_UPDATE_DATE,
479: X_CREATED_BY
480: from AME_CONFIG_VARS_TL ACVTL
481: where ACVTL.VARIABLE_NAME = X_VARIABLE_NAME
482: and ACVTL.LANGUAGE = userenv('LANG');
483: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
484: return true;

Line 505: from AME_CONFIG_VARS ACV,

501: select ACV.LAST_UPDATED_BY,
502: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)
503: into X_CURRENT_OWNER,
504: X_CURRENT_LAST_UPDATE_DATE
505: from AME_CONFIG_VARS ACV,
506: AME_CALLING_APPS ACA,
507: FND_APPLICATION_VL FAV
508: where FAV.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
509: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_ID

Line 521: from AME_CONFIG_VARS ACV

517: select ACV.LAST_UPDATED_BY,
518: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)
519: into X_CURRENT_OWNER,
520: X_CURRENT_LAST_UPDATE_DATE
521: from AME_CONFIG_VARS ACV
522: where (ACV.APPLICATION_ID is null or ACV.APPLICATION_ID = 0)
523: and ACV.VARIABLE_NAME = X_VARIABLE_NAME
524: and sysdate between ACV.START_DATE and nvl(ACV.END_DATE - (1/86400),sysdate);
525: end if;

Line 653: delete from AME_CONFIG_VARS

649: (X_VARIABLE_NAME in varchar2
650: ,X_APPLICATION_ID in number
651: ) as
652: begin
653: delete from AME_CONFIG_VARS
654: where VARIABLE_NAME = X_VARIABLE_NAME
655: and nvl(APPLICATION_ID,0) = nvl(X_APPLICATION_ID,0);
656: if sql%notfound then
657: raise no_data_found;

Line 660: delete from AME_CONFIG_VARS_TL

656: if sql%notfound then
657: raise no_data_found;
658: end if;
659: if AME_SEED_UTILITY.MLS_ENABLED then
660: delete from AME_CONFIG_VARS_TL
661: where VARIABLE_NAME = X_VARIABLE_NAME;
662: end if;
663: end DELETE_ROW;
664:

Line 665: end AME_CONFIG_VARS_API;

661: where VARIABLE_NAME = X_VARIABLE_NAME;
662: end if;
663: end DELETE_ROW;
664:
665: end AME_CONFIG_VARS_API;