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_ALLOC_BR_COND_SUM_GT

Line 2049: FEM_ALLOC_BR_COND_SUM_GT table with it

2045: /*************************************************************************
2046:
2047: generate_condition_summary
2048: This procedure generates the condition summary info and populates the
2049: FEM_ALLOC_BR_COND_SUM_GT table with it
2050:
2051: *************************************************************************/
2052: PROCEDURE generate_condition_summary (
2053: p_condition_object_id IN NUMBER,

Line 2078: v_table_name FEM_ALLOC_BR_COND_SUM_GT.table_display_name%TYPE;

2074:
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;

Line 2080: v_cond_type FEM_ALLOC_BR_COND_SUM_GT.condition_type%TYPE;

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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;

Line 2081: v_cond_column FEM_ALLOC_BR_COND_SUM_GT.column_display_name%TYPE;

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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;

Line 2082: v_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;

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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2086: v_hier_attr FEM_ALLOC_BR_COND_SUM_GT.hier_attr_display_name%TYPE;

Line 2083: v_temp_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2086: v_hier_attr FEM_ALLOC_BR_COND_SUM_GT.hier_attr_display_name%TYPE;
2087: v_dim_comp_type VARCHAR2(1); -- Not shown on the screen - differentiates

Line 2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2086: v_hier_attr FEM_ALLOC_BR_COND_SUM_GT.hier_attr_display_name%TYPE;
2087: v_dim_comp_type VARCHAR2(1); -- Not shown on the screen - differentiates
2088: -- hierarchy components from Attribute components

Line 2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2086: v_hier_attr FEM_ALLOC_BR_COND_SUM_GT.hier_attr_display_name%TYPE;
2087: v_dim_comp_type VARCHAR2(1); -- Not shown on the screen - differentiates
2088: -- hierarchy components from Attribute components
2089: v_value_set_id NUMBER; -- Not shown on the screen - identifies the value_set

Line 2086: v_hier_attr FEM_ALLOC_BR_COND_SUM_GT.hier_attr_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;
2084: v_temp_min_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2085: v_temp_max_cond_value FEM_ALLOC_BR_COND_SUM_GT.condition_value%TYPE;
2086: v_hier_attr FEM_ALLOC_BR_COND_SUM_GT.hier_attr_display_name%TYPE;
2087: v_dim_comp_type VARCHAR2(1); -- Not shown on the screen - differentiates
2088: -- hierarchy components from Attribute components
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

Line 2208: DELETE FROM fem_alloc_br_cond_sum_gt

2204: END IF;
2205:
2206:
2207: -- initialize
2208: DELETE FROM fem_alloc_br_cond_sum_gt
2209: WHERE condition_obj_def_id IN (SELECT object_definition_id
2210: FROM fem_object_definition_b
2211: WHERE object_id = p_condition_object_id);
2212:

Line 2249: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (

2245: FOR hier IN c_hier (comp.cond_comp_obj_def_id) LOOP
2246: v_hier_attr := hier.object_name;
2247: v_cond_value := null;
2248:
2249: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (
2250: CONDITION_OBJ_DEF_ID,
2251: TABLE_DISPLAY_NAME,
2252: COLUMN_DISPLAY_NAME,
2253: CONDITION_TYPE,

Line 2298: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (

2294: ELSE -- NUMBER, VARCHAR or DATE attribute
2295: v_cond_value := attr.dim_attr_value;
2296: END IF;
2297:
2298: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (
2299: CONDITION_OBJ_DEF_ID,
2300: TABLE_DISPLAY_NAME,
2301: COLUMN_DISPLAY_NAME,
2302: CONDITION_TYPE,

Line 2345: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (

2341: dimcomp.value,
2342: v_value_set_id);
2343:
2344:
2345: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (
2346: CONDITION_OBJ_DEF_ID,
2347: TABLE_DISPLAY_NAME,
2348: COLUMN_DISPLAY_NAME,
2349: CONDITION_TYPE,

Line 2474: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (

2470: WHERE table_name = step.table_name
2471: AND column_name = step.column_name;
2472:
2473:
2474: INSERT INTO FEM_ALLOC_BR_COND_SUM_GT (
2475: CONDITION_OBJ_DEF_ID,
2476: TABLE_DISPLAY_NAME,
2477: COLUMN_DISPLAY_NAME,
2478: CONDITION_TYPE,