DBA Data[Home] [Help]

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.2 2007/10/09 15:14:49 dggriffi 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 338: update FND_LOOKUP_VALUES set

334: sgid := X_SECURITY_GROUP_ID;
335: end if;
336:
337: -- Update "non-translated" values in all languages
338: update FND_LOOKUP_VALUES set
339: TAG = X_TAG,
340: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
341: ATTRIBUTE1 = X_ATTRIBUTE1,
342: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 369: update FND_LOOKUP_VALUES set

365: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
366: and LOOKUP_CODE = X_LOOKUP_CODE;
367:
368: -- Update "translated" values in current language
369: update FND_LOOKUP_VALUES set
370: MEANING = X_MEANING,
371: DESCRIPTION = X_DESCRIPTION,
372: SOURCE_LANG = userenv('LANG')
373: where LOOKUP_TYPE = X_LOOKUP_TYPE

Line 463: from fnd_lookup_values

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

Line 472: update FND_LOOKUP_VALUES set

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

Line 528: delete from FND_LOOKUP_VALUES

524: else
525: sgid := X_SECURITY_GROUP_ID;
526: end if;
527:
528: delete from FND_LOOKUP_VALUES
529: where LOOKUP_TYPE = X_LOOKUP_TYPE
530: and SECURITY_GROUP_ID = sgid
531: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
532: and LOOKUP_CODE = X_LOOKUP_CODE;

Line 569: update FND_LOOKUP_VALUES T set (

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

Line 575: from FND_LOOKUP_VALUES B

571: DESCRIPTION
572: ) = (select
573: B.MEANING,
574: B.DESCRIPTION
575: from FND_LOOKUP_VALUES B
576: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
577: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
578: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
579: and B.LOOKUP_CODE = T.LOOKUP_CODE

Line 593: from FND_LOOKUP_VALUES SUBB, FND_LOOKUP_VALUES SUBT

589: SUBT.SECURITY_GROUP_ID,
590: SUBT.VIEW_APPLICATION_ID,
591: SUBT.LOOKUP_CODE,
592: SUBT.LANGUAGE
593: from FND_LOOKUP_VALUES SUBB, FND_LOOKUP_VALUES SUBT
594: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
595: and SUBB.SECURITY_GROUP_ID = SUBT.SECURITY_GROUP_ID
596: and SUBB.VIEW_APPLICATION_ID = SUBT.VIEW_APPLICATION_ID
597: and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE

Line 607: from FND_LOOKUP_VALUES DUP

603: ))
604: -- ***** BEGIN NEW CLAUSE FOR UPDATE *****
605: and not exists
606: (select null
607: from FND_LOOKUP_VALUES DUP
608: where DUP.LOOKUP_TYPE = T.LOOKUP_TYPE
609: and DUP.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
610: and DUP.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
611: and DUP.LANGUAGE = T.LANGUAGE

Line 615: from FND_LOOKUP_VALUES B

611: and DUP.LANGUAGE = T.LANGUAGE
612: and (DUP.MEANING) =
613: (select
614: B.MEANING
615: from FND_LOOKUP_VALUES B
616: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
617: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
618: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
619: and B.LOOKUP_CODE = T.LOOKUP_CODE

Line 625: update FND_LOOKUP_VALUES set

621: -- ***** END NEW CLAUSE FOR UPDATE *****
622:
623: -- ***** NEW CODE FOR INSERT HERE *****
624: loop
625: update FND_LOOKUP_VALUES set
626: MEANING = '@'||MEANING
627: where (
628: LOOKUP_TYPE,
629: VIEW_APPLICATION_ID,

Line 639: from FND_LOOKUP_VALUES B, FND_LANGUAGES L

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

Line 644: from FND_LOOKUP_VALUES T

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

Line 656: insert into FND_LOOKUP_VALUES (

652: end loop;
653: -- ***** END CODE FOR INSERT HERE *****
654: */
655:
656: insert into FND_LOOKUP_VALUES (
657: TAG,
658: ATTRIBUTE_CATEGORY,
659: ATTRIBUTE1,
660: ATTRIBUTE2,

Line 726: from FND_LOOKUP_VALUES B, FND_LANGUAGES L

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

Line 731: from FND_LOOKUP_VALUES T

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

Line 806: from fnd_lookup_values_vl

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

Line 814: Fnd_Lookup_Values_Pkg.Update_Row (

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

Line 851: Fnd_Lookup_Values_Pkg.Insert_Row(

847: end if;
848:
849: exception
850: when no_data_found then
851: Fnd_Lookup_Values_Pkg.Insert_Row(
852: X_ROWID => row_id,
853: X_LOOKUP_TYPE => x_lookup_type,
854: X_SECURITY_GROUP_ID => secgrp.security_group_id,
855: X_VIEW_APPLICATION_ID => view_appid,

Line 892: end FND_LOOKUP_VALUES_PKG;

888: end loop;
889:
890: end Load_Row;
891:
892: end FND_LOOKUP_VALUES_PKG;