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.FND_LOOKUP_TYPES_PKG dependencies on FND_LOOKUP_TYPES

Line 1: package body FND_LOOKUP_TYPES_PKG as

1: package body FND_LOOKUP_TYPES_PKG as
2: /* $Header: AFLVMLTB.pls 120.2 2007/10/05 18:49:52 dggriffi ship $ */
3:
4:
5: X_LANG VARCHAR2(2);

Line 22: cursor C is select ROWID from FND_LOOKUP_TYPES

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from FND_LOOKUP_TYPES
23: where LOOKUP_TYPE = X_LOOKUP_TYPE
24: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
25: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
26: ;

Line 30: insert into FND_LOOKUP_TYPES (

26: ;
27:
28:
29: begin
30: insert into FND_LOOKUP_TYPES (
31: APPLICATION_ID,
32: LOOKUP_TYPE,
33: CUSTOMIZATION_LEVEL,
34: SECURITY_GROUP_ID,

Line 54: insert into FND_LOOKUP_TYPES_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FND_LOOKUP_TYPES_TL (
55: LOOKUP_TYPE,
56: SECURITY_GROUP_ID,
57: VIEW_APPLICATION_ID,
58: MEANING,

Line 84: from FND_LOOKUP_TYPES_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from FND_LOOKUP_TYPES_TL T
85: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
86: and T.SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
87: and T.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 170: from fnd_lookup_types_tl

166: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
167:
168: select last_updated_by, last_update_date
169: into db_luby, db_ludate
170: from fnd_lookup_types_tl
171: where lookup_type = X_LOOKUP_TYPE
172: and security_group_id = X_SECURITY_GROUP_ID
173: and view_application_id = X_VIEW_APPLICATION_ID
174: and language = userenv('LANG');

Line 178: update fnd_lookup_types_tl set

174: and language = userenv('LANG');
175:
176: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
177: db_ludate, X_CUSTOM_MODE)) then
178: update fnd_lookup_types_tl set
179: meaning = nvl(X_MEANING, meaning),
180: description = nvl(X_DESCRIPTION, description),
181: last_update_date = f_ludate,
182: last_updated_by = f_luby,

Line 226: from FND_LOOKUP_TYPES

222: ) is
223: cursor c is select
224: APPLICATION_ID,
225: CUSTOMIZATION_LEVEL
226: from FND_LOOKUP_TYPES
227: where LOOKUP_TYPE = X_LOOKUP_TYPE
228: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
229: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
230: for update of LOOKUP_TYPE nowait;

Line 237: from FND_LOOKUP_TYPES_TL

233: cursor c1 is select
234: MEANING,
235: DESCRIPTION,
236: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
237: from FND_LOOKUP_TYPES_TL
238: where LOOKUP_TYPE = X_LOOKUP_TYPE
239: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
240: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
241: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 293: update FND_LOOKUP_TYPES set

289: ) is
290:
291:
292: begin
293: update FND_LOOKUP_TYPES set
294: APPLICATION_ID = X_APPLICATION_ID,
295: CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
296: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
297: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 307: update FND_LOOKUP_TYPES_TL set

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update FND_LOOKUP_TYPES_TL set
308: MEANING = X_MEANING,
309: DESCRIPTION = X_DESCRIPTION,
310: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 351: delete from FND_LOOKUP_TYPES_TL

347: X_SECURITY_GROUP_ID in NUMBER,
348: X_VIEW_APPLICATION_ID in NUMBER
349: ) is
350: begin
351: delete from FND_LOOKUP_TYPES_TL
352: where LOOKUP_TYPE = X_LOOKUP_TYPE
353: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
354: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID;
355:

Line 360: delete from FND_LOOKUP_TYPES

356: if (sql%notfound) then
357: raise no_data_found;
358: end if;
359:
360: delete from FND_LOOKUP_TYPES
361: where LOOKUP_TYPE = X_LOOKUP_TYPE
362: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
363: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID;
364:

Line 400: delete from FND_LOOKUP_TYPES_TL T

396: /* as a quick workaround to fix the time-consuming table handler issue */
397: /* Eventually we'll need to turn them into a separate fix_language procedure */
398: /*
399:
400: delete from FND_LOOKUP_TYPES_TL T
401: where not exists
402: (select NULL
403: from FND_LOOKUP_TYPES B
404: where B.LOOKUP_TYPE = T.LOOKUP_TYPE

Line 403: from FND_LOOKUP_TYPES B

399:
400: delete from FND_LOOKUP_TYPES_TL T
401: where not exists
402: (select NULL
403: from FND_LOOKUP_TYPES B
404: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
405: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
406: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
407: );

Line 409: update FND_LOOKUP_TYPES_TL T set (

405: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
406: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
407: );
408:
409: update FND_LOOKUP_TYPES_TL T set (
410: MEANING,
411: DESCRIPTION
412: ) = (select
413: B.MEANING,

Line 415: from FND_LOOKUP_TYPES_TL B

411: DESCRIPTION
412: ) = (select
413: B.MEANING,
414: B.DESCRIPTION
415: from FND_LOOKUP_TYPES_TL B
416: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
417: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
418: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
419: and B.LANGUAGE = T.SOURCE_LANG)

Line 430: from FND_LOOKUP_TYPES_TL SUBB, FND_LOOKUP_TYPES_TL SUBT

426: SUBT.LOOKUP_TYPE,
427: SUBT.SECURITY_GROUP_ID,
428: SUBT.VIEW_APPLICATION_ID,
429: SUBT.LANGUAGE
430: from FND_LOOKUP_TYPES_TL SUBB, FND_LOOKUP_TYPES_TL SUBT
431: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
432: and SUBB.SECURITY_GROUP_ID = SUBT.SECURITY_GROUP_ID
433: and SUBB.VIEW_APPLICATION_ID = SUBT.VIEW_APPLICATION_ID
434: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 443: from FND_LOOKUP_TYPES_TL DUP

439: ))
440: -- ***** BEGIN NEW CLAUSE FOR UPDATE *****
441: and not exists
442: (select null
443: from FND_LOOKUP_TYPES_TL DUP
444: where DUP.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
445: and DUP.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
446: and DUP.LANGUAGE = T.LANGUAGE
447: and (DUP.MEANING) =

Line 450: from FND_LOOKUP_TYPES_TL B

446: and DUP.LANGUAGE = T.LANGUAGE
447: and (DUP.MEANING) =
448: (select
449: B.MEANING
450: from FND_LOOKUP_TYPES_TL B
451: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
452: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
453: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
454: and B.LANGUAGE = T.SOURCE_LANG));

Line 459: update FND_LOOKUP_TYPES_TL set

455: -- ***** END NEW CLAUSE FOR UPDATE *****
456:
457: -- ***** NEW CODE FOR INSERT HERE *****
458: loop
459: update FND_LOOKUP_TYPES_TL set
460: MEANING = '@'||MEANING
461: where (
462: MEANING,
463: VIEW_APPLICATION_ID,

Line 471: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L

467: B.MEANING,
468: B.VIEW_APPLICATION_ID,
469: B.SECURITY_GROUP_ID,
470: L.LANGUAGE_CODE
471: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL

Line 476: from FND_LOOKUP_TYPES_TL T

472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from FND_LOOKUP_TYPES_TL T
477: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
478: and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
479: and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
480: and T.LANGUAGE = L.LANGUAGE_CODE));

Line 487: insert into FND_LOOKUP_TYPES_TL (

483: end loop;
484: -- ***** END CODE FOR INSERT HERE *****
485: */
486:
487: insert into FND_LOOKUP_TYPES_TL (
488: LOOKUP_TYPE,
489: SECURITY_GROUP_ID,
490: VIEW_APPLICATION_ID,
491: MEANING,

Line 513: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L

509: B.LAST_UPDATE_DATE,
510: B.LAST_UPDATE_LOGIN,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from FND_LOOKUP_TYPES_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from FND_LOOKUP_TYPES_TL T
519: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
520: and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
521: and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
522: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 548: from FND_LOOKUP_TYPES LT, FND_SECURITY_GROUPS SG

544: db_ludate date; -- entity update date in db
545:
546: cursor secgrp_curs is
547: select SG.SECURITY_GROUP_ID
548: from FND_LOOKUP_TYPES LT, FND_SECURITY_GROUPS SG
549: where LT.LOOKUP_TYPE = x_lookup_type
550: and LT.VIEW_APPLICATION_ID = view_appid
551: and LT.SECURITY_GROUP_ID = SG.SECURITY_GROUP_ID
552: and SG.SECURITY_GROUP_KEY like nvl(x_security_group, 'STANDARD');

Line 583: Fnd_Lookup_Types_Pkg.Insert_Row(

579: into secgrp_id
580: from FND_SECURITY_GROUPS
581: where SECURITY_GROUP_KEY = nvl(x_security_group, 'STANDARD');
582:
583: Fnd_Lookup_Types_Pkg.Insert_Row(
584: x_rowid => row_id,
585: x_lookup_type => x_lookup_type,
586: x_security_group_id => secgrp_id,
587: x_view_application_id => view_appid,

Line 601: from FND_LOOKUP_TYPES_VL

597: else
598: loop
599: select LAST_UPDATED_BY, LAST_UPDATE_DATE
600: into db_luby, db_ludate
601: from FND_LOOKUP_TYPES_VL
602: where LOOKUP_TYPE = x_lookup_type
603: and SECURITY_GROUP_ID = secgrp_id
604: and VIEW_APPLICATION_ID = view_appid;
605:

Line 609: Fnd_Lookup_Types_Pkg.Update_Row(

605:
606: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
607: db_ludate, X_CUSTOM_MODE)) then
608: -- Update row in all matching security groups.
609: Fnd_Lookup_Types_Pkg.Update_Row(
610: x_lookup_type => x_lookup_type,
611: x_security_group_id => secgrp_id,
612: x_view_application_id => view_appid,
613: x_application_id => owner_appid,

Line 631: end FND_LOOKUP_TYPES_PKG;

627: close secgrp_curs;
628:
629: end LOAD_ROW;
630:
631: end FND_LOOKUP_TYPES_PKG;