eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEX_SEGMENTS

Line 143: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;

139: --
140: SUBTYPE app_type IS fnd_application%ROWTYPE;
141: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
142: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
143: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
144: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;
145:
146: TYPE varchar2_30_array_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
147: TYPE number_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 144: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;

140: SUBTYPE app_type IS fnd_application%ROWTYPE;
141: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
142: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
143: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
144: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;
145:
146: TYPE varchar2_30_array_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
147: TYPE number_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
148:

Line 994: (application_column_name fnd_id_flex_segments.application_column_name%TYPE,

990: x_numof_column_names OUT nocopy NUMBER,
991: x_column_names OUT nocopy varchar2_30_array_type)
992: IS
993: TYPE segment_info IS RECORD
994: (application_column_name fnd_id_flex_segments.application_column_name%TYPE,
995: display_flag fnd_id_flex_segments.display_flag%TYPE,
996: enabled_flag fnd_id_flex_segments.enabled_flag%TYPE,
997: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE,
998: to_include VARCHAR2(1),

Line 995: display_flag fnd_id_flex_segments.display_flag%TYPE,

991: x_column_names OUT nocopy varchar2_30_array_type)
992: IS
993: TYPE segment_info IS RECORD
994: (application_column_name fnd_id_flex_segments.application_column_name%TYPE,
995: display_flag fnd_id_flex_segments.display_flag%TYPE,
996: enabled_flag fnd_id_flex_segments.enabled_flag%TYPE,
997: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE,
998: to_include VARCHAR2(1),
999: is_parent VARCHAR2(1),

Line 996: enabled_flag fnd_id_flex_segments.enabled_flag%TYPE,

992: IS
993: TYPE segment_info IS RECORD
994: (application_column_name fnd_id_flex_segments.application_column_name%TYPE,
995: display_flag fnd_id_flex_segments.display_flag%TYPE,
996: enabled_flag fnd_id_flex_segments.enabled_flag%TYPE,
997: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE,
998: to_include VARCHAR2(1),
999: is_parent VARCHAR2(1),
1000: child_segment_num NUMBER);

Line 997: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE,

993: TYPE segment_info IS RECORD
994: (application_column_name fnd_id_flex_segments.application_column_name%TYPE,
995: display_flag fnd_id_flex_segments.display_flag%TYPE,
996: enabled_flag fnd_id_flex_segments.enabled_flag%TYPE,
997: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE,
998: to_include VARCHAR2(1),
999: is_parent VARCHAR2(1),
1000: child_segment_num NUMBER);
1001:

Line 1018: CURSOR c_segment_info(c_application_id fnd_id_flex_segments.application_id%TYPE,

1014: l_numof_values NUMBER;
1015: l_return_code VARCHAR2(1);
1016: l_segment_info_array segment_info_array;
1017:
1018: CURSOR c_segment_info(c_application_id fnd_id_flex_segments.application_id%TYPE,
1019: c_id_flex_code fnd_id_flex_segments.id_flex_code%TYPE,
1020: c_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE)
1021: IS
1022: SELECT application_column_name, enabled_flag, display_flag, flex_value_set_id

Line 1019: c_id_flex_code fnd_id_flex_segments.id_flex_code%TYPE,

1015: l_return_code VARCHAR2(1);
1016: l_segment_info_array segment_info_array;
1017:
1018: CURSOR c_segment_info(c_application_id fnd_id_flex_segments.application_id%TYPE,
1019: c_id_flex_code fnd_id_flex_segments.id_flex_code%TYPE,
1020: c_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE)
1021: IS
1022: SELECT application_column_name, enabled_flag, display_flag, flex_value_set_id
1023: FROM fnd_id_flex_segments

Line 1020: c_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE)

1016: l_segment_info_array segment_info_array;
1017:
1018: CURSOR c_segment_info(c_application_id fnd_id_flex_segments.application_id%TYPE,
1019: c_id_flex_code fnd_id_flex_segments.id_flex_code%TYPE,
1020: c_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE)
1021: IS
1022: SELECT application_column_name, enabled_flag, display_flag, flex_value_set_id
1023: FROM fnd_id_flex_segments
1024: WHERE application_id = c_application_id

Line 1023: FROM fnd_id_flex_segments

1019: c_id_flex_code fnd_id_flex_segments.id_flex_code%TYPE,
1020: c_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE)
1021: IS
1022: SELECT application_column_name, enabled_flag, display_flag, flex_value_set_id
1023: FROM fnd_id_flex_segments
1024: WHERE application_id = c_application_id
1025: AND id_flex_code = c_id_flex_code
1026: AND id_flex_num = c_id_flex_num
1027: ORDER BY segment_num, segment_name;

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

1109: -- ------------------------------------------------------------------------
1110: -- Gets the segment number corresponding to the qualifier
1111: -- name entered. Segment number is the display order of the segment
1112: -- not to be confused with the SEGMENT_NUM column of the
1113: -- FND_ID_FLEX_SEGMENTS table. Returns TRUE segment_number if ok,
1114: -- or FALSE and sets error using FND_MESSAGES on error.
1115: -- If the qualifier is non-unique, it gives the first segment with this
1116: -- qualifier that appears in flexfield window. (Ref: FF guide page 295).
1117: -- ------------------------------------------------------------------------

Line 1155: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

1151: -- Entity is not in the cache, get it from DB.
1152: --
1153: SELECT s.segment_num
1154: INTO this_segment_num
1155: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
1156: fnd_segment_attribute_types sat
1157: WHERE s.application_id = appl_id
1158: AND s.id_flex_code = key_flex_code
1159: AND s.id_flex_num = structure_number

Line 1177: FROM fnd_id_flex_segments

1173: ORDER BY s.segment_num; -- Order By and rownum < 2 ensures we get first segment.
1174:
1175: SELECT count(segment_num)
1176: INTO l_segment_number
1177: FROM fnd_id_flex_segments
1178: WHERE application_id = appl_id
1179: AND id_flex_code = key_flex_code
1180: AND id_flex_num = structure_number
1181: AND enabled_flag = 'Y'

Line 1448: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,

1444: -- Returns KFF Segment
1445: --------------------------------------------------------------------------------
1446: PROCEDURE get_kff_seg
1447: (p_kff_str IN kff_str_type,
1448: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
1449: x_kff_seg OUT nocopy kff_seg_type)
1450: IS
1451: l_key VARCHAR2(2000);
1452: l_value fnd_plsql_cache.generic_cache_value_type;

Line 1483: FROM fnd_id_flex_segments fifsg

1479: --
1480: BEGIN
1481: SELECT fifsg.*
1482: INTO l_kff_seg
1483: FROM fnd_id_flex_segments fifsg
1484: WHERE fifsg.application_id = p_kff_str.application_id
1485: AND fifsg.id_flex_code = p_kff_str.id_flex_code
1486: AND fifsg.id_flex_num = p_kff_str.id_flex_num
1487: AND fifsg.application_column_name = p_application_column_name;

Line 1565: FROM fnd_id_flex_segments_tl fifsgtl

1561: --
1562: BEGIN
1563: SELECT fifsgtl.*
1564: INTO l_kff_seg_tl
1565: FROM fnd_id_flex_segments_tl fifsgtl
1566: WHERE fifsgtl.application_id = p_kff_seg.application_id
1567: AND fifsgtl.id_flex_code = p_kff_seg.id_flex_code
1568: AND fifsgtl.id_flex_num = p_kff_seg.id_flex_num
1569: AND fifsgtl.application_column_name = p_kff_seg.application_column_name

Line 1904: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,

1900: (p_lexical_name IN VARCHAR2,
1901: p_application_short_name IN fnd_application.application_short_name%TYPE,
1902: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
1903: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
1904: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
1905: p_metadata_type IN VARCHAR2,
1906: x_metadata OUT nocopy VARCHAR2)
1907: IS
1908: BEGIN

Line 2460: FROM fnd_id_flex_segments fifs

2456: p_bind_variable.name := p_lexical_name || p_bind_variable_num;
2457:
2458: SELECT flex_value_set_id
2459: INTO l_flex_value_set_id
2460: FROM fnd_id_flex_segments fifs
2461: WHERE fifs.application_id = l_kff_flx.application_id
2462: AND fifs.id_flex_code = l_kff_flx.id_flex_code
2463: AND fifs.id_flex_num = p_id_flex_num
2464: AND fifs.application_column_name = p_column_name;