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_APPLICATION

Line 20: SUBTYPE fnd_app_type IS fnd_application%ROWTYPE;

16: internal_messages VARCHAR2(10000);
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

Line 191: RETURN fnd_application.application_id%TYPE

187:
188: /* ====================================================================== */
189:
190: FUNCTION application_id_f(application_short_name_in IN VARCHAR2)
191: RETURN fnd_application.application_id%TYPE
192: IS
193: application_id_ret fnd_application.application_id%TYPE;
194: BEGIN
195: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 193: application_id_ret fnd_application.application_id%TYPE;

189:
190: FUNCTION application_id_f(application_short_name_in IN VARCHAR2)
191: RETURN fnd_application.application_id%TYPE
192: IS
193: application_id_ret fnd_application.application_id%TYPE;
194: BEGIN
195: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
196: application_id
197: INTO application_id_ret

Line 198: FROM fnd_application

194: BEGIN
195: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
196: application_id
197: INTO application_id_ret
198: FROM fnd_application
199: WHERE application_short_name = application_short_name_in;
200:
201: RETURN application_id_ret;
202:

Line 259: application_id_in IN fnd_application.application_id%TYPE,

255:
256:
257: /* check whether the named descr ff exists in the specified app */
258: PROCEDURE check_existance(
259: application_id_in IN fnd_application.application_id%TYPE,
260: descriptive_flexfield_name_in IN VARCHAR2)
261: IS
262: dummy NUMBER(1);
263: BEGIN

Line 281: application_id_in IN fnd_application.application_id%TYPE,

277:
278: /* check whether the context exists in the
279: named descr ff in the specified app */
280: PROCEDURE check_existance(
281: application_id_in IN fnd_application.application_id%TYPE,
282: descriptive_flexfield_name_in IN VARCHAR2,
283: descr_flex_context_code_in IN VARCHAR2)
284: IS
285: dummy NUMBER(1);

Line 976: application_id_i fnd_application.application_id%TYPE;

972: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
973: := last_update_date_f;
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;

Line 977: table_application_id_i fnd_application.application_id%TYPE;

973: := last_update_date_f;
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;

Line 1191: application_id_i fnd_application.application_id%TYPE;

1187: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1188: := last_update_date_f;
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;

Line 1192: table_application_id_i fnd_application.application_id%TYPE;

1188: := last_update_date_f;
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);

Line 1262: application_id_i fnd_application.application_id%TYPE;

1258: context_default_value IN VARCHAR2 DEFAULT NULL,
1259: context_override_value_set_nam IN VARCHAR2 DEFAULT NULL,
1260: context_runtime_property_funct IN VARCHAR2 DEFAULT NULL)
1261: IS
1262: application_id_i fnd_application.application_id%TYPE;
1263: l_context_override_value_set_i NUMBER;
1264: BEGIN
1265: message_init;
1266: application_id_i := application_id_f(appl_short_name);

Line 1318: appid fnd_application.application_id%TYPE;

1314: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1315: := last_update_date_f;
1316: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
1317: := last_updated_by_f;
1318: appid fnd_application.application_id%TYPE;
1319: BEGIN
1320: message_init;
1321: appid := application_id_f(appl_short_name);
1322: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 1344: application_id_i fnd_application.application_id%TYPE;

1340: description IN VARCHAR2,
1341: enabled IN VARCHAR2,
1342: global_flag IN VARCHAR2 DEFAULT 'N')
1343: IS
1344: application_id_i fnd_application.application_id%TYPE;
1345: BEGIN
1346: message_init;
1347: application_id_i := application_id_f(appl_short_name);
1348: check_existance(application_id_i, flexfield_name);

Line 1396: application_id_i fnd_application.application_id%TYPE;

1392: RANGE IN VARCHAR2 DEFAULT NULL,
1393: srw_parameter IN VARCHAR2 DEFAULT NULL,
1394: runtime_property_function IN VARCHAR2 DEFAULT NULL)
1395: IS
1396: application_id_i fnd_application.application_id%TYPE;
1397: default_type_i fnd_descr_flex_column_usages.default_type%TYPE;
1398: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;
1399: range_code_i fnd_descr_flex_column_usages.range_code%TYPE;
1400: dummy NUMBER(1);

Line 1978: application_id_i fnd_application.application_id%TYPE;

1974: flexfield_name IN VARCHAR2,
1975: context_field_name IN VARCHAR2,
1976: description IN VARCHAR2)
1977: IS
1978: application_id_i fnd_application.application_id%TYPE;
1979: BEGIN
1980: message_init;
1981: application_id_i := application_id_f(appl_short_name);
1982:

Line 2004: application_id_i fnd_application.application_id%TYPE;

2000: PROCEDURE delete_reference_field(appl_short_name IN VARCHAR2,
2001: flexfield_name IN VARCHAR2,
2002: context_field_name IN VARCHAR2)
2003: IS
2004: application_id_i fnd_application.application_id%TYPE;
2005: rec_count NUMBER;
2006: BEGIN
2007: message_init;
2008: application_id_i := application_id_f(appl_short_name);

Line 2038: application_id_i fnd_application.application_id%TYPE;

2034: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
2035: := last_update_date_f;
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;

Line 2039: table_application_id_i fnd_application.application_id%TYPE;

2035: := last_update_date_f;
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);

Line 2096: application_id_i fnd_application.application_id%TYPE;

2092:
2093: PROCEDURE delete_flexfield(appl_short_name IN VARCHAR2,
2094: flexfield_name IN VARCHAR2)
2095: IS
2096: application_id_i fnd_application.application_id%TYPE;
2097: table_application_id_i fnd_application.application_id%TYPE;
2098: BEGIN
2099: message_init;
2100: application_id_i := application_id_f(appl_short_name);

Line 2097: table_application_id_i fnd_application.application_id%TYPE;

2093: PROCEDURE delete_flexfield(appl_short_name IN VARCHAR2,
2094: flexfield_name IN VARCHAR2)
2095: IS
2096: application_id_i fnd_application.application_id%TYPE;
2097: table_application_id_i fnd_application.application_id%TYPE;
2098: BEGIN
2099: message_init;
2100: application_id_i := application_id_f(appl_short_name);
2101:

Line 2192: application_id_i fnd_application.application_id%TYPE;

2188: flexfield_name IN VARCHAR2,
2189: context IN VARCHAR2,
2190: enable IN BOOLEAN DEFAULT TRUE)
2191: IS
2192: application_id_i fnd_application.application_id%TYPE;
2193: enabled_flag_i VARCHAR2(1);
2194: cnt NUMBER;
2195: BEGIN
2196: message_init;

Line 2227: l_application_id fnd_application.application_id%TYPE;

2223: p_description IN VARCHAR2 DEFAULT NULL,
2224: p_enabled_flag IN VARCHAR2 DEFAULT NULL,
2225: p_language IN VARCHAR2)
2226: IS
2227: l_application_id fnd_application.application_id%TYPE;
2228: l_boolean_flag1 BOOLEAN;
2229: l_lang_exists NUMBER;
2230: l_dflex_contexts_tl fnd_descr_flex_contexts_tl%ROWTYPE;
2231: l_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;

Line 2296: application_id_i fnd_application.application_id%TYPE;

2292: PROCEDURE delete_context(appl_short_name IN VARCHAR2,
2293: flexfield_name IN VARCHAR2,
2294: context IN VARCHAR2)
2295: IS
2296: application_id_i fnd_application.application_id%TYPE;
2297: rec_count NUMBER;
2298: BEGIN
2299: message_init;
2300: application_id_i := application_id_f(appl_short_name);

Line 2381: application_id_i fnd_application.application_id%TYPE;

2377: flexfield_name IN VARCHAR2,
2378: context IN VARCHAR2,
2379: segment IN VARCHAR2)
2380: IS
2381: application_id_i fnd_application.application_id%TYPE;
2382: BEGIN
2383: message_init;
2384: application_id_i := application_id_f(appl_short_name);
2385:

Line 2429: application_id_i fnd_application.application_id%TYPE;

2425:
2426: FUNCTION flexfield_exists(appl_short_name IN VARCHAR2,
2427: flexfield_name IN VARCHAR2) RETURN BOOLEAN
2428: IS
2429: application_id_i fnd_application.application_id%TYPE;
2430: cnt NUMBER;
2431: BEGIN
2432: message_init;
2433: application_id_i := application_id_f(appl_short_name);

Line 2455: l_application_id fnd_application.application_id%TYPE;

2451: FUNCTION context_exists(p_appl_short_name IN VARCHAR2,
2452: p_flexfield_name IN VARCHAR2,
2453: p_context_code IN VARCHAR2) RETURN BOOLEAN
2454: IS
2455: l_application_id fnd_application.application_id%TYPE;
2456: BEGIN
2457: message_init;
2458: l_application_id := application_id_f(p_appl_short_name);
2459: BEGIN

Line 2480: l_application_id fnd_application.application_id%TYPE;

2476: p_segment_name IN VARCHAR2 DEFAULT NULL,
2477: p_column_name IN VARCHAR2 DEFAULT NULL)
2478: RETURN BOOLEAN
2479: IS
2480: l_application_id fnd_application.application_id%TYPE;
2481: cnt NUMBER;
2482: BEGIN
2483: message_init;
2484: l_application_id := application_id_f(p_appl_short_name);

Line 2639: p_application_short_name IN fnd_application.application_short_name%TYPE,

2635:
2636: -- This API gets the application details
2637: PROCEDURE get_application
2638: (
2639: p_application_short_name IN fnd_application.application_short_name%TYPE,
2640: x_application OUT NOCOPY fnd_app_type
2641: ) IS
2642: BEGIN
2643: SELECT *

Line 2645: FROM fnd_application fa

2641: ) IS
2642: BEGIN
2643: SELECT *
2644: INTO x_application
2645: FROM fnd_application fa
2646: WHERE fa.application_short_name = p_application_short_name;
2647: EXCEPTION
2648: WHEN NO_DATA_FOUND THEN
2649: RAISE_APPLICATION_ERROR(-20200,'No Application exists with application_short_name = '

Line 2656: p_application_id IN fnd_application.application_id%TYPE,

2652:
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

Line 2675: p_application_id IN fnd_application.application_id%TYPE,

2671:
2672: -- This API gets the Descriptive Flexfield details
2673: PROCEDURE get_descriptive_flexfield
2674: (
2675: p_application_id IN fnd_application.application_id%TYPE,
2676: p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,
2677: x_descriptive_flexfield OUT NOCOPY fnd_dff_type
2678: ) IS
2679: BEGIN

Line 2694: p_old_application_short_name IN fnd_application.application_short_name%TYPE,

2690:
2691: -- This API renames an exisisting descriptive flexfield
2692: PROCEDURE rename_dff
2693: (
2694: p_old_application_short_name IN fnd_application.application_short_name%TYPE,
2695: p_old_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,
2696: p_new_application_short_name IN fnd_application.application_short_name%TYPE,
2697: p_new_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
2698: ) IS

Line 2696: p_new_application_short_name IN fnd_application.application_short_name%TYPE,

2692: PROCEDURE rename_dff
2693: (
2694: p_old_application_short_name IN fnd_application.application_short_name%TYPE,
2695: p_old_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,
2696: p_new_application_short_name IN fnd_application.application_short_name%TYPE,
2697: p_new_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
2698: ) IS
2699:
2700: l_old_application fnd_app_type;

Line 2879: p_application_short_name IN fnd_application.application_short_name%TYPE,

2875: -- same column types, and same size or bigger size columns. (For ATTRIBUTE columns).
2876:
2877: PROCEDURE migrate_dff
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

Line 2881: p_new_table_appl_short_name IN fnd_application.application_short_name%TYPE,

2877: PROCEDURE migrate_dff
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;