APPS.FND_FLEX_DIAGNOSE dependencies on FND_ID_FLEX_SEGMENTS

Line 35: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;

31: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;
32:
33: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
34: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
35: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
36: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%ROWTYPE;
38: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
39: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;

Line 526: FROM fnd_id_flex_segments

522: IS
523: BEGIN
524: SELECT *
525: INTO x_kff_seg
526: FROM fnd_id_flex_segments
527: WHERE application_id = p_kff_str.application_id
528: AND id_flex_code = p_kff_str.id_flex_code
529: AND id_flex_num = p_kff_str.id_flex_num
530: AND application_column_name = p_application_column_name;

Line 534: x_message := msg_uts('FND_ID_FLEX_SEGMENTS',

530: AND application_column_name = p_application_column_name;
531: RETURN(TRUE);
532: EXCEPTION
533: WHEN OTHERS THEN
534: x_message := msg_uts('FND_ID_FLEX_SEGMENTS',
535: 'application_id', p_kff_str.application_id,
536: 'id_flex_code', p_kff_str.id_flex_code,
537: 'id_flex_num', p_kff_str.id_flex_num,
538: 'application_column_name', p_application_column_name);

Line 3545: FROM fnd_id_flex_segments_vl

3541: segment_name || '/' ||
3542: form_left_prompt || '/' ||
3543: Nvl(description, '')
3544: INTO l_return
3545: FROM fnd_id_flex_segments_vl
3546: WHERE application_id = p_application_id
3547: AND id_flex_code = p_id_flex_code
3548: AND id_flex_num = p_id_flex_num
3549: AND application_column_name = p_application_column_name;

Line 4593: FROM fnd_id_flex_segments ifsg

4589: -- Segments without Structure.
4590: --
4591: BEGIN
4592: DELETE
4593: FROM fnd_id_flex_segments ifsg
4594: WHERE application_id = p_application_id
4595: AND id_flex_code = p_id_flex_code
4596: AND id_flex_num = p_id_flex_num
4597: AND application_column_name = p_application_column_name

Line 4609: 'Unable to delete from FND_ID_FLEX_SEGMENTS. ' || Sqlerrm;

4605: GOTO return_success;
4606: EXCEPTION
4607: WHEN OTHERS THEN
4608: x_message :=
4609: 'Unable to delete from FND_ID_FLEX_SEGMENTS. ' || Sqlerrm;
4610: GOTO return_error;
4611: END;
4612: END IF;
4613:

Line 4686: UPDATE fnd_id_flex_segments SET

4682: GOTO return_error;
4683: END IF;
4684:
4685: BEGIN
4686: UPDATE fnd_id_flex_segments SET
4687: flex_value_set_id = NULL,
4688: last_update_date = Sysdate,
4689: last_updated_by = 1
4690: WHERE application_id = l_kff_seg.application_id

Line 4699: 'Unable to update FND_ID_FLEX_SEGMENTS. ' || Sqlerrm;

4695: GOTO return_success;
4696: EXCEPTION
4697: WHEN OTHERS THEN
4698: x_message :=
4699: 'Unable to update FND_ID_FLEX_SEGMENTS. ' || Sqlerrm;
4700: GOTO return_error;
4701: END;
4702: END IF;
4703:

Line 4744: UPDATE fnd_id_flex_segments SET

4740: l_kff_seg.security_enabled_flag := 'N';
4741: END IF;
4742:
4743: BEGIN
4744: UPDATE fnd_id_flex_segments SET
4745: default_type = l_kff_seg.default_type,
4746: range_code = l_kff_seg.range_code,
4747: application_column_index_flag = l_kff_seg.application_column_index_flag,
4748: enabled_flag = l_kff_seg.enabled_flag,

Line 4763: 'Unable to update FND_ID_FLEX_SEGMENTS. ' || Sqlerrm;

4759: GOTO return_success;
4760: EXCEPTION
4761: WHEN OTHERS THEN
4762: x_message :=
4763: 'Unable to update FND_ID_FLEX_SEGMENTS. ' || Sqlerrm;
4764: GOTO return_error;
4765: END;
4766: END IF;
4767:

Line 5427: FROM fnd_id_flex_segments ifsg

5423: AND application_column_name = p_application_column_name
5424: AND segment_attribute_type = p_segment_attribute_type
5425: AND NOT EXISTS
5426: (SELECT null
5427: FROM fnd_id_flex_segments ifsg
5428: WHERE ifsg.application_id = sav.application_id
5429: AND ifsg.id_flex_code = sav.id_flex_code
5430: AND ifsg.id_flex_num = sav.id_flex_num
5431: AND ifsg.application_column_name = sav.application_column_name);