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_TL

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 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 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 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 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 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 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 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 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),