DBA Data[Home] [Help]

APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 759: FROM fem_global_vs_combo_defs

755:
756: BEGIN
757: SELECT value_set_id
758: INTO v_dim_vs_id
759: FROM fem_global_vs_combo_defs
760: WHERE global_vs_combo_id = v_global_vs_id
761: AND dimension_id = p_dimension_id;
762:
763: g_cache_dim_vs_id := v_dim_vs_id;

Line 825: FROM fem_global_vs_combo_defs

821:
822: BEGIN
823: SELECT value_set_id
824: INTO v_vs_id
825: FROM fem_global_vs_combo_defs
826: WHERE global_vs_combo_id = v_global_vs_id
827: AND dimension_id = p_dimension_id;
828: EXCEPTION
829: WHEN no_data_found THEN

Line 918: FROM fem_global_vs_combo_defs

914:
915: BEGIN
916: SELECT value_set_id
917: INTO v_vs_id
918: FROM fem_global_vs_combo_defs
919: WHERE global_vs_combo_id = v_global_vs_id
920: AND dimension_id = p_dimension_id;
921: EXCEPTION
922: WHEN no_data_found THEN

Line 8661: INSERT INTO fem_global_vs_combo_defs

8657: AND value_set_display_code = r_vs_dim_id.dimension_varchar_label;
8658:
8659: -- RCF 4/20/2005 Obsolete - v_vs_dim_id := r_vs_dim_id.dimension_id;
8660:
8661: INSERT INTO fem_global_vs_combo_defs
8662: (global_vs_combo_id,
8663: dimension_id,
8664: value_set_id,
8665: creation_date,