DBA Data[Home] [Help]

APPS.FF_DEL_GLOBAL_PKG SQL Statements

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

Line: 12

    Package used to support delete operations on ff_globals_f.
  Notes

  History
    04-04-2001 K.Kawol     115.0        Date created.

 ============================================================================*/
 TYPE tab_globalid_type IS TABLE OF ff_globals_f.global_id%TYPE
      INDEX BY BINARY_INTEGER;
Line: 71

 PROCEDURE Delete_User_Entity IS
  l_globalid ff_globals_f.global_id%TYPE;
Line: 79

    select count(*)
      into no_of_global
      from ff_globals_f
     where global_id = l_globalid;
Line: 85

      delete from ff_user_entities
      where creator_id = l_globalid
      and creator_type = 'S';
Line: 92

 END Delete_User_Entity;