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_VALUES_PKG dependencies on FND_LOOKUP_VALUES

Line 1: PACKAGE BODY FND_LOOKUP_VALUES_PKG as

1: PACKAGE BODY FND_LOOKUP_VALUES_PKG as
2: /* $Header: AFLVMLUB.pls 120.3 2011/02/21 22:50:03 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 42: cursor C is select ROWID from FND_LOOKUP_VALUES

38: ) is
39: sgid NUMBER;
40: X_LANG VARCHAR2(2);
41:
42: cursor C is select ROWID from FND_LOOKUP_VALUES
43: where LOOKUP_TYPE = X_LOOKUP_TYPE
44: and SECURITY_GROUP_ID = sgid
45: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
46: and LOOKUP_CODE = X_LOOKUP_CODE

Line 56: insert into FND_LOOKUP_VALUES (

52: else
53: sgid := X_SECURITY_GROUP_ID;
54: end if;
55:
56: insert into FND_LOOKUP_VALUES (
57: TAG,
58: ATTRIBUTE_CATEGORY,
59: ATTRIBUTE1,
60: ATTRIBUTE2,

Line 130: from FND_LOOKUP_VALUES T

126: from FND_LANGUAGES L
127: where L.INSTALLED_FLAG in ('I', 'B')
128: and not exists
129: (select NULL
130: from FND_LOOKUP_VALUES T
131: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
132: and T.SECURITY_GROUP_ID = sgid
133: and T.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
134: and T.LOOKUP_CODE = X_LOOKUP_CODE

Line 222: from FND_LOOKUP_VALUES

218: ATTRIBUTE15,
219: MEANING,
220: DESCRIPTION,
221: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: from FND_LOOKUP_VALUES
223: where LOOKUP_TYPE = X_LOOKUP_TYPE
224: and SECURITY_GROUP_ID = sgid
225: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
226: and LOOKUP_CODE = X_LOOKUP_CODE

Line 329: l_null varchar2(20) := fnd_lookup_values_pkg.null_char;

325: ) is
326: sgid NUMBER;
327: X_LANG VARCHAR2(2);
328:
329: l_null varchar2(20) := fnd_lookup_values_pkg.null_char;
330:
331: begin
332: -- Bug 2103124
333: if (X_SECURITY_GROUP_ID is NULL) then

Line 341: update FND_LOOKUP_VALUES A

337: end if;
338:
339: -- Update "non-translated" values in all languages
340:
341: update FND_LOOKUP_VALUES A
342: set
343: A.TAG = X_TAG,
344: A.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
345: A.ATTRIBUTE1 = decode(x_attribute1,l_null,null, null,A.attribute1, x_attribute1) ,

Line 373: update FND_LOOKUP_VALUES set

369: and A.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
370: and A.LOOKUP_CODE = X_LOOKUP_CODE;
371:
372: -- Update "translated" values in current language
373: update FND_LOOKUP_VALUES set
374: MEANING = X_MEANING,
375: DESCRIPTION = X_DESCRIPTION,
376: SOURCE_LANG = userenv('LANG')
377: where LOOKUP_TYPE = X_LOOKUP_TYPE

Line 467: from fnd_lookup_values

463: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
464:
465: select LAST_UPDATED_BY, LAST_UPDATE_DATE
466: into db_luby, db_ludate
467: from fnd_lookup_values
468: where LOOKUP_TYPE = X_LOOKUP_TYPE
469: and SECURITY_GROUP_ID = sgid
470: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
471: and LOOKUP_CODE = X_LOOKUP_CODE

Line 476: update FND_LOOKUP_VALUES set

472: and LANGUAGE = userenv('LANG');
473:
474: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
475: db_ludate, X_CUSTOM_MODE)) then
476: update FND_LOOKUP_VALUES set
477: MEANING = nvl(X_MEANING, meaning),
478: DESCRIPTION = nvl(X_DESCRIPTION, description),
479: LAST_UPDATE_DATE = f_ludate,
480: LAST_UPDATED_BY = f_luby,

Line 532: delete from FND_LOOKUP_VALUES

528: else
529: sgid := X_SECURITY_GROUP_ID;
530: end if;
531:
532: delete from FND_LOOKUP_VALUES
533: where LOOKUP_TYPE = X_LOOKUP_TYPE
534: and SECURITY_GROUP_ID = sgid
535: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
536: and LOOKUP_CODE = X_LOOKUP_CODE;

Line 573: update FND_LOOKUP_VALUES T set (

569: /* as a quick workaround to fix the time-consuming table handler issue */
570: /* Eventually we'll need to turn them into a separate fix_language procedure */
571: /*
572:
573: update FND_LOOKUP_VALUES T set (
574: MEANING,
575: DESCRIPTION
576: ) = (select
577: B.MEANING,

Line 579: from FND_LOOKUP_VALUES B

575: DESCRIPTION
576: ) = (select
577: B.MEANING,
578: B.DESCRIPTION
579: from FND_LOOKUP_VALUES B
580: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
581: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
582: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
583: and B.LOOKUP_CODE = T.LOOKUP_CODE

Line 597: from FND_LOOKUP_VALUES SUBB, FND_LOOKUP_VALUES SUBT

593: SUBT.SECURITY_GROUP_ID,
594: SUBT.VIEW_APPLICATION_ID,
595: SUBT.LOOKUP_CODE,
596: SUBT.LANGUAGE
597: from FND_LOOKUP_VALUES SUBB, FND_LOOKUP_VALUES SUBT
598: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
599: and SUBB.SECURITY_GROUP_ID = SUBT.SECURITY_GROUP_ID
600: and SUBB.VIEW_APPLICATION_ID = SUBT.VIEW_APPLICATION_ID
601: and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE

Line 611: from FND_LOOKUP_VALUES DUP

607: ))
608: -- ***** BEGIN NEW CLAUSE FOR UPDATE *****
609: and not exists
610: (select null
611: from FND_LOOKUP_VALUES DUP
612: where DUP.LOOKUP_TYPE = T.LOOKUP_TYPE
613: and DUP.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
614: and DUP.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
615: and DUP.LANGUAGE = T.LANGUAGE

Line 619: from FND_LOOKUP_VALUES B

615: and DUP.LANGUAGE = T.LANGUAGE
616: and (DUP.MEANING) =
617: (select
618: B.MEANING
619: from FND_LOOKUP_VALUES B
620: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
621: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
622: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
623: and B.LOOKUP_CODE = T.LOOKUP_CODE

Line 629: update FND_LOOKUP_VALUES set

625: -- ***** END NEW CLAUSE FOR UPDATE *****
626:
627: -- ***** NEW CODE FOR INSERT HERE *****
628: loop
629: update FND_LOOKUP_VALUES set
630: MEANING = '@'||MEANING
631: where (
632: LOOKUP_TYPE,
633: VIEW_APPLICATION_ID,

Line 643: from FND_LOOKUP_VALUES B, FND_LANGUAGES L

639: B.VIEW_APPLICATION_ID,
640: B.MEANING,
641: B.SECURITY_GROUP_ID,
642: L.LANGUAGE_CODE
643: from FND_LOOKUP_VALUES B, FND_LANGUAGES L
644: where L.INSTALLED_FLAG in ('I', 'B')
645: and B.LANGUAGE = userenv('LANG')
646: and not exists
647: (select NULL

Line 648: from FND_LOOKUP_VALUES T

644: where L.INSTALLED_FLAG in ('I', 'B')
645: and B.LANGUAGE = userenv('LANG')
646: and not exists
647: (select NULL
648: from FND_LOOKUP_VALUES T
649: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
650: and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
651: and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
652: and T.LOOKUP_CODE = B.LOOKUP_CODE

Line 660: insert into FND_LOOKUP_VALUES (

656: end loop;
657: -- ***** END CODE FOR INSERT HERE *****
658: */
659:
660: insert into FND_LOOKUP_VALUES (
661: TAG,
662: ATTRIBUTE_CATEGORY,
663: ATTRIBUTE1,
664: ATTRIBUTE2,

Line 730: from FND_LOOKUP_VALUES B, FND_LANGUAGES L

726: B.ATTRIBUTE14,
727: B.ATTRIBUTE15,
728: L.LANGUAGE_CODE,
729: B.SOURCE_LANG
730: from FND_LOOKUP_VALUES B, FND_LANGUAGES L
731: where L.INSTALLED_FLAG in ('I', 'B')
732: and B.LANGUAGE = userenv('LANG')
733: and not exists
734: (select NULL

Line 735: from FND_LOOKUP_VALUES T

731: where L.INSTALLED_FLAG in ('I', 'B')
732: and B.LANGUAGE = userenv('LANG')
733: and not exists
734: (select NULL
735: from FND_LOOKUP_VALUES T
736: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
737: and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
738: and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
739: and T.LOOKUP_CODE = B.LOOKUP_CODE

Line 810: from fnd_lookup_values_vl

806: -- check the db last update fields for each record in the cursor
807: begin
808: select LAST_UPDATED_BY, LAST_UPDATE_DATE
809: into db_luby, db_ludate
810: from fnd_lookup_values_vl
811: where LOOKUP_TYPE = X_LOOKUP_TYPE
812: and SECURITY_GROUP_ID = secgrp.security_group_id
813: and VIEW_APPLICATION_ID = view_appid
814: and LOOKUP_CODE = X_LOOKUP_CODE;

Line 818: Fnd_Lookup_Values_Pkg.Update_Row (

814: and LOOKUP_CODE = X_LOOKUP_CODE;
815:
816: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
817: db_ludate, X_CUSTOM_MODE)) then
818: Fnd_Lookup_Values_Pkg.Update_Row (
819: X_LOOKUP_TYPE => x_lookup_type,
820: X_SECURITY_GROUP_ID => secgrp.security_group_id,
821: X_VIEW_APPLICATION_ID => view_appid,
822: X_LOOKUP_CODE => x_lookup_code,

Line 855: Fnd_Lookup_Values_Pkg.Insert_Row(

851: end if;
852:
853: exception
854: when no_data_found then
855: Fnd_Lookup_Values_Pkg.Insert_Row(
856: X_ROWID => row_id,
857: X_LOOKUP_TYPE => x_lookup_type,
858: X_SECURITY_GROUP_ID => secgrp.security_group_id,
859: X_VIEW_APPLICATION_ID => view_appid,

Line 896: end FND_LOOKUP_VALUES_PKG;

892: end loop;
893:
894: end Load_Row;
895:
896: end FND_LOOKUP_VALUES_PKG;