APPS.FII_FDHM_PKG dependencies on FND_FLEX_VALUES_TL

Line 695: insert into FND_FLEX_VALUES_TL (

691: IF ( installed_lang_cursor%NOTFOUND ) THEN
692: CLOSE installed_lang_cursor;
693: RETURN;
694: ELSIF ( lang_code <> userenv('LANG') ) THEN
695: insert into FND_FLEX_VALUES_TL (
696: FLEX_VALUE_ID,
697: LAST_UPDATE_DATE,
698: LAST_UPDATED_BY,
699: CREATION_DATE,

Line 718: from fnd_flex_values_tl t1 left outer join

714: t1.DESCRIPTION,
715: t1.FLEX_VALUE_MEANING,
716: lang_code,
717: t1.SOURCE_LANG
718: from fnd_flex_values_tl t1 left outer join
719: fnd_flex_values_tl t2
720: on t1.flex_value_id = t2.flex_value_id
721: and t2.language = lang_code
722: where t1.language = userenv('LANG')

Line 719: fnd_flex_values_tl t2

715: t1.FLEX_VALUE_MEANING,
716: lang_code,
717: t1.SOURCE_LANG
718: from fnd_flex_values_tl t1 left outer join
719: fnd_flex_values_tl t2
720: on t1.flex_value_id = t2.flex_value_id
721: and t2.language = lang_code
722: where t1.language = userenv('LANG')
723: and t2.flex_value_id is NULL

Line 734: insert into FND_FLEX_VALUES_TL(

730:
731: PROCEDURE insert_tl_records_for_id(value_id number) is
732: BEGIN
733:
734: insert into FND_FLEX_VALUES_TL(
735: FLEX_VALUE_ID,
736: LAST_UPDATE_DATE,
737: LAST_UPDATED_BY,
738: CREATION_DATE,

Line 757: from fnd_flex_values_tl t1, FND_LANGUAGES ls

753: t1.DESCRIPTION,
754: t1.FLEX_VALUE_MEANING,
755: ls.LANGUAGE_CODE,
756: t1.SOURCE_LANG
757: from fnd_flex_values_tl t1, FND_LANGUAGES ls
758: where t1.flex_value_id = value_id
759: and t1.language = userenv('LANG')
760: and ls.INSTALLED_FLAG in ('B', 'I')
761: and ls.LANGUAGE_CODE <> userenv('LANG');

Line 768: delete from FND_FLEX_VALUES_TL

764:
765: PROCEDURE delete_tl_records_for_id(value_id number) is
766: BEGIN
767:
768: delete from FND_FLEX_VALUES_TL
769: where flex_value_id = value_id
770: and language <> userenv('LANG');
771:
772: END delete_tl_records_for_id;