APPS.FND_FLEX_DIAGNOSE dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%ROWTYPE;

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;
41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;

Line 605: FROM fnd_segment_attribute_values

601: END IF;
602:
603: SELECT *
604: INTO x_kff_qlv
605: FROM fnd_segment_attribute_values
606: WHERE application_id = p_kff_seg.application_id
607: AND id_flex_code = p_kff_seg.id_flex_code
608: AND id_flex_num = p_kff_seg.id_flex_num
609: AND application_column_name = p_kff_seg.application_column_name

Line 614: x_message := msg_uts('FND_SEGMENT_ATTRIBUTE_VALUES',

610: AND segment_attribute_type = p_kff_flq.segment_attribute_type;
611: RETURN(TRUE);
612: EXCEPTION
613: WHEN OTHERS THEN
614: x_message := msg_uts('FND_SEGMENT_ATTRIBUTE_VALUES',
615: 'application_id', p_kff_seg.application_id,
616: 'id_flex_code', p_kff_seg.id_flex_code,
617: 'id_flex_num', p_kff_seg.id_flex_num,
618: 'application_column_name', p_kff_seg.application_column_name,

Line 5419: FROM fnd_segment_attribute_values sav

5415: -- Qualifier assignments without segments.
5416: --
5417: BEGIN
5418: DELETE
5419: FROM fnd_segment_attribute_values sav
5420: WHERE application_id = p_application_id
5421: AND id_flex_code = p_id_flex_code
5422: AND id_flex_num = p_id_flex_num
5423: AND application_column_name = p_application_column_name

Line 5437: 'Unable to delete from FND_SEGMENT_ATTRIBUTE_VALUES. ' ||Sqlerrm;

5433: GOTO return_success;
5434: EXCEPTION
5435: WHEN OTHERS THEN
5436: x_message :=
5437: 'Unable to delete from FND_SEGMENT_ATTRIBUTE_VALUES. ' ||Sqlerrm;
5438: GOTO return_error;
5439: END;
5440: END IF;
5441:

Line 5448: FROM fnd_segment_attribute_values sav

5444: -- Qualifier assignments without qualifiers.
5445: --
5446: BEGIN
5447: DELETE
5448: FROM fnd_segment_attribute_values sav
5449: WHERE application_id = p_application_id
5450: AND id_flex_code = p_id_flex_code
5451: AND id_flex_num = p_id_flex_num
5452: AND application_column_name = p_application_column_name

Line 5465: 'Unable to delete from FND_SEGMENT_ATTRIBUTE_VALUES. ' ||Sqlerrm;

5461: GOTO return_success;
5462: EXCEPTION
5463: WHEN OTHERS THEN
5464: x_message :=
5465: 'Unable to delete from FND_SEGMENT_ATTRIBUTE_VALUES. ' ||Sqlerrm;
5466: GOTO return_error;
5467: END;
5468: END IF;
5469:

Line 5512: INSERT INTO fnd_segment_attribute_values

5508: GOTO return_error;
5509: END IF;
5510:
5511: BEGIN
5512: INSERT INTO fnd_segment_attribute_values
5513: (
5514: application_id,
5515: id_flex_code,
5516: id_flex_num,

Line 5546: 'Unable to insert into FND_SEGMENT_ATTRIBUTE_VALUES. ' ||Sqlerrm;

5542: GOTO return_success;
5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: x_message :=
5546: 'Unable to insert into FND_SEGMENT_ATTRIBUTE_VALUES. ' ||Sqlerrm;
5547: GOTO return_error;
5548: END;
5549: END IF;
5550:

Line 5568: UPDATE fnd_segment_attribute_values SET

5564: l_kff_qlv.attribute_value := l_kff_flq.global_flag;
5565: END IF;
5566:
5567: BEGIN
5568: UPDATE fnd_segment_attribute_values SET
5569: attribute_value = l_kff_qlv.attribute_value,
5570: last_update_date = Sysdate,
5571: last_updated_by = 1
5572: WHERE application_id = l_kff_qlv.application_id

Line 5582: 'Unable to update FND_SEGMENT_ATTRIBUTE_VALUES. ' || Sqlerrm;

5578: GOTO return_success;
5579: EXCEPTION
5580: WHEN OTHERS THEN
5581: x_message :=
5582: 'Unable to update FND_SEGMENT_ATTRIBUTE_VALUES. ' || Sqlerrm;
5583: GOTO return_error;
5584: END;
5585: END IF;
5586: