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_FLEX_VALUES_PKG dependencies on FND_FLEX_VALUES

Line 1: package body FND_FLEX_VALUES_PKG as

1: package body FND_FLEX_VALUES_PKG as
2: /* $Header: AFFFVLSB.pls 120.5 2010/08/20 09:30:04 tebarnes ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 78: cursor C is select ROWID from FND_FLEX_VALUES

74: X_LAST_UPDATE_DATE in DATE,
75: X_LAST_UPDATED_BY in NUMBER,
76: X_LAST_UPDATE_LOGIN in NUMBER
77: ) is
78: cursor C is select ROWID from FND_FLEX_VALUES
79: where FLEX_VALUE_ID = X_FLEX_VALUE_ID
80: ;
81: begin
82: insert into FND_FLEX_VALUES (

Line 82: insert into FND_FLEX_VALUES (

78: cursor C is select ROWID from FND_FLEX_VALUES
79: where FLEX_VALUE_ID = X_FLEX_VALUE_ID
80: ;
81: begin
82: insert into FND_FLEX_VALUES (
83: ATTRIBUTE_SORT_ORDER,
84: FLEX_VALUE_SET_ID,
85: FLEX_VALUE_ID,
86: FLEX_VALUE,

Line 224: insert into FND_FLEX_VALUES_TL (

220: X_LAST_UPDATED_BY,
221: X_LAST_UPDATE_LOGIN
222: );
223:
224: insert into FND_FLEX_VALUES_TL (
225: FLEX_VALUE_ID,
226: LAST_UPDATE_DATE,
227: LAST_UPDATED_BY,
228: CREATION_DATE,

Line 250: from FND_FLEX_VALUES_TL T

246: from FND_LANGUAGES L
247: where L.INSTALLED_FLAG in ('I', 'B')
248: and not exists
249: (select NULL
250: from FND_FLEX_VALUES_TL T
251: where T.FLEX_VALUE_ID = X_FLEX_VALUE_ID
252: and T.LANGUAGE = L.LANGUAGE_CODE);
253:
254: open c;

Line 396: from FND_FLEX_VALUES

392: ATTRIBUTE47,
393: ATTRIBUTE48,
394: ATTRIBUTE49,
395: ATTRIBUTE50
396: from FND_FLEX_VALUES
397: where FLEX_VALUE_ID = X_FLEX_VALUE_ID
398: for update of FLEX_VALUE_ID nowait;
399: recinfo c%rowtype;
400:

Line 405: from FND_FLEX_VALUES_TL

401: cursor c1 is select
402: FLEX_VALUE_MEANING,
403: DESCRIPTION,
404: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
405: from FND_FLEX_VALUES_TL
406: where FLEX_VALUE_ID = X_FLEX_VALUE_ID
407: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
408: for update of FLEX_VALUE_ID nowait;
409: begin

Line 635: update FND_FLEX_VALUES set

631: X_LAST_UPDATED_BY in NUMBER,
632: X_LAST_UPDATE_LOGIN in NUMBER
633: ) is
634: begin
635: update FND_FLEX_VALUES set
636: ATTRIBUTE_SORT_ORDER = X_ATTRIBUTE_SORT_ORDER,
637: FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID,
638: FLEX_VALUE = X_FLEX_VALUE,
639: ENABLED_FLAG = X_ENABLED_FLAG,

Line 707: update FND_FLEX_VALUES_TL set

703:
704: if (sql%notfound) then
705: raise no_data_found;
706: else
707: update FND_FLEX_VALUES_TL set
708: FLEX_VALUE_MEANING = X_FLEX_VALUE_MEANING,
709: DESCRIPTION = X_DESCRIPTION,
710: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
711: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 718: insert into FND_FLEX_VALUES_TL (

714: where FLEX_VALUE_ID = X_FLEX_VALUE_ID
715: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
716:
717: if (sql%notfound) then
718: insert into FND_FLEX_VALUES_TL (
719: FLEX_VALUE_ID,
720: LAST_UPDATE_DATE,
721: LAST_UPDATED_BY,
722: CREATION_DATE,

Line 744: from FND_FLEX_VALUES_TL T

740: from FND_LANGUAGES L
741: where L.INSTALLED_FLAG in ('I', 'B')
742: and not exists
743: (select NULL
744: from FND_FLEX_VALUES_TL T
745: where T.FLEX_VALUE_ID = X_FLEX_VALUE_ID
746: and T.LANGUAGE = L.LANGUAGE_CODE);
747: -- raise no_data_found;
748: end if;

Line 756: delete from FND_FLEX_VALUES_TL

752: procedure DELETE_ROW (
753: X_FLEX_VALUE_ID in NUMBER
754: ) is
755: begin
756: delete from FND_FLEX_VALUES_TL
757: where FLEX_VALUE_ID = X_FLEX_VALUE_ID;
758:
759: if (sql%notfound) then
760: raise no_data_found;

Line 763: delete from FND_FLEX_VALUES

759: if (sql%notfound) then
760: raise no_data_found;
761: end if;
762:
763: delete from FND_FLEX_VALUES
764: where FLEX_VALUE_ID = X_FLEX_VALUE_ID;
765:
766: if (sql%notfound) then
767: raise no_data_found;

Line 774: /*For fnd_flex_values records with no rows in the fnd_flex_values_tl table,

770:
771: procedure ADD_BASE_LANGUAGE
772: is
773: BEGIN
774: /*For fnd_flex_values records with no rows in the fnd_flex_values_tl table,
775: add the base language row so the ADD_LANGUAGE code will add the additional
776: installed language rows */
777:
778:

Line 779: INSERT INTO FND_FLEX_VALUES_TL

775: add the base language row so the ADD_LANGUAGE code will add the additional
776: installed language rows */
777:
778:
779: INSERT INTO FND_FLEX_VALUES_TL
780: (FLEX_VALUE_ID,
781: LAST_UPDATE_DATE,
782: LAST_UPDATED_BY,
783: CREATION_DATE,

Line 803: FROM FND_FLEX_VALUES

799: where installed_flag='B'),
800: (select language_code
801: from fnd_languages
802: where installed_flag='B')
803: FROM FND_FLEX_VALUES
804: WHERE FLEX_VALUE_ID NOT IN
805: (SELECT FLEX_VALUE_ID
806: FROM FND_FLEX_VALUES_TL
807: WHERE FLEX_VALUE_ID IN

Line 806: FROM FND_FLEX_VALUES_TL

802: where installed_flag='B')
803: FROM FND_FLEX_VALUES
804: WHERE FLEX_VALUE_ID NOT IN
805: (SELECT FLEX_VALUE_ID
806: FROM FND_FLEX_VALUES_TL
807: WHERE FLEX_VALUE_ID IN
808: (SELECT FLEX_VALUE_ID
809: FROM FND_FLEX_VALUES));
810:

Line 809: FROM FND_FLEX_VALUES));

805: (SELECT FLEX_VALUE_ID
806: FROM FND_FLEX_VALUES_TL
807: WHERE FLEX_VALUE_ID IN
808: (SELECT FLEX_VALUE_ID
809: FROM FND_FLEX_VALUES));
810:
811: end ADD_BASE_LANGUAGE;
812:
813: procedure ADD_LANGUAGE

Line 822: delete from FND_FLEX_VALUES_TL T

818: /* as a quick workaround to fix the time-consuming table handler issue */
819: /* Eventually we'll need to turn them into a separate fix_language procedure */
820: /*
821:
822: delete from FND_FLEX_VALUES_TL T
823: where not exists
824: (select NULL
825: from FND_FLEX_VALUES B
826: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID

Line 825: from FND_FLEX_VALUES B

821:
822: delete from FND_FLEX_VALUES_TL T
823: where not exists
824: (select NULL
825: from FND_FLEX_VALUES B
826: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
827: );
828:
829: update FND_FLEX_VALUES_TL T set (

Line 829: update FND_FLEX_VALUES_TL T set (

825: from FND_FLEX_VALUES B
826: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
827: );
828:
829: update FND_FLEX_VALUES_TL T set (
830: FLEX_VALUE_MEANING,
831: DESCRIPTION
832: ) = (select
833: B.FLEX_VALUE_MEANING,

Line 835: from FND_FLEX_VALUES_TL B

831: DESCRIPTION
832: ) = (select
833: B.FLEX_VALUE_MEANING,
834: B.DESCRIPTION
835: from FND_FLEX_VALUES_TL B
836: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
837: and B.LANGUAGE = T.SOURCE_LANG)
838: where (
839: T.FLEX_VALUE_ID,

Line 844: from FND_FLEX_VALUES_TL SUBB, FND_FLEX_VALUES_TL SUBT

840: T.LANGUAGE
841: ) in (select
842: SUBT.FLEX_VALUE_ID,
843: SUBT.LANGUAGE
844: from FND_FLEX_VALUES_TL SUBB, FND_FLEX_VALUES_TL SUBT
845: where SUBB.FLEX_VALUE_ID = SUBT.FLEX_VALUE_ID
846: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
847: and (SUBB.FLEX_VALUE_MEANING <> SUBT.FLEX_VALUE_MEANING
848: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 854: /* Call ADD_BASE_LANGUAGE to insure all values in fnd_flex_values table

850: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
851: ));
852: */
853:
854: /* Call ADD_BASE_LANGUAGE to insure all values in fnd_flex_values table
855: have an associated row in the fnd_flex_values_tl table for the base language
856: before doing the add_language code to insert missing installed language
857: rows in the fnd_flex_values_tl table */
858:

Line 855: have an associated row in the fnd_flex_values_tl table for the base language

851: ));
852: */
853:
854: /* Call ADD_BASE_LANGUAGE to insure all values in fnd_flex_values table
855: have an associated row in the fnd_flex_values_tl table for the base language
856: before doing the add_language code to insert missing installed language
857: rows in the fnd_flex_values_tl table */
858:
859: add_base_language;

Line 857: rows in the fnd_flex_values_tl table */

853:
854: /* Call ADD_BASE_LANGUAGE to insure all values in fnd_flex_values table
855: have an associated row in the fnd_flex_values_tl table for the base language
856: before doing the add_language code to insert missing installed language
857: rows in the fnd_flex_values_tl table */
858:
859: add_base_language;
860:
861: insert /*+ append */ into FND_FLEX_VALUES_TL (

Line 861: insert /+ append / into FND_FLEX_VALUES_TL (

857: rows in the fnd_flex_values_tl table */
858:
859: add_base_language;
860:
861: insert /*+ append */ into FND_FLEX_VALUES_TL (
862: FLEX_VALUE_ID,
863: LAST_UPDATE_DATE,
864: LAST_UPDATED_BY,
865: CREATION_DATE,

Line 885: from FND_LANGUAGES L, FND_FLEX_VALUES_TL B

881: B.DESCRIPTION,
882: B.FLEX_VALUE_MEANING,
883: L.LANGUAGE_CODE,
884: B.SOURCE_LANG
885: from FND_LANGUAGES L, FND_FLEX_VALUES_TL B
886: where DECODE(L.INSTALLED_FLAG, 'I', 1, 'B', 1, 0) = 1
887: and B.LANGUAGE = userenv('LANG')
888: ) v, FND_FLEX_VALUES_TL t
889: where t.flex_value_id(+) = v.flex_value_id

Line 888: ) v, FND_FLEX_VALUES_TL t

884: B.SOURCE_LANG
885: from FND_LANGUAGES L, FND_FLEX_VALUES_TL B
886: where DECODE(L.INSTALLED_FLAG, 'I', 1, 'B', 1, 0) = 1
887: and B.LANGUAGE = userenv('LANG')
888: ) v, FND_FLEX_VALUES_TL t
889: where t.flex_value_id(+) = v.flex_value_id
890: and t.language(+) = v.language_code
891: and t.flex_value_id is NULL;
892:

Line 977: FROM fnd_flex_values

973: BEGIN
974: IF (l_validation_type in ('D', 'Y')) THEN
975: SELECT flex_value_id
976: INTO l_flex_value_id
977: FROM fnd_flex_values
978: WHERE flex_value_set_id = l_flex_value_set_id
979: AND flex_value = x_flex_value
980: AND (parent_flex_value_low = x_parent_flex_value_low OR
981: (parent_flex_value_low IS NULL AND

Line 986: FROM fnd_flex_values

982: x_parent_flex_value_low IS NULL));
983: ELSE
984: SELECT flex_value_id
985: INTO l_flex_value_id
986: FROM fnd_flex_values
987: WHERE flex_value_set_id = l_flex_value_set_id
988: AND flex_value = x_flex_value;
989: END IF;
990:

Line 991: fnd_flex_values_pkg.update_row

987: WHERE flex_value_set_id = l_flex_value_set_id
988: AND flex_value = x_flex_value;
989: END IF;
990:
991: fnd_flex_values_pkg.update_row
992: (X_FLEX_VALUE_ID => l_flex_value_id,
993: X_ATTRIBUTE_SORT_ORDER => x_attribute_sort_order,
994: X_FLEX_VALUE_SET_ID => l_flex_value_set_id,
995: X_FLEX_VALUE => x_flex_value,

Line 1063: SELECT fnd_flex_values_s.NEXTVAL

1059: X_LAST_UPDATED_BY => x_who.last_updated_by,
1060: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
1061: EXCEPTION
1062: WHEN no_data_found THEN
1063: SELECT fnd_flex_values_s.NEXTVAL
1064: INTO l_flex_value_id
1065: FROM dual;
1066:
1067: fnd_flex_values_pkg.insert_row

Line 1067: fnd_flex_values_pkg.insert_row

1063: SELECT fnd_flex_values_s.NEXTVAL
1064: INTO l_flex_value_id
1065: FROM dual;
1066:
1067: fnd_flex_values_pkg.insert_row
1068: (X_ROWID => l_rowid,
1069: X_FLEX_VALUE_ID => l_flex_value_id,
1070: X_ATTRIBUTE_SORT_ORDER => x_attribute_sort_order,
1071: X_FLEX_VALUE_SET_ID => l_flex_value_set_id,

Line 1159: UPDATE fnd_flex_values_tl SET

1155: INTO l_flex_value_set_id, l_validation_type
1156: FROM fnd_flex_value_sets
1157: WHERE flex_value_set_name = x_flex_value_set_name;
1158:
1159: UPDATE fnd_flex_values_tl SET
1160: flex_value_meaning = Decode(l_validation_type,
1161: 'X', Nvl(x_flex_value_meaning, flex_value_meaning),
1162: 'Y', Nvl(x_flex_value_meaning, flex_value_meaning),
1163: flex_value_meaning),

Line 1171: FROM fnd_flex_values

1167: last_update_login = x_who.last_update_login,
1168: source_lang = userenv('LANG')
1169: WHERE (flex_value_id =
1170: (SELECT flex_value_id
1171: FROM fnd_flex_values
1172: WHERE flex_value_set_id = l_flex_value_set_id
1173: AND flex_value = x_flex_value
1174: AND ((l_validation_type NOT IN ('D', 'Y')) OR
1175: (l_validation_type IN ('D', 'Y') AND

Line 1182: end FND_FLEX_VALUES_PKG;

1178: x_parent_flex_value_low IS NULL))))))
1179: AND userenv('LANG') in (language, source_lang);
1180: END translate_row;
1181:
1182: end FND_FLEX_VALUES_PKG;