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_RU_ENGINE_PVT dependencies on FEM_RU_NODES_T

Line 2148: from fem_ru_nodes_t

2144: p_request_id in number
2145: ,p_object_id in number
2146: ) is
2147: select node_id
2148: from fem_ru_nodes_t
2149: where created_by_request_id = p_request_id
2150: and created_by_object_id = p_object_id
2151: and root_flag = 'Y'
2152: and costed_flag = 'N';

Line 2159: from fem_ru_nodes_t

2155: p_request_id in number
2156: ,p_object_id in number
2157: ) is
2158: select node_id
2159: from fem_ru_nodes_t
2160: where created_by_request_id = p_request_id
2161: and created_by_object_id = p_object_id
2162: and condition_flag = 'Y'
2163: and costed_flag = 'N';

Line 2397: from fem_ru_nodes_t

2393:
2394: -- query to count number of uncosted nodes
2395: select count(*)
2396: into l_uncosted_node_count
2397: from fem_ru_nodes_t
2398: where created_by_request_id = p_request_rec.request_id
2399: and created_by_object_id = l_rule_rec.rollup_obj_id
2400: and costed_flag = 'N';
2401:

Line 3095: ' from fem_ru_nodes_t n'||

3091: ' and created_by_object_id = :b_rollup_obj_id'||
3092: ' )'||
3093: ' and exists ('||
3094: ' select 1'||
3095: ' from fem_ru_nodes_t n'||
3096: ' where n.created_by_request_id = :b_request_id'||
3097: ' and n.created_by_object_id = :b_rollup_obj_id'||
3098: ' and n.node_id = b.cost_object_id'||
3099: ' and n.costed_flag = ''Y'''||

Line 3259: ' from fem_ru_nodes_t n'||

3255: ' and created_by_object_id = :b_rollup_obj_id'||
3256: ' )'||
3257: ' and exists ('||
3258: ' select 1'||
3259: ' from fem_ru_nodes_t n'||
3260: ' where n.created_by_request_id = :b_request_id'||
3261: ' and n.created_by_object_id = :b_rollup_obj_id'||
3262: ' and n.node_id = b.activity_id'||
3263: ' and n.costed_flag = ''Y'''||

Line 3446: -- Register the FEM_RU_NODES_T processing table as INSERT. This is needed

3442: ,p_table_name => 'FEM_BALANCES'
3443: ,p_statement_type => 'INSERT'
3444: );
3445:
3446: -- Register the FEM_RU_NODES_T processing table as INSERT. This is needed
3447: -- in the event of a engine failure where the only way to purge these records
3448: -- is through the Undo Process
3449: Register_Table (
3450: p_request_rec => p_request_rec

Line 3452: ,p_table_name => 'FEM_RU_NODES_T'

3448: -- is through the Undo Process
3449: Register_Table (
3450: p_request_rec => p_request_rec
3451: ,p_rule_rec => p_rule_rec
3452: ,p_table_name => 'FEM_RU_NODES_T'
3453: ,p_statement_type => 'INSERT'
3454: );
3455:
3456: if (p_request_rec.dimension_rec.dimension_varchar_label = 'COST_OBJECT') then

Line 3887: | rule's condition, and stores them in the FEM_RU_NODES_T table. If any of

Line 3889: | FEM_RU_NODES_T table.

3885: | DESCRIPTION
3886: | Finds all the nodes in the rollup hierarchy that satisfies the rollup
3887: | rule's condition, and stores them in the FEM_RU_NODES_T table. If any of
3888: | condition nodes are hierarchies, these are labeled as such in the
3889: | FEM_RU_NODES_T table.
3890: |
3891: | SCOPE - PRIVATE
3892: |
3893: +============================================================================*/

Line 3988: -- into FEM_RU_NODES_T

3984: ,p_msg_text => 'Step 2: Find "Parent" Condition Nodes'
3985: );
3986:
3987: -- Build SQL statement for finding and inserting "Parent" Condition Nodes
3988: -- into FEM_RU_NODES_T
3989: l_find_cond_node_stmt :=
3990: ' insert into fem_ru_nodes_t ('||
3991: ' created_by_request_id'||
3992: ' ,created_by_object_id'||

Line 3990: ' insert into fem_ru_nodes_t ('||

3986:
3987: -- Build SQL statement for finding and inserting "Parent" Condition Nodes
3988: -- into FEM_RU_NODES_T
3989: l_find_cond_node_stmt :=
3990: ' insert into fem_ru_nodes_t ('||
3991: ' created_by_request_id'||
3992: ' ,created_by_object_id'||
3993: ' ,node_id'||
3994: ' ,costed_flag'||

Line 4010: ' from fem_ru_nodes_t n'||

4006: -- ' and {{data_slice}}'||
4007: ' and '||l_cond_where_clause||
4008: ' and not exists ('||
4009: ' select 1'||
4010: ' from fem_ru_nodes_t n'||
4011: ' where n.created_by_request_id = :b_request_id'||
4012: ' and n.created_by_object_id = :b_rollup_obj_id'||
4013: ' and n.node_id = m.'||l_dimension_rec.member_col||
4014: ' )';

Line 4086: -- Count the number of "Parent" Condition Nodes in FEM_RU_NODES_T

4082: ,p_module => G_BLOCK||'.'||l_api_name
4083: ,p_msg_text => 'Step 3: Count "Parent" Condition Nodes'
4084: );
4085:
4086: -- Count the number of "Parent" Condition Nodes in FEM_RU_NODES_T
4087: select count(*)
4088: into l_node_count
4089: from fem_ru_nodes_t
4090: where created_by_request_id = p_request_rec.request_id

Line 4089: from fem_ru_nodes_t

4085:
4086: -- Count the number of "Parent" Condition Nodes in FEM_RU_NODES_T
4087: select count(*)
4088: into l_node_count
4089: from fem_ru_nodes_t
4090: where created_by_request_id = p_request_rec.request_id
4091: and created_by_object_id = p_rule_rec.rollup_obj_id;
4092:
4093: if (l_node_count = 0) then

Line 4195: -- in FEM_RU_NODES_T and update the Root Node Flag to Y.

4191: ,p_msg_text => 'Step 4: Find "Root" Condition Nodes'
4192: );
4193:
4194: -- Build SQL statement for finding any possible "Root" Condition Nodes
4195: -- in FEM_RU_NODES_T and update the Root Node Flag to Y.
4196: l_find_cond_root_stmt :=
4197: ' update fem_ru_nodes_t n'||
4198: ' set root_flag = ''Y'''||
4199: ' where created_by_request_id = :b_request_id'||

Line 4197: ' update fem_ru_nodes_t n'||

4193:
4194: -- Build SQL statement for finding any possible "Root" Condition Nodes
4195: -- in FEM_RU_NODES_T and update the Root Node Flag to Y.
4196: l_find_cond_root_stmt :=
4197: ' update fem_ru_nodes_t n'||
4198: ' set root_flag = ''Y'''||
4199: ' where created_by_request_id = :b_request_id'||
4200: ' and created_by_object_id = :b_rollup_obj_id';
4201: -- ' and {{data_slice}}';

Line 4279: | FEM_RU_NODES_T table.

4275: | Find_Root_Nodes
4276: |
4277: | DESCRIPTION
4278: | Finds all the root nodes in the rollup hierarchy, and stores them in the
4279: | FEM_RU_NODES_T table.
4280: |
4281: | SCOPE - PRIVATE
4282: |
4283: +============================================================================*/

Line 4320: -- FEM_RU_NODES_T

4316: ,p_msg_text => 'Step 1: Find Root Nodes'
4317: );
4318:
4319: -- Build SQL statement for finding and inserting Root Nodes into
4320: -- FEM_RU_NODES_T
4321: l_find_root_node_stmt :=
4322: ' insert into fem_ru_nodes_t ('||
4323: ' created_by_request_id'||
4324: ' ,created_by_object_id'||

Line 4322: ' insert into fem_ru_nodes_t ('||

4318:
4319: -- Build SQL statement for finding and inserting Root Nodes into
4320: -- FEM_RU_NODES_T
4321: l_find_root_node_stmt :=
4322: ' insert into fem_ru_nodes_t ('||
4323: ' created_by_request_id'||
4324: ' ,created_by_object_id'||
4325: ' ,node_id'||
4326: ' ,costed_flag'||

Line 4341: ' from fem_ru_nodes_t n'||

4337: ' where m.local_vs_combo_id = :b_local_vs_combo_id'||
4338: -- ' and {{data_slice}}'||
4339: ' and not exists ('||
4340: ' select 1'||
4341: ' from fem_ru_nodes_t n'||
4342: ' where n.created_by_request_id = :b_request_id'||
4343: ' and n.created_by_object_id = :b_rollup_obj_id'||
4344: ' and n.node_id = m.'||l_dimension_rec.member_col||
4345: ' )';

Line 4432: from fem_ru_nodes_t

4428: );
4429:
4430: select count(*)
4431: into l_node_count
4432: from fem_ru_nodes_t
4433: where created_by_request_id = p_request_rec.request_id
4434: and created_by_object_id = p_rule_rec.rollup_obj_id
4435: and root_flag = 'Y';
4436:

Line 4558: from fem_ru_nodes_t

4554: );
4555:
4556: select costed_flag
4557: into l_costed_flag
4558: from fem_ru_nodes_t
4559: where created_by_request_id = p_request_rec.request_id
4560: and created_by_object_id = p_rule_rec.rollup_obj_id
4561: and node_id = p_top_node_id;
4562:

Line 4622: ,fem_ru_nodes_t n

4618: ,h.child_sequence_num
4619: ,nvl(n.costed_flag,'N') as costed_flag
4620: from fem_cost_objects_hier h
4621: ,fem_cost_objects parent
4622: ,fem_ru_nodes_t n
4623: where h.hierarchy_obj_id = p_rule_rec.hier_obj_id
4624: and p_request_rec.effective_date between h.effective_start_date and h.effective_end_date
4625: and parent.cost_object_id = h.parent_id
4626: and parent.ledger_id = p_request_rec.ledger_id

Line 4696: ,fem_ru_nodes_t n

4692: ,h.single_depth_flag
4693: ,h.weighting_pct
4694: ,nvl(n.costed_flag,'N') as costed_flag
4695: from fem_activities_hier h
4696: ,fem_ru_nodes_t n
4697: where h.hierarchy_obj_def_id = p_rule_rec.hier_obj_def_id
4698: and h.child_id <> h.parent_id
4699: and h.single_depth_flag = 'Y'
4700: and n.created_by_request_id (+) = p_request_rec.request_id

Line 4722: -- STEP 2: Find Child Nodes not in FEM_RU_NODES_T table

4718:
4719: end if;
4720:
4721: ------------------------------------------------------------------------------
4722: -- STEP 2: Find Child Nodes not in FEM_RU_NODES_T table
4723: ------------------------------------------------------------------------------
4724: FEM_ENGINES_PKG.Tech_Message (
4725: p_severity => G_LOG_LEVEL_1
4726: ,p_module => G_BLOCK||'.'||l_api_name

Line 4731: -- FEM_RU_NODES_T

4727: ,p_msg_text => 'Step 2: Find Child Nodes'
4728: );
4729:
4730: -- Build SQL statement for finding and inserting Child Nodes into
4731: -- FEM_RU_NODES_T
4732: l_find_child_nodes_stmt :=
4733: ' insert into fem_ru_nodes_t ('||
4734: ' created_by_request_id'||
4735: ' ,created_by_object_id'||

Line 4733: ' insert into fem_ru_nodes_t ('||

4729:
4730: -- Build SQL statement for finding and inserting Child Nodes into
4731: -- FEM_RU_NODES_T
4732: l_find_child_nodes_stmt :=
4733: ' insert into fem_ru_nodes_t ('||
4734: ' created_by_request_id'||
4735: ' ,created_by_object_id'||
4736: ' ,node_id'||
4737: ' ,costed_flag'||

Line 4756: ' from fem_ru_nodes_t n'||

4752: ' where h.created_by_request_id = :b_request_id'||
4753: ' and h.created_by_object_id = :b_rollup_obj_id'||
4754: ' and not exists ('||
4755: ' select 1'||
4756: ' from fem_ru_nodes_t n'||
4757: ' where n.created_by_request_id = h.created_by_request_id'||
4758: ' and n.created_by_object_id = h.created_by_object_id'||
4759: ' and n.node_id = h.child_id'||
4760: ' )';

Line 4789: ' from fem_ru_nodes_t n'||

4785: ' and h.child_id <> h.parent_id'||
4786: ' and h.single_depth_flag = ''Y'''||
4787: ' and not exists ('||
4788: ' select 1'||
4789: ' from fem_ru_nodes_t n'||
4790: ' where n.created_by_request_id = h.created_by_request_id'||
4791: ' and n.created_by_object_id = h.created_by_object_id'||
4792: ' and n.node_id = h.child_id'||
4793: ' )';

Line 4818: ' from fem_ru_nodes_t n'||

4814: ' and h.child_id <> h.parent_id'||
4815: ' and h.single_depth_flag = ''Y'''||
4816: ' and not exists ('||
4817: ' select 1'||
4818: ' from fem_ru_nodes_t n'||
4819: ' where n.created_by_request_id = :b_request_id'||
4820: ' and n.created_by_object_id = :b_rollup_obj_id'||
4821: ' and n.node_id = h.child_id'||
4822: ' )';

Line 4862: -- FEM_RU_NODES_T. A join to FEM_COST_OBJECTS is necessary for

4858:
4859: if (l_dimension_rec.dimension_varchar_label = 'COST_OBJECT') then
4860:
4861: -- The source table query comes from the list of uncosted nodes in
4862: -- FEM_RU_NODES_T. A join to FEM_COST_OBJECTS is necessary for
4863: -- Populate_Cost_Object_Id to work properly as it needs all the
4864: -- component dimension columns for the join on FEM_BALANCES.
4865: l_source_table_query_stmt :=
4866: ' select co.cost_object_id'||

Line 4868: ' ,fem_ru_nodes_t n'||

4864: -- component dimension columns for the join on FEM_BALANCES.
4865: l_source_table_query_stmt :=
4866: ' select co.cost_object_id'||
4867: ' from fem_cost_objects co'||
4868: ' ,fem_ru_nodes_t n'||
4869: ' where n.created_by_request_id = :b_request_id'||
4870: ' and n.created_by_object_id = :b_rollup_obj_id'||
4871: ' and n.costed_flag = ''N'''||
4872: ' and n.node_id = co.cost_object_id';

Line 4900: -- uncosted nodes in FEM_RU_NODES_T. A join to FEM_ACTIVITIES is

4896:
4897: if (p_rule_rec.cond_exists) then
4898:
4899: -- If a condition exists, the source table query comes from the list of
4900: -- uncosted nodes in FEM_RU_NODES_T. A join to FEM_ACTIVITIES is
4901: -- necessary for Populate_Activity_Id to work properly as it needs all the
4902: -- component dimension columns for the join on FEM_BALANCES.
4903: l_source_table_query_stmt :=
4904: ' select act.activity_id'||

Line 4906: ' ,fem_ru_nodes_t n'||

4902: -- component dimension columns for the join on FEM_BALANCES.
4903: l_source_table_query_stmt :=
4904: ' select act.activity_id'||
4905: ' from fem_activities act'||
4906: ' ,fem_ru_nodes_t n'||
4907: ' where n.created_by_request_id = :b_request_id'||
4908: ' and n.created_by_object_id = :b_rollup_obj_id'||
4909: ' and n.costed_flag = ''N'''||
4910: ' and n.node_id = act.activity_id';

Line 5059: ' from fem_ru_nodes_t n'||

5055: -- Build SQL statement for retrieving all parent nodes of a hierarchy at the
5056: -- specified parent depth number that have not been costed
5057: l_find_parent_nodes_stmt :=
5058: ' select n.node_id'||
5059: ' from fem_ru_nodes_t n'||
5060: ' where n.created_by_request_id = :b_request_id'||
5061: ' and n.created_by_object_id = :b_rollup_obj_id'||
5062: ' and n.costed_flag = ''N''';
5063: -- ' and {{data_slice}}'||

Line 5405: from fem_ru_nodes_t

5401: );
5402:
5403: select costed_flag
5404: into l_costed_flag
5405: from fem_ru_nodes_t
5406: where created_by_request_id = p_request_id
5407: and created_by_object_id = p_rollup_obj_id
5408: and node_id = p_parent_id;
5409:

Line 5739: update fem_ru_nodes_t

5735: ,p_msg_text => 'Step 6: Mark All Uncosted Children Just Processed as Costed'
5736: );
5737:
5738: forall i in 1..l_find_children_last_row
5739: update fem_ru_nodes_t
5740: set costed_flag = 'Y'
5741: where created_by_request_id = p_request_id
5742: and created_by_object_id = p_rollup_obj_id
5743: and node_id = l_child_id_tbl(i)

Line 5763: update fem_ru_nodes_t

5759: ,p_module => G_BLOCK||'.'||l_api_name
5760: ,p_msg_text => 'Step 7: Mark the Parent as Costed'
5761: );
5762:
5763: update fem_ru_nodes_t
5764: set costed_flag = 'Y'
5765: where created_by_request_id = p_request_id
5766: and created_by_object_id = p_rollup_obj_id
5767: and node_id = p_parent_id;

Line 6095: -- FEM_BALANCES before purging FEM_RU_NODES_T.

6091: if (p_exec_status_code = G_EXEC_STATUS_SUCCESS) then
6092:
6093: ----------------------------------------------------------------------------
6094: -- STEP 2: If a successful object execution, update number of input rows in
6095: -- FEM_BALANCES before purging FEM_RU_NODES_T.
6096: ----------------------------------------------------------------------------
6097: FEM_ENGINES_PKG.Tech_Message (
6098: p_severity => G_LOG_LEVEL_1
6099: ,p_module => G_BLOCK||'.'||l_api_name

Line 6165: -- STEP 3: Delete all records in the FEM_RU_NODES_T table

6161:
6162: end if;
6163:
6164: ------------------------------------------------------------------------------
6165: -- STEP 3: Delete all records in the FEM_RU_NODES_T table
6166: ------------------------------------------------------------------------------
6167: --todo: should only delete records for p_exec_status_code = SUCCESS. But
6168: --until we bring in error reprocessing, must always delete temp data.
6169: FEM_ENGINES_PKG.Tech_Message (

Line 6172: ,p_msg_text => 'Step 3: Purging Records in FEM_RU_NODES_T'

6168: --until we bring in error reprocessing, must always delete temp data.
6169: FEM_ENGINES_PKG.Tech_Message (
6170: p_severity => G_LOG_LEVEL_1
6171: ,p_module => G_BLOCK||'.'||l_api_name
6172: ,p_msg_text => 'Step 3: Purging Records in FEM_RU_NODES_T'
6173: );
6174:
6175: delete from fem_ru_nodes_t
6176: where created_by_request_id = p_request_rec.request_id

Line 6175: delete from fem_ru_nodes_t

6171: ,p_module => G_BLOCK||'.'||l_api_name
6172: ,p_msg_text => 'Step 3: Purging Records in FEM_RU_NODES_T'
6173: );
6174:
6175: delete from fem_ru_nodes_t
6176: where created_by_request_id = p_request_rec.request_id
6177: and created_by_object_id = p_rule_rec.rollup_obj_id;
6178:
6179: commit;