DBA Data[Home] [Help]

APPS.FEM_RULE_SET_MANAGER dependencies on FEM_OBJECT_DEFINITION_B

Line 245: ,x_Object_Definition_ID OUT NOCOPY FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE

241:
242:
243: Procedure Get_ValidDefinition_Pub(p_Object_ID IN DEF_OBJECT_ID%TYPE
244: ,p_Rule_Effective_Date IN VARCHAR2
245: ,x_Object_Definition_ID OUT NOCOPY FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE
246: ,x_Err_Code OUT NOCOPY NUMBER
247: ,x_Err_Msg OUT NOCOPY VARCHAR2) IS
248: l_Rule_Effective_Date DATE;
249: l_Approval_Status_Code DEF_APPROVAL_STATUS_CODE%TYPE;

Line 397: ,fem_object_definition_b od

393:
394: Cursor getObjectID(p_Obj_Def_ID IN DEF_OBJECT_DEFINITION_ID%TYPE) IS
395: SELECT o.object_id
396: from fem_object_catalog_b o
397: ,fem_object_definition_b od
398: where o.object_id = od.object_id
399: and od.object_definition_id = p_Obj_Def_ID;
400:
401: Begin

Line 2088: ,FEM_OBJECT_DEFINITION_B rsm_d

2084: from
2085: FEM_RULE_SET_MEMBERS rsm
2086: ,FEM_RULE_SETS rs
2087: ,FEM_OBJECT_CATALOG_VL cm_o
2088: ,FEM_OBJECT_DEFINITION_B rsm_d
2089: ,FEM_FOLDERS_VL cm_f
2090: where
2091: rsm.RULE_SET_OBJ_DEF_ID = rsm_d.OBJECT_DEFINITION_ID
2092: and rsm_d.OBJECT_ID = p_Curr_RuleSet_Object_ID