  TMS_UNIVERS  ,  
      
,     .
  TMS_UNIVERS_TRLOCK,  
 UNIVLOCK_CHECKTIP    .

  TMS_AFX, TMS_MPT, TMS_MUNC, TMS_ORG  
 ,   TMS_UNIVERS  ,
  ,    .  
  UNIVLOCK_CHECKCOD,   
  TIP  GR1     
UNIVLOCK_CHECKTIP.   ,    
  TIP  GR1,   
  .

      :
1.     ?
2.  ,       ?

    .
  TMS_UNIVLOCK,   -  :

TIP	VARCHAR2(1)
GR1	VARCHAR2(5)
PERSON	VARCHAR2(50)

       
-   Univers -   
TIP  GR1    TIP ( GR1 ).
 PERSON    ,
     .

     TMS_UNIVLOCK_TR,
      
  .    -
        .


     .
   XUNIVUNLOCK,   -  :

TIP	VARCHAR2(1)
GR1	VARCHAR2(5)

      ,  
     
 - .     
      ,
    . , 
   ,     
  RunSQL,      :

BEGIN
INSERT INTO VUNIVUNLOCK (TIP,GR1) VALUES ('O','R');
END;

         
 (  ).  ,  
    XUNIVUNLOCK,    VUNIVUNLOCK.
      ,  
   RunSQL     (F5)

