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 := '0089B8D9A98768A7E670896C665503C8';
    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, DATA1)
    VALUES(
      l_data_guid,
      0,
      'Base64',
-- data0
'UEsDBBQACAAIAKKaEz8AAAAAAAAAAAAAAAABAAAAeu1c63ObSBL/fn8Fxd5WvFVavWzJcsr2FgJkUZGEDp
CSfKKwGNvsIqB4+HFX/t+vZ3hIIIgAKXF2k1TFwsxMT/dM/7p7etq6/ON5bVKPyPUM26KuqHedZvsdhayV
rRvWPX6xUEa/D979cX3puPYK6YGL4u5XNHSmqZWLNB/pw5crWpQYdsJTrCjN4VERxBlNIde13amtoyva82
2HpvwXB565IfSdS+KSpu4DQ7+i2+3BxXDAXTAXg/P+gDnn++fwps/2+71e+5Qd0JSpef7C0fFkMPVp53TQ
7g/6vdPeBU3pyFu5huMTtoAsy3MLiVc5XmZVbsgBH5a2RttNM2bKR02wBJZ3RT/4vvO+1Xp6emrarrYyUX
Nlr1uOdtcC0R8NLDKsCaPDo+1+mk7o68sHpOnIjWh7gePYLnA3NzX/znbX9PVZv9HptBvdzlmje9roXcBT
t3EB/7vtwWUrHL1D5VaBFaKvMW8FfdB6GW4Bfd1pN7vNdvO0oCdw33Q04MS5dQOrqFPEL2e4aOXbroE8+t
o0rOD5tNsgn/2z8FM1fM0ygnXDs03NNTx4/+DAD83AXZ4MS7efPBgUPfXPioT0tXu8lqA69PWvaK2rrm37
v7b4qQwtqGCU7mzEbraLOqE7LTD9JQIOXPpaQjo11vwiyUGnx8h0POTDEml36spTdWQiH6krM/B85KoWqK
5qWL5rF25YtO0Rc14y6S/d5lmz22nIgcxHz+/lwPoXtf/f1Fi5tvcCHKy9X3rNwRe21wt0m77GPws63T3p
Cwm0FZCj3Woeaum3utXiiJgzkG4zTEcr2FYNo8i7vvQ19x75E8PzI8w+2J5P8K4jyzc0U9l6mwIgK8mqxI
9U5UaRCQZj+G01AHoeQYW0WxN5m0cKGPC8sPOf2qPWNDXrvin7LmhLTOSjKH1QOUFSJyJLt6qNXci8hJFf
dZw4HC1kllF4Tp0zsgwscFVJyGNGguF4CcZiyEFrawVam+U+ZOnBquYv/VbDj7r0eAn2Lv2X6Q5t20SaFR
PmhNFIxYLt5ygzUpDVmaioH4UZJ36U6wwvPfSQLdydFoRdCiyvsvxMkYTKWjBfDEFwjp8IsqIykwn5pbIQ
7GQhK7z0EbZVDYMOsrF11BLPrxJuRqIEiJnwJG6pSGUsAoGDqUj8lBFmwuxGTbiqvL6MpAjMpDYLjDxV5x
Ivw+7WGSrOIKZKQFZl9HDCsB9UcaGoNwuhMsI5RmGGjMyrwkxWmBlbb/EitUqpVC2TJTGYoTrqKLKSSvYQ
b566ZCaLyrMvOfnDoTTmkrDc4LQ+CWGu1qewFCRlwUwO5COmchAreFumgiSJx9mdiFTnmMS6hxID4y6yI1
llxzz7Acdp/1kI4DbrkukegRA2KQdSAXMkC3VGHehXMhTqmBGOx562snOcCWxdh1qLTWL3D1usLIk6bIwE
GM1/AknAdc4ZBcSZ4Wj7KHSAt6PQAUHL0/EQBPz+Fe27AdqoVfUgOI8OMFKe0G4UyNxAgKAqojoE2RbyuD
ouQwp4bGLfDyCxiWpr0MHHIsxDHa2TeVnGFhdOWzX0fj5hFAgYp1XHYSn5WTpSqWGgFEa64Ssvl/xZ5oZM
yWNPeqjCT+dqbGuIYVcxTCproAwx8gSn73C4V1L6DAmItcUlnzqOV5EElGUIHEyZGY4t5AUnqiDUnFibu8
Ba4dP4Np0oo+i9eGvNauq3OLe4tuHJac5d+5Elv0lobT8i/NNHnOF68WRu/IbFEgTOQZOwD2j1lxzotuxr
fpDMscq8LjuFTshvskmCZeAEhfFfxCHHhGlX8QwGtHDz2oQJ37Bdmzc5AuS149N+OrPl+ciBD1gdJ/ChG3
Io9Oy4yAvT2v/+X8jqyW+vNIUsrBJ6bD3DZPWIuei1B3zvrHvBtLscy7dP273zAXvRb190e51uNh8mTucL
BR9OBEXl5umUWKYtNkIOsGuayJw/aB6iwgyFh3nDabzmViKtBI/DfB5XtqUbfiQyrP97zdJPognS+YnXRv
Q6SXi84rVJCYmtr8wri7kqg0HeFjHdQgRM9kAnOWfjMdyF5LeYIxB6Ic1Grr2ea/7DyTsu7uC1RKIw1NYb
cqdAzbeS9a0oPd5ptluBZTy3ZOQHDgVsvCN7+4xWAQFWPGu4gLpNgLZwCleUzV9RBOuJtyIhdMAC3RoWuY
OJusQ8NsnFBbvWJ4aFlprrNZPYjWRSqEfNDFCiKPnpjVesYaUnIGfqySS0+Bv6oU4247xeNZqh7yaWN6a4
uQeoRGk7biQpAOyHN1xiLQJFX2n+ScLydg7stUFFS5V25VjBK7GRk6bcWaucTq+hfdqGwTdHxRK5xt0Lha
0/FXhY3MMRwpVDyNb1IOySb1g7sFnykjD6HLpYhoXzEHbYoM/slCMuN4WkfZ2r4GqTgyuPqexGFruYjL89
CXcWejwaduDhAeB+GkVhRhnPxJfwTBgE5JKU/5SeBY7b29ZpzEmkSxizCaOdvlj2yKS3Uq5rnyfbupcoId
OopEyhNcW0i21t3PpPcEhMu4SLz3PsP33WT5/102dFIOr89Flv67OY7t/QZ+0IcVpCiPkYwz6sT8KbAWyK
s5Fwk2SGSHtYpJRqfwNHxU8p1rbujPsgPEFTDGiE52uWT93ZLjVDTxSukvGqoQ/0CtbVZ+6RleQmvcBzkK
UrxhrZAbzt5azuWQVPl7msLuPt8N4yHKfyU5bZ3CZmPV9+r6peMOeWIQPb3R7VLHwde1CF/TCDGAq+y3rY
Wo3oFBhLSIW1WEVGyrZAdYj2J78VaT8bd0i0f+vNl7Wfi8qmIgxsBhJ1/5q4AwukxrV5XlSwRSXsCBaG4A
rV8XkdFgJp5vxsxLWH/cE5wOmMwOn8vHPe7p63c3JDlu2fFAPrt33QSrxebM5i0CQpXdxh294lHSoozw0o
3RF1MQ3sLM3ckoPKCIpxHZXLHhf+8mc5GwGHYeMmhZ9DMNHw5tZt0w5nqWCwEkdk5IZifEEVBhVXNLJW7o
vjI70SYXz5val6yXCbrYoJ456UDfmWDjUN7LCmmZrYK80EVD8CQ7b7crSgtlfWX+5eqpQH9WIOcMBQWIJB
EKXPu6je6VHVi+Vh8Ehe7KtikMTyGeajoxUeW40YxLOsmnKRM3EWnkvF2eQzEWJSDZCkNnKXt0zN5Bsf+b
Ku8HcDez/TpMb2GnlHw0r/W2Al8m+R3smFDjDp8B0p81dF4t9DFSNzjS8YTTgFHahx59/QOid1FkXGOelQ
M5X1VbUu7xSTUzCbqx31jvnpS9adrRuU3bpMqcFrcSoAloiZ4ZSqOFJwcXNONmCnyxskBHLjFzb8g5knzU
VHs8cXJS+utw4nRdmnKkeUCA64eKwIKrjte7GbWLH25BG+UDBfba68EvWSoHyrUxwpOiJlRkfIsMeFEAWV
TFEGPmt/1poVaGaYUd2TAWXKWpVCRd+n1tGI/drto2f/Gi/I5m08WOE/KZct0uGytZHu7YxQVBn1VaxQ2f
IZ2z0psPiN4xunr+LM/zFm6qiHrj1x6cav/whHJPa7AgPHRxe9eaeouOmI56ejKehbHqS+S4XNiSKPdMTi
fhjz/fbaW/ZA9mZhAr7BTinZGGmm/3CgivE1ykE3KhEVAGztzq5W5PT5Tl3vwbpRdFgvrkvI1sefZAJ8Mn
06vC+qn4kb8v9O+bVMDUPZGjVykge471wuJw3lasErVdANCwrF9te0hDmIXKYzTemCuj/tW7Jl8MnllnEA
7xIvj2ncI/xeg1S1AWuD6OTPBfYL16lZlp3mI11CEr/OQsCzNMd7sH3ybS2xquNvZFBX2+zvYice+AHeJg
NXgesiyyd4iFasGAmb9/F38lz/H1BLBwjcPYg3QAsAAMlHAABQSwECFAAUAAgACACimhM/3D2IN0ALAADJ
RwAAAQAAAAAAAAAA',
-- data1
'AAAAAAAAAAAAelBLBQYAAAAAAQABAC8AAABvCwAAAAA='
      );

    UPDATE MGMT_PAF_TEXTUAL_DATA
    SET DATA_SIZE = 4044
    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',
      'DBRACPROV',
      'PROCEDURE_NAME_DBDN',
      'PROCEDURE_DESC_DBDN',
     to_timestamp('2011-08-19 19:21:05.359', 'yyyy-mm-dd hh24:mi:ss.ff'),
      'ORACLE CORPORATION',
      'Y',
      'paf_cs_delete_cluster_node_intro',
      l_data_guid
     );

    COMMIT;
  END;
END;
/