[Home] [Help]
458: -- p_obj_def_id is the rule version of the parent mapping rule.
459: CURSOR c_row_group_info (cv_obj_def_id NUMBER) IS
460: SELECT f.table_name, f.function_cd, f.sub_object_id,
461: m.preview_row_group, m.preview_row_group_display_seq
462: FROM fem_alloc_br_formula f, fem_function_cd_mapping m
463: WHERE f.function_cd = m.function_cd
464: AND f.object_definition_id = cv_obj_def_id
465: AND nvl(f.enable_flg,'Y') = 'Y'
466: ORDER BY m.preview_row_group_process_seq;
587: ELSE
588:
589: v_temp_table_seq := v_temp_table_seq + 1;
590:
591: -- First, assume fact table name is from FEM_ALLOC_BR_FORMULA.TABLE_NAME
592: v_fact_table_name := row_group.table_name;
593:
594: -- If this is the driver and the mapping rule type is Retrieve Stats,
595: -- get the fact table name from FEM_STAT_LOOKUPS.STAT_LOOKUP_TABLE
592: v_fact_table_name := row_group.table_name;
593:
594: -- If this is the driver and the mapping rule type is Retrieve Stats,
595: -- get the fact table name from FEM_STAT_LOOKUPS.STAT_LOOKUP_TABLE
596: -- instead of FEM_ALLOC_BR_FORMULA.TABLE_NAME.
597: IF row_group.preview_row_group = G_DRIVER AND
598: v_map_rule_type = G_RETRIEVE_STAT THEN
599:
600: -- First get Stat Lookup obj def id
2334: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
2335: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
2336: v_return_code NUMBER;
2337: v_cal_per_end_date FEM_CAL_PERIODS_ATTR.date_assign_value%TYPE;
2338: v_amount_column FEM_ALLOC_BR_FORMULA.column_name%TYPE;
2339: v_sql VARCHAR2(4000);
2340: v_amount NUMBER;
2341: v_conv_amount NUMBER;
2342: v_amount_currency FEM_BALANCES.currency_code%TYPE;
2471: --
2472:
2473: -- For Ledger tables, the amount column is always XTD_BALANCE_F.
2474: -- For Account/Transaction tables, the amount column is stored in
2475: -- FEM_ALLOC_BR_FORMULA.column_name
2476: IF p_map_table_type = G_LEDGER_TYPE THEN
2477:
2478: v_amount_column := G_LEDGER_AMOUNT_COL;
2479:
2480: ELSIF p_map_table_type = G_ACCT_TRANS_TYPE THEN
2481:
2482: SELECT f.column_name
2483: INTO v_amount_column
2484: FROM fem_alloc_br_formula f, fem_function_cd_mapping m
2485: WHERE f.object_definition_id = p_map_obj_def_id
2486: AND f.function_cd = m.function_cd
2487: AND m.preview_row_group = p_preview_row_group;
2488: