Audit package details in using Stored procedure

Where [dbo].[PDV_Insert_PDV_Audit_Package] =Name of the SP

      PDV_Audit_Package is Table name where we are storing audit details.

Create Procedure [dbo].[PDV_Insert_PDV_Audit_Package]

(

      @ParentPackageID UniqueIdentifier, 

      @ParentPackageName NVarchar(50),   

      @PackageID UniqueIdentifier,

      @PackageName NVarchar(50),

      @Host NVarchar(50),

      @ExecutionStatus Varchar(20),

      @ExecutionID Varchar(14)

) As

Begin

      Set NoCount On

     

      Insert PDV_Audit_Package

            (

                  ParentPackageID,

                  ParentPackageName,

                  PackageID,

                  PackageName,

                  Host,

                  ExecutionStatus,

                  ExecutionID,

                  PackageExecutionTime

            )

      Values

            (

                  @ParentPackageID,

                  @ParentPackageName,

                  @PackageID,

                  @PackageName,

                  @Host,

                  @ExecutionStatus,

                  @ExecutionID,

                  GETDATE())

End