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_DSC_API dependencies on FND_TABLES

Line 21: SUBTYPE fnd_tbl_type IS fnd_tables%ROWTYPE;

17: chr_newline VARCHAR2(8) := fnd_global.newline;
18:
19: -- The following subtypes are used in the APIs rename_dff and migrate_dff
20: SUBTYPE fnd_app_type IS fnd_application%ROWTYPE;
21: SUBTYPE fnd_tbl_type IS fnd_tables%ROWTYPE;
22: SUBTYPE fnd_dff_type IS fnd_descriptive_flexs%ROWTYPE;
23:
24: -- The following constants are used as error constants
25: error_context_not_set CONSTANT NUMBER := -20001;

Line 216: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,

212: END;
213:
214: /* ---------------------------------------------------------------------- */
215:
216: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,
217: table_name_in IN VARCHAR2)
218: RETURN fnd_tables.table_id%TYPE
219: IS
220: table_id_ret fnd_tables.table_id%TYPE;

Line 218: RETURN fnd_tables.table_id%TYPE

214: /* ---------------------------------------------------------------------- */
215:
216: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,
217: table_name_in IN VARCHAR2)
218: RETURN fnd_tables.table_id%TYPE
219: IS
220: table_id_ret fnd_tables.table_id%TYPE;
221: BEGIN
222: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 220: table_id_ret fnd_tables.table_id%TYPE;

216: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,
217: table_name_in IN VARCHAR2)
218: RETURN fnd_tables.table_id%TYPE
219: IS
220: table_id_ret fnd_tables.table_id%TYPE;
221: BEGIN
222: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
223: table_id
224: INTO table_id_ret

Line 225: FROM fnd_tables

221: BEGIN
222: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
223: table_id
224: INTO table_id_ret
225: FROM fnd_tables
226: WHERE table_name = table_name_in
227: AND application_id = application_id_in;
228: RETURN table_id_ret;
229: EXCEPTION

Line 339: FROM fnd_tables

335: /* assume valid application_id, table_application_id */
336: BEGIN
337: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
338: NULL INTO dummy
339: FROM fnd_tables
340: WHERE table_name = application_table_name
341: AND application_id = table_application_id;
342: EXCEPTION
343: WHEN no_data_found THEN

Line 862: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df

858: -- flexfield
859: BEGIN
860: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
861: NULL INTO dummy
862: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df
863: WHERE df.application_id = application_id_in
864: AND df.descriptive_flexfield_name = descriptive_flexfield_name_in
865: AND t.application_id = df.table_application_id
866: AND t.table_name = df.application_table_name

Line 978: application_table_id_i fnd_tables.table_id%TYPE;

974: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
975: := last_updated_by_f;
976: application_id_i fnd_application.application_id%TYPE;
977: table_application_id_i fnd_application.application_id%TYPE;
978: application_table_id_i fnd_tables.table_id%TYPE;
979: itisSRS BOOLEAN;
980: numcount NUMBER;
981: ffucode fnd_columns.flexfield_usage_code%TYPE;
982: BEGIN

Line 1193: application_table_id_i fnd_tables.table_id%TYPE;

1189: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
1190: := last_updated_by_f;
1191: application_id_i fnd_application.application_id%TYPE;
1192: table_application_id_i fnd_application.application_id%TYPE;
1193: application_table_id_i fnd_tables.table_id%TYPE;
1194: BEGIN
1195: message_init;
1196: println('enabling columns for:' || flexfield_name);
1197: application_id_i := application_id_f(appl_short_name);

Line 1202: FROM fnd_descriptive_flexs df, fnd_tables t

1198: BEGIN
1199: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1200: table_application_id, table_id
1201: INTO table_application_id_i, application_table_id_i
1202: FROM fnd_descriptive_flexs df, fnd_tables t
1203: WHERE df.application_id = application_id_i
1204: AND df.descriptive_flexfield_name = flexfield_name
1205: AND t.application_id = df.table_application_id
1206: AND t.table_name = df.application_table_name;

Line 1474: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df

1470: c.column_type, c.width,
1471: df.application_table_name
1472: INTO application_column_type_i, application_column_width_i,
1473: application_table_name_i
1474: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df
1475: WHERE c.application_id = t.application_id
1476: AND c.table_id = t.table_id
1477: AND c.column_name = create_segment.column
1478: AND t.table_name = df.application_table_name

Line 1781: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df

1777: BEGIN
1778: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1779: c.column_type, c.width, df.application_table_name
1780: INTO l_column_type, l_column_width, l_table_name
1781: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df
1782: WHERE c.application_id = t.application_id
1783: AND c.table_id = t.table_id
1784: AND c.column_name = l_column_name
1785: AND t.table_name = df.application_table_name

Line 2040: application_table_id_i fnd_tables.table_id%TYPE;

2036: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
2037: := last_updated_by_f;
2038: application_id_i fnd_application.application_id%TYPE;
2039: table_application_id_i fnd_application.application_id%TYPE;
2040: application_table_id_i fnd_tables.table_id%TYPE;
2041: BEGIN
2042: message_init;
2043: println('disabling columns for:' || flexfield_name);
2044: application_id_i := application_id_f(appl_short_name);

Line 2049: FROM fnd_descriptive_flexs df, fnd_tables t

2045: BEGIN
2046: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2047: table_application_id, table_id
2048: INTO table_application_id_i, application_table_id_i
2049: FROM fnd_descriptive_flexs df, fnd_tables t
2050: WHERE df.application_id = application_id_i
2051: AND df.descriptive_flexfield_name = flexfield_name
2052: AND t.application_id = df.table_application_id
2053: AND t.table_name = df.application_table_name;

Line 2518: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,

2514: NULL;
2515: RAISE;
2516: END segment_exists;
2517:
2518: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2519: p_table_name IN fnd_tables.table_name%TYPE,
2520: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2521: IS
2522: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

Line 2519: p_table_name IN fnd_tables.table_name%TYPE,

2515: RAISE;
2516: END segment_exists;
2517:
2518: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2519: p_table_name IN fnd_tables.table_name%TYPE,
2520: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2521: IS
2522: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2523: l_a_id fnd_descriptive_flexs.application_id%TYPE;

Line 2522: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

2518: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2519: p_table_name IN fnd_tables.table_name%TYPE,
2520: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2521: IS
2522: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2523: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2524: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2525: BEGIN
2526: x_message := 'This table is not used by Descriptive Flexfields.';

Line 2559: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,

2555: RETURN(TRUE);
2556: END is_table_used;
2557:
2558:
2559: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2560: p_table_name IN fnd_tables.table_name%TYPE,
2561: p_column_name IN fnd_columns.column_name%TYPE,
2562: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2563: IS

Line 2560: p_table_name IN fnd_tables.table_name%TYPE,

2556: END is_table_used;
2557:
2558:
2559: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2560: p_table_name IN fnd_tables.table_name%TYPE,
2561: p_column_name IN fnd_columns.column_name%TYPE,
2562: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2563: IS
2564: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

Line 2564: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

2560: p_table_name IN fnd_tables.table_name%TYPE,
2561: p_column_name IN fnd_columns.column_name%TYPE,
2562: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2563: IS
2564: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2565: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
2566: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2567: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2568: l_context_col fnd_descriptive_flexs.context_column_name%TYPE;

Line 2657: p_table_name IN fnd_tables.table_name%TYPE,

2653: -- This API gets the table details
2654: PROCEDURE get_table
2655: (
2656: p_application_id IN fnd_application.application_id%TYPE,
2657: p_table_name IN fnd_tables.table_name%TYPE,
2658: x_table OUT NOCOPY fnd_tbl_type
2659: ) IS
2660: BEGIN
2661: SELECT *

Line 2663: FROM fnd_tables ft

2659: ) IS
2660: BEGIN
2661: SELECT *
2662: INTO x_table
2663: FROM fnd_tables ft
2664: WHERE ft.application_id = p_application_id
2665: AND ft.table_name = p_table_name;
2666: EXCEPTION
2667: WHEN NO_DATA_FOUND THEN

Line 2882: p_new_table_name IN fnd_tables.table_name%TYPE

2878: (
2879: p_application_short_name IN fnd_application.application_short_name%TYPE,
2880: p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,
2881: p_new_table_appl_short_name IN fnd_application.application_short_name%TYPE,
2882: p_new_table_name IN fnd_tables.table_name%TYPE
2883: ) IS
2884:
2885: l_application fnd_app_type;
2886: l_dff fnd_dff_type;