APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_ALLOC_BR_OBJECTS

Line 25: G_RETRIEVE_STAT CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE

21: := 'CREDIT';
22: G_ACCT_TRANS_TYPE CONSTANT VARCHAR2(30) := 'ACCOUNT_TRANS';
23: G_LEDGER_TYPE CONSTANT VARCHAR2(30) := 'LEDGER';
24: G_OTHER_TABLE_TYPE CONSTANT VARCHAR2(30) := 'OTHER_TABLE_TYPE';
25: G_RETRIEVE_STAT CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
26: := 'RETRIEVE_STATISTICS';
27: G_BY_DIMENSION CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
28: := 'DIMENSION';
29: G_FACTOR_TABLE CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE

Line 27: G_BY_DIMENSION CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE

23: G_LEDGER_TYPE CONSTANT VARCHAR2(30) := 'LEDGER';
24: G_OTHER_TABLE_TYPE CONSTANT VARCHAR2(30) := 'OTHER_TABLE_TYPE';
25: G_RETRIEVE_STAT CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
26: := 'RETRIEVE_STATISTICS';
27: G_BY_DIMENSION CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
28: := 'DIMENSION';
29: G_FACTOR_TABLE CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
30: := 'FACTOR_TABLE';
31: G_NUMBER_TYPE CONSTANT VARCHAR2(15) := 'NUMBER';

Line 29: G_FACTOR_TABLE CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE

25: G_RETRIEVE_STAT CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
26: := 'RETRIEVE_STATISTICS';
27: G_BY_DIMENSION CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
28: := 'DIMENSION';
29: G_FACTOR_TABLE CONSTANT FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE
30: := 'FACTOR_TABLE';
31: G_NUMBER_TYPE CONSTANT VARCHAR2(15) := 'NUMBER';
32: G_VARCHAR_TYPE CONSTANT VARCHAR2(15) := 'VARCHAR';
33: G_UNSUPPORTED_TYPE CONSTANT VARCHAR2(15) := 'UNSUPPORTED';

Line 450: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;

446: v_map_obj_id FEM_OBJECT_DEFINITION_B.object_id%TYPE;
447: v_stat_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
448: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
449: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;
450: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
451: v_temp_table_seq NUMBER;
452: v_map_where_clause VARCHAR2(16000);
453: v_create_temp_table BOOLEAN;
454: v_debit_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;

Line 542: FROM fem_alloc_br_objects

538:
539: -- Get map rule type
540: SELECT map_rule_type_code
541: INTO v_map_rule_type
542: FROM fem_alloc_br_objects
543: WHERE map_rule_object_id = v_map_obj_id;
544:
545: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
546: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1546: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;

1542: IS
1543: --
1544: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1545: 'fem.plsql.fem_mapping_preview_util_pkg.GetOutputMatchingTable';
1546: v_map_rule_type FEM_ALLOC_BR_OBJECTS.map_rule_type_code%TYPE;
1547: v_fact_table_name FEM_ALLOC_PREVIEW_STATS.fact_table_name%TYPE;
1548: v_temp_table_name FEM_ALLOC_PREVIEW_STATS.temp_table_name%TYPE;
1549: v_map_table_type VARCHAR2(30);
1550: v_temp_table_group FEM_ALLOC_PREVIEW_STATS.preview_row_group%TYPE;