DBA Data[Home] [Help]

APPS.FII_FDHM_PKG dependencies on FND_FLEX_VALUES

Line 59: FROM FND_FLEX_VALUES

55: END IF;
56:
57: SELECT COUNT(*)
58: INTO range_size
59: FROM FND_FLEX_VALUES
60: WHERE flex_value_set_id = child_value_set_id
61: AND summary_flag = sum_flag
62: AND flex_value BETWEEN range_low AND range_high;
63:

Line 91: FROM fnd_flex_values

87: the flex value immediately following the value to be removed.*/
88:
89: SELECT MIN(flex_value)
90: INTO new_bound
91: FROM fnd_flex_values
92: WHERE flex_value_set_id = child_value_set_id
93: AND summary_flag = sum_flag
94: AND flex_value > child
95: AND flex_value <= range_high

Line 125: FROM fnd_flex_values

121: the upper boundary of the original range has to be adjusted to be
122: the flex value immediately before the value to be removed. */
123: SELECT MAX(flex_value)
124: INTO new_bound
125: FROM fnd_flex_values
126: WHERE flex_value_set_id = child_value_set_id
127: AND summary_flag = sum_flag
128: AND flex_value >= range_low
129: AND flex_value < child

Line 180: FROM fnd_flex_values

176: original range, and the upper bound will be the flex value before
177: the value to be removed. */
178: SELECT MAX(flex_value)
179: INTO new_bound
180: FROM fnd_flex_values
181: WHERE flex_value_set_id = child_value_set_id
182: AND summary_flag = sum_flag
183: AND flex_value >= range_low
184: AND flex_value < child

Line 247: FROM fnd_flex_values

243: original range, and the lower bound will be the flex value after
244: the value to be removed. */
245: SELECT MIN(flex_value)
246: INTO new_bound
247: FROM fnd_flex_values
248: WHERE flex_value_set_id = child_value_set_id
249: AND summary_flag = sum_flag
250: AND flex_value > child
251: AND flex_value <= range_high

Line 323: FROM fnd_flex_values

319: IS
320: child VARCHAR2(60);
321: CURSOR find_children_cursor (low VARCHAR2, high VARCHAR2, vsid NUMBER) IS
322: SELECT flex_value
323: FROM fnd_flex_values
324: WHERE flex_value_set_id = vsid
325: AND summary_flag = 'Y'
326: AND flex_value BETWEEN low AND high
327: ORDER by flex_value;

Line 361: FROM fnd_flex_values

357: BEGIN
358: -- try to find another flex value that is the same as the current one
359: SELECT count(*)
360: INTO row_count
361: FROM fnd_flex_values
362: WHERE flex_value_set_id = value_set_id
363: AND flex_value = f_value
364: AND ((parent_low IS null) OR
365: (parent_flex_value_low = parent_low));

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;