REM############################################################################
REM
REM Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.
REM
REM
REM PRODUCT
REM     Oracle Enterprise Manager
REM
REM THIS FILE IS MACHINE GENERATED. DO NOT EDIT!
REM
REM DEPLOYMENT PROCEDURE SQL FOR DEPLOYMENT PROCEDURE : 
REM
REM#############################################################################

BEGIN
  DECLARE
    l_dp_version MGMT_PAF_PROCEDURES.VERSION%TYPE;
    l_data_guid MGMT_PAF_TEXTUAL_DATA.DATA_GUID%TYPE;
    l_guid MGMT_PAF_PROCEDURES.PROCEDURE_GUID%TYPE;
  BEGIN

    l_guid := 'FB972B99D567776EE029938B97332295';
    SELECT version INTO l_dp_version
    FROM MGMT_PAF_PROCEDURES
    WHERE PROCEDURE_GUID = l_guid;
  EXCEPTION WHEN NO_DATA_FOUND THEN

    SELECT SYS_GUID() into l_data_guid from dual;

    INSERT INTO MGMT_PAF_TEXTUAL_DATA
    ( DATA_GUID , DATA_SIZE , ENCODING 
, DATA0)
    VALUES(
      l_data_guid,
      0,
      'Base64',
-- data0
'UEsDBBQACAAIAEs9Ez8AAAAAAAAAAAAAAAABAAAAetVXbW+bSBD+Kwhd5VZqjYPj2FS2Kwyk9gkbxEt69w
mtYRtzByzaXTuNTvnv3cUYQ2qi2JcPd18SdnZ45mHmmdn1+MuPNBF2EJMYZcJE6Fx1ex0BZiGK4uyeG3zv
9tOo82U6zjEKYbTF8OA+EZmzKIQYAgqj2eNEtBxVMw1RgBgjvEQRnIjk7zgXBfqYs+eZbZiCjdEu5q8zfF
G438bRRLydKUN5pij64GY4HN4YRk9WlP6IWft9WVYGopAAQv084oFY2P5Vf3hzrVzL7EkUIkhCHOe0oMRj
BLphm9afwZ5O4Fq33jfVMZjZ1UQhAyl80U8UWE4yMhE3lOafJenh4aGLMAgT2A1RKuXgu5TXPkKN2CPCfy
xNcTreQBBBXMZgnt0cpOI0X+NtNpb2m8+cCAX3HIVlUZy+g2kUYIToO8lYumwHtrzFizGHSU4gZfDgewDW
aEuDdQ6ToE6u7XXGjGwjJE7536NTBMMEYMBTSaZjCvA9pGZMaFnADSK0KHgEMxqDxCutKXxWBU91vhpeYC
5cL7Dnqmsc0s4JzhkKYbnaARyDdQKbkX6tpusvPI1hNOrHgdxtTENAIH9PlKZjqYYoHSHZovldhMKc/cuZ
JUlgYm8YhrD3Z1X/7R8mM9CtmD5VKlWVQW9kDK6vR6OerGtGr98bDEeactNT5MGV/CwHuh24nvq1Sbsymj
Mul5IJk1WOMpZTl62FasW5MOF9Zrx8Z3WLUWoDunm/N4YoCwF939EO3kSyCpEKNUvRcTrME/TIal9tSJ2P
naiwdv8CuPPh6QP7yCjGMKTxDraE7egHhypSzbKPdFhLGsofj8sOx4c/YLilUD+GoXjLhYO0BILMzw+GX7
KtnJPt31XndMb5xj7r6zgrplvpcCDUXalLI9DSyIwzeAcw6c646mzVm4vCDiRb5nxsUC641wNxHTeASpXx
7ocmCgtpPp2FqVlL21oZKy/gWxXwsa5FSzSkxdal4qSG+KdjjJKERb2gFdTXFacctcUweF6fxl6jMdpo7R
+79SFwktzsQnLyC+zky/u2pF05rliMt++9WtO/WQtqZyXS9Qy7pcjF1pltWJ7Pc6sm84YG9imZs3PovBay
HUszXLfZQBVyceEhpCjSRbB3huMurFUr8t3+HnUeuG4t1cWqhXKEUhBn5zP+Tw+6AlPVl+yrfddwTn85l4
EapXHmE4iz8xNQ8Hasu4VuOIHvmKcjFJdXdlPycXIBfqseOHS7GKpju54JW3Xdb5ajv5AJGxDygHD09OJB
UB+xreZ/cVXSXzc5WIOrK98+fUA0NxsnRDU5ixH89nO0GIxvNkaN85Jxao429v4H9xmpUaH2G8jRfvidOf
0JUEsHCHxaPH/4AwAAnQ4AAFBLAQIUABQACAAIAEs9Ez98Wjx/+AMAAJ0OAAABAAAAAAAAAAAAAAAAAAAA
AAB6UEsFBgAAAAABAAEALwAAACcEAAAAAA=='
      );

    UPDATE MGMT_PAF_TEXTUAL_DATA
    SET DATA_SIZE = 1530
    WHERE DATA_GUID = l_data_guid;

    INSERT INTO MGMT_PAF_PROCEDURES
    ( PROCEDURE_GUID ,
      BASE_GUID, 
      VERSION,
      APPLICATION_NAME,
      NAME,
      DESCRIPTION,
      LAST_UPDATED,
      CREATED_BY,
      IS_ORACLE,
      HELPSET,
      DATA_GUID
    ) VALUES ( 
      l_guid,
      l_guid,
      '1.0',
      'BPEL Provisioning',
      'BPEL_DEPLOY_ORACLE_SOFTWARE',
      'BPEL_DEPLOY_ORACLE_SOFTWARE_DESC',
     to_timestamp('2011-08-19 07:42:22.131', 'yyyy-mm-dd hh24:mi:ss.ff'),
      'ORACLE',
      'Y',
      'paf_about_bpel_provisioning',
      l_data_guid
     );

    COMMIT;
  END;
END;
/