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 542: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

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

Line 562: l_flex_seg_error_prompt fnd_id_flex_segments_vl.form_left_prompt%type;

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

Line 930: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

926: ,p_segment27 in varchar2 default null
927: ,p_segment28 in varchar2 default null
928: ,p_segment29 in varchar2 default null
929: ,p_segment30 in varchar2 default null
930: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
931: ,p_flex_num in number
932: -- Bug fix 2148839. Application id passed.
933: ,p_application_id in number
934: ,p_parameter out nocopy fnd_flex_ext.SegmentArray

Line 959: from fnd_id_flex_segments_vl

955: -- performance.
956:
957: cursor get_pop_segs 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 968: from fnd_id_flex_segments_vl

964: order by to_number(substr(application_column_name,8,2));
965: --
966: cursor get_seg_order is
967: select substr(application_column_name,8,2)
968: from fnd_id_flex_segments_vl
969: where id_flex_code = p_flex_code
970: and id_flex_num = p_flex_num
971: and enabled_flag = 'Y'
972: and application_id = p_application_id

Line 1134: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

1130: --
1131: --
1132: function check_pop_segments
1133: (p_parameter in fnd_flex_ext.SegmentArray
1134: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1135: ,p_flex_num in number
1136: -- Bug fix 2148839.parameter p_application_id added.
1137: ,p_application_id in number
1138: ) RETURN boolean

Line 1276: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

1272: -- ----------------------------------------------------------------------------
1273: --
1274: procedure ins_or_sel_keyflex_comb
1275: (p_appl_short_name in fnd_application.application_short_name%TYPE
1276: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1277: ,p_flex_num in number
1278: ,p_segment1 in varchar2 default null
1279: ,p_segment2 in varchar2 default null
1280: ,p_segment3 in varchar2 default null

Line 1540: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE

1536: -- ----------------------------------------------------------------------------
1537: --
1538: procedure upd_or_sel_keyflex_comb
1539: (p_appl_short_name in fnd_application.application_short_name%TYPE
1540: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1541: ,p_flex_num in number
1542: ,p_segment1 in varchar2 default hr_api.g_varchar2
1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1657: from fnd_id_flex_segments_vl

1653: --
1654: -- 1141260 : Corrected order by of following cursor.
1655: cursor get_seg_num is
1656: select substr(application_column_name,8,2)
1657: from fnd_id_flex_segments_vl
1658: where id_flex_code = p_flex_code
1659: and id_flex_num = p_flex_num
1660: and enabled_flag='Y'
1661: and application_id = l_application_id --3456567 to avoid FTS