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.1.12010000.1 2008/07/25 14:14:55 appldev 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 708: update FND_FLEX_VALUES_TL set

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

Line 727: delete from FND_FLEX_VALUES_TL

723: procedure DELETE_ROW (
724: X_FLEX_VALUE_ID in NUMBER
725: ) is
726: begin
727: delete from FND_FLEX_VALUES_TL
728: where FLEX_VALUE_ID = X_FLEX_VALUE_ID;
729:
730: if (sql%notfound) then
731: raise no_data_found;

Line 734: delete from FND_FLEX_VALUES

730: if (sql%notfound) then
731: raise no_data_found;
732: end if;
733:
734: delete from FND_FLEX_VALUES
735: where FLEX_VALUE_ID = X_FLEX_VALUE_ID;
736:
737: if (sql%notfound) then
738: raise no_data_found;

Line 751: delete from FND_FLEX_VALUES_TL T

747: /* as a quick workaround to fix the time-consuming table handler issue */
748: /* Eventually we'll need to turn them into a separate fix_language procedure */
749: /*
750:
751: delete from FND_FLEX_VALUES_TL T
752: where not exists
753: (select NULL
754: from FND_FLEX_VALUES B
755: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID

Line 754: from FND_FLEX_VALUES B

750:
751: delete from FND_FLEX_VALUES_TL T
752: where not exists
753: (select NULL
754: from FND_FLEX_VALUES B
755: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
756: );
757:
758: update FND_FLEX_VALUES_TL T set (

Line 758: update FND_FLEX_VALUES_TL T set (

754: from FND_FLEX_VALUES B
755: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
756: );
757:
758: update FND_FLEX_VALUES_TL T set (
759: FLEX_VALUE_MEANING,
760: DESCRIPTION
761: ) = (select
762: B.FLEX_VALUE_MEANING,

Line 764: from FND_FLEX_VALUES_TL B

760: DESCRIPTION
761: ) = (select
762: B.FLEX_VALUE_MEANING,
763: B.DESCRIPTION
764: from FND_FLEX_VALUES_TL B
765: where B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
766: and B.LANGUAGE = T.SOURCE_LANG)
767: where (
768: T.FLEX_VALUE_ID,

Line 773: from FND_FLEX_VALUES_TL SUBB, FND_FLEX_VALUES_TL SUBT

769: T.LANGUAGE
770: ) in (select
771: SUBT.FLEX_VALUE_ID,
772: SUBT.LANGUAGE
773: from FND_FLEX_VALUES_TL SUBB, FND_FLEX_VALUES_TL SUBT
774: where SUBB.FLEX_VALUE_ID = SUBT.FLEX_VALUE_ID
775: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
776: and (SUBB.FLEX_VALUE_MEANING <> SUBT.FLEX_VALUE_MEANING
777: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 783: insert /+ append parallel(tt) / into FND_FLEX_VALUES_TL tt (

779: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
780: ));
781: */
782:
783: insert /*+ append parallel(tt) */ into FND_FLEX_VALUES_TL tt (
784: FLEX_VALUE_ID,
785: LAST_UPDATE_DATE,
786: LAST_UPDATED_BY,
787: CREATION_DATE,

Line 807: from FND_FLEX_VALUES_TL B, FND_LANGUAGES L

803: B.DESCRIPTION,
804: B.FLEX_VALUE_MEANING,
805: L.LANGUAGE_CODE,
806: B.SOURCE_LANG
807: from FND_FLEX_VALUES_TL B, FND_LANGUAGES L
808: where L.INSTALLED_FLAG in ('I', 'B')
809: and B.LANGUAGE = userenv('LANG')
810: ) v, FND_FLEX_VALUES_TL t
811: where t.flex_value_id(+) = v.flex_value_id

Line 810: ) v, FND_FLEX_VALUES_TL t

806: B.SOURCE_LANG
807: from FND_FLEX_VALUES_TL B, FND_LANGUAGES L
808: where L.INSTALLED_FLAG in ('I', 'B')
809: and B.LANGUAGE = userenv('LANG')
810: ) v, FND_FLEX_VALUES_TL t
811: where t.flex_value_id(+) = v.flex_value_id
812: and t.language(+) = v.language_code
813: and t.flex_value_id is NULL;
814:

Line 899: FROM fnd_flex_values

895: BEGIN
896: IF (l_validation_type in ('D', 'Y')) THEN
897: SELECT flex_value_id
898: INTO l_flex_value_id
899: FROM fnd_flex_values
900: WHERE flex_value_set_id = l_flex_value_set_id
901: AND flex_value = x_flex_value
902: AND (parent_flex_value_low = x_parent_flex_value_low OR
903: (parent_flex_value_low IS NULL AND

Line 908: FROM fnd_flex_values

904: x_parent_flex_value_low IS NULL));
905: ELSE
906: SELECT flex_value_id
907: INTO l_flex_value_id
908: FROM fnd_flex_values
909: WHERE flex_value_set_id = l_flex_value_set_id
910: AND flex_value = x_flex_value;
911: END IF;
912:

Line 913: fnd_flex_values_pkg.update_row

909: WHERE flex_value_set_id = l_flex_value_set_id
910: AND flex_value = x_flex_value;
911: END IF;
912:
913: fnd_flex_values_pkg.update_row
914: (X_FLEX_VALUE_ID => l_flex_value_id,
915: X_ATTRIBUTE_SORT_ORDER => x_attribute_sort_order,
916: X_FLEX_VALUE_SET_ID => l_flex_value_set_id,
917: X_FLEX_VALUE => x_flex_value,

Line 985: SELECT fnd_flex_values_s.NEXTVAL

981: X_LAST_UPDATED_BY => x_who.last_updated_by,
982: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
983: EXCEPTION
984: WHEN no_data_found THEN
985: SELECT fnd_flex_values_s.NEXTVAL
986: INTO l_flex_value_id
987: FROM dual;
988:
989: fnd_flex_values_pkg.insert_row

Line 989: fnd_flex_values_pkg.insert_row

985: SELECT fnd_flex_values_s.NEXTVAL
986: INTO l_flex_value_id
987: FROM dual;
988:
989: fnd_flex_values_pkg.insert_row
990: (X_ROWID => l_rowid,
991: X_FLEX_VALUE_ID => l_flex_value_id,
992: X_ATTRIBUTE_SORT_ORDER => x_attribute_sort_order,
993: X_FLEX_VALUE_SET_ID => l_flex_value_set_id,

Line 1081: UPDATE fnd_flex_values_tl SET

1077: INTO l_flex_value_set_id, l_validation_type
1078: FROM fnd_flex_value_sets
1079: WHERE flex_value_set_name = x_flex_value_set_name;
1080:
1081: UPDATE fnd_flex_values_tl SET
1082: flex_value_meaning = Decode(l_validation_type,
1083: 'X', Nvl(x_flex_value_meaning, flex_value_meaning),
1084: 'Y', Nvl(x_flex_value_meaning, flex_value_meaning),
1085: flex_value_meaning),

Line 1093: FROM fnd_flex_values

1089: last_update_login = x_who.last_update_login,
1090: source_lang = userenv('LANG')
1091: WHERE (flex_value_id =
1092: (SELECT flex_value_id
1093: FROM fnd_flex_values
1094: WHERE flex_value_set_id = l_flex_value_set_id
1095: AND flex_value = x_flex_value
1096: AND ((l_validation_type NOT IN ('D', 'Y')) OR
1097: (l_validation_type IN ('D', 'Y') AND

Line 1104: end FND_FLEX_VALUES_PKG;

1100: x_parent_flex_value_low IS NULL))))))
1101: AND userenv('LANG') in (language, source_lang);
1102: END translate_row;
1103:
1104: end FND_FLEX_VALUES_PKG;