APPS.FEM_HIER_UTILS_PVT dependencies on FEM_OBJECT_DEFINITION_VL

Line 73: from fem_hierarchies fh, fem_object_definition_vl fod

69:
70: Cursor l_hier_csr is
71: Select fh.flattened_rows_flag,
72: fod.display_name
73: from fem_hierarchies fh, fem_object_definition_vl fod
74: where fod.object_definition_id = p_hier_obj_defn_id
75: and fod.object_id = fh.hierarchy_obj_id;
76:
77:

Line 540: from fem_hierarchies fh, fem_object_definition_vl fod

536: For l_hier_csr_rec in
537: ( Select fh.flattened_rows_flag,
538: fh.dimension_id,
539: fod.display_name
540: from fem_hierarchies fh, fem_object_definition_vl fod
541: where fod.object_definition_id = p_hier_obj_defn_id
542: and fod.object_id = fh.hierarchy_obj_id)
543: Loop
544: l_flattened_rows_flag := l_hier_csr_rec.flattened_rows_flag;

Line 4375: l_object_definition_rec FEM_OBJECT_DEFINITION_VL%rowtype;

4371: l_last_update_login NUMBER := fnd_global.login_id;
4372:
4373: l_new_version_id NUMBER;
4374:
4375: l_object_definition_rec FEM_OBJECT_DEFINITION_VL%rowtype;
4376: l_row_id ROWID;
4377:
4378: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Hier_Version' ;
4379: l_api_version CONSTANT NUMBER := 1.0;

Line 4386: FROM fem_object_definition_vl

4382:
4383: CURSOR l_object_definition_csr (p_version_id IN NUMBER)
4384: IS
4385: SELECT *
4386: FROM fem_object_definition_vl
4387: WHERE object_definition_id = p_version_id;
4388:
4389: CURSOR l_dimension_detail_csr (c_hierarchy_id IN NUMBER)
4390: IS

Line 4835: from fem_object_definition_vl

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);
4837:
4838: delete_hierarchy (p_api_version => 1.0,
4839: p_return_status => l_return_status,

Line 4873: from fem_object_definition_vl

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);
4875:
4876: commit;
4877:

Line 4902: from fem_object_definition_vl

4898:
4899: cursor obj_def_csr (p_object_id IN NUMBER)
4900: is
4901: select object_definition_id
4902: from fem_object_definition_vl
4903: where object_id = p_object_id;
4904:
4905: l_sql_stmt VARCHAR2(2000);
4906: l_delete_allowed BOOLEAN;

Line 5088: FROM fem_object_definition_vl

5084:
5085: CURSOR obj_def_csr (p_object_id IN NUMBER)
5086: IS
5087: SELECT object_definition_id
5088: FROM fem_object_definition_vl
5089: WHERE object_id = p_object_id;
5090:
5091: CURSOR other_version_exists_csr (p_object_id IN NUMBER,
5092: p_version_id IN NUMBER)

Line 5098: fem_object_definition_vl ver

5094: SELECT 'Y' FROM dual
5095: WHERE EXISTs
5096: (SELECT 1
5097: FROM fem_object_catalog_vl obj,
5098: fem_object_definition_vl ver
5099: WHERE obj.object_id = ver.object_id
5100: AND ver.object_definition_id <> p_version_id
5101: AND ver.object_id = p_object_id);
5102:

Line 7439: ' FEM_OBJECT_DEFINITION_VL OD, '||

7435: l_stmt := l_stmt ||
7436: 'WHERE CO.COST_OBJECT_ID = :1 AND ' ||
7437: ' EXISTS (SELECT 1 ' ||
7438: ' FROM '||l_hierarchy_table_name||' H2, '||
7439: ' FEM_OBJECT_DEFINITION_VL OD, '||
7440: ' FEM_HIER_VALUE_SETS VS '||
7441: ' WHERE (H2.PARENT_ID = CO.COST_OBJECT_ID) AND '||
7442: ' H2.HIERARCHY_OBJ_ID = OD.OBJECT_ID AND '||
7443: ' OD.EFFECTIVE_START_DATE BETWEEN H2.EFFECTIVE_START_DATE AND H2.EFFECTIVE_END_DATE '||

Line 8048: FROM fem_object_definition_vl a

8044: c_eff_end_date IN DATE)
8045: IS
8046: SELECT 'Y' FROM dual
8047: WHERE EXISTS (SELECT 1
8048: FROM fem_object_definition_vl a
8049: WHERE object_id = c_hierarchy_id
8050: AND effective_end_date > c_eff_end_date);
8051:
8052: CURSOR l_version_details_csr (c_version_id IN NUMBER)