DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_TABLES

Line 220: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,

216: RETURN(FALSE);
217: END column_exists;
218:
219: -- --------------------------------------------------
220: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,
221: p_table_name IN fnd_tables.table_name%TYPE)
222: RETURN BOOLEAN
223: IS
224: l_table_type fnd_tables.table_type%TYPE;

Line 221: p_table_name IN fnd_tables.table_name%TYPE)

217: END column_exists;
218:
219: -- --------------------------------------------------
220: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,
221: p_table_name IN fnd_tables.table_name%TYPE)
222: RETURN BOOLEAN
223: IS
224: l_table_type fnd_tables.table_type%TYPE;
225: BEGIN

Line 224: l_table_type fnd_tables.table_type%TYPE;

220: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,
221: p_table_name IN fnd_tables.table_name%TYPE)
222: RETURN BOOLEAN
223: IS
224: l_table_type fnd_tables.table_type%TYPE;
225: BEGIN
226: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
227: ft.table_type
228: INTO l_table_type

Line 229: FROM fnd_tables ft

225: BEGIN
226: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
227: ft.table_type
228: INTO l_table_type
229: FROM fnd_tables ft
230: WHERE ft.application_id = p_application_id
231: AND ft.table_name = p_table_name;
232:
233: IF (l_table_type = 'F') THEN

Line 1461: FROM fnd_tables ft

1457: AND dfc.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
1458: AND dfc.descriptive_flex_context_code = dfcu.descriptive_flex_context_code
1459: AND ((fc.application_id, fc.table_id) =
1460: (SELECT ft.application_id, ft.table_id
1461: FROM fnd_tables ft
1462: WHERE ft.application_id = df.table_application_id
1463: AND ft.table_name = df.application_table_name))
1464: AND fc.column_name = dfcu.application_column_name
1465: AND fc.flexfield_usage_code = 'D'

Line 1648: FROM fnd_tables ft

1644: AND ifst.id_flex_code = ifsg.id_flex_code
1645: AND ifst.id_flex_num = ifsg.id_flex_num
1646: AND ((fc.application_id, fc.table_id) =
1647: (SELECT ft.application_id, ft.table_id
1648: FROM fnd_tables ft
1649: WHERE ft.application_id = idf.table_application_id
1650: AND ft.table_name = idf.application_table_name))
1651: AND fc.column_name = ifsg.application_column_name
1652: AND fc.flexfield_usage_code = 'K'

Line 2261: FROM fnd_tables ft

2257: AND dfc.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
2258: AND dfc.descriptive_flex_context_code = dfcu.descriptive_flex_context_code
2259: AND ((fc.application_id, fc.table_id) =
2260: (SELECT ft.application_id, ft.table_id
2261: FROM fnd_tables ft
2262: WHERE ft.application_id = df.table_application_id
2263: AND ft.table_name = df.application_table_name))
2264: AND fc.column_name = dfcu.application_column_name
2265: AND fc.flexfield_usage_code = 'D'

Line 2294: FROM fnd_tables ft

2290: AND ifst.id_flex_code = ifsg.id_flex_code
2291: AND ifst.id_flex_num = ifsg.id_flex_num
2292: AND ((fc.application_id, fc.table_id) =
2293: (SELECT ft.application_id, ft.table_id
2294: FROM fnd_tables ft
2295: WHERE ft.application_id = idf.table_application_id
2296: AND ft.table_name = idf.application_table_name))
2297: AND fc.column_name = ifsg.application_column_name
2298: AND fc.flexfield_usage_code = 'K'