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_SEGMENT_ATTRIBUTE_TYPES

Line 1526: INTO fnd_segment_attribute_types(application_id,

1522: message_init;
1523: check_instantiated(flexfield);
1524:
1525: INSERT
1526: INTO fnd_segment_attribute_types(application_id,
1527: id_flex_code,
1528: segment_attribute_type,
1529: global_flag,
1530: required_flag,

Line 1626: FROM fnd_segment_attribute_types sat

1622: --
1623: BEGIN
1624: SELECT 0
1625: INTO l_return
1626: FROM fnd_segment_attribute_types sat
1627: WHERE sat.application_id = flexfield.application_id
1628: AND sat.id_flex_code = flexfield.flex_code
1629: AND sat.segment_attribute_type = qualifier_name
1630: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 1709: DELETE FROM fnd_segment_attribute_types sat

1705:
1706: --
1707: -- Delete from SAT
1708: --
1709: DELETE FROM fnd_segment_attribute_types sat
1710: WHERE sat.application_id = flexfield.application_id
1711: AND sat.id_flex_code = flexfield.flex_code
1712: AND sat.segment_attribute_type = qualifier_name
1713: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 1756: fnd_segment_attribute_types sat

1752: last_update_date_i,
1753: last_updated_by_i,
1754: last_update_login_i
1755: FROM fnd_id_flex_segments ifsg,
1756: fnd_segment_attribute_types sat
1757: WHERE sat.application_id = ifsg.application_id
1758: AND sat.id_flex_code = ifsg.id_flex_code
1759: AND NOT exists
1760: (SELECT NULL

Line 1804: FROM fnd_segment_attribute_types sat

1800: INTO dummy
1801: FROM dual
1802: WHERE EXISTS
1803: (SELECT 1
1804: FROM fnd_segment_attribute_types sat
1805: WHERE sat.application_id = flexfield.application_id
1806: AND sat.id_flex_code = flexfield.flex_code
1807: AND sat.segment_attribute_type = flex_qualifier)
1808: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 1954: FROM fnd_segment_attribute_types sat

1950: --
1951: BEGIN
1952: SELECT 0
1953: INTO l_return
1954: FROM fnd_segment_attribute_types sat
1955: WHERE sat.application_id = flexfield.application_id
1956: AND sat.id_flex_code = flexfield.flex_code
1957: AND sat.segment_attribute_type = flex_qualifier
1958: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 2139: DELETE FROM fnd_segment_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:
2139: DELETE FROM fnd_segment_attribute_types
2140: WHERE application_id = flexfield.application_id
2141: AND id_flex_code = flexfield.flex_code
2142: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2143:

Line 2840: FROM fnd_id_flex_segments s, fnd_segment_attribute_types t

2836: last_update_login_i,
2837:
2838: t.global_flag,
2839: s.application_id
2840: FROM fnd_id_flex_segments s, fnd_segment_attribute_types t
2841: WHERE s.application_id = flexfield.application_id
2842: AND s.application_column_name = segment.column_name
2843: AND s.id_flex_code = flexfield.flex_code
2844: AND s.id_flex_num = structure.structure_number

Line 3370: FROM fnd_segment_attribute_types

3366: recurse IN BOOLEAN DEFAULT TRUE)
3367: IS
3368: CURSOR flex_qualifier_c IS
3369: SELECT *
3370: FROM fnd_segment_attribute_types
3371: WHERE application_id = flexfield.application_id
3372: AND id_flex_code = flexfield.flex_code
3373: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3374: BEGIN

Line 3505: fnd_segment_attribute_types sat

3501: IS
3502: CURSOR assignments_c IS
3503: SELECT sav.segment_attribute_type
3504: FROM fnd_segment_attribute_values sav,
3505: fnd_segment_attribute_types sat
3506: WHERE sav.application_id = flexfield.application_id
3507: AND sav.id_flex_code = flexfield.flex_code
3508: AND sav.id_flex_num = structure.structure_number
3509: AND sav.application_column_name = segment.column_name

Line 3869: fnd_segment_attribute_types sat

3865: ELSE
3866: SELECT s.segment_num
3867: INTO l_segment_num
3868: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
3869: fnd_segment_attribute_types sat
3870: WHERE s.application_id = p_application_id
3871: AND s.id_flex_code = p_id_flex_code
3872: AND s.id_flex_num = p_id_flex_num
3873: AND s.enabled_flag = 'Y'