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_DESCRIPTIVE_FLEXS

Line 22: SUBTYPE fnd_dff_type IS fnd_descriptive_flexs%ROWTYPE;

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;
26: error_same_dff_name CONSTANT NUMBER := -20002;

Line 266: FROM fnd_descriptive_flexs

262: dummy NUMBER(1);
263: BEGIN
264: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
265: NULL INTO dummy
266: FROM fnd_descriptive_flexs
267: WHERE application_id = application_id_in
268: AND descriptive_flexfield_name = descriptive_flexfield_name_in;
269: EXCEPTION
270: WHEN no_data_found THEN

Line 349: INTO fnd_descriptive_flexs(application_id,

345: RAISE bad_parameter;
346: END;
347:
348: INSERT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
349: INTO fnd_descriptive_flexs(application_id,
350: application_table_name,
351: descriptive_flexfield_name,
352: table_application_id,
353: concatenated_segs_view_name,

Line 387: println('inserted into fnd_descriptive_flexs');

383: freeze_flex_definition_flag,
384: protected_flag,
385: default_context_field_name,
386: default_context_value);
387: println('inserted into fnd_descriptive_flexs');
388: EXCEPTION
389: WHEN dup_val_on_index THEN
390: message('insert to fnd_descriptive_flexs failed - ' ||
391: 'duplicate flexfield name or application id');

Line 390: message('insert to fnd_descriptive_flexs failed - ' ||

386: default_context_value);
387: println('inserted into fnd_descriptive_flexs');
388: EXCEPTION
389: WHEN dup_val_on_index THEN
390: message('insert to fnd_descriptive_flexs failed - ' ||
391: 'duplicate flexfield name or application id');
392: RAISE bad_parameter;
393: WHEN value_too_large THEN
394: message('insert to fnd_descriptive_flexs failed - ' ||

Line 394: message('insert to fnd_descriptive_flexs failed - ' ||

390: message('insert to fnd_descriptive_flexs failed - ' ||
391: 'duplicate flexfield name or application id');
392: RAISE bad_parameter;
393: WHEN value_too_large THEN
394: message('insert to fnd_descriptive_flexs failed - ' ||
395: 'value too large');
396: RAISE bad_parameter;
397: END;
398:

Line 426: fnd_descriptive_flexs SET

422: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
423: := last_updated_by_f;
424: BEGIN
425: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
426: fnd_descriptive_flexs SET
427: context_required_flag = context_required_flag_in,
428: context_user_override_flag = context_user_override_flag_in,
429: concatenated_segment_delimiter = concat_segment_delimiter_in,
430: freeze_flex_definition_flag = freeze_flex_definition_flag_in,

Line 441: fnd_descriptive_flexs SET

437: WHERE application_id = application_id_in
438: AND descriptive_flexfield_name = descriptive_flexfield_name_in;
439: IF(customer_mode) THEN
440: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
441: fnd_descriptive_flexs SET
442: last_update_date = last_update_date_i,
443: last_updated_by = last_updated_by_i,
444: last_update_login = last_update_login_i
445: WHERE application_id = application_id_in

Line 450: message('update on fnd_descriptive_flexs failed');

446: AND descriptive_flexfield_name = descriptive_flexfield_name_in;
447: END IF;
448: EXCEPTION
449: WHEN OTHERS THEN
450: message('update on fnd_descriptive_flexs failed');
451: RAISE bad_parameter;
452: END;
453:
454:

Line 477: println('inserting into fnd_descriptive flexs tl');

473: := created_by_f;
474: BEGIN
475: FOR lang_rec IN lang_cur
476: LOOP
477: println('inserting into fnd_descriptive flexs tl');
478: println('application_id ='|| application_id);
479: println('descriptive_flexfield_name ='|| descriptive_flexfield_name);
480: println('title ='|| title);
481: println('form_context_prompt ='|| form_context_prompt);

Line 484: INTO fnd_descriptive_flexs_tl(application_id,

480: println('title ='|| title);
481: println('form_context_prompt ='|| form_context_prompt);
482: println('lang_rec.language_code ='|| lang_rec.language_code);
483: INSERT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
484: INTO fnd_descriptive_flexs_tl(application_id,
485: descriptive_flexfield_name,
486: title,
487: description,
488: form_context_prompt,

Line 508: -- println('inserted into fnd_descriptive_flexs_tl');

504: creation_date,
505: created_by,
506: last_update_login,
507: userenv('LANG'));
508: -- println('inserted into fnd_descriptive_flexs_tl');
509: END LOOP;
510: EXCEPTION
511: WHEN dup_val_on_index THEN
512: message('insert failed - duplicate language, flexfield name, or application id');

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

858: -- flexfield
859: BEGIN
860: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi 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 1202: FROM fnd_descriptive_flexs df, fnd_tables t

1198: BEGIN
1199: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi 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 1296: fnd_descriptive_flexs_tl

1292: p_context_override_value_set_i => l_context_override_value_set_i,
1293: p_context_runtime_property_fun => context_runtime_property_funct);
1294: IF(prompt IS NOT NULL) THEN
1295: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1296: fnd_descriptive_flexs_tl
1297: SET
1298: form_context_prompt = prompt
1299: WHERE application_id = application_id_i
1300: AND descriptive_flexfield_name = flexfield_name;

Line 1323: fnd_descriptive_flexs SET

1319: BEGIN
1320: message_init;
1321: appid := application_id_f(appl_short_name);
1322: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1323: fnd_descriptive_flexs SET
1324: last_update_date = last_update_date_i,
1325: last_updated_by = last_updated_by_i,
1326: last_update_login = last_update_login_i,
1327: freeze_flex_definition_flag = 'Y'

Line 1465: fnd_descriptive_flexs.application_table_name%TYPE;

1461: fnd_columns.column_type%TYPE;
1462: application_column_width_i
1463: fnd_columns.width%TYPE;
1464: application_table_name_i
1465: fnd_descriptive_flexs.application_table_name%TYPE;
1466: BEGIN
1467: -- get information on the table column
1468: BEGIN
1469: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

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 1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;

1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
1678: l_column_type fnd_columns.column_type%TYPE;
1679: l_column_width fnd_columns.width%TYPE;
1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
1681:
1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
1683: := last_update_login_f;
1684: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE

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

1777: BEGIN
1778: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi 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 2017: FROM fnd_descriptive_flexs

2013: -- descriptive flexfield.
2014: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2015: count('x')
2016: INTO rec_count
2017: FROM fnd_descriptive_flexs
2018: WHERE application_id = application_id_i
2019: AND descriptive_flexfield_name = flexfield_name
2020: AND default_context_field_name = context_field_name;
2021:

Line 2050: FROM fnd_descriptive_flexs df, fnd_tables t

2046: BEGIN
2047: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2048: table_application_id, table_id
2049: INTO table_application_id_i, application_table_id_i
2050: FROM fnd_descriptive_flexs df, fnd_tables t
2051: WHERE df.application_id = application_id_i
2052: AND df.descriptive_flexfield_name = flexfield_name
2053: AND t.application_id = df.table_application_id
2054: AND t.table_name = df.application_table_name;

Line 2137: FROM fnd_descriptive_flexs_tl

2133: END;
2134:
2135: BEGIN
2136: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2137: FROM fnd_descriptive_flexs_tl
2138: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2139: AND application_id = application_id_i;
2140: println('deleted from fnd_descriptive_flexs_tl');
2141: END;

Line 2140: println('deleted from fnd_descriptive_flexs_tl');

2136: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2137: FROM fnd_descriptive_flexs_tl
2138: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2139: AND application_id = application_id_i;
2140: println('deleted from fnd_descriptive_flexs_tl');
2141: END;
2142:
2143: BEGIN
2144: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

Line 2147: FROM fnd_descriptive_flexs

2143: BEGIN
2144: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2145: table_application_id
2146: INTO table_application_id_i
2147: FROM fnd_descriptive_flexs
2148: WHERE descriptive_flexfield_name = flexfield_name
2149: AND application_id = application_id_i;
2150:
2151: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

Line 2164: FROM fnd_descriptive_flexs

2160: NULL;
2161: END;
2162:
2163: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2164: FROM fnd_descriptive_flexs
2165: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2166: AND application_id = application_id_i;
2167: println('deleted from fnd_descriptive_flexs');
2168:

Line 2167: println('deleted from fnd_descriptive_flexs');

2163: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2164: FROM fnd_descriptive_flexs
2165: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2166: AND application_id = application_id_i;
2167: println('deleted from fnd_descriptive_flexs');
2168:
2169: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2170: FROM fnd_default_context_fields
2171: WHERE application_id = application_id_i

Line 2312: FROM fnd_descriptive_flexs

2308: -- descriptive flexfield.
2309: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2310: count('x')
2311: INTO rec_count
2312: FROM fnd_descriptive_flexs
2313: WHERE application_id = application_id_i
2314: AND descriptive_flexfield_name = flexfield_name
2315: AND default_context_field_name = context;
2316:

Line 2438: FROM fnd_descriptive_flexs

2434: application_id_i := application_id_f(appl_short_name);
2435: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2436: COUNT(*)
2437: INTO cnt
2438: FROM fnd_descriptive_flexs
2439: WHERE application_id = application_id_i
2440: AND descriptive_flexfield_name = flexfield_name;
2441: IF(cnt > 0) THEN
2442: RETURN TRUE;

Line 2524: l_a_id fnd_descriptive_flexs.application_id%TYPE;

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

Line 2525: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;

2521: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2522: IS
2523: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2524: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2525: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2526: BEGIN
2527: x_message := 'This table is not used by Descriptive Flexfields.';
2528: BEGIN
2529: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

Line 2532: FROM fnd_descriptive_flexs

2528: BEGIN
2529: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2530: application_id, descriptive_flexfield_name
2531: INTO l_a_id, l_dff_name
2532: FROM fnd_descriptive_flexs
2533: WHERE table_application_id = p_application_id
2534: AND Upper(application_table_name) = up_table_name
2535: AND ROWNUM = 1;
2536: x_message :=

Line 2546: 'SELECT FROM FND_DESCRIPTIVE_FLEXS is failed. ' || chr_newline ||

2542: WHEN no_data_found THEN
2543: NULL;
2544: WHEN OTHERS THEN
2545: x_message :=
2546: 'SELECT FROM FND_DESCRIPTIVE_FLEXS is failed. ' || chr_newline ||
2547: 'SQLERRM : ' || Sqlerrm;
2548: RETURN(TRUE);
2549: END;
2550: RETURN(FALSE);

Line 2567: l_a_id fnd_descriptive_flexs.application_id%TYPE;

2563: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2564: IS
2565: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2566: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
2567: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2568: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2569: l_context_col fnd_descriptive_flexs.context_column_name%TYPE;
2570: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
2571: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;

Line 2568: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;

2564: IS
2565: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2566: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
2567: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2568: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2569: l_context_col fnd_descriptive_flexs.context_column_name%TYPE;
2570: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
2571: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;
2572: BEGIN

Line 2569: l_context_col fnd_descriptive_flexs.context_column_name%TYPE;

2565: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2566: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
2567: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2568: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2569: l_context_col fnd_descriptive_flexs.context_column_name%TYPE;
2570: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
2571: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;
2572: BEGIN
2573: x_message := 'This column is not used by Descriptive Flexfields.';

Line 2579: FROM fnd_descriptive_flexs

2575: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2576: application_id, descriptive_flexfield_name,
2577: context_column_name
2578: INTO l_a_id, l_dff_name, l_context_col
2579: FROM fnd_descriptive_flexs
2580: WHERE table_application_id = p_application_id
2581: AND Upper(application_table_name) = up_table_name
2582: AND Upper(context_column_name) = up_column_name
2583: AND ROWNUM = 1;

Line 2595: 'SELECT FROM FND_DESCRIPTIVE_FLEXS is failed.'||chr_newline ||

2591: WHEN no_data_found THEN
2592: NULL;
2593: WHEN OTHERS THEN
2594: x_message :=
2595: 'SELECT FROM FND_DESCRIPTIVE_FLEXS is failed.'||chr_newline ||
2596: 'SQLERRM : ' || Sqlerrm;
2597: RETURN(TRUE);
2598: END;
2599:

Line 2605: FROM fnd_descr_flex_column_usages dfcu, fnd_descriptive_flexs df

2601: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2602: dfcu.application_id, dfcu.descriptive_flexfield_name,
2603: dfcu.descriptive_flex_context_code, dfcu.end_user_column_name
2604: INTO l_a_id, l_dff_name, l_context, l_segment
2605: FROM fnd_descr_flex_column_usages dfcu, fnd_descriptive_flexs df
2606: WHERE df.application_id = dfcu.application_id
2607: AND df.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
2608: AND df.table_application_id = p_application_id
2609: AND Upper(df.application_table_name) = up_table_name

Line 2677: p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,

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

Line 2683: FROM fnd_descriptive_flexs fdff

2679: ) IS
2680: BEGIN
2681: SELECT *
2682: INTO x_descriptive_flexfield
2683: FROM fnd_descriptive_flexs fdff
2684: WHERE fdff.application_id = p_application_id
2685: AND fdff.descriptive_flexfield_name = p_descriptive_flexfield_name;
2686: EXCEPTION
2687: WHEN NO_DATA_FOUND THEN

Line 2696: p_old_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,

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

Line 2698: p_new_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE

2694: (
2695: p_old_application_short_name IN fnd_application.application_short_name%TYPE,
2696: p_old_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,
2697: p_new_application_short_name IN fnd_application.application_short_name%TYPE,
2698: p_new_dff_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
2699: ) IS
2700:
2701: l_old_application fnd_app_type;
2702: l_new_application fnd_app_type;

Line 2706: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;

2702: l_new_application fnd_app_type;
2703: l_new_dff fnd_dff_type;
2704: l_old_dff fnd_dff_type;
2705: l_table fnd_tbl_type;
2706: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2707: l_error_message VARCHAR2(4000);
2708: l_illegal_character VARCHAR2(1000);
2709: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2710: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;

Line 2709: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;

2705: l_table fnd_tbl_type;
2706: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2707: l_error_message VARCHAR2(4000);
2708: l_illegal_character VARCHAR2(1000);
2709: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2710: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2711: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2712: BEGIN
2713: l_last_update_date := SYSDATE;

Line 2710: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;

2706: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2707: l_error_message VARCHAR2(4000);
2708: l_illegal_character VARCHAR2(1000);
2709: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2710: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2711: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2712: BEGIN
2713: l_last_update_date := SYSDATE;
2714: l_last_updated_by := fnd_global.user_id();

Line 2711: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;

2707: l_error_message VARCHAR2(4000);
2708: l_illegal_character VARCHAR2(1000);
2709: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2710: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2711: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2712: BEGIN
2713: l_last_update_date := SYSDATE;
2714: l_last_updated_by := fnd_global.user_id();
2715: l_last_update_login := fnd_global.login_id();

Line 2766: FROM fnd_descriptive_flexs

2762: BEGIN
2763: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2764: descriptive_flexfield_name
2765: INTO l_dff_name
2766: FROM fnd_descriptive_flexs
2767: WHERE application_id = l_new_application.application_id
2768: AND descriptive_flexfield_name = p_new_dff_name;
2769: l_error_message := 'A DFF with name ' || p_new_dff_name || ' already exists for the application table ' || l_old_dff.application_table_name;
2770: RAISE_APPLICATION_ERROR(error_dff_already_exists, l_error_message, TRUE);

Line 2778: fnd_descriptive_flexs

2774: END;
2775:
2776:
2777: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2778: fnd_descriptive_flexs
2779: SET application_id = l_new_application.application_id,
2780: descriptive_flexfield_name = p_new_dff_name,
2781: last_update_date = l_last_update_date,
2782: last_updated_by = l_last_updated_by,

Line 2788: fnd_descriptive_flexs_tl

2784: WHERE application_id = l_old_application.application_id
2785: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2786:
2787: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2788: fnd_descriptive_flexs_tl
2789: SET application_id = l_new_application.application_id,
2790: descriptive_flexfield_name = p_new_dff_name,
2791: last_update_date = l_last_update_date,
2792: last_updated_by = l_last_updated_by,

Line 2881: p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,

2877:
2878: PROCEDURE migrate_dff
2879: (
2880: p_application_short_name IN fnd_application.application_short_name%TYPE,
2881: p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE,
2882: p_new_table_appl_short_name IN fnd_application.application_short_name%TYPE,
2883: p_new_table_name IN fnd_tables.table_name%TYPE
2884: ) IS
2885:

Line 2897: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;

2893: l_column_name fnd_columns.column_name%TYPE;
2894: l_error_message VARCHAR2(4000);
2895:
2896: l_error_msg VARCHAR2(4000) := '';
2897: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2898: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2899: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2900:
2901: CURSOR cur_columns_reg(p_dff fnd_dff_type,

Line 2898: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;

2894: l_error_message VARCHAR2(4000);
2895:
2896: l_error_msg VARCHAR2(4000) := '';
2897: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2898: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2899: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2900:
2901: CURSOR cur_columns_reg(p_dff fnd_dff_type,
2902: p_old_table fnd_tbl_type,

Line 2899: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;

2895:
2896: l_error_msg VARCHAR2(4000) := '';
2897: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;
2898: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2899: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2900:
2901: CURSOR cur_columns_reg(p_dff fnd_dff_type,
2902: p_old_table fnd_tbl_type,
2903: p_new_table fnd_tbl_type) IS

Line 3003: fnd_descriptive_flexs

2999: END IF;
3000: END LOOP;
3001:
3002: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
3003: fnd_descriptive_flexs
3004: SET application_table_name = p_new_table_name,
3005: table_application_id = l_new_table.application_id,
3006: last_update_date = l_last_update_date,
3007: last_updated_by = l_last_updated_by,

Line 3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;

3082: l_column_name
3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
3084: l_column_type fnd_columns.column_type%TYPE;
3085: l_column_width fnd_columns.width%TYPE;
3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
3087:
3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
3089: := last_update_login_f;
3090: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE