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