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.

[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_HIER_DEFINITIONS

Line 683: Update fem_hier_definitions

679: End Loop; -- Outer Loop Top Nodes
680:
681: end if;
682: -- To set the completion of the Hierarchy Version explosion.
683: Update fem_hier_definitions
684: set flattened_rows_completion_code = 'COMPLETED',
685: last_updated_by = g_current_user_id,
686: last_update_date = g_current_date,
687: last_update_login = g_current_login_id,

Line 4459: INSERT INTO fem_hier_definitions

4455: X_LAST_UPDATE_DATE => l_last_update_date,
4456: X_LAST_UPDATED_BY => l_last_updated_by,
4457: X_LAST_UPDATE_LOGIN => l_last_update_login);
4458:
4459: INSERT INTO fem_hier_definitions
4460: (hierarchy_obj_def_id,
4461: flattened_rows_completion_code,
4462: created_by,
4463: creation_date,

Line 4564: FROM fem_hier_definitions

4560: begin
4561:
4562: SELECT flattened_rows_completion_code
4563: INTO l_hier_version_status
4564: FROM fem_hier_definitions
4565: WHERE hierarchy_obj_def_id = p_hier_version_id;
4566:
4567: SELECT WRITE_FLAG
4568: INTO l_write_status

Line 4613: FROM fem_hier_definitions

4609: begin
4610:
4611: SELECT flattened_rows_completion_code
4612: INTO l_hier_version_status
4613: FROM fem_hier_definitions
4614: WHERE hierarchy_obj_def_id = p_hier_version_id;
4615:
4616: if l_hier_version_status = 'PENDING_DELETION' then
4617: l_detail_status := 'N';

Line 4655: FROM fem_hier_definitions

4651: begin
4652:
4653: SELECT flattened_rows_completion_code
4654: INTO l_hier_version_status
4655: FROM fem_hier_definitions
4656: WHERE hierarchy_obj_def_id = p_hier_version_id;
4657:
4658: if l_hier_version_status = 'PENDING_DELETION' then
4659: l_duplicate_status := 'N';

Line 4696: FROM fem_hier_definitions

4692: begin
4693:
4694: SELECT flattened_rows_completion_code
4695: INTO l_hier_version_status
4696: FROM fem_hier_definitions
4697: WHERE hierarchy_obj_def_id = p_hier_ver_id;
4698:
4699: if l_hier_version_status = 'PENDING_DELETION' then
4700: l_delete_status := 'N';

Line 4734: FROM fem_hier_definitions hierDef,

4730: begin
4731:
4732: SELECT distinct flattened_rows_completion_code
4733: INTO l_hier_status
4734: FROM fem_hier_definitions hierDef,
4735: fem_object_definition_b objDef
4736: WHERE hierDef.hierarchy_obj_def_id = objDef.object_definition_id
4737: AND objDef.object_id = p_hierarchy_id;
4738:

Line 4776: FROM fem_hier_definitions hierDef,

4772: begin
4773:
4774: SELECT distinct flattened_rows_completion_code
4775: INTO l_hier_status
4776: FROM fem_hier_definitions hierDef,
4777: fem_object_definition_b objDef
4778: WHERE hierDef.hierarchy_obj_def_id = objDef.object_definition_id
4779: AND objDef.object_id = p_hierarchy_id;
4780:

Line 4832: UPDATE fem_hier_definitions

4828: -- Bug:4042475
4829: -- When deleting the Hierarchy we set the status of all the versions
4830: -- of the Hierarchy to PENDING_DELETION
4831:
4832: UPDATE fem_hier_definitions
4833: SET flattened_rows_completion_code = 'PENDING_DELETION'
4834: WHERE hierarchy_obj_def_id in (select object_definition_id
4835: from fem_object_definition_vl
4836: where object_id = p_hier_obj_id);

Line 4870: UPDATE fem_hier_definitions

4866:
4867: --The follwoing update statement may not update any rows as
4868: --Delete is already done.
4869:
4870: UPDATE fem_hier_definitions
4871: SET flattened_rows_completion_code = 'COMPLETE'
4872: WHERE hierarchy_obj_def_id in (select object_definition_id
4873: from fem_object_definition_vl
4874: where object_id = p_hier_obj_id);

Line 5013: FROM fem_hier_definitions

5009: --Get the previous status of 'flattened_rows_completion_code'
5010:
5011: SELECT flattened_rows_completion_code
5012: INTO l_current_hier_status
5013: FROM fem_hier_definitions
5014: WHERE hierarchy_obj_def_id = p_hier_version_id;
5015:
5016: --Bug:4042475
5017:

Line 5018: UPDATE fem_hier_definitions

5014: WHERE hierarchy_obj_def_id = p_hier_version_id;
5015:
5016: --Bug:4042475
5017:
5018: UPDATE fem_hier_definitions
5019: SET flattened_rows_completion_code = 'PENDING_DELETION'
5020: WHERE hierarchy_obj_def_id = p_hier_version_id;
5021:
5022: commit;

Line 5036: UPDATE fem_hier_definitions

5032: if l_return_status in ('U', 'E') then
5033:
5034: --Retain the initial status when there is any error.
5035:
5036: UPDATE fem_hier_definitions
5037: SET flattened_rows_completion_code = l_current_hier_status
5038: WHERE hierarchy_obj_def_id = p_hier_version_id;
5039:
5040: commit;

Line 5057: UPDATE fem_hier_definitions

5053: end if;
5054:
5055: --Bug:4042475
5056:
5057: UPDATE fem_hier_definitions
5058: SET flattened_rows_completion_code = 'COMPLETE'
5059: WHERE hierarchy_obj_def_id = p_hier_version_id;
5060:
5061: commit;

Line 5148: DELETE FROM fem_hier_definitions

5144: IF p_hier_version_id is NULL THEN
5145:
5146: FOR obj_def_rec IN obj_def_csr (p_object_id => p_hier_obj_id) LOOP
5147:
5148: DELETE FROM fem_hier_definitions
5149: WHERE hierarchy_obj_def_id = obj_def_rec.object_definition_id;
5150:
5151: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
5152:

Line 5223: DELETE FROM fem_hier_definitions

5219: execute immediate l_sql_stmt;
5220:
5221: END IF; -- p_hier_table_name = 'FEM_COST_OBJECTS_HIER'
5222:
5223: DELETE FROM fem_hier_definitions
5224: WHERE hierarchy_obj_def_id = p_hier_version_id;
5225:
5226: FEM_BUSINESS_RULE_PVT.DeleteObjectDefinition
5227: (p_object_type_code => 'HIERARCHY',

Line 8952: UPDATE fem_hier_definitions

8948: END IF;
8949:
8950: END LOOP;
8951:
8952: UPDATE fem_hier_definitions
8953: SET flattened_rows_completion_code = 'COMPLETED'
8954: WHERE hierarchy_obj_def_id IN
8955: (SELECT object_definition_id
8956: FROM fem_object_definition_b