[Home] [Help]
1470: -- Manually set the hierarchy rollup tables
1471: if (x_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
1472:
1473: -- Used for all COUC Rollups
1474: x_dimension_rec.hier_rollup_table := 'FEM_RU_COST_OBJ_HIER_T';
1475:
1476: elsif (x_dimension_rec.dimension_varchar_label = 'ACTIVITY') then
1477:
1478: -- Used for Activity Cost/Statistic Rollups that have a Condition
3454: );
3455:
3456: if (p_request_rec.dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
3457:
3458: -- Register the FEM_RU_COST_OBJ_HIER_T processing table as INSERT.
3459: -- This is needed in the event of a engine failure where the only way to
3460: -- purge these records is through the Undo Process
3461: Register_Table (
3462: p_request_rec => p_request_rec
3460: -- purge these records is through the Undo Process
3461: Register_Table (
3462: p_request_rec => p_request_rec
3463: ,p_rule_rec => p_rule_rec
3464: ,p_table_name => 'FEM_RU_COST_OBJ_HIER_T'
3465: ,p_statement_type => 'INSERT'
3466: );
3467:
3468: elsif ( (p_request_rec.dimension_rec.dimension_varchar_label = 'ACTIVITY')
4475: |
4476: | Flattening of the rollup hierarchy is necessary when performing rollups on
4477: | the cost object hierarchy (regardless if a condition is specified or not),
4478: | or on the activity hierarchy if and only if a condition is specified. The
4479: | flattened hierarchy is store in FEM_RU_COST_OBJ_HIER_T for the cost object
4480: | hierarchy, and in FEM_RU_ACTIVITIES_HIER_T for the activity hierarchy.
4481: | After finishing all rollup processing for a top node, the flattened
4482: | hierarchies need to be purged.
4483: |
4567: if (l_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
4568:
4569: ----------------------------------------------------------------------------
4570: -- STEP 1.a: Flatten the Cost Object hierarchy into the
4571: -- FEM_RU_COST_OBJ_HIER_T table.
4572: ----------------------------------------------------------------------------
4573: FEM_ENGINES_PKG.Tech_Message (
4574: p_severity => G_LOG_LEVEL_1
4575: ,p_module => G_BLOCK||'.'||l_api_name
4579: begin
4580:
4581: -- Flatten Cost Object hierarchy. Can't use MP as this is a connect by
4582: -- query.
4583: insert into fem_ru_cost_obj_hier_t (
4584: created_by_request_id
4585: ,created_by_object_id
4586: ,relationship_id
4587: ,parent_id
4975: if (l_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
4976:
4977: select min(h.parent_depth_num)
4978: into l_min_parent_depth_num
4979: from fem_ru_cost_obj_hier_t h
4980: where h.created_by_request_id = p_request_rec.request_id
4981: and h.created_by_object_id = p_rule_rec.rollup_obj_id
4982: and h.parent_id = p_top_node_id;
4983:
4982: and h.parent_id = p_top_node_id;
4983:
4984: select max(h.parent_depth_num)
4985: into l_max_parent_depth_num
4986: from fem_ru_cost_obj_hier_t h
4987: where h.created_by_request_id = p_request_rec.request_id
4988: and h.created_by_object_id = p_rule_rec.rollup_obj_id;
4989:
4990: elsif (l_dimension_rec.dimension_varchar_label = 'ACTIVITY') then
5210:
5211: if (l_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
5212:
5213: ----------------------------------------------------------------------------
5214: -- STEP 7.a: Purge all records in FEM_RU_COST_OBJ_HIER_T
5215: ----------------------------------------------------------------------------
5216: FEM_ENGINES_PKG.Tech_Message (
5217: p_severity => G_LOG_LEVEL_1
5218: ,p_module => G_BLOCK||'.'||l_api_name
5215: ----------------------------------------------------------------------------
5216: FEM_ENGINES_PKG.Tech_Message (
5217: p_severity => G_LOG_LEVEL_1
5218: ,p_module => G_BLOCK||'.'||l_api_name
5219: ,p_msg_text => 'Step 7.a: Purge all records in FEM_RU_COST_OBJ_HIER_T'
5220: );
5221:
5222: delete from fem_ru_cost_obj_hier_t
5223: where created_by_request_id = p_request_rec.request_id
5218: ,p_module => G_BLOCK||'.'||l_api_name
5219: ,p_msg_text => 'Step 7.a: Purge all records in FEM_RU_COST_OBJ_HIER_T'
5220: );
5221:
5222: delete from fem_ru_cost_obj_hier_t
5223: where created_by_request_id = p_request_rec.request_id
5224: and created_by_object_id = p_rule_rec.rollup_obj_id;
5225:
5226: commit;
6184: if (l_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
6185:
6186: --------------------------------------------------------------------------
6187: -- STEP 4.a: For a COUC rollup, need to delete all records for this
6188: -- request id in the FEM_RU_COST_OBJ_HIER_T table
6189: --------------------------------------------------------------------------
6190: --todo: Until we bring in error reprocessing, must all ways delete temp data.
6191: FEM_ENGINES_PKG.Tech_Message (
6192: p_severity => G_LOG_LEVEL_1
6190: --todo: Until we bring in error reprocessing, must all ways delete temp data.
6191: FEM_ENGINES_PKG.Tech_Message (
6192: p_severity => G_LOG_LEVEL_1
6193: ,p_module => G_BLOCK||'.'||l_api_name
6194: ,p_msg_text => 'Step 4.a: Purging Records in FEM_RU_COST_OBJ_HIER_T'
6195: );
6196:
6197: delete from fem_ru_cost_obj_hier_t
6198: where created_by_request_id = p_request_rec.request_id
6193: ,p_module => G_BLOCK||'.'||l_api_name
6194: ,p_msg_text => 'Step 4.a: Purging Records in FEM_RU_COST_OBJ_HIER_T'
6195: );
6196:
6197: delete from fem_ru_cost_obj_hier_t
6198: where created_by_request_id = p_request_rec.request_id
6199: and created_by_object_id = p_rule_rec.rollup_obj_id;
6200:
6201: commit;