APPS.AME_CONFIG_VARS_API dependencies on AME_CONFIG_VARS_TL

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 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 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 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 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 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: