APPS.HR_KFLEX_UTILITY dependencies on FND_ID_FLEX_SEGMENTS_VL

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 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 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 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