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.

[Home] [Help]

APPS.ITA_SETUP_PARAMETERS_PKG dependencies on ITA_SETUP_PARAMETERS_TL

Line 81: insert into ITA_SETUP_PARAMETERS_TL (

77: X_COLUMN_REFERENCE1,
78: X_COLUMN_REFERENCE2
79: );
80:
81: insert into ITA_SETUP_PARAMETERS_TL (
82: PARAMETER_CODE,
83: PARAMETER_NAME,
84: CREATED_BY,
85: CREATION_DATE,

Line 107: from ITA_SETUP_PARAMETERS_TL T

103: from FND_LANGUAGES L
104: where L.INSTALLED_FLAG in ('I', 'B')
105: and not exists
106: (select NULL
107: from ITA_SETUP_PARAMETERS_TL T
108: where T.PARAMETER_CODE = X_PARAMETER_CODE
109: and T.LANGUAGE = L.LANGUAGE_CODE);
110:
111: open c;

Line 166: from ITA_SETUP_PARAMETERS_TL

162:
163: cursor c1 is select
164: PARAMETER_NAME,
165: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
166: from ITA_SETUP_PARAMETERS_TL
167: where PARAMETER_CODE = X_PARAMETER_CODE
168: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
169: for update of PARAMETER_CODE nowait;
170: begin

Line 284: update ITA_SETUP_PARAMETERS_TL set

280: if (sql%notfound) then
281: raise no_data_found;
282: end if;
283:
284: update ITA_SETUP_PARAMETERS_TL set
285: PARAMETER_NAME = X_PARAMETER_NAME,
286: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
287: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
288: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 302: delete from ITA_SETUP_PARAMETERS_TL

298: procedure DELETE_ROW (
299: X_PARAMETER_CODE in VARCHAR2
300: ) is
301: begin
302: delete from ITA_SETUP_PARAMETERS_TL
303: where PARAMETER_CODE = X_PARAMETER_CODE;
304:
305: if (sql%notfound) then
306: raise no_data_found;

Line 320: delete from ITA_SETUP_PARAMETERS_TL T

316:
317: procedure ADD_LANGUAGE
318: is
319: begin
320: delete from ITA_SETUP_PARAMETERS_TL T
321: where not exists
322: (select NULL
323: from ITA_SETUP_PARAMETERS_B B
324: where B.PARAMETER_CODE = T.PARAMETER_CODE

Line 327: update ITA_SETUP_PARAMETERS_TL T set (

323: from ITA_SETUP_PARAMETERS_B B
324: where B.PARAMETER_CODE = T.PARAMETER_CODE
325: );
326:
327: update ITA_SETUP_PARAMETERS_TL T set (
328: PARAMETER_NAME
329: ) = (select
330: B.PARAMETER_NAME
331: from ITA_SETUP_PARAMETERS_TL B

Line 331: from ITA_SETUP_PARAMETERS_TL B

327: update ITA_SETUP_PARAMETERS_TL T set (
328: PARAMETER_NAME
329: ) = (select
330: B.PARAMETER_NAME
331: from ITA_SETUP_PARAMETERS_TL B
332: where B.PARAMETER_CODE = T.PARAMETER_CODE
333: and B.LANGUAGE = T.SOURCE_LANG)
334: where (
335: T.PARAMETER_CODE,

Line 340: from ITA_SETUP_PARAMETERS_TL SUBB, ITA_SETUP_PARAMETERS_TL SUBT

336: T.LANGUAGE
337: ) in (select
338: SUBT.PARAMETER_CODE,
339: SUBT.LANGUAGE
340: from ITA_SETUP_PARAMETERS_TL SUBB, ITA_SETUP_PARAMETERS_TL SUBT
341: where SUBB.PARAMETER_CODE = SUBT.PARAMETER_CODE
342: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
343: and (SUBB.PARAMETER_NAME <> SUBT.PARAMETER_NAME
344: or (SUBB.PARAMETER_NAME is null and SUBT.PARAMETER_NAME is not null)

Line 348: insert into ITA_SETUP_PARAMETERS_TL (

344: or (SUBB.PARAMETER_NAME is null and SUBT.PARAMETER_NAME is not null)
345: or (SUBB.PARAMETER_NAME is not null and SUBT.PARAMETER_NAME is null)
346: ));
347:
348: insert into ITA_SETUP_PARAMETERS_TL (
349: PARAMETER_CODE,
350: PARAMETER_NAME,
351: CREATED_BY,
352: CREATION_DATE,

Line 370: from ITA_SETUP_PARAMETERS_TL B, FND_LANGUAGES L

366: B.LAST_UPDATE_LOGIN,
367: B.OBJECT_VERSION_NUMBER,
368: L.LANGUAGE_CODE,
369: B.SOURCE_LANG
370: from ITA_SETUP_PARAMETERS_TL B, FND_LANGUAGES L
371: where L.INSTALLED_FLAG in ('I', 'B')
372: and B.LANGUAGE = userenv('LANG')
373: and not exists
374: (select NULL

Line 375: from ITA_SETUP_PARAMETERS_TL T

371: where L.INSTALLED_FLAG in ('I', 'B')
372: and B.LANGUAGE = userenv('LANG')
373: and not exists
374: (select NULL
375: from ITA_SETUP_PARAMETERS_TL T
376: where T.PARAMETER_CODE = B.PARAMETER_CODE
377: and T.LANGUAGE = L.LANGUAGE_CODE);
378: end ADD_LANGUAGE;
379:

Line 481: -- Inserting records into the ITA_SETUP_PARAMETERS_B and ITA_SETUP_PARAMETERS_TL

477: end if;
478: exception
479: when no_data_found then
480: -- Record doesn't exist - insert in all cases
481: -- Inserting records into the ITA_SETUP_PARAMETERS_B and ITA_SETUP_PARAMETERS_TL
482: -- in and only if the parameter is part of the schema.
483: if flag = 'Y' then
484: ITA_SETUP_PARAMETERS_PKG.INSERT_ROW(
485: X_ROWID => ROW_ID,

Line 556: from ITA_SETUP_PARAMETERS_TL

552:
553: begin
554: select LAST_UPDATED_BY, LAST_UPDATE_DATE
555: into db_luby, db_ludate
556: from ITA_SETUP_PARAMETERS_TL
557: where PARAMETER_CODE = X_PARAMETER_CODE
558: and LANGUAGE = userenv('LANG');
559:
560: -- Test for customization and version

Line 564: update ITA_SETUP_PARAMETERS_TL set

560: -- Test for customization and version
561: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
562: db_ludate, x_CUSTOM_MODE)) then
563: -- Update translations for this language
564: update ITA_SETUP_PARAMETERS_TL set
565: PARAMETER_NAME = decode(x_PARAMETER_NAME,
566: fnd_load_util.null_value, null, -- Real null
567: null, x_PARAMETER_NAME, -- No change
568: x_PARAMETER_NAME),