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 := '5E6456B53D257C87E040578C060B0D08';
    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
'UEsDBBQACAAIAPgVZTwAAAAAAAAAAAAAAAABAAAAeu1c61PjOBL/zl+h8s4WUAVxeAWYBfbyMJDdEOfihJ
355DW2IJ5xLK8k86gt/vdryXZwEjuJk3AzezdMzQxI3S2p9euHWgpnvz4PPfSIKXOJj87R5l6pvImwbxPH
9R9EQ793uXuy+evFWUCJjZ2Q4oT8XAFiBdkUWxw7tZdzRe9W6y1NQZhSQm+Ig88VxkmgIP4SwPcdi9sDnV
q2h+teyDimTxbFCnoIXedcOdIqh0eV2tFBY//ouH5yrJUPy0fHJ/VypVwrN8onCvIsxvuBI0aDsfcrx8cn
lXLldP+4oiAHM5u6AZfzqncNs6u3Ws32ldnQjHpXQb41FDOo9urXZqpbQbB+n50rA86Dj6r69PRUInKGJZ
sM1cC6V2Hdj65YLyik6sC3hH66aSkXZwNsOZjGkoGyFFhD5SK4o6F/pkadE0SMWw9CCmhMufgZDx2TEsJ/
VrUbA3pwDpdQ/DX2AoY5iLe45TyaNjNtysxAaBQkmq7PKXFCW6w/TwzMkIUOUS7Ev3kzxDwMTOw/KhcbCL
5++glBE6qT4RDwAe0uJf4Q+xw9WtS17jzMJB0QQeeW0mqYrWatW+1+NkHX16bRvtGVHeWD1r79e1O7aXR1
vbf5qnru3cH+x4zWqbYAUy+zw8f8idCvmX1fnK/qF4pFn+oenFRU23NhznPplO1fxlbT0bqtI1hPxgpy55
V0AJJ2ZxPhZ652dKP5Kbu7321md1z3blpmx6IM03yC3Yggc/Q7159qYy9saPmq5QxdX41MialtzHcbbWO3
XDo8kUpajA0oYXd290p7p2quftSj0knpIL+buRyb8qdFCRea3MIDqm7lpLLruX74vMsHYLHO7jD0uJuFEb
PWbOdhBJQ9yfJbVzOv9RstgyVG5CTHhFm9u0VNjd+sFRo3d4wM2TmCs0AqtJPVnlZ04rYMcFuBZ/F7QoeI
Bdh27107x4NJHvE1fEEfCIOw92co/CHaZX/+MtYJoS/VSyd6BxZ1REg7TwiGKQJ7QIYB2gL5ySzFl3uPtu
SY+C+kGKGvGwraRn+P+mejQA2ZNHHVewoSvY5LTqYk5bsnlcCell8Maas61wVGzQsb6xr6FWGP4bVpgQUW
tReZiyRcsx5WG/x1Y0wnY2i87uz2P02jRdIoI2ApEbKsymFBYKGZy2pWK4dtFSLYY0aUmyIsrtP3HH2WUl
sioGRpqqBal1asELnIyuTQGWpdTbGrjT5S56Se2MFp+VkpqKfciUIkAYOyGHPtjzNoltHO+sfM1UkQ2EKH
/7c6wWta+Tri3DeLdLOdUbX5aUa2kZvzrbA/03PQjcu9daYklhcMrLnTGlGuORqvMPq0ahoWfQL1jSlnCt
o/ob7PwiAglGMH6ZAKW1yUbowXxvFwYxwGGxuQGV+GvqwTIE7k4T4zJy4Jyg7F9+4z4gMMHV6IUQDrglGA
kVD3wfUtL+oQxK4fhJyhXfH93jbSMqTKIoPo399Gt5KPhXexuqMlQRa99SEh34F8W1BtQ8r9L/OXuP9Dx+
IDAwfQqHxUZKvQmgNT9WFuUucjEa9p3U10gYBIPiq9CS1NUskBJrWeJyki3njd2HirrzgY4CA2hfjs4oxb
9AHzlst4XBQbEMYVUB6HoOjip3PFjkpjsrDmgPZcy+ulKMcKXb2rHkDU6JmXeheOlEbPEMWtpNolGGoYwC
ALb9hRLs5G+5s7k+lRh3j2qDdaasQhzh9xBANpHxHHF+vRKnmW/1AyOAXGRBKh1rUYWS3G1pOL0g3xU1Fe
12fc8m3MijKKVd9GNdGirD5xcHveXEPueqVbbHNCJ/mgteiQNmXtJbRjsWGk3JWYl9lTYG7GW7Pk2Am70W
wsoa1utd7A3HK9wsCglt0ituWlp7+ykN4DX4scsRUrCzFcZxkZuu+Bs15mN+9dypZCEcWBZ9nYkZX2hkuX
AEIfDi6FnQqTrlDU7gtztglPM6spV6q+ee8ZHfODTZ7Pz4w0UYARTr/R7Gr1XvNWG79eEXyXhNYhgJGhwX
FQGBtsyd2hoa/Ly5B+8EAh7hb1p5K32WBL8RnUXo6xYXFrKcYu9rDFIvO9T9K5FHN8hRUVwEvOXSmwSpAY
QD7XEbd4jL3Jc8hbq1DoQhKDQEjsVGtgUl9JyN+EjVqKyJHK9+/JFeYy84lIAbqd+H5LdBaRaFQbNf06e7
np9njB6niOxgRyL85sMoSMFgscI/wcUEEvTOHD3xM62xIMJXGLuf2a3GZeVk+Pyifa0eH+5X55v1HXygfy
NvO0Uj7dP9rbnzCvZrvZM+v6Tcc0elpn3KrG+8R8KfE8kWQNAAMoMnIm5wV4Kk1mfVlTOsieEnZcLnB4rn
AaTmZ9LV3vmPqtliSaU3ep47OeS66MFJ23nOjb0mRSmbWgwxUXBDlskQVlkisLIWcCfluZkDnKXk40kbQE
gYYv5E6OBP830uszetUrLZomTPc3vZasBwgjPy9jYaRVBoSgL19oy0nUNTWvSva8gpAGhCXuWziaSOacDR
ifoNDkH004ZmtX6clGa55aCyj7zvXlI4W0GzCj44o8jKUgFJ8mXoW6xtlGjv+NR1pR0p7HIn1+Fo/oyGOS
/j6LSXRkMI2i4dSCJrMZyazGSIAzp0shaLiPEQRHPwkBoIqPIKHfbV9SMhTH3q3NRkLA1Oh5Bkq1JD5YjR
4BqFXPU6+wj6lrq93QN/kAmwBIiv9iZqO2KfCMn7EN+G+8jRvvPqlD3PL7QdIAYbsKpi6fJUyj7TgbbTYB
HfHYoMRyfMK3Ym2+pVuvYiIjYFpB4L2kgTn+XkRvX7aa9Z5ZbVdbn42mMQ6+qe4p8I1WWmpXbzSzPnRakN
/eWpTFr0muC8JyhkAJCpGEi7kviIyFhUMWSF86BDLEkeQ4vhIJ1BIo/95zbV5IapBofWEbmyHMZV3LHom6
tzyGiy1RPE5q3l/CgW4kRaJRJgJpw5ntyJNM5y3678DWUJ6074y2JHVYf90R4XmnslMWfzJ9/8kC6QK4w2
7PrLWq9d/1fk+6TvF30mWmaMTqinkFtKhb6BpjPsEYhNwhTz6CDnRj+QBDB3UxIyGFiLWJtlERDzGlntMl
Ir1xHSup2ukYeYeXHKIitg5nxDUa+qg2NCUu6Skmz8F34YN4lbeC8SzjfCaNaq0wjINSFghRI0ZhUczNjk
rVVQA4D3tLwW7J1GeGRCHKfMQZiUeq1vn+m5vrYyDvkO5FJMLgT43obdd697m2QPYR5xypQs3rHCR0+225
0Z2uJi6FokNEDipm0yqFzBYHo72EMCbfnRZCxPoxJt6vhiwLY3GpbYm0yHQWTpaLJS+m68zMXv7JZjCF/P
p7I39R1K8R8T/A/r2AffnTZlRXRqMEs+hpc1TdiPKeaeA3lgjt9b7R02/MTtUUQbyh/9GGU/DE+TGL5NsG
eOfOZK5jei7jGZAE1VsGDozvZMOj6gKqD7D9la15y7U5Fa1o0LE3EiyM4CCeQci6ApLWsSBOIJZr/zbr11
r9dyMbJmmKHyiZj5Kq3ANJgf5w+QDO3qhFHsQnbZYES05cvJyDlaki00xAwDGz9TmKdHFZMycgziD8tvBI
gsWaCjvvFtQkUn3H9NOHablZxZcLiU58+Za56ORi7r9oEBM5YWQNtdB3PBw5JuGn4s/bIVFovhPXLAIGbI
Vi7WxbOSiX38FWutV6rd9utLTFLGYGufK91FsXqYx+4+h7a3muIxcf+di1BuCD8t4coMTDYxZ7eAEcFzuI
UOTDGXY2biDluq22mo1qr6m34xu7iQ+EThH88KnfoTNc+YQcTxd1CeEoOiivs1x0UN5f/NBc+MQsYGloPV
NUgUxAb7PTyzkzZ1B+B3iGtZr0HwKUdZZSDsoH71tK0Y0FK4jThMsXU8TjsB/VlB+lw7ku8fDdwb94CT2b
eCUj+FFE/5+wBENc',
-- data1
'2oeBtAY4Ja5+ZT3bKI6WuT6UV/lzL7BzqH7cYK/7BrvwsxASjF6FZD36OChXFnr0oXfmvvlIkRR/8jHbgu
A8DeHi7ZfhqHvl0n6pXNorldUufnBlgcG5S15wFjsnTmnkeP35dMpumkZdPOX8LNWXaC+rX+CniAFVr7R2
L/rtHgm23n7RTyGgimezcvQ1GY8Ay9i8VrPteqtv9LSuCU7nCg4c2TONP2uUaUR5z1bFuk3x5K55Bf+1Wp
kvV+vEv3cfwujJdp14HrYje55XlzqZ537jOoWz6JQiRWVRTMGG+VbABoSLJYx0Jd6DmXZ6ORnvQGPG36F1
xGiHlGKfjz/8VOMXyGr6TfX85tHv9rr4D1BLBwhb5CZ6hAwAABFMAABQSwECFAAUAAgACAD4FWU8W+Qmeo
QMAAARTAAAAQAAAAAAAAAAAAAAAAAAAAAAelBLBQYAAAAAAQABAC8AAACzDAAAAAA='
      );

    UPDATE MGMT_PAF_TEXTUAL_DATA
    SET DATA_SIZE = 4481
    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',
      'PatchOracleClusterware',
      'PATCH_CRS_ROLLING',
      'CRS_ROLLING_DESCR',
     to_timestamp('2010-03-05 02:47:49.276', 'yyyy-mm-dd hh24:mi:ss.ff'),
      'ORACLE',
      'Y',
      'patadv_cs_crs_patching_introduction',
      l_data_guid
     );

    COMMIT;
  END;
END;
/