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.HR_KFLEX_UTILITY dependencies on FND_ID_FLEX_SEGMENTS

Line 93: ,p_flex_code fnd_id_flex_segments.id_flex_code%TYPE

89: --
90: --
91: FUNCTION get_no_segments
92: (p_flex_num number
93: ,p_flex_code fnd_id_flex_segments.id_flex_code%TYPE
94: -- Bug fix 2148839.
95: ,p_application_id IN number
96: )
97: RETURN NUMBER

Line 109: from fnd_id_flex_segments

105: -- performance.
106:
107: cursor number_of_segments is
108: select count(*)
109: from fnd_id_flex_segments
110: where id_flex_code = p_flex_code
111: and id_flex_num = p_flex_num
112: and application_id = p_application_id
113: and enabled_flag = 'Y';

Line 164: l_error_segment_name fnd_id_flex_segments.segment_name%TYPE;

160: l_structure fnd_flex_key_api.structure_type;
161: l_segment fnd_flex_key_api.segment_type;
162: l_segment_list fnd_flex_key_api.segment_list;
163: l_nsegments number;
164: l_error_segment_name fnd_id_flex_segments.segment_name%TYPE;
165:
166: begin
167:
168: -- Obtain the application column name corresponding to the error segment

Line 311: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

307: --
308: procedure check_segment_combination
309: (p_appl_short_name in fnd_application.application_short_name%TYPE
310: ,p_flex_num in number
311: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
312: ,p_concat_segments_in in varchar2
313: ,p_ccid out nocopy number
314: ,p_concat_segments_out out nocopy varchar2
315: ) is

Line 320: l_flex_seg_error_prompt fnd_id_flex_segments_vl.form_left_prompt%type;

316: --
317: l_proc varchar2(72);
318: error_seg number;
319: app_col_name fnd_columns.column_name%TYPE;
320: l_flex_seg_error_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
321: value VARCHAR2(2000); -- Note: PL/SQL value errors may occur if
322: -- we increase the db size of key flex
323: -- segments.
324: l_table_name VARCHAR2(60);

Line 541: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

537: --
538: procedure check_segment_combination
539: (p_appl_short_name in fnd_application.application_short_name%TYPE
540: ,p_flex_num in number
541: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
542: ,p_parameter in fnd_flex_ext.SegmentArray
543: ,p_too_many_segs in boolean
544: ,p_ccid out nocopy number
545: ,p_concat_segments_out out nocopy varchar2

Line 561: l_flex_seg_error_prompt fnd_id_flex_segments_vl.form_left_prompt%type;

557: l_segment_value varchar2(2000);
558: l_first_seg boolean;
559: error_seg number;
560: app_col_name fnd_columns.column_name%TYPE;
561: l_flex_seg_error_prompt fnd_id_flex_segments_vl.form_left_prompt%type;
562: value VARCHAR2(2000); -- Note: PL/SQL value errors may occur if
563: -- we increase the db size of key flex
564: -- segments.
565: l_table_name VARCHAR2(60);

Line 921: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

917: ,p_segment27 in varchar2 default null
918: ,p_segment28 in varchar2 default null
919: ,p_segment29 in varchar2 default null
920: ,p_segment30 in varchar2 default null
921: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
922: ,p_flex_num in number
923: -- Bug fix 2148839. Application id passed.
924: ,p_application_id in number
925: ,p_parameter out nocopy fnd_flex_ext.SegmentArray

Line 950: from fnd_id_flex_segments_vl

946: -- performance.
947:
948: cursor get_pop_segs is
949: select substr(application_column_name,8,2)
950: from fnd_id_flex_segments_vl
951: where id_flex_code = p_flex_code
952: and id_flex_num = p_flex_num
953: and enabled_flag='Y'
954: and application_id = p_application_id

Line 959: from fnd_id_flex_segments_vl

955: order by to_number(substr(application_column_name,8,2));
956: --
957: cursor get_seg_order is
958: select substr(application_column_name,8,2)
959: from fnd_id_flex_segments_vl
960: where id_flex_code = p_flex_code
961: and id_flex_num = p_flex_num
962: and enabled_flag = 'Y'
963: and application_id = p_application_id

Line 1125: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

1121: --
1122: --
1123: function check_pop_segments
1124: (p_parameter in fnd_flex_ext.SegmentArray
1125: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1126: ,p_flex_num in number
1127: -- Bug fix 2148839.parameter p_application_id added.
1128: ,p_application_id in number
1129: ) RETURN boolean

Line 1267: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

1263: -- ----------------------------------------------------------------------------
1264: --
1265: procedure ins_or_sel_keyflex_comb
1266: (p_appl_short_name in fnd_application.application_short_name%TYPE
1267: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1268: ,p_flex_num in number
1269: ,p_segment1 in varchar2 default null
1270: ,p_segment2 in varchar2 default null
1271: ,p_segment3 in varchar2 default null

Line 1531: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

1527: -- ----------------------------------------------------------------------------
1528: --
1529: procedure upd_or_sel_keyflex_comb
1530: (p_appl_short_name in fnd_application.application_short_name%TYPE
1531: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1532: ,p_flex_num in number
1533: ,p_segment1 in varchar2 default hr_api.g_varchar2
1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1648: from fnd_id_flex_segments_vl

1644: --
1645: -- 1141260 : Corrected order by of following cursor.
1646: cursor get_seg_num is
1647: select substr(application_column_name,8,2)
1648: from fnd_id_flex_segments_vl
1649: where id_flex_code = p_flex_code
1650: and id_flex_num = p_flex_num
1651: and enabled_flag='Y'
1652: and application_id = l_application_id --3456567 to avoid FTS