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