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_DESCR_FLEX_COLUMN_USAGES

Line 681: INTO fnd_descr_flex_column_usages(application_id,

677: created_by fnd_flex_value_sets.created_by%TYPE
678: := created_by_f;
679: BEGIN
680: INSERT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
681: INTO fnd_descr_flex_column_usages(application_id,
682: descriptive_flexfield_name,
683: descriptive_flex_context_code,
684: application_column_name,
685: end_user_column_name,

Line 912: FROM fnd_descr_flex_column_usages cu

908: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
909: NULL INTO dummy FROM dual
910: WHERE NOT EXISTS
911: (SELECT NULL
912: FROM fnd_descr_flex_column_usages cu
913: WHERE cu.application_id = application_id_in
914: AND cu.descriptive_flexfield_name = descriptive_flexfield_name_in
915: AND cu.application_column_name = application_column_name_in
916: AND ( -- already in use in the current context

Line 1397: default_type_i fnd_descr_flex_column_usages.default_type%TYPE;

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);
1401: BEGIN

Line 1399: range_code_i fnd_descr_flex_column_usages.range_code%TYPE;

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);
1401: BEGIN
1402: message_init;
1403: application_id_i := application_id_f(appl_short_name);

Line 1530: FROM fnd_descr_flex_column_usages u

1526: OR application_column_width_i
1527: >= Nvl(t.id_column_size, v.maximum_size))
1528: AND(v.validation_type <> 'D'
1529: OR EXISTS (SELECT NULL
1530: FROM fnd_descr_flex_column_usages u
1531: WHERE application_id = application_id_i
1532: AND descriptive_flexfield_name
1533: = create_segment.flexfield_name
1534: AND descriptive_flex_context_code

Line 1819: FROM fnd_descr_flex_column_usages u

1815: OR l_column_width
1816: >= Nvl(t.id_column_size, v.maximum_size))
1817: AND(v.validation_type <> 'D'
1818: OR EXISTS (SELECT NULL
1819: FROM fnd_descr_flex_column_usages u
1820: WHERE application_id = l_application_id
1821: AND descriptive_flexfield_name
1822: = p_flexfield_name
1823: AND descriptive_flex_context_code

Line 2113: FROM fnd_descr_flex_column_usages

2109: END;
2110:
2111: BEGIN
2112: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2113: FROM fnd_descr_flex_column_usages
2114: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2115: AND application_id = application_id_i;
2116: println('deleted from fnd_descr_column_usages');
2117: END;

Line 2337: FROM fnd_descr_flex_column_usages

2333: END;
2334:
2335: BEGIN
2336: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2337: FROM fnd_descr_flex_column_usages
2338: WHERE descriptive_flex_context_code = context
2339: AND descriptive_flexfield_name = delete_context.flexfield_name
2340: AND application_id = application_id_i;
2341: println('deleted from fnd_descr_column_usages');

Line 2392: FROM fnd_descr_flex_column_usages cu

2388: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2389: FROM fnd_descr_flex_col_usage_tl t
2390: WHERE
2391: EXISTS (SELECT *
2392: FROM fnd_descr_flex_column_usages cu
2393: WHERE cu.end_user_column_name = segment
2394: AND cu.descriptive_flex_context_code = context
2395: AND cu.descriptive_flexfield_name = flexfield_name
2396: AND cu.application_id = application_id_i

Line 2411: FROM fnd_descr_flex_column_usages

2407: END;
2408:
2409: BEGIN
2410: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2411: FROM fnd_descr_flex_column_usages
2412: WHERE end_user_column_name = segment
2413: AND descriptive_flex_context_code = context
2414: AND descriptive_flexfield_name = flexfield_name
2415: AND application_id = application_id_i;

Line 2500: FROM fnd_descr_flex_column_usages

2496: RAISE bad_parameter;
2497: END IF;
2498: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2499: COUNT(*) INTO cnt
2500: FROM fnd_descr_flex_column_usages
2501: WHERE application_id = l_application_id
2502: AND descriptive_flexfield_name = p_flexfield_name
2503: AND descriptive_flex_context_code = p_context_code
2504: AND (((p_column_name IS NOT NULL) AND

Line 2570: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

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.';
2574: BEGIN

Line 2571: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;

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.';
2574: BEGIN
2575: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

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 2624: 'SELECT FROM FND_DESCR_FLEX_COLUMN_USAGES is failed.'||chr_newline ||

2620: WHEN no_data_found THEN
2621: NULL;
2622: WHEN OTHERS THEN
2623: x_message :=
2624: 'SELECT FROM FND_DESCR_FLEX_COLUMN_USAGES is failed.'||chr_newline ||
2625: 'SQLERRM : ' || Sqlerrm;
2626: RETURN(TRUE);
2627: END;
2628: RETURN(FALSE);

Line 2828: fnd_descr_flex_column_usages

2824: WHERE application_id = l_old_application.application_id
2825: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2826:
2827: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2828: fnd_descr_flex_column_usages
2829: SET application_id = l_new_application.application_id,
2830: descriptive_flexfield_name = p_new_dff_name,
2831: last_update_date = l_last_update_date,
2832: last_updated_by = l_last_updated_by,