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.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_LOOKUPS

Line 2079: v_cond_type_code FEM_LOOKUPS.lookup_code%TYPE;

2075: v_sql varchar2(4000);
2076:
2077: -- Dimension Component Properties
2078: v_table_name FEM_ALLOC_BR_COND_SUM_GT.table_display_name%TYPE;
2079: v_cond_type_code FEM_LOOKUPS.lookup_code%TYPE;
2080: v_cond_type FEM_ALLOC_BR_COND_SUM_GT.condition_type%TYPE;
2081: v_cond_column FEM_ALLOC_BR_COND_SUM_GT.column_display_name%TYPE;
2082: v_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2083: v_temp_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;

Line 2093: v_any_table FEM_LOOKUPS.meaning%TYPE;

2089: v_value_set_id NUMBER; -- Not shown on the screen - identifies the value_set
2090: -- if the member comes from a value set dimension
2091:
2092:
2093: v_any_table FEM_LOOKUPS.meaning%TYPE;
2094: v_operator_name FEM_LOOKUPS.meaning%TYPE;
2095: v_and_name FEM_LOOKUPS.meaning%TYPE;
2096: -- Dimension Metadata
2097: v_member_table VARCHAR2(30);

Line 2094: v_operator_name FEM_LOOKUPS.meaning%TYPE;

2090: -- if the member comes from a value set dimension
2091:
2092:
2093: v_any_table FEM_LOOKUPS.meaning%TYPE;
2094: v_operator_name FEM_LOOKUPS.meaning%TYPE;
2095: v_and_name FEM_LOOKUPS.meaning%TYPE;
2096: -- Dimension Metadata
2097: v_member_table VARCHAR2(30);
2098: v_member_col VARCHAR2(30);

Line 2095: v_and_name FEM_LOOKUPS.meaning%TYPE;

2091:
2092:
2093: v_any_table FEM_LOOKUPS.meaning%TYPE;
2094: v_operator_name FEM_LOOKUPS.meaning%TYPE;
2095: v_and_name FEM_LOOKUPS.meaning%TYPE;
2096: -- Dimension Metadata
2097: v_member_table VARCHAR2(30);
2098: v_member_col VARCHAR2(30);
2099: v_member_name_col VARCHAR2(30);

Line 2215: FROM fem_lookups

2211: WHERE object_id = p_condition_object_id);
2212:
2213: SELECT meaning
2214: INTO v_any_table
2215: FROM fem_lookups
2216: WHERE lookup_type = 'FEM_CONDITION_TABLE_MACROS'
2217: AND lookup_code = 'ANY';
2218:
2219:

Line 2241: FROM fem_lookups

2237: -------------------------------------------------------------------
2238: -- Hierarchy component
2239: SELECT meaning
2240: INTO v_cond_type
2241: FROM fem_lookups
2242: WHERE lookup_type = 'FEM_CONDITION_DIM_COMP_TYPES'
2243: AND lookup_code = 'HIERARCHY';
2244:
2245: FOR hier IN c_hier (comp.cond_comp_obj_def_id) LOOP

Line 2269: FROM fem_lookups

2265: -------------------------------------------------------------------
2266: -- Attribute component
2267: SELECT meaning
2268: INTO v_cond_type
2269: FROM fem_lookups
2270: WHERE lookup_type = 'FEM_CONDITION_DIM_COMP_TYPES'
2271: AND lookup_code = 'ATTRIBUTE';
2272:
2273: FOR attr IN c_attr (comp.cond_comp_obj_def_id,dimcomp.dim_id) LOOP

Line 2324: FROM fem_lookups

2320: v_hier_attr := null;
2321:
2322: SELECT meaning
2323: INTO v_cond_type
2324: FROM fem_lookups
2325: WHERE lookup_type = 'FEM_CONDITION_DIM_COMP_TYPES'
2326: AND lookup_code = 'VALUE';
2327:
2328: SELECT value_set_required_flag

Line 2371: FROM fem_lookups

2367:
2368:
2369: SELECT meaning
2370: INTO v_operator_name
2371: FROM fem_lookups
2372: WHERE lookup_type = 'FEM_CONDITION_OPERATOR'
2373: AND lookup_code = step.operator;
2374:
2375: IF step.step_type ='DATA_SPECIFIC' THEN

Line 2378: FROM fem_lookups

2374:
2375: IF step.step_type ='DATA_SPECIFIC' THEN
2376: SELECT meaning
2377: INTO v_cond_type
2378: FROM fem_lookups
2379: WHERE lookup_type = 'FEM_CONDITION_DATA_STEP_TYPE'
2380: AND lookup_code = 'DATA_SPECIFIC';
2381:
2382:

Line 2410: FROM fem_lookups

2406: ELSIF step.step_type = 'DATA_RANGE' THEN
2407:
2408: SELECT meaning
2409: INTO v_cond_type
2410: FROM fem_lookups
2411: WHERE lookup_type = 'FEM_CONDITION_DATA_STEP_TYPE'
2412: AND lookup_code = 'DATA_RANGE';
2413:
2414: SELECT meaning

Line 2416: FROM fem_lookups

2412: AND lookup_code = 'DATA_RANGE';
2413:
2414: SELECT meaning
2415: INTO v_and_name
2416: FROM fem_lookups
2417: WHERE lookup_type = 'FEM_CONDITION_OPERATOR_AND'
2418: AND lookup_code = 'AND';
2419:
2420: IF step.fem_data_type_code = 'DIMENSION' THEN

Line 2454: FROM fem_lookups

2450:
2451: ELSIF step.step_type = 'DATA_ANOTHER_COL' THEN
2452: SELECT meaning
2453: INTO v_cond_type
2454: FROM fem_lookups
2455: WHERE lookup_type = 'FEM_CONDITION_DATA_STEP_TYPE'
2456: AND lookup_code = 'ANOTHER_COL';
2457:
2458: v_cond_value := step.value;

Line 2918: v_hier_relation_code FEM_LOOKUPS.lookup_code%TYPE;

2914: v_sql varchar2(4000);
2915:
2916: -- Dimension Component Properties
2917: v_matching_dimension_name FEM_ALLOC_BR_FCTR_SUM_GT.matching_dimension_name%TYPE;
2918: v_hier_relation_code FEM_LOOKUPS.lookup_code%TYPE;
2919: v_hier_name FEM_ALLOC_BR_FCTR_SUM_GT.hierarchy_name%TYPE;
2920: v_group_name FEM_ALLOC_BR_FCTR_SUM_GT.dimension_group_name%TYPE;
2921: v_hier_relation_desc FEM_ALLOC_BR_FCTR_SUM_GT.hier_relation_desc%TYPE;
2922:

Line 3018: FROM fem_lookups

3014:
3015: IF dim.hier_relation_code IS NOT NULL THEN
3016: SELECT meaning
3017: INTO v_hier_relation_desc
3018: FROM fem_lookups
3019: WHERE lookup_type = 'FEM_COND_HIER_RELATIONS'
3020: AND lookup_code = dim.hier_relation_code;
3021:
3022: END IF;