DBA Data[Home] [Help]

APPS.FND_FLEX_KEY_API dependencies on FND_FLEX_VALIDATION_QUALIFIERS

Line 1893: -- Insert into FND_FLEX_VALIDATION_QUALIFIERS

1889: AND column_name = derived_column
1890: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
1891:
1892: --
1893: -- Insert into FND_FLEX_VALIDATION_QUALIFIERS
1894: --
1895: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,
1896: id_flex_application_id,
1897: id_flex_code,

Line 1895: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,

1891:
1892: --
1893: -- Insert into FND_FLEX_VALIDATION_QUALIFIERS
1894: --
1895: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,
1896: id_flex_application_id,
1897: id_flex_code,
1898: segment_attribute_type,
1899: value_attribute_type,

Line 1922: FROM fnd_flex_validation_qualifiers q

1918: AND ifsg.flex_value_set_id IS NOT NULL
1919: AND ifsg.enabled_flag = 'Y'
1920: AND NOT EXISTS
1921: (SELECT NULL
1922: FROM fnd_flex_validation_qualifiers q
1923: WHERE q.flex_value_set_id = ifsg.flex_value_set_id
1924: AND q.id_flex_application_id = flexfield.application_id
1925: AND q.id_flex_code = flexfield.flex_code
1926: AND q.segment_attribute_type = flex_qualifier

Line 1990: -- Delete from fnd_flex_validation_qualifiers

1986: 'SQLERRM : ' || Sqlerrm);
1987: RETURN(-1);
1988: END;
1989: --
1990: -- Delete from fnd_flex_validation_qualifiers
1991: --
1992: DELETE FROM fnd_flex_validation_qualifiers fvq
1993: WHERE fvq.id_flex_application_id = flexfield.application_id
1994: AND fvq.id_flex_code = flexfield.flex_code

Line 1992: DELETE FROM fnd_flex_validation_qualifiers fvq

1988: END;
1989: --
1990: -- Delete from fnd_flex_validation_qualifiers
1991: --
1992: DELETE FROM fnd_flex_validation_qualifiers fvq
1993: WHERE fvq.id_flex_application_id = flexfield.application_id
1994: AND fvq.id_flex_code = flexfield.flex_code
1995: AND fvq.segment_attribute_type = flex_qualifier
1996: AND fvq.value_attribute_type = qualifier_name

Line 2849: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,

2845: AND t.application_id = s.application_id
2846: AND t.id_flex_code = s.id_flex_code
2847: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2848:
2849: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,
2850: id_flex_application_id,
2851: id_flex_code,
2852: segment_attribute_type,
2853: value_attribute_type,

Line 2876: FROM fnd_flex_validation_qualifiers q

2872: AND sav.id_flex_code = vat.id_flex_code
2873: AND sav.segment_attribute_type = vat.segment_attribute_type
2874: AND NOT EXISTS
2875: (SELECT NULL
2876: FROM fnd_flex_validation_qualifiers q
2877: WHERE q.flex_value_set_id = segment.value_set_id
2878: AND q.id_flex_application_id = flexfield.application_id
2879: AND q.id_flex_code = flexfield.flex_code
2880: AND q.segment_attribute_type = sav.segment_attribute_type

Line 2972: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,

2968: AND application_column_name = segment.column_name
2969: AND segment_attribute_type = flexfield_qualifier
2970: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2971:
2972: INSERT INTO fnd_flex_validation_qualifiers (flex_value_set_id,
2973: id_flex_application_id,
2974: id_flex_code,
2975: segment_attribute_type,
2976: value_attribute_type,

Line 3000: FROM fnd_flex_validation_qualifiers q

2996: AND sav.segment_attribute_type = vat.segment_attribute_type
2997: AND sav.segment_attribute_type = flexfield_qualifier
2998: AND NOT EXISTS
2999: (SELECT NULL
3000: FROM fnd_flex_validation_qualifiers q
3001: WHERE q.flex_value_set_id = segment.value_set_id
3002: AND q.id_flex_application_id = flexfield.application_id
3003: AND q.id_flex_code = flexfield.flex_code
3004: AND q.segment_attribute_type = sav.segment_attribute_type

Line 3089: INSERT INTO fnd_flex_validation_qualifiers

3085: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3086: END IF;
3087:
3088: BEGIN
3089: INSERT INTO fnd_flex_validation_qualifiers
3090: (flex_value_set_id,
3091: id_flex_application_id,
3092: id_flex_code,
3093: segment_attribute_type,

Line 3116: (SELECT NULL FROM fnd_flex_validation_qualifiers q

3112: AND sav.application_id = vat.application_id
3113: AND sav.id_flex_code = vat.id_flex_code
3114: AND sav.segment_attribute_type = vat.segment_attribute_type
3115: AND NOT EXISTS
3116: (SELECT NULL FROM fnd_flex_validation_qualifiers q
3117: WHERE q.flex_value_set_id = segment.value_set_id
3118: AND q.id_flex_application_id = flexfield.application_id
3119: AND q.id_flex_code = flexfield.flex_code
3120: AND q.segment_attribute_type = sav.segment_attribute_type