APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 64: FROM fnd_id_flex_segments_vl

60: structure IN structure_type,
61: enabled IN VARCHAR2 DEFAULT NULL) IS
62: SELECT segment_name,
63: application_column_name
64: FROM fnd_id_flex_segments_vl
65: WHERE application_id = flexfield.application_id
66: AND id_flex_code = flexfield.flex_code
67: AND id_flex_num = structure.structure_number
68: AND (enabled IS NULL or enabled_flag = 'Y')

Line 720: segment_name IN fnd_id_flex_segments_vl.segment_name%TYPE)

716: /* ------------------------------------------------------------ */
717: FUNCTION check_duplicate_segment(
718: flexfield IN flexfield_type,
719: structure IN structure_type,
720: segment_name IN fnd_id_flex_segments_vl.segment_name%TYPE)
721: RETURN NUMBER
722: IS
723: row_count NUMBER;
724: BEGIN

Line 730: FROM fnd_id_flex_segments_vl v

726: -- Check for duplicate segment name.
727: --
728: SELECT count(*)
729: INTO row_count
730: FROM fnd_id_flex_segments_vl v
731: WHERE application_id = flexfield.application_id
732: AND id_flex_code = flexfield.flex_code
733: AND id_flex_num = structure.structure_number
734: AND v.segment_name = check_duplicate_segment.segment_name

Line 2706: FROM fnd_id_flex_segments_vl seg

2702: seg.concatenation_description_len,
2703: seg.form_above_prompt,
2704: seg.form_left_prompt
2705: INTO segment
2706: FROM fnd_id_flex_segments_vl seg
2707: WHERE seg.application_id = flexfield.application_id
2708: AND seg.id_flex_code = flexfield.flex_code
2709: AND seg.id_flex_num = structure.structure_number
2710: AND seg.segment_name = find_segment.segment_name