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_HIER_UTILS_PVT dependencies on FEM_OBJECT_DEFINITION_B

Line 2559: FROM fem_object_definition_b

2555:
2556: CURSOR l_hier_ver_detail_csr (c_version_id IN NUMBER)
2557: IS
2558: SELECT effective_start_date
2559: FROM fem_object_definition_b
2560: WHERE object_definition_id = c_version_id;
2561:
2562: BEGIN
2563:

Line 4108: FROM fem_object_definition_b

4104: elsif p_hier_table_name = 'FEM_COST_OBJECTS_HIER' then
4105:
4106: SELECT effective_start_date
4107: INTO l_version_start_date
4108: FROM fem_object_definition_b
4109: WHERE object_definition_id = p_src_hier_version_id ;
4110:
4111: SELECT fcoh.rowid,
4112: fem_cost_objects_hier_s.NEXTVAL,

Line 4735: fem_object_definition_b objDef

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:
4739:

Line 4777: fem_object_definition_b objDef

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:
4781: SELECT WRITE_FLAG

Line 5112: FROM fem_object_definition_b

5108: child_sequence_num
5109: FROM fem_cost_objects_hier
5110: WHERE hierarchy_obj_id = c_hierarchy_id
5111: AND (SELECT effective_start_date
5112: FROM fem_object_definition_b
5113: WHERE object_definition_id = c_version_id) BETWEEN
5114: effective_start_date AND effective_end_date;
5115:
5116: l_sql_stmt VARCHAR2(2000);

Line 7604: FROM fem_object_definition_b

7600: CURSOR l_hier_ver_details_csr (c_version_id IN NUMBER)
7601: IS
7602: SELECT effective_start_date,
7603: effective_end_date
7604: FROM fem_object_definition_b
7605: WHERE object_definition_id = c_version_id;
7606:
7607: -- WIP - May have to change the logic to find
7608: -- if there is only one version so far.

Line 7612: FROM fem_object_definition_b

7608: -- if there is only one version so far.
7609: CURSOR l_is_first_version_csr (c_hierarchy_id IN NUMBER)
7610: IS
7611: SELECT COUNT(*)
7612: FROM fem_object_definition_b
7613: WHERE object_id = c_hierarchy_id;
7614:
7615: CURSOR l_is_prior_version_csr (c_hierarchy_id IN NUMBER,
7616: c_version_id IN NUMBER)

Line 7620: FROM fem_object_definition_b a,

7616: c_version_id IN NUMBER)
7617: IS
7618: SELECT 'Y' FROM dual
7619: WHERE EXISTS( SELECT 1
7620: FROM fem_object_definition_b a,
7621: fem_object_definition_b b
7622: WHERE a.object_id = b.object_id
7623: AND a.object_id = c_hierarchy_id
7624: AND b.object_definition_id = c_version_id

Line 7621: fem_object_definition_b b

7617: IS
7618: SELECT 'Y' FROM dual
7619: WHERE EXISTS( SELECT 1
7620: FROM fem_object_definition_b a,
7621: fem_object_definition_b b
7622: WHERE a.object_id = b.object_id
7623: AND a.object_id = c_hierarchy_id
7624: AND b.object_definition_id = c_version_id
7625: AND a.effective_start_date > b.effective_end_date);

Line 8039: FROM fem_object_definition_b

8035: c_eff_start_date IN DATE)
8036: IS
8037: SELECT 'Y' FROM dual
8038: WHERE EXISTS( SELECT 1
8039: FROM fem_object_definition_b
8040: WHERE object_id = c_hierarchy_id
8041: AND effective_start_date < c_eff_start_date);
8042:
8043: CURSOR l_later_version_exists_csr(c_hierarchy_id IN NUMBER,

Line 8055: FROM fem_object_definition_b

8051:
8052: CURSOR l_version_details_csr (c_version_id IN NUMBER)
8053: IS
8054: SELECT effective_start_date, effective_end_date
8055: FROM fem_object_definition_b
8056: WHERE object_definition_id = c_version_id;
8057:
8058: CURSOR l_all_children_csr (c_hierarchy_id IN NUMBER,
8059: c_parent_id IN NUMBER)

Line 8439: FROM fem_object_definition_b

8435:
8436: CURSOR l_version_csr (c_version_id IN NUMBER)
8437: IS
8438: SELECT effective_start_date
8439: FROM fem_object_definition_b
8440: WHERE object_definition_id = c_version_id;
8441:
8442: CURSOR l_relation_csr (c_hierarchy_id IN NUMBER,
8443: c_parent_id IN NUMBER,

Line 8903: FROM fem_object_definition_b

8899:
8900: CURSOR l_hier_version_csr (c_hierarchy_id IN NUMBER)
8901: IS
8902: SELECT object_definition_id
8903: FROM fem_object_definition_b
8904: WHERE object_id = c_hierarchy_id;
8905:
8906: l_api_name CONSTANT VARCHAR2(30) := 'Flatten_Whole_Hierarchy' ;
8907: l_api_version CONSTANT NUMBER := 1.0;

Line 8956: FROM fem_object_definition_b

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
8957: WHERE object_id = p_hierarchy_id);
8958:
8959: IF FND_API.To_Boolean(p_commit) THEN
8960: COMMIT WORK;

Line 9148: ' FROM FEM_OBJECT_DEFINITION_B WHERE OBJECT_ID = :1) ' ||

9144:
9145: l_access_sql := ' SELECT COUNT(*) FROM DUAL WHERE EXISTS ' ||
9146: ' (SELECT 1 FROM ' || p_hier_table || ' WHERE ' ||
9147: ' HIERARCHY_OBJ_DEF_ID IN (SELECT OBJECT_DEFINITION_ID ' ||
9148: ' FROM FEM_OBJECT_DEFINITION_B WHERE OBJECT_ID = :1) ' ||
9149: ' AND CHILD_VALUE_SET_ID = :2) ';
9150: EXECUTE IMMEDIATE l_access_sql INTO l_result USING p_hierarchy_id, p_value_set_id;
9151: IF l_result <> 0 THEN
9152: RETURN 'N';