APPS.GL_JAHE_PKG dependencies on FND_FLEX_VALUES

Line 72: FROM FND_FLEX_VALUES

68: END IF;
69:
70: SELECT COUNT(*)
71: INTO range_size
72: FROM FND_FLEX_VALUES
73: WHERE flex_value_set_id = value_set_id
74: AND summary_flag = sum_flag
75: AND flex_value BETWEEN range_low AND range_high;
76:

Line 93: FROM fnd_flex_values

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

Line 115: FROM fnd_flex_values

111: the upper boundary of the original range has to be adjusted to be
112: the flex value immediately before the value to be removed. */
113: SELECT MAX(flex_value)
114: INTO new_bound
115: FROM fnd_flex_values
116: WHERE flex_value_set_id = value_set_id
117: AND summary_flag = sum_flag
118: AND flex_value >= range_low
119: AND flex_value < child

Line 148: FROM fnd_flex_values

144: original range, and the upper bound will be the flex value before
145: the value to be removed. */
146: SELECT MAX(flex_value)
147: INTO new_bound
148: FROM fnd_flex_values
149: WHERE flex_value_set_id = value_set_id
150: AND summary_flag = sum_flag
151: AND flex_value >= range_low
152: AND flex_value < child

Line 187: FROM fnd_flex_values

183: original range, and the lower bound will be the flex value after
184: the value to be removed. */
185: SELECT MIN(flex_value)
186: INTO new_bound
187: FROM fnd_flex_values
188: WHERE flex_value_set_id = value_set_id
189: AND summary_flag = sum_flag
190: AND flex_value > child
191: AND flex_value <= range_high

Line 235: FROM fnd_flex_values

231: IS
232: child VARCHAR2(60);
233: CURSOR find_children_cursor (low VARCHAR2, high VARCHAR2, vsid NUMBER) IS
234: SELECT flex_value
235: FROM fnd_flex_values
236: WHERE flex_value_set_id = vsid
237: AND summary_flag = 'Y'
238: AND flex_value BETWEEN low AND high
239: ORDER by flex_value;

Line 296: FROM fnd_flex_values

292: -- we can use a exists clause here also, but as
293: -- a stable quick fix a rownum limiter is used instead
294: SELECT 1
295: INTO has_value
296: FROM fnd_flex_values
297: WHERE flex_value_set_id = value_set_id
298: AND summary_flag = 'N'
299: AND flex_value > merged_high
300: AND flex_value < low

Line 342: FROM fnd_flex_values

338: BEGIN
339: -- try to find another flex value that is the same as the current one
340: SELECT count(*)
341: INTO row_count
342: FROM fnd_flex_values
343: WHERE flex_value_set_id = value_set_id
344: AND flex_value = f_value
345: AND ((parent_low IS null) OR
346: (parent_flex_value_low = parent_low));

Line 487: insert into FND_FLEX_VALUES_TL (

483: IF ( installed_lang_cursor%NOTFOUND ) THEN
484: CLOSE installed_lang_cursor;
485: RETURN;
486: ELSIF ( lang_code <> userenv('LANG') ) THEN
487: insert into FND_FLEX_VALUES_TL (
488: FLEX_VALUE_ID,
489: LAST_UPDATE_DATE,
490: LAST_UPDATED_BY,
491: CREATION_DATE,

Line 510: from fnd_flex_values_tl T1

506: T1.DESCRIPTION,
507: T1.FLEX_VALUE_MEANING,
508: lang_code,
509: T1.SOURCE_LANG
510: from fnd_flex_values_tl T1
511: -- Bug 4775405, add join
512: ,fnd_flex_values B
513: where language = userenv('LANG')
514: and not exists (select NULL

Line 512: ,fnd_flex_values B

508: lang_code,
509: T1.SOURCE_LANG
510: from fnd_flex_values_tl T1
511: -- Bug 4775405, add join
512: ,fnd_flex_values B
513: where language = userenv('LANG')
514: and not exists (select NULL
515: from fnd_flex_values_tl T2
516: where T2.language = lang_code

Line 515: from fnd_flex_values_tl T2

511: -- Bug 4775405, add join
512: ,fnd_flex_values B
513: where language = userenv('LANG')
514: and not exists (select NULL
515: from fnd_flex_values_tl T2
516: where T2.language = lang_code
517: and T2.flex_value_id = T1.flex_value_id)
518: -- Bug 4775405, add filter
519: and T1.flex_value_id = B.flex_value_id