APPS.FEM_OBJECT_CATALOG_UTIL_PKG dependencies on FEM_OBJECT_TYPES

Line 116: FROM fem_object_types_b

112:
113: /* Validate that the Object Type exists */
114: SELECT count(*)
115: INTO v_count
116: FROM fem_object_types_b
117: WHERE object_type_code = p_object_type_code;
118:
119: IF v_count = 0 THEN
120: RAISE e_invalid_object_type;

Line 426: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

422: v_date_range_is_valid VARCHAR2(1);
423: v_rowid VARCHAR2(100);
424: v_approval_status_code VARCHAR2(30);
425: v_count NUMBER;
426: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
427:
428: /* ==========================================================================
429: ** This procedure creates a new Object Definition for the specified Object ID.
430: ** It calls validate_obj_def_effdate to verify that the Start Date and

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 738: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

734: c_api_name CONSTANT VARCHAR2(30) := 'delete_object';
735: c_api_version CONSTANT NUMBER := 1.0;
736: v_can_delete_object VARCHAR2(1);
737: v_count NUMBER;
738: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
739: v_object_name VARCHAR2(150);
740:
741: BEGIN
742: