APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_OBJECT_CATALOG_VL

Line 101: ,fem_object_catalog_vl obj

97: ,typ.view_only_oa_function_name
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

Line 131: ,fem_object_catalog_vl obj

127: ,fol.folder_name
128: ,def.effective_start_date
129: ,def.effective_end_date
130: from fem_object_definition_vl def
131: ,fem_object_catalog_vl obj
132: ,fem_folders_vl fol
133: where def.object_id = obj.object_id
134: and fol.folder_id = obj.folder_id
135: and def.old_approved_copy_flag = G_CURRENT_COPY

Line 1839: -- FEM_OBJECT_CATALOG_VL. That record must already exist.

1835: -- Duplicates only the detail records of a Business Rule (source) into
1836: -- another empty Business Rule (target). It does not duplicate any of the
1837: -- Business Rule Definition records.
1838: -- NOTE: It does not copy the Business Rule record in
1839: -- FEM_OBJECT_CATALOG_VL. That record must already exist.
1840: --
1841: -- IN
1842: -- p_api_version - API Version
1843: -- p_init_msg_list - Initialize Message List Flag (Boolean)

Line 2189: from fem_object_catalog_vl obj

2185: select obj.object_id
2186: ,typ.object_type_name
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)

Line 2328: ,fem_object_catalog_vl obj

2324: ,def.display_name as obj_def_name
2325: ,def.object_id
2326: ,obj.object_name
2327: from fem_object_definition_vl def
2328: ,fem_object_catalog_vl obj
2329: where upper(def.display_name) = upper(p_obj_def_name)
2330: and def.object_id = p_obj_id
2331: and def.old_approved_copy_flag = G_CURRENT_COPY
2332: and def.object_definition_id <> nvl(p_obj_def_id,-1)

Line 3761: -- Creates a new Object by copying records in the FEM_OBJECT_CATALOG_VL

3757: -- PROCEDURE
3758: -- CopyObjectRec
3759: --
3760: -- DESCRIPTION
3761: -- Creates a new Object by copying records in the FEM_OBJECT_CATALOG_VL
3762: -- table.
3763: --
3764: -- IN
3765: -- p_source_obj_id - Source Object ID

Line 3786: l_obj_vl_rec fem_object_catalog_vl%ROWTYPE;

3782: IS
3783:
3784: l_api_name constant varchar2(30) := 'CopyObjectRec';
3785:
3786: l_obj_vl_rec fem_object_catalog_vl%ROWTYPE;
3787: l_rowid rowid;
3788:
3789: BEGIN
3790:

Line 3819: from fem_object_catalog_vl

3815: ,l_obj_vl_rec.last_update_date
3816: ,l_obj_vl_rec.last_updated_by
3817: ,l_obj_vl_rec.last_update_login
3818: ,l_obj_vl_rec.object_version_number
3819: from fem_object_catalog_vl
3820: where object_id = p_source_obj_id;
3821:
3822: FEM_OBJECT_CATALOG_PKG.Insert_Row (
3823: x_rowid => l_rowid

Line 4065: -- FEM_OBJECT_CATALOG_VL table.

4061: -- DeleteObjectRec
4062: --
4063: -- DESCRIPTION
4064: -- Deletes an Object by performing deletes on records in the
4065: -- FEM_OBJECT_CATALOG_VL table.
4066: --
4067: -- IN
4068: -- p_obj_id - Object ID
4069: --