DBA Data[Home] [Help]

APPS.FEM_BR_CONDITION_DIMENSION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
--------------------------------------------------------------------------------
IS

  l_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';
Line: 54

     SELECT object_type_code
     FROM fem_object_catalog_b
     WHERE object_id = (SELECT object_id
                        FROM fem_object_definition_b
                        WHERE object_definition_id = p_obj_def_id);
Line: 71

     delete from fem_cond_dim_cmp_dtl
     where cond_dim_cmp_obj_def_id = p_obj_def_id;
Line: 74

     delete from fem_cond_dim_components
     where cond_dim_cmp_obj_def_id = p_obj_def_id;
Line: 109

END DeleteObjectDefinition;