APPS.FEM_BR_MAP_PREVIEW_PVT SQL Statements

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

Line: 15

PROCEDURE DeleteMappingPreviewRec(
  p_obj_def_id          IN          NUMBER
);

Line: 19

PROCEDURE DeletePreviewResults(
  p_obj_def_id          IN          NUMBER
);

Line: 39

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          IN          NUMBER
)
-------------------------------------------------------------------------------
IS

  g_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';

Line: 49

  DeletePreviewResults(
    p_obj_def_id     => p_obj_def_id
  );

Line: 53

  DeleteMappingPreviewRec(
    p_obj_def_id     => p_obj_def_id
  );

Line: 63

END DeleteObjectDefinition;

Line: 82

PROCEDURE DeleteMappingPreviewRec(
  p_obj_def_id IN NUMBER
)
-------------------------------------------------------------------------------
IS
BEGIN

  DELETE FROM fem_alloc_previews
  WHERE preview_obj_def_id = p_obj_def_id;

Line: 92

END DeleteMappingPreviewRec;

Line: 106

PROCEDURE DeletePreviewResults(
  p_obj_def_id IN NUMBER
)
-------------------------------------------------------------------------------
IS
    v_return_status VARCHAR2(1);

Line: 133

END DeletePreviewResults;