DBA Data[Home] [Help]

APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_OBJECT_CATALOG_B

Line 38: t_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

34: --------------------------------------------------------------------------------
35: -- VARIABLE TYPE DEFINITIONS
36: --------------------------------------------------------------------------------
37: t_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
38: t_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
39: t_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
40: t_folder_id FEM_OBJECT_CATALOG_B.folder_id%TYPE;
41: t_object_definition_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
42: t_approval_status_code FEM_OBJECT_DEFINITION_B.approval_status_code%TYPE;

Line 40: t_folder_id FEM_OBJECT_CATALOG_B.folder_id%TYPE;

36: --------------------------------------------------------------------------------
37: t_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
38: t_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
39: t_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
40: t_folder_id FEM_OBJECT_CATALOG_B.folder_id%TYPE;
41: t_object_definition_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
42: t_approval_status_code FEM_OBJECT_DEFINITION_B.approval_status_code%TYPE;
43:
44: t_request_id FEM_WF_REQUESTS.wf_request_id%TYPE;

Line 4395: ,fem_object_catalog_b obj

4391: into l_count
4392: from fem_wf_requests req
4393: ,fem_wf_req_object_defs req_def
4394: ,fem_object_definition_b def
4395: ,fem_object_catalog_b obj
4396: ,fem_object_types typ
4397: where req.wf_request_id = p_request_id
4398: and req.wf_request_item_code = p_request_item_code
4399: and req.wf_request_type_code = p_request_type_code