Get_Status

Retrieves the record state. The state may be New_Record, Removed_Record, Modified_Record or Queried_Record.

FUNCTION Get_Status (   
   record_ IN type_record_ ) RETURN type_status_

Parameters

record_
Foundation1 record.

Return

Record state.

Example

DECLARE  
   status_ type_status_;  
BEGIN  
   ...  
   status_ := Plsqlap_Record_API.Get_Status(AM);  
   IF ( status_ = Plsqlap_Record_API.New_record_ ) THEN  
      -- Record state is New_Record  
   ELSIF ( status_ = Plsqlap_Record_API.Modified_record_ ) THEN  
      -- Record state is Modified_Record  
   ELSIF ( status_ = Plsqlap_Record_API.Removed_record_ ) THEN  
      -- Record state is Removed_Record  
   ELSIF ( status_ = Plsqlap_Record_API.Queried_record_ ) THEN  
      -- Record state is Querid_Record  
   ELSE  
      NULL;  
   END IF;  
   ...  
END;