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.8.12010000.1 2008/07/25 14:13:39 appldev 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.8.12010000.1 2008/07/25 14:13:39 appldev 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 2112: FROM fnd_descr_flex_column_usages

2108: END;
2109:
2110: BEGIN
2111: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2112: FROM fnd_descr_flex_column_usages
2113: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2114: AND application_id = application_id_i;
2115: println('deleted from fnd_descr_column_usages');
2116: END;

Line 2336: FROM fnd_descr_flex_column_usages

2332: END;
2333:
2334: BEGIN
2335: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2336: FROM fnd_descr_flex_column_usages
2337: WHERE descriptive_flex_context_code = context
2338: AND descriptive_flexfield_name = delete_context.flexfield_name
2339: AND application_id = application_id_i;
2340: println('deleted from fnd_descr_column_usages');

Line 2391: FROM fnd_descr_flex_column_usages cu

2387: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2388: FROM fnd_descr_flex_col_usage_tl t
2389: WHERE
2390: EXISTS (SELECT *
2391: FROM fnd_descr_flex_column_usages cu
2392: WHERE cu.end_user_column_name = segment
2393: AND cu.descriptive_flex_context_code = context
2394: AND cu.descriptive_flexfield_name = flexfield_name
2395: AND cu.application_id = application_id_i

Line 2410: FROM fnd_descr_flex_column_usages

2406: END;
2407:
2408: BEGIN
2409: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2410: FROM fnd_descr_flex_column_usages
2411: WHERE end_user_column_name = segment
2412: AND descriptive_flex_context_code = context
2413: AND descriptive_flexfield_name = flexfield_name
2414: AND application_id = application_id_i;

Line 2499: FROM fnd_descr_flex_column_usages

2495: RAISE bad_parameter;
2496: END IF;
2497: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2498: COUNT(*) INTO cnt
2499: FROM fnd_descr_flex_column_usages
2500: WHERE application_id = l_application_id
2501: AND descriptive_flexfield_name = p_flexfield_name
2502: AND descriptive_flex_context_code = p_context_code
2503: AND (((p_column_name IS NOT NULL) AND

Line 2569: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

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;
2569: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
2570: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;
2571: BEGIN
2572: x_message := 'This column is not used by Descriptive Flexfields.';
2573: BEGIN

Line 2570: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;

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;
2569: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
2570: l_segment fnd_descr_flex_column_usages.end_user_column_name%TYPE;
2571: BEGIN
2572: x_message := 'This column is not used by Descriptive Flexfields.';
2573: BEGIN
2574: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 2604: FROM fnd_descr_flex_column_usages dfcu, fnd_descriptive_flexs df

2600: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2601: dfcu.application_id, dfcu.descriptive_flexfield_name,
2602: dfcu.descriptive_flex_context_code, dfcu.end_user_column_name
2603: INTO l_a_id, l_dff_name, l_context, l_segment
2604: FROM fnd_descr_flex_column_usages dfcu, fnd_descriptive_flexs df
2605: WHERE df.application_id = dfcu.application_id
2606: AND df.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
2607: AND df.table_application_id = p_application_id
2608: AND Upper(df.application_table_name) = up_table_name

Line 2623: 'SELECT FROM FND_DESCR_FLEX_COLUMN_USAGES is failed.'||chr_newline ||

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

Line 2827: fnd_descr_flex_column_usages

2823: WHERE application_id = l_old_application.application_id
2824: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2825:
2826: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2827: fnd_descr_flex_column_usages
2828: SET application_id = l_new_application.application_id,
2829: descriptive_flexfield_name = p_new_dff_name,
2830: last_update_date = l_last_update_date,
2831: last_updated_by = l_last_updated_by,