APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_OBJECT_TYPES

Line 37: t_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

33:
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;

Line 50: t_plsql_pkg_name FEM_OBJECT_TYPES.object_plsql_pkg_name%TYPE;

46:
47: t_code FND_LOOKUP_VALUES.lookup_code%TYPE;
48: t_meaning FND_LOOKUP_VALUES.meaning%TYPE;
49:
50: t_plsql_pkg_name FEM_OBJECT_TYPES.object_plsql_pkg_name%TYPE;
51:
52: t_return_status varchar2(1);
53: t_msg_count number;
54: t_msg_data varchar2(2000);

Line 102: ,fem_object_types_vl typ

98: from fem_wf_requests req
99: ,fem_wf_req_object_defs req_def
100: ,fem_object_definition_vl def
101: ,fem_object_catalog_vl obj
102: ,fem_object_types_vl typ
103: ,fem_folders_vl fol
104: where req.wf_request_id = p_request_id
105: and req.wf_request_item_code = p_request_item_code
106: and req.wf_request_type_code = p_request_type_code

Line 2191: ,fem_object_types_vl typ

2187: , f.folder_name
2188: , obj.object_name
2189: from fem_object_catalog_vl obj
2190: ,fem_folders_vl f
2191: ,fem_object_types_vl typ
2192: where upper(obj.object_name) = upper(p_obj_name)
2193: and obj.object_id <> nvl(p_obj_id,-1)
2194: and f.folder_id = obj.folder_id
2195: and typ.object_type_code = obj.object_type_code;

Line 2545: ,fem_object_types_b rs_type

2541:
2542: select rs_type.isetup_import_export_flag
2543: into l_isetup_import_export_flag
2544: from fem_rule_sets rs
2545: ,fem_object_types_b rs_type
2546: where rs.rule_set_obj_def_id = p_ruleset_obj_def_id
2547: and rs_type.object_type_code = rs.rule_set_object_type_code;
2548:
2549: return l_isetup_import_export_flag;

Line 3341: from fem_object_types

3337: ,p_msg_text => 'BEGIN, p_object_type_code:' || p_object_type_code
3338: );
3339: select object_plsql_pkg_name
3340: into l_package_name
3341: from fem_object_types
3342: where object_type_code = p_object_type_code;
3343:
3344: FEM_ENGINES_PKG.Tech_Message (
3345: p_severity => G_LOG_LEVEL_3

Line 4396: ,fem_object_types typ

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
4400: and req_def.wf_request_id = req.wf_request_id