eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_KEY_API dependencies on FND_VALUE_ATTRIBUTE_TYPES

Line 1607: FROM fnd_value_attribute_types vat

1603: p_id_flex_code IN VARCHAR2,
1604: p_segment_attribute_type IN VARCHAR2)
1605: IS
1606: SELECT value_attribute_type
1607: FROM fnd_value_attribute_types vat
1608: WHERE vat.application_id = p_application_id
1609: AND vat.id_flex_code = p_id_flex_code
1610: AND vat.segment_attribute_type = p_segment_attribute_type
1611: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 1974: FROM fnd_value_attribute_types vat

1970: --
1971: BEGIN
1972: SELECT 0
1973: INTO l_return
1974: FROM fnd_value_attribute_types vat
1975: WHERE vat.application_id = flexfield.application_id
1976: AND vat.id_flex_code = flexfield.flex_code
1977: AND vat.segment_attribute_type = flex_qualifier
1978: AND vat.value_attribute_type = qualifier_name

Line 2014: DELETE FROM fnd_value_attribute_types vat

2010:
2011: --
2012: -- Delete from VAT table
2013: --
2014: DELETE FROM fnd_value_attribute_types vat
2015: WHERE vat.application_id = flexfield.application_id
2016: AND vat.id_flex_code = flexfield.flex_code
2017: AND vat.segment_attribute_type = flex_qualifier
2018: AND vat.value_attribute_type = qualifier_name

Line 2134: DELETE FROM fnd_value_attribute_types

2130: DELETE FROM fnd_val_attribute_types_tl
2131: WHERE application_id = flexfield.application_id
2132: AND id_flex_code = flexfield.flex_code
2133: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2134: DELETE FROM fnd_value_attribute_types
2135: WHERE application_id = flexfield.application_id
2136: AND id_flex_code = flexfield.flex_code
2137: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2138:

Line 2863: fnd_value_attribute_types vat

2859: sav.segment_attribute_type,
2860: vat.value_attribute_type,
2861: sysdate
2862: FROM fnd_segment_attribute_values sav,
2863: fnd_value_attribute_types vat
2864: WHERE segment.value_set_id IS NOT NULL
2865: AND segment.enabled_flag = 'Y'
2866: AND sav.application_id = flexfield.application_id
2867: AND sav.id_flex_code = flexfield.flex_code

Line 2986: fnd_value_attribute_types vat

2982: sav.segment_attribute_type,
2983: vat.value_attribute_type,
2984: sysdate
2985: FROM fnd_segment_attribute_values sav,
2986: fnd_value_attribute_types vat
2987: WHERE segment.value_set_id IS NOT NULL
2988: AND segment.enabled_flag = 'Y'
2989: AND sav.application_id = flexfield.application_id
2990: AND sav.id_flex_code = flexfield.flex_code

Line 3104: fnd_value_attribute_types vat

3100: sav.segment_attribute_type,
3101: vat.value_attribute_type,
3102: Sysdate
3103: FROM fnd_segment_attribute_values sav,
3104: fnd_value_attribute_types vat
3105: WHERE segment.value_set_id IS NOT NULL
3106: AND segment.enabled_flag = 'Y'
3107: AND sav.application_id = flexfield.application_id
3108: AND sav.id_flex_code = flexfield.flex_code

Line 3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;

3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;
3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;
3717: l_set_col fnd_id_flexs.set_defining_column_name%TYPE;
3718: BEGIN

Line 3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;

3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;
3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;
3717: l_set_col fnd_id_flexs.set_defining_column_name%TYPE;
3718: BEGIN
3719: x_message := 'This column is not used by Key Flexfields.';

Line 3808: FROM fnd_id_flexs idf, fnd_value_attribute_types vat

3804: BEGIN
3805: SELECT idf.application_id, idf.id_flex_code,
3806: idf.id_flex_name, vat.segment_attribute_type, vat.value_attribute_type
3807: INTO l_a_id, l_flex_code, l_flex_name, l_seg_att, l_val_att
3808: FROM fnd_id_flexs idf, fnd_value_attribute_types vat
3809: WHERE idf.application_id = vat.application_id
3810: AND idf.id_flex_code = vat.id_flex_code
3811: AND idf.table_application_id = p_application_id
3812: AND Upper(idf.application_table_name) = up_table_name

Line 3829: 'SELECT FROM FND_VALUE_ATTRIBUTE_TYPES is failed. ' ||chr_newline||

3825: WHEN no_data_found THEN
3826: NULL;
3827: WHEN OTHERS THEN
3828: x_message :=
3829: 'SELECT FROM FND_VALUE_ATTRIBUTE_TYPES is failed. ' ||chr_newline||
3830: 'SQLERRM : ' || Sqlerrm;
3831: RETURN(TRUE);
3832: END;
3833: RETURN(FALSE);