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.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 332: -- (FND_ID_FLEX_SEGMENTS table)

328: -- Procedure
329: -- validate_segment
330: -- Purpose
331: -- Do the validation for one particular segment of a structure
332: -- (FND_ID_FLEX_SEGMENTS table)
333: -- History
334: -- 10.09.2000 O Monnier Created.
335: --
336: PROCEDURE validate_segment(v_application_id IN NUMBER,

Line 459: FROM FND_ID_FLEX_SEGMENTS

455: -- Check that SegmentNum is unique for a particular structure
456: --
457: SELECT count(*)
458: INTO v_count
459: FROM FND_ID_FLEX_SEGMENTS
460: WHERE application_id = v_application_id
461: AND id_flex_code = v_id_flex_code
462: AND id_flex_num = v_id_flex_num
463: AND segment_num = v_segment_num;

Line 602: UPDATE FND_ID_FLEX_SEGMENTS

598: RAISE invalid_default_value;
599: END IF;
600:
601: IF (v_default_value <> v_storage_value) THEN
602: UPDATE FND_ID_FLEX_SEGMENTS
603: SET default_value = v_storage_value
604: WHERE application_id = v_application_id
605: AND id_flex_code = v_id_flex_code
606: AND id_flex_num = v_id_flex_num

Line 763: -- (FND_ID_FLEX_SEGMENTS_TL table)

759: -- Procedure
760: -- validate_segment_tl
761: -- Purpose
762: -- Do the validation for one particular translated segment of a structure
763: -- (FND_ID_FLEX_SEGMENTS_TL table)
764: -- NO VALIDATION CODE IS NEEDED NOW.
765: -- History
766: -- 10.09.2000 O Monnier Created.
767: --

Line 1812: FROM FND_ID_FLEX_SEGMENTS fs,

1808: CURSOR c_check_qualifiers
1809: IS
1810: SELECT sat.segment_prompt,
1811: fs.segment_num
1812: FROM FND_ID_FLEX_SEGMENTS fs,
1813: FND_SEGMENT_ATTRIBUTE_TYPES sat
1814: WHERE fs.application_id = v_application_id
1815: AND fs.id_flex_code = v_id_flex_code
1816: AND fs.id_flex_num = v_id_flex_num

Line 1841: FND_ID_FLEX_SEGMENTS fs

1837: AND sat.id_flex_code = v_id_flex_code
1838: AND sat.required_flag = 'Y'
1839: AND NOT EXISTS (SELECT 'Exist'
1840: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav,
1841: FND_ID_FLEX_SEGMENTS fs
1842: WHERE sav.application_id = v_application_id
1843: AND sav.id_flex_code = v_id_flex_code
1844: AND sav.id_flex_num = v_id_flex_num
1845: AND sav.segment_attribute_type = sat.segment_attribute_type

Line 1857: FROM FND_ID_FLEX_SEGMENTS fs

1853: -- Retrieve the range code information
1854: CURSOR c_check_range_code
1855: IS
1856: SELECT fs.segment_num, fs.range_code
1857: FROM FND_ID_FLEX_SEGMENTS fs
1858: WHERE fs.application_id = v_application_id
1859: AND fs.id_flex_code = v_id_flex_code
1860: AND fs.id_flex_num = v_id_flex_num
1861: AND fs.range_code IN ('L','H')

Line 1871: FROM FND_ID_FLEX_SEGMENTS fs

1867: -- Check if the balancing segment and the natural account segment are the same.
1868: CURSOR c_check_balancing_and_account
1869: IS
1870: SELECT fs.segment_num
1871: FROM FND_ID_FLEX_SEGMENTS fs
1872: WHERE fs.application_id = v_application_id
1873: AND fs.id_flex_code = v_id_flex_code
1874: AND fs.id_flex_num = v_id_flex_num
1875: AND fs.application_column_name IN (SELECT sav1.application_column_name

Line 1923: FROM FND_ID_FLEX_SEGMENTS fs,

1919: -- should not add up to more than 240.
1920: --
1921: SELECT NVL((sum(fv.maximum_size) + count(fs.application_column_name) - 1),0)
1922: INTO v_count
1923: FROM FND_ID_FLEX_SEGMENTS fs,
1924: FND_FLEX_VALUE_SETS fv
1925: WHERE fs.application_id = v_application_id
1926: AND fs.id_flex_code = v_id_flex_code
1927: AND fs.id_flex_num = v_id_flex_num

Line 1959: FROM FND_ID_FLEX_SEGMENTS

1955: -- The accounting flexfield requires consecutive segment numbers beginning with 1.
1956: --
1957: SELECT max(segment_num),count(segment_num)
1958: INTO v_max,v_count
1959: FROM FND_ID_FLEX_SEGMENTS
1960: WHERE application_id = v_application_id
1961: AND id_flex_code = v_id_flex_code
1962: AND id_flex_num = v_id_flex_num;
1963:

Line 2020: FROM FND_ID_FLEX_SEGMENTS fs

2016:
2017: IF (v_range_code = 'L') THEN
2018: SELECT NVL(min(segment_num),-1000)
2019: INTO v_range_code_min_high_seg_num
2020: FROM FND_ID_FLEX_SEGMENTS fs
2021: WHERE fs.application_id = v_application_id
2022: AND fs.id_flex_code = v_id_flex_code
2023: AND fs.id_flex_num = v_id_flex_num
2024: AND fs.segment_num > v_segment_num

Line 2030: FROM FND_ID_FLEX_SEGMENTS fs

2026: AND fs.range_code = 'H';
2027:
2028: SELECT NVL(min(segment_num),1000)
2029: INTO v_range_code_min_low_seg_num
2030: FROM FND_ID_FLEX_SEGMENTS fs
2031: WHERE fs.application_id = v_application_id
2032: AND fs.id_flex_code = v_id_flex_code
2033: AND fs.id_flex_num = v_id_flex_num
2034: AND fs.segment_num > v_segment_num

Line 2046: FROM FND_ID_FLEX_SEGMENTS fs

2042:
2043: ELSE IF (v_range_code = 'H') THEN
2044: SELECT NVL(max(segment_num),1000)
2045: INTO v_range_code_max_low_seg_num
2046: FROM FND_ID_FLEX_SEGMENTS fs
2047: WHERE fs.application_id = v_application_id
2048: AND fs.id_flex_code = v_id_flex_code
2049: AND fs.id_flex_num = v_id_flex_num
2050: AND fs.segment_num < v_segment_num

Line 2056: FROM FND_ID_FLEX_SEGMENTS fs

2052: AND fs.range_code = 'L';
2053:
2054: SELECT NVL(max(segment_num),-1000)
2055: INTO v_range_code_max_high_seg_num
2056: FROM FND_ID_FLEX_SEGMENTS fs
2057: WHERE fs.application_id = v_application_id
2058: AND fs.id_flex_code = v_id_flex_code
2059: AND fs.id_flex_num = v_id_flex_num
2060: AND fs.segment_num < v_segment_num

Line 2093: fnd_id_flex_segments seg

2089: vat.value_attribute_type,
2090: sysdate
2091: FROM fnd_segment_attribute_values sav,
2092: fnd_value_attribute_types vat,
2093: fnd_id_flex_segments seg
2094: WHERE seg.application_id = v_application_id
2095: AND seg.id_flex_code = v_id_flex_code
2096: AND seg.id_flex_num = v_id_flex_num
2097: AND seg.flex_value_set_id IS NOT NULL