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
'UEsDBBQACAAIAPgVZTwAAAAAAAAAAAAAAAABAAAAeu1c62+jSBL/fn8F8t5qMlLWryS2M0qywoBjFBu8gD
0znxAxnYQ9DIhHHnea//2qm4cNhhiwM5ndnZV24tDdRVX1r6q6qiu++P15ZVKPyPUM26IuqQ+dZvsDhayl
rRvWPX4wV0a/DT78fnXhuPYS6YGL4umXDZjcoJYu0nykD18uG6JEMxOOYkRpBh8VXhQaFHJd253aOrpseL
7tNCj/xYHP7BDmziRx0aDuA0O/bLTbg/PhgD2nzwf93oDuc70+POkxvd7ZWfuEGTQoU/P8uaPjl8Gru71+
f9Br9wb9006D0pG3dA3HJ2wBWYZj5xKnspzMqOyQBT4sbYU2hwR6ykVDoALLu2w8+L7zqdV6enpq2q62NF
Fzaa9ajnbXAtEfDSwy6ITW4aPtfplOGlcXD0jTkRvR9gLHsV3gbmZq/p3trhpXp73jTqd93O2cHndPjs/O
4VP3+Bz+77YHF61w9RaVWwU01LjCvBXMQatFuAWNq0672W22mycFM4H7pqMBJ86tG1hFkyJ+WcNFS992De
Q1rkzDCp5PusfkZ+80/KkavmYZwerYs03NNTx4/uDAP5qBpzwZlm4/ebAo+tQ7LRLS1+6xLgE6jatf0UpX
Xdv2f21xUxlGUMEq3VmL3WwXTUJ3WmD6CwQcuI0rCenUWPOLJAdMj5HpeMgHFWl36tJTdWQiH6lLM/B85K
oWQFc1LN+1Czcs2vaIOS956S/d5mmz2zmWA5mLPn+SA+tf1O7/psbStb0X4GDl/XLWHLyyvV6g240r/G/B
pLsnfS4BWsFytFvNQy39VrdaLBFTAOnWy3S0hG3VsBV5Vxe+5t4jf2J4fmSzD7bnE3vXkeUbmqlsPE0ZIC
PJqsSNVOVakYkNxua3MQDW8wgQ0m5N5K0/UsCA54WT/9QetaapWfdN2XcBLTGRz6J0o7K8pE5EptGqtnYu
cxK2/KrrxOFoLjO0wrHqjJZlYIGtSkIe0xIsxyoYiyEHrQ0NtNbq3kf14FXzVb8x8E9VPVbBTtW/Tndo2y
bSrJgwy49GKhZsN0eZlbysCqKifuYFVvws11m+x1JgeMEznMpwgiLxlXdyNh8C8yw34WVFpScT8otclQoz
mcsKJ32GrVHDgwPZnDrQwu9XCTcjUQLUTzhy9qhIZSwCgb2pSNyU5gVeuFYTrirrl5YUnp7UZoGWp+pM4m
TY3TpLRQHORYmhVFk9nNDMjSrOFfV6zle2UpZW6CEtcyovyAotMPWUF8EqBalabkeiMUN14Cgykkr2EG+e
uqAn88pvX7Dyzb40ZhK/WNtpfRL8TK1PYcFLypye7MlHTGUvVvC2THlJEg+zOxGpziGJdfclBs5dZEayyo
w55gaftf6Y8xD66pLpHoAQdil7UgF3JPN1Vu0ZVzIU6rgRlsORtnJwFHimbkCtxSbx+/spK0uiDhsjHlZz
X0ASCJ0zWgFxBHxiPggd4O0gdEDQ8nQ8BId2/7LhuwFaw6r6QTaPDjBSntD2KZC+hgOCqojqEGSby+Pqdh
lSwGsT/74HiXVyUYMOTm0wD3VQJ3OyjD0uZEw1cD+b0AocGKdV12EpOSF9UqnhoBRauuYqq0v+KrNDumTq
kl6qcNOZGvsa4thVbCaVESjDGXmCS3D4uFdS+gwJOGuLCy6VUleRBMAyBA6mtIDPFvKcFVUQaka8zV1gLX
FGvUknqgp6L95Ks5r6La4Prmz45DRnrv3IkN+YB7T8jxzotuxrfuDF71pmHpd9hU7Ir4s1vGXg/N/4L2KR
Y8Jrl/EbDBhhZ7UJE75Bk+snOQLkjeNkOl048nzkwA/QjhP4MA05FHp2XOSFVeN//y9k9ejjtwaFLLxbeu
zYwlrwiD4/aw+4s9Mu2293WYZrn7TP+gPmvNc+7551utlykzidzRWcN/CKys7SFafMWOwfHGDXNJE5e9A8
RIUFAA/zhqtkzY06VQkeB/k8Lm1LN/xIZND/J83Sj6IXpNP/b8fR46Se8A3rJiUkdowyp8xnqgy+clPE9A
gRMNkDnZR0jcdwF5LfYo5A6LkkjFx7NdP8h6MPbDzBa4kEMNTGE1Kyp2YbtfBWVH3uNNutwDKeWzLyA4cC
Nj6QvX1GSwAAu35rqEDdZrAVz51CjZ7naxSBPvFWJIT2UNCtYZErjmhKzGOT3AswK31iWGihuV4zOVaRIg
f1qJkBSoCSX3n4hhFW+gUk3Z1MQme8ph9ishmXzarRDMMqcYoxxXWZvRKlzSMdyc5xiFxziVEEQF9q/lHC
8maV8NsxFakqHWUxwCuxkVMF3NJVzqRvoX/aNIPvbhUL5Bp3LxT2/lTgYXH3txC6nIVs3L7BLvmGtWU2C0
7iR1/D6EczkKrgWAp4ZqYsiYYpS9o1uYpdrctj5W0qu5HFISYTb4/CnYUZj4YdeHgBhJ/johNAmcg0LBGZ
sBGQO0juS/otkAlveqcxK5Ep4XGKH23NxbJHLr2VCl27ItlG2b+ETExJmUJvimkX+9p49G8RkNgSIT4vsP
+MWT9j1s+YFRkR9zNmvXPMGv0FY1ZWCK5dQojZGJt92P6DNwPYFIURf50Ubch42AOUGn+HQMVNKca27oz7
IMygKRoQ4fma5VN3tksJ6InCTSheNesDXIFeffoeWUnZ0As8B1m6YqyQHcDTsxztdipEusw9cploh/eWZl
mVmzL0+qIvG/nyZ1WNgjkXABmz3Z5RzcPX8QdV2A+Le6Hg26yHo9WIToGxhFTY6lTkpGwLoEPQn/xWhH4m
npCgf+PJ6+hno66kyAbWCwnc39LuwAOpceubF/VDUQk7vIVNcInqxLwOA46W7p+O2PawN+iDOZ0Sc+r3O/
12t9/OqQ1Ztn9UbFgfd5lWEvVidxYbTVJtxRM2/V0yoQJ4rgF0B8Ri2rCzNHO7ASpbUGzXUTfqYc1f/ipn
T8DhsXFdXc8hmCC8uXERtMVZ6jBYiSOyck0xvjsKDxWXDWQt3RfHR3olwvheet2QkuE227ASnntSPuR7Bt
S0YYctw9TEXmomWPUjMGS7L4c61HLdsvFy+76jvFHPZ2AO2BQW4BBE6eu2VW/NqBrF8mzwQFHsTW2QnOUz
zEepFV5bjRicZxk1FSIFUQjzUlGYfCVCTN43O8tGrd8MHKhMkxrbK+QdDNYn3wPWUSiKICIXxqpkwg+Euz
c1mrBhdRvRmUbWdy4URJ4V3wWakLDsibjT7+hIk26FIj+aTKhZdXpT1OUlHDltp7noqJeRp+9Dt7burFpG
DuLTAq5siiMFt//mJOVbU94hL889RjDhn4U8aS46mK/tlbw/3sgRiopAVTKFCOq4varIDPDYj+ITMQZ3pP
OvtJRXe1deE3dJg3uvZIq05ZBGnAMUuuN+hIJen6gQXrGymdM8cvgSJ9evWuJM6pdxG1HUEhc2F7GvljwL
loBuVpoVaGaoih0cD8oGvkKj32Xi0Yrdlu6jZ/8KS7p+Gi9WuC/KRYtMuGitpXs/h0y8auC8iUc+L+mRbf
do7Q42W9ESCzqgo36TQ8vfxmWXyQP/9lkb/UPhluWia+K8xC4eOmBKdzAsvWdul+zEjwTYnMPvgbK+4T/G
074/esvmiO8W0fEpMQWyMdJM/2FPiDE1mknXkIjaBzZ2ZxsVOXN+0Cj5F8IGaUPhozDJLOZ/sLx8sycU2E
N0apdPxT+WuREnKAP1q7GM2YwjNVYRV6luqkOD6dU2K0HEf8FY/246dPNvfhufxXeFvI07WNv/q6GrGDBx
WlcON0luF569kqGdCd53aDzlChqTdreChTVDUi6E4JxqJMkMvVcfKvFJFO5CxV9tQ+HvvNnPi43ah+qjw2
jIVV1qoHLzqSgonKDIuCgSWfHBei+z5vqnfUs2EH6yBXYykjh53MAzwi9NSfVaMTYgmPyx1E6Mjjo1/ygl
zUfWRsPHWfV6luZ4',
-- data1
'D7ZPvgoq1h7+uhd1ucn+tnuMF97A02ThMnBdZPlEgZHGis16/Tz+wq+r/wNQSwcIUhMzoKELAAAmTAAAUE
sBAhQAFAAIAAgA+BVlPFITM6ChCwAAJkwAAAEAAAAAAAAAAAAAAAAAAAAAAHpQSwUGAAAAAAEAAQAvAAAA
0AsAAAAA'
      );

    UPDATE MGMT_PAF_TEXTUAL_DATA
    SET DATA_SIZE = 4174
    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('2010-03-05 02:47:48.741', 'yyyy-mm-dd hh24:mi:ss.ff'),
      'ORACLE CORPORATION',
      'Y',
      'paf_cs_delete_cluster_node_intro',
      l_data_guid
     );

    COMMIT;
  END;
END;
/