APPS.FND_FLEX_DIAGNOSE dependencies on FND_SEGMENT_ATTRIBUTE_TYPES

Line 36: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%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;
40: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;

Line 551: FROM fnd_segment_attribute_types

547: IS
548: BEGIN
549: SELECT *
550: INTO x_kff_flq
551: FROM fnd_segment_attribute_types
552: WHERE application_id = p_kff_flx.application_id
553: AND id_flex_code = p_kff_flx.id_flex_code
554: AND segment_attribute_type = p_segment_attribute_type;
555: RETURN(TRUE);

Line 558: x_message := msg_uts('FND_SEGMENT_ATTRIBUTE_TYPES',

554: AND segment_attribute_type = p_segment_attribute_type;
555: RETURN(TRUE);
556: EXCEPTION
557: WHEN OTHERS THEN
558: x_message := msg_uts('FND_SEGMENT_ATTRIBUTE_TYPES',
559: 'application_id', p_kff_flx.application_id,
560: 'id_flex_code', p_kff_flx.id_flex_code,
561: 'segment_attribute_type', p_segment_attribute_type);
562: RETURN(FALSE);

Line 3653: FROM fnd_segment_attribute_types

3649: SELECT segment_attribute_type || '/' ||
3650: global_flag || '/' || required_flag || '/' || unique_flag || '/' ||
3651: segment_prompt
3652: INTO l_return
3653: FROM fnd_segment_attribute_types
3654: WHERE application_id = p_application_id
3655: AND id_flex_code = p_id_flex_code
3656: AND segment_attribute_type = p_segment_attribute_type;
3657: RETURN(line_return(l_return));

Line 5318: FROM fnd_segment_attribute_types sat

5314: -- Flex Qualfiers without KFF.
5315: --
5316: BEGIN
5317: DELETE
5318: FROM fnd_segment_attribute_types sat
5319: WHERE application_id = p_application_id
5320: AND id_flex_code = p_id_flex_code
5321: AND segment_attribute_type = p_segment_attribute_type
5322: AND NOT EXISTS

Line 5332: 'Unable to delete from FND_SEGMENT_ATTRIBUTE_TYPES. ' || Sqlerrm;

5328: GOTO return_success;
5329: EXCEPTION
5330: WHEN OTHERS THEN
5331: x_message :=
5332: 'Unable to delete from FND_SEGMENT_ATTRIBUTE_TYPES. ' || Sqlerrm;
5333: GOTO return_error;
5334: END;
5335: END IF;
5336:

Line 5371: UPDATE fnd_segment_attribute_types SET

5367: l_kff_flq.unique_flag := 'N';
5368: END IF;
5369:
5370: BEGIN
5371: UPDATE fnd_segment_attribute_types SET
5372: global_flag = l_kff_flq.global_flag,
5373: required_flag = l_kff_flq.required_flag,
5374: unique_flag = l_kff_flq.unique_flag,
5375: last_update_date = Sysdate,

Line 5385: 'Unable to update FND_SEGMENT_ATTRIBUTE_TYPES. ' || Sqlerrm;

5381: GOTO return_success;
5382: EXCEPTION
5383: WHEN OTHERS THEN
5384: x_message :=
5385: 'Unable to update FND_SEGMENT_ATTRIBUTE_TYPES. ' || Sqlerrm;
5386: GOTO return_error;
5387: END;
5388: END IF;
5389:

Line 5456: FROM fnd_segment_attribute_types sat

5452: AND application_column_name = p_application_column_name
5453: AND segment_attribute_type = p_segment_attribute_type
5454: AND NOT EXISTS
5455: (SELECT null
5456: FROM fnd_segment_attribute_types sat
5457: WHERE sat.application_id = sav.application_id
5458: AND sat.id_flex_code = sav.id_flex_code
5459: AND sat.segment_attribute_type = sav.segment_attribute_type);
5460: x_message := SQL%rowcount || ' row(s) deleted.';

Line 5622: FROM fnd_segment_attribute_types sat

5618: AND segment_attribute_type = p_segment_attribute_type
5619: AND value_attribute_type = p_value_attribute_type
5620: AND NOT EXISTS
5621: (SELECT null
5622: FROM fnd_segment_attribute_types sat
5623: WHERE sat.application_id = vat.application_id
5624: AND sat.id_flex_code = vat.id_flex_code
5625: AND sat.segment_attribute_type = vat.segment_attribute_type);
5626: x_message := SQL%rowcount || ' row(s) deleted.';