DBA Data[Home] [Help]

APPS.FEM_RULE_SET_MANAGER dependencies on FEM_OBJECT_DEFINITION_B

Line 67: DEF_OBJECT_DEFINITION_ID FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE;

63: DEF_OBJECT_DISPLAY_NAME FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
64: DEF_FOLDER_ID FEM_FOLDERS_B.FOLDER_ID%TYPE;
65: DEF_FOLDER_NAME FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
66:
67: DEF_OBJECT_DEFINITION_ID FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE;
68: DEF_APPROVAL_STATUS_CODE FEM_OBJECT_DEFINITION_B.APPROVAL_STATUS_CODE%TYPE;
69:
70: DEF_RULESET_OBJECT_TYPE_CODE FEM_RULE_SETS.RULE_SET_OBJECT_TYPE_CODE%TYPE;
71:

Line 68: DEF_APPROVAL_STATUS_CODE FEM_OBJECT_DEFINITION_B.APPROVAL_STATUS_CODE%TYPE;

64: DEF_FOLDER_ID FEM_FOLDERS_B.FOLDER_ID%TYPE;
65: DEF_FOLDER_NAME FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
66:
67: DEF_OBJECT_DEFINITION_ID FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE;
68: DEF_APPROVAL_STATUS_CODE FEM_OBJECT_DEFINITION_B.APPROVAL_STATUS_CODE%TYPE;
69:
70: DEF_RULESET_OBJECT_TYPE_CODE FEM_RULE_SETS.RULE_SET_OBJECT_TYPE_CODE%TYPE;
71:
72: DEF_CHILD_EXEC_SEQUENCE FEM_RULE_SET_MEMBERS.CHILD_EXECUTION_SEQUENCE%TYPE;

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

140: and a.OLD_APPROVED_COPY_FLAG = 'N';
141:
142: Procedure Get_ValidDefinition_Pub(p_Object_ID IN DEF_OBJECT_ID%TYPE
143: ,p_Rule_Effective_Date IN VARCHAR2
144: ,x_Object_Definition_ID OUT NOCOPY FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE
145: ,x_Err_Code OUT NOCOPY NUMBER
146: ,x_Err_Msg OUT NOCOPY VARCHAR2);
147:
148: Procedure Validate_Rule_Public(x_Err_Code OUT NOCOPY NUMBER