APPS.FEM_OBJECT_CATALOG_UTIL_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 476: FROM fem_object_catalog_b

472:
473: -- Bug 4309949: ignore folder security for Undo objects
474: SELECT object_type_code
475: INTO v_object_type_code
476: FROM fem_object_catalog_b
477: WHERE object_id = p_object_id;
478:
479: IF v_object_type_code <> 'UNDO' THEN
480: -- Validate that the user can write to the object

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 513: FROM fem_object_types t, fem_object_catalog_b o

509: FROM dual;
510:
511: SELECT DECODE(t.workflow_enabled_flag,'Y','NEW','NOT_APPLICABLE')
512: INTO v_approval_status_code
513: FROM fem_object_types t, fem_object_catalog_b o
514: WHERE o.object_id = p_object_id
515: AND o.object_type_code = t.object_type_code;
516:
517:

Line 765: FROM fem_object_catalog_b

761:
762: -- Bug 4309949: ignore folder security for Undo objects
763: SELECT object_type_code
764: INTO v_object_type_code
765: FROM fem_object_catalog_b
766: WHERE object_id = p_object_id;
767:
768: IF v_object_type_code <> 'UNDO' THEN
769: -- Validate that the user can write to the Folder

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

Line 816: DELETE fem_object_catalog_b

812:
813: DELETE fem_object_catalog_tl
814: WHERE object_id = p_object_id;
815:
816: DELETE fem_object_catalog_b
817: WHERE object_id = p_object_id;
818:
819: fem_engines_pkg.put_message(p_app_name =>'FEM',
820: p_msg_name => 'FEM_DELETED_OBJ_TXT',p_token1 => 'OBJECT_NAME',