APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 90: -- (FND_ID_FLEX_STRUCTURES table)

86: -- Procedure
87: -- validate_structure
88: -- Purpose
89: -- Do the validation for the structure
90: -- (FND_ID_FLEX_STRUCTURES table)
91: -- History
92: -- 10.09.2000 O Monnier Created.
93: --
94: PROCEDURE validate_structure(v_application_id IN NUMBER,

Line 199: FND_ID_FLEX_STRUCTURES FS

195: SYSDATE,
196: FS.CREATED_BY,
197: FS.LAST_UPDATE_LOGIN
198: FROM FND_FLEX_WORKFLOW_PROCESSES FWP,
199: FND_ID_FLEX_STRUCTURES FS
200: WHERE FWP.APPLICATION_ID = v_application_id
201: AND FWP.ID_FLEX_CODE = v_id_flex_code
202: AND FWP.ID_FLEX_NUM = 101
203: AND FS.APPLICATION_ID = v_application_id

Line 264: -- (FND_ID_FLEX_STRUCTURES_TL table)

260: -- Procedure
261: -- validate_structure_tl
262: -- Purpose
263: -- Do the validation for the translated structure
264: -- (FND_ID_FLEX_STRUCTURES_TL table)
265: -- History
266: -- 10.09.2000 O Monnier Created.
267: --
268: PROCEDURE validate_structure_tl(v_application_id IN NUMBER,

Line 294: FROM FND_ID_FLEX_STRUCTURES_VL

290: --
291: IF (v_userenvlang = v_language) THEN
292: SELECT count(*)
293: INTO v_count
294: FROM FND_ID_FLEX_STRUCTURES_VL
295: WHERE application_id = v_application_id
296: AND id_flex_code = v_id_flex_code
297: AND id_flex_structure_name = v_id_flex_structure_name;
298:

Line 1802: FROM FND_ID_FLEX_STRUCTURES

1798:
1799: -- Retrieve the flexfield structure information required.
1800: CURSOR c_id_flex_structure IS
1801: SELECT freeze_flex_definition_flag
1802: FROM FND_ID_FLEX_STRUCTURES
1803: WHERE application_id = v_application_id
1804: AND id_flex_code = v_id_flex_code
1805: AND id_flex_num = v_id_flex_num;
1806:

Line 1831: FROM FND_ID_FLEX_STRUCTURES ft,

1827: -- Check if all required segment qualifiers are defined.
1828: CURSOR c_check_required_qualifiers
1829: IS
1830: SELECT sat.segment_prompt
1831: FROM FND_ID_FLEX_STRUCTURES ft,
1832: FND_SEGMENT_ATTRIBUTE_TYPES sat
1833: WHERE ft.application_id = v_application_id
1834: AND ft.id_flex_code = v_id_flex_code
1835: AND ft.id_flex_num = v_id_flex_num

Line 2195: FROM FND_ID_FLEX_STRUCTURES

2191: -- Retrieve the flexfield structure information required.
2192: CURSOR c_id_flex_structure IS
2193: SELECT id_flex_num,
2194: structure_view_name
2195: FROM FND_ID_FLEX_STRUCTURES
2196: WHERE application_id = v_application_id
2197: AND id_flex_code = v_id_flex_code
2198: AND id_flex_structure_code = v_id_flex_structure_code;
2199: