APPS.FND_FLEX_DIAGNOSE dependencies on FND_VALUE_ATTRIBUTE_TYPES

Line 38: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%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;
41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
42: SUBTYPE kff_cvi_type IS fnd_flex_include_rule_lines%ROWTYPE;

Line 574: FROM fnd_value_attribute_types

570: IS
571: BEGIN
572: SELECT *
573: INTO x_kff_sgq
574: FROM fnd_value_attribute_types
575: WHERE application_id = p_kff_flq.application_id
576: AND id_flex_code = p_kff_flq.id_flex_code
577: AND segment_attribute_type = p_kff_flq.segment_attribute_type
578: AND value_attribute_type = p_value_attribute_type;

Line 582: x_message := msg_uts('FND_VALUE_ATTRIBUTE_TYPES',

578: AND value_attribute_type = p_value_attribute_type;
579: RETURN(TRUE);
580: EXCEPTION
581: WHEN OTHERS THEN
582: x_message := msg_uts('FND_VALUE_ATTRIBUTE_TYPES',
583: 'application_id', p_kff_flq.application_id,
584: 'id_flex_code', p_kff_flq.id_flex_code,
585: 'segment_attribute_type', p_kff_flq.segment_attribute_type,
586: 'value_attribute_type', p_value_attribute_type);

Line 5615: FROM fnd_value_attribute_types vat

5611: -- Segment Qualifiers without Flexfield Qualifier.
5612: --
5613: BEGIN
5614: DELETE
5615: FROM fnd_value_attribute_types vat
5616: WHERE application_id = p_application_id
5617: AND id_flex_code = p_id_flex_code
5618: AND segment_attribute_type = p_segment_attribute_type
5619: AND value_attribute_type = p_value_attribute_type

Line 5631: 'Unable to delete from FND_VALUE_ATTRIBUTE_TYPES. ' || Sqlerrm;

5627: GOTO return_success;
5628: EXCEPTION
5629: WHEN OTHERS THEN
5630: x_message :=
5631: 'Unable to delete from FND_VALUE_ATTRIBUTE_TYPES. ' || Sqlerrm;
5632: GOTO return_error;
5633: END;
5634: END IF;
5635:

Line 5701: UPDATE fnd_value_attribute_types SET

5697: l_kff_sgq.required_flag := 'Y';
5698: END IF;
5699:
5700: BEGIN
5701: UPDATE fnd_value_attribute_types SET
5702: required_flag = l_kff_sgq.required_flag,
5703: last_update_date = Sysdate,
5704: last_updated_by = 1
5705: WHERE application_id = l_kff_sgq.application_id

Line 5714: 'Unable to update FND_VALUE_ATTRIBUTE_TYPES. ' || Sqlerrm;

5710: GOTO return_success;
5711: EXCEPTION
5712: WHEN OTHERS THEN
5713: x_message :=
5714: 'Unable to update FND_VALUE_ATTRIBUTE_TYPES. ' || Sqlerrm;
5715: GOTO return_error;
5716: END;
5717: END IF;
5718:

Line 5751: FROM fnd_value_attribute_types vat

5747: AND value_attribute_type = p_value_attribute_type
5748: AND flex_value_set_id = p_flex_value_set_id
5749: AND NOT EXISTS
5750: (SELECT null
5751: FROM fnd_value_attribute_types vat
5752: WHERE vat.application_id = fvq.id_flex_application_id
5753: AND vat.id_flex_code = fvq.id_flex_code
5754: AND vat.segment_attribute_type = fvq.segment_attribute_type
5755: AND vat.value_attribute_type = fvq.value_attribute_type);

Line 5953: FROM fnd_value_attribute_types

5949: AND application_table_name = l_tbl.table_name;
5950: BEGIN
5951: SELECT *
5952: INTO l_kff_sgq
5953: FROM fnd_value_attribute_types
5954: WHERE application_id = l_kff_flx.application_id
5955: AND id_flex_code = l_kff_flx.id_flex_code
5956: AND application_column_name = l_col.column_name;
5957: x_message := ('This column is used by ' ||

Line 5969: 'Unable to select from FND_VALUE_ATTRIBUTE_TYPES. ' ||

5965: WHEN no_data_found THEN
5966: NULL;
5967: WHEN OTHERS THEN
5968: x_message :=
5969: 'Unable to select from FND_VALUE_ATTRIBUTE_TYPES. ' ||
5970: Sqlerrm;
5971: GOTO return_error;
5972: END;
5973: EXCEPTION