DBA Data[Home] [Help]

APPS.FEM_ADMIN_UTIL_PKG dependencies on FND_LOOKUP_VALUES

Line 379: v_obj_name FND_LOOKUP_VALUES.meaning%TYPE;

375:
376: v_sql VARCHAR2(4000);
377: v_col_list VARCHAR2(2000);
378: v_col_name ALL_TAB_COLUMNS.column_name%TYPE;
379: v_obj_name FND_LOOKUP_VALUES.meaning%TYPE;
380: v_col_prop_cd FEM_TAB_COLUMN_PROP.column_property_code%TYPE;
381: v_msg_name FND_NEW_MESSAGES.message_name%TYPE;
382: v_vsr_flag FEM_XDIM_DIMENSIONS.value_set_required_flag%TYPE;
383: v_count NUMBER;

Line 425: FROM fnd_lookup_values_vl

421:
422: -- Object that is being validated against
423: SELECT meaning
424: INTO v_obj_name
425: FROM fnd_lookup_values_vl
426: WHERE lookup_type = 'FEM_TAB_CLASS_OBJECTS'
427: AND lookup_code = p_prop_type;
428:
429: -- First, test for the case where a fixed column set is required.

Line 2377: FROM fnd_lookup_values_vl

2373: v_tab_class_cd VARCHAR2(30);
2374:
2375: CURSOR c_table_classes IS
2376: SELECT lookup_code
2377: FROM fnd_lookup_values_vl
2378: WHERE lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC';
2379:
2380:
2381: BEGIN

Line 2509: FROM fnd_lookup_values_vl flv

2505: */
2506:
2507: CURSOR c_table_classes IS
2508: SELECT lookup_code
2509: FROM fnd_lookup_values_vl flv
2510: WHERE flv.lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC'
2511: AND not exists(
2512: select ftcp.table_classification_code
2513: from fem_table_class_prop ftcp,