APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_OBJECT_DEFINITION_VL

Line 100: ,fem_object_definition_vl def

96: ,fol.folder_name
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

Line 130: from fem_object_definition_vl def

126: ,obj.object_name
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

Line 798: -- FEM_OBJECT_DEFINITION_VL. That record must already exist.

794: -- DESCRIPTION
795: -- Duplicates all the detail records of a Business Rule Definition (source)
796: -- into another empty Business Rule Definition (target).
797: -- NOTE: It does not copy the Business Rule Definition record in
798: -- FEM_OBJECT_DEFINITION_VL. That record must already exist.
799: --
800: -- IN
801: -- p_api_version - API Version
802: -- p_init_msg_list - Initialize Message List Flag (Boolean)

Line 2327: from fem_object_definition_vl def

2323: select def.object_definition_id as obj_def_id
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

Line 3386: -- p_is_full_copy - Is Full Copy (include FEM_OBJECT_DEFINITION_VL)

3382: -- p_object_type_code - Object Type Code
3383: -- p_source_obj_def_id - Source Object Definition ID
3384: -- p_target_obj_def_id - Target Object Definition ID
3385: -- p_target_copy_flag - Target's Old Approved Copy Flag value
3386: -- p_is_full_copy - Is Full Copy (include FEM_OBJECT_DEFINITION_VL)
3387: -- p_is_new_copy - Is New Copy (indicates new info in WHO columns)
3388: --
3389: --------------------------------------------------------------------------------
3390: PROCEDURE CopyObjectDefinitionInternal (

Line 3849: -- FEM_OBJECT_DEFINITION_VL table.

3845: -- CopyObjectDefinitionRec
3846: --
3847: -- DESCRIPTION
3848: -- Creates a new Object Definition by copying records in the
3849: -- FEM_OBJECT_DEFINITION_VL table.
3850: --
3851: -- IN
3852: -- p_source_obj_def_id - Source Object Definition ID
3853: -- p_target_obj_def_id - Target Object Definition ID

Line 3877: l_obj_def_vl_rec fem_object_definition_vl%ROWTYPE;

3873: IS
3874:
3875: l_api_name constant varchar2(30) := 'CopyObjectDefinitionRec';
3876:
3877: l_obj_def_vl_rec fem_object_definition_vl%ROWTYPE;
3878: l_rowid rowid;
3879:
3880: BEGIN
3881:

Line 3921: from fem_object_definition_vl

3917: ,l_obj_def_vl_rec.last_update_date
3918: ,l_obj_def_vl_rec.last_updated_by
3919: ,l_obj_def_vl_rec.last_update_login
3920: ,l_obj_def_vl_rec.object_version_number
3921: from fem_object_definition_vl
3922: where object_definition_id = p_source_obj_def_id;
3923:
3924: FEM_OBJECT_DEFINITION_PKG.Insert_Row (
3925: x_rowid => l_rowid