APPS.FA_RX_FLEX_PKG dependencies on FND_SEGMENT_ATTRIBUTE_TYPES

Line 36: fnd_segment_attribute_types sat

32: union all
33: select s.segment_num, s.application_column_name, s.flex_value_set_id
34: from fnd_id_flex_segments s,
35: fnd_segment_attribute_values sav,
36: fnd_segment_attribute_types sat
37: where s.application_id = p_application_id
38: and s.id_flex_code = p_id_flex_code
39: and s.id_flex_num = p_id_flex_num
40: and s.enabled_flag = 'Y'

Line 411: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;

407:
408: table_alias varchar2(40);
409: buffer varchar2(2000);
410:
411: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;
412: l_segnum fnd_id_flex_segments.segment_num%type;
413: l_id_flex_num number;
414: begin
415: IF (g_print_debug) THEN

Line 603: l_qualifier fnd_segment_attribute_types.segment_attribute_type%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;
605: l_id_flex_num number;
606: l_counter number := 0;
607: begin

Line 865: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;

861: concatenated_description varchar2(2000);
862: seg_parent_value FND_FLEX_VALUES.PARENT_FLEX_VALUE_LOW%type;
863: i number;
864:
865: l_qualifier fnd_segment_attribute_types.segment_attribute_type%type;
866: l_segnum fnd_id_flex_segments.segment_num%type;
867: l_id_flex_num number;
868: l_counter number := 0;
869: found boolean;