APPS.FEM_OBJECT_CATALOG_UTIL_PKG dependencies on FEM_USER_FOLDERS

Line 163: FROM fem_user_folders

159: -- validate that the Folder ID exists and that
160: -- the user can write to the folder
161: SELECT count(*)
162: INTO v_count
163: FROM fem_user_folders
164: WHERE user_id = pc_user_id
165: AND folder_id = p_folder_id
166: AND write_flag = 'Y';
167:

Line 486: FROM fem_object_catalog_b o, fem_user_folders f

482: -- and, either, the user object is not read only, or,
483: -- the user created the object
484: SELECT count(*)
485: INTO v_count
486: FROM fem_object_catalog_b o, fem_user_folders f
487: WHERE o.object_id = p_object_id
488: AND (o.object_access_code = 'W' OR o.created_by = pc_user_id)
489: AND o.folder_id = f.folder_id
490: AND f.user_id = pc_user_id

Line 775: FROM fem_object_catalog_b o, fem_user_folders f

771: -- folder, and either the object is not read only, or the
772: -- user is the creator of the object.
773: SELECT count(*)
774: INTO v_count
775: FROM fem_object_catalog_b o, fem_user_folders f
776: WHERE o.object_id = p_object_id
777: AND (o.object_access_code = 'W' OR o.created_by = pc_user_id)
778: AND o.folder_id = f.folder_id
779: AND f.user_id = pc_user_id