APPS.FA_RX_FLEX_PKG dependencies on FND_FLEX_VALUE_SETS

Line 70: from FND_FLEX_VALUE_SETS a, FND_ID_FLEX_SEGMENTS b, FND_ID_FLEX_SEGMENTS c

66: p_id_flex_num in number,
67: p_value_set_id in number)
68: Is
69: select c.segment_num parent_seg_num
70: from FND_FLEX_VALUE_SETS a, FND_ID_FLEX_SEGMENTS b, FND_ID_FLEX_SEGMENTS c
71: where b.APPLICATION_ID = p_application_id
72: and b.ID_FLEX_CODE = p_id_flex_code
73: and b.ID_FLEX_NUM = p_id_flex_num
74: and (b.FLEX_VALUE_SET_ID = a.FLEX_VALUE_SET_ID)

Line 400: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;

396: return varchar2
397: is
398: segnum fnd_id_flex_segments.segment_num%type;
399: colname fnd_id_flex_segments.application_column_name%type;
400: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
401:
402: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
403: op1 seg_array;
404: op2 seg_array;

Line 600: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;

596: c integer;
597: rows integer;
598: segnum fnd_id_flex_segments.segment_num%type;
599: colname fnd_id_flex_segments.application_column_name%type;
600: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
601: buffer varchar2(2000);
602:
603: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;
604: l_segnum fnd_id_flex_segments.segment_num%type;

Line 857: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;

853: sep fnd_id_flex_structures.concatenated_segment_delimiter%type;
854:
855: segnum fnd_id_flex_segments.segment_num%type;
856: colname fnd_id_flex_segments.application_column_name%type;
857: seg_value_set_id fnd_flex_value_sets.flex_value_set_id%type;
858:
859: seg_value varchar2(50);
860: seg_desc fnd_flex_values_vl.description%type;
861: concatenated_description varchar2(2000);