APPS.FND_FLEX_APIS dependencies on FND_ID_FLEX_SEGMENTS

Line 8: -- FND_ID_FLEX_SEGMENTS table. Returns TRUE segment_number if ok,

4: -- ------------------------------------------------------------------------
5: -- Gets the segment number corresponding to the **UNIQUE** qualifier
6: -- name entered. Segment number is the display order of the segment
7: -- not to be confused with the SEGMENT_NUM column of the
8: -- FND_ID_FLEX_SEGMENTS table. Returns TRUE segment_number if ok,
9: -- or FALSE and sets error using FND_MESSAGES on error.
10: -- ------------------------------------------------------------------------
11: FUNCTION get_qualifier_segnum(appl_id IN NUMBER,
12: key_flex_code IN VARCHAR2,

Line 21: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

17: IS
18: this_segment_num NUMBER;
19: BEGIN
20: SELECT s.segment_num INTO this_segment_num
21: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
22: fnd_segment_attribute_types sat
23: WHERE s.application_id = appl_id
24: AND s.id_flex_code = key_flex_code
25: AND s.id_flex_num = structure_number

Line 40: FROM fnd_id_flex_segments

36: AND sat.segment_attribute_type = flex_qual_name
37: AND '$Header: AFFFAPIB.pls 120.1.12010000.2 2008/10/24 20:55:06 tebarnes ship $' IS NOT NULL;
38:
39: SELECT count(segment_num) INTO segment_number
40: FROM fnd_id_flex_segments
41: WHERE application_id = appl_id
42: AND id_flex_code = key_flex_code
43: AND id_flex_num = structure_number
44: AND enabled_flag = 'Y'

Line 95: FROM fnd_id_flex_segments_vl s, fnd_flex_value_sets vs

91: SELECT application_column_name, segment_name,
92: form_left_prompt, flex_value_set_name
93: INTO x_appcol_name, x_seg_name,
94: x_prompt, x_value_set_name
95: FROM fnd_id_flex_segments_vl s, fnd_flex_value_sets vs
96: WHERE s.application_id = x_application_id
97: AND s.id_flex_code = x_id_flex_code
98: AND s.id_flex_num = x_id_flex_num
99: AND s.segment_num = x_seg_num