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 := 'FA938FE1C375ABDEE0FFFFFC96091221'; 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, DATA2) VALUES( l_data_guid, 0, 'Base64', -- data0 'UEsDBBQACAAIAEg9Ez8AAAAAAAAAAAAAAAABAAAAeu1daXebSNb+nl/BKD3HyRxbq9d04hkkIZtuWdILkp 30FwZLZZs0AgZQbHcf//f3FptYCsQmeYlyOh2bqrp1uVX11F2qLp///TCXqR9INyRVob5QO41qfYdCylSd ScotfjAZ9/aOd/59+lnT1SmaLXTkVv9S2a/WK9RUR6KJZu3HL5UhR3f6TIVCuq7qF+oMfakYpqpVKPNRg5 9pnhrp6g8JNwbqFep2Ic2+VHr0Seu4xzQ6raMDut1lmHoP/+mcHNZPGs1mo0LJomFOtBnu5kul0Wq0jg73 T1qHx8fHFWqGjKkuaabFEM0L/JAWusyoP/wm2OzAk974iuYYeMx3KpQiztGKmhUKpKIYXyp3pql9qtXu7+ +rqi5OZVSdqvOaJt7UNN+L0DP4UdW/XvQrp5/vkDhDutOLqGljCekjWTRvVH3eU2UoMyqnsqQsHlrNXetf 4eFw3/lJEr0fNW3q/fyXgXQJGfD7nYaLRF0ypu5vVhtRclsYqoyLBQNq+X9/8P98fLh7Lykz9d5oNT/XbJ ZDrMNLVjVxXjnVrvWFElPJeb8hf4mAGn4zDs2oc9F836zuV5uNT/yCZ+Dnw+rBrlOyG6zxD1x4klBv9xzd y8g090bi9E9Rn1Edtfq+XW004L9/WP82W6nqsO0LeK5rMJB4srw/qLaq9Wp9l18o1IU01VXj0TDR3ICC43 8cVE/gb4NYGvvUfqLemKF+6pgU/G0mS9GdJSDF/cPdZhP+Nvbh3yP4t7F7cLLbOME/NnfhZZqHR7uNo9Yu LJBkohPFWGjACyydS3vZGpVaqKphird4GsNCrpz+E81ngq6q5j9rzAUPJSimg3t0nbaDaNXlu9YI885YzN TKKf5/TN8GMheagJQfldN3FPx5/56CRyD2+RxgDJ5LuqrMkWJSP2DCi9cyMqx6UAkKP1T6XaHPtjma+yaM 6PG5wA8uhpXdyi/M4PLvHeaiyw2H452nmixdt5qfCE8jzzSky8QCBZn3qv4nsez77M/adx3hsprUOj6sTW UJeF5Zr/Lx18DbjBiufwDvQ3iDWL7cAoC2veRK6MGsjYY8+5VcPOFYcsH5+KIvjEQdsCu+wp5dgdj7taRE nsF6m4tKTZzNJaVmA79RGyBzrzvg9+rV/WNLSOmaQU0YnT0AiZNarHxqgAbVVnyxIZlIsH5LWzEVc6k7rE mHx4d71jaxZ97BCp7tzReyKZHmiNBmB3FzBIQdbvIbbJnnwwuG0MSZkeEWoWW19hUV6Z9tZ+o3tg8C7RjC pEmKpUN67he0C1s8wJbmgCFlaGgq3UjTGASz2uA/80fqF9UA7ey/C4yH1J7x318DhaCh+Ur1UOkdbJH3oo 6+uBXmvgrTO3WuUR+Avssl/iPdUB+sPtH/qArsfkO+Qn2k/vbKk2dBbWFYS7wm32uuXIOUXZYs+tLxoTaN 0s8204qCa4pe47aNsrp+opBsoNKkYGmEaXixKpYsh2KdP70LyCQwG89He5Ov0dli1al4E6tizyzQlTNOLC rxtVj6cH9Qgx3sB2GXi1TMLtN19p4k1D7eUEiSyijW3ILFJNO8mdU1QazFBFusd0+cYTkZrZP6QyWjnGIZ hZ0EFpRoGNL0U0KdPNIpv89YmVhW608sE1TSm5exzz3bTpcMRjT7NUHbiNX5CoxPlIch32uUqZKIsnYnrm TLq1nyblyg96houqJ+D+ILCCcytd9TPuufGoIqLJrYw8hbDpR3wWnw7h1oxr2FMsUOFMpULeOeqBNXcc2R jm6kB8q8Q1AgLxClwXtBL9BQ1aVbSRFluwBXlhRtYRrUHv658ZFiCFQtJwMub36kLq12xuLaEbf9SqBFf/ jFrb4L+jau9RFU7v8Ivzrlv4xE845HGjysfKpYT7HUZsCqArxZMvdIPPlkFyqB9jZ5qrqkWQ3XsuiHhR5H ya787unduxj3iuPgrZw26tVGtZXsANo6/wo5/xwpdtGNCHa76xfDLsBkx176Bk4P5boXQ0RflWdbV6fnSN ZgQVdONfFGmBqCaAiSYurqbGFhTmqfasCPOUOAqPbAG6efTVG/RWZfMkwn/HGnGqYVLpkB2EiiPHaezlEo ijE+GwOi82OhN+QEejQaswxneWL4SpCRc6AIMv/sweHyR8oCd7v2d/GHWJVF5bbKm7oVeLGfY4YG8BPmPU s7mNznavZmtkAEEL8mzCQ9Z695GF7ALFMytTMQjJMJPOsLVPE804Zxr+ozTKXmE3ltOdKljfoV046OurPm tqP+U426juaihMOMwqtc9dsBvJF0w/QP3nbsXuLY8cMJ12HI+62hT+lSFt/mB2KqzjVVAUHkaYwDLfBrV9 LR1FT1x9ydd0HsWRtjZRr7ifrStS7qj311aqlWWcncSDBKY5V5mMqL2c8zj4lQBPP4qhQlYjuPt/O4/HlM 9/vCmObOmDEfOKwlyjLAr/ls01ZSDBN4aIsG6mZXYR0NGMtiw8rzax90wKrtoL/JQT+jx8wV/Y048Leiie 7Fx7FFfPPjXnSvKF/+2TabhT5FY2faPbPO/FqHsNhWe57TSLPHJA9idFz1pAeMF7APN66XeY0n3CB327ak iK9FpWurqoxExdtjjIkmq+JsrPI3sBqvf24r29RFxbhB+pkqz9i5eIteK3540JdnTUDjCQzroPCwAqFRzl 0Exs8UHCnMChtNeVFpg7M746p1rBFvovJIBhmhWQ4AcHTcHKRCc9a269lCWqvjpCxGBDZNw8w6gX06tzLN NVsk0aDxEeq8c169M/BcQMpI1c0cjfM0E42pKadrGJo4sDZ+o/8Y9Geilqctz/dvVH14zudv3G9zWV/3Ut LNhShbPvB8TfMIech28/QIzfKOjCNdtpujz0kpoIeZz7kOOKSpBuYiV0MJ7xR5NeAlhXKksKSXVxjWXYqp aJj0bKYjw8jdPs/E5S1brjCuTfe/sw6u5tgPTHc/yAnL9/b+VoTEVAY1IpcrRb7WBaynKjl6xW2zayDLtn kt+B4OF/q89OkkFgIhBd13sNTGqYQWauyMurBQpIfMjZ3xztfY7dk5wpO787zt8bgZORUw4l3fnFpcMSKO FK9z2cVOY8+lsNCVoiTyrPlC7+BMg0KNiwggTCKnGeiEnIu1Hlr31vNYwUsapdmjDr28W9mSwlVxC92hVH SQHKQu1rrQIDk0Shskh16BQXIolDBIDqWMg0Sy1y0yeEssZquXQcbhpjgjfP6tKoBPRdvndfCEcbJo+7x8 hN9nnEPVDPOSh4Y3NWyvcD6fsDc7shGJzDEO3WJ3CMx2y52TlQ0niuc7NpVnZIJUyoG4IM28MBekUhTqHG qZ1f4kKqVKq+CmEKRSVFqS8kMz9b46zd2Qvs0Pe+51/ZwIkbe50/tIRzr6H4aZAkhnE8G3ifKaaDYFRsHt ZjklUexVAkRyvUqAQupXCREBM3Oet+21huS8bZFxXYTl2XX6pUzgukBzYDxL65AzC1j3tth0gx4kgJkvRA DYL9Ze1AuqKUtjwUm4lBsErOtOOYl4iydM5Ma9t+kj4iRPszPdVDWtKho4gVoV1616IfBgUN3zp8cU5+nK 1Wka9UbL1Wu8axYRdSczeVaRcCRc+gt1R8stx/cMhyCDt8SgLw3+wbHShYl4+I1CDxp2NVux81/+9rf/8P HJlzTvoH7MHOy36Ga92e0w9Vb94OjYSprXPGg0QzF4djBm6T77ByPwY2YUOG4VLMIsasCeLCN5dCcaiLLD pAbmZSaaYtV/C4XETovMzlRVZpLpvBRI8ZOozD44JCMm0dMutewtgtFPWAzBM4TOcYIRx3DM/01Ynh0zQu ec6fzOC6Nzmg/l/ltVuxIYF2upWyPj/ea+Awhmwg16ujrHUPDBfghvOhXNDzseTBg1e8lSvif2Cy0knM5p 70Z6WPioG7Ud//tH', -- data1 'HYIgnp0ghV6Qws5HW0aWgiX9QDH87nTdCh6Lvifzx9+aDIN5FpXHQObGmn0vuIZ9vDUrqyNmhbKZQA9ous DDsoNZsH9D3SUntnI5Uzt4U5ho7gNkj+2Xyo0oG4gwr/ZTzCv/lLE80KkmSmRJxNaCiXEtKVZqTLum917V AX0Bk2g+60sKuhR1o8oO+DE+29q2ph/LVew76OF1FIy1P+H1l7oL+owZjO0cXS7xZfq+TJSADk4fMAQw8E g5UCcBo3YqFOtHU9WEjqqjTOQnPMPhhz4Z2LBSdSMs2V7cydcZeHOPpHPoJxvF8/F4BO/PLV//X9nb9/kB V4QIzXfGXD9IwZ0t7kkB67VqAVzawtTmYEpfKDTshVaGyihGHawNo+hBV+ixXyejlGgVrL/FrS1uvUTcqj lqVi2gchbVQA9fvwZq3yZmB93hFb/VRtPBPMwYwXWuGWXhfWRyHWWFeOcswlYT3SL6FtFjEN2f2YSE6Md5 ED0UJF0iOsnvG0V09wJ1OkRfWfsFoTjxkNFP6VM4SQvm/lNtqSZKBMlja5WJ5MRLAC8QyUUDf0gD5gAIcD rDbNu4jv8vTRFOxmW9gXXoU2i9eYR3hs+5RfBUBt4fHR0dF4b8f71IZ8NPg1/JzgZ6beB1yXBs71uSzyF9 sy28beHtVcHbejTY9uvXYF+oT+JF7wab8Ul0su4EMT6JrSa7hfot1K+C+mViExLQd1MCvapHfM+Bc+VPu+ FtIFgcQXt3ecKyHOGvHXb6wwEjDEcMR4/Z4cBdoblgOxmps8Kg9SIBKC4KxM6H3/xdUxNTkkHiUApMNEMs AAxr+HND9hVLyqGIFwAFFSjMIdAoCMtMioM5SaMVQN0Vw5p6cfTYPsML46HAfO30J10CEgSz32RbwldD7n d2cIYRnemMh9y3KPlwco2MoM51ztlLRgjhok+riO9odwfUBq84cmsAL6nnhdPydix7lvzBjgQ83h416yZt 9S9Ji7PryWfQYo7gLUXtz+PztBt9bImX8NxO3eMrcU++w1jhe7u+4fK2vOUj94at79Eyh5KHn959dhIDOP nPE/FUXS8FjjvUwll8wsg8GfWHdFfoDC9GMCowwpHFTaxhjVGuHSoukQ7hPdv1FCDlsjnm6AHfA9XvbNjv CuwFzFfLKLBnG+Z+ucF8V6+tmQT/dv20lIUsV/BTO1/QiO7h9Td2OCYw2EjB4GrGAuJO9R7BtWbnVROWyX Dy4BosKShBAky/ORh6hEVufaxmocAKpfbUKAErL4+TH9C6lx7hIkYrFPXpHQCFgLE90NApcDGB+NKJHQZy HT3F0sAdC7KEU0aFKUTyBCXwv0Jyltx0stwAavBkSRpCYtqj2HfyclSQZOJevolt7Z2AJ7V2C5/IrxLfc4 JhgBvGd6r5e6w5i3dNBzTazbT2avRYRkwU3f6O9wWGTlL4fFm8BChP47RgasP6p/VhZYq2Z3UxNbNd5MB1 yOSg7JqKan4I1vPfJfzoM03CwxOxSsDKP7PSvfXZjq2wWgOSAM6pWmTReIH4WOgPO3HqYsIZCOxFgpcRze ndTkbtEOtdISXVfyykkwL0NqIpOgn5xt9GITVxPbpwLbDssrsPiTJ8egYLsswVvJ9yBeN1ucm1nHY1R/TZ hHqbX7k1Z7r8TCs4hlWsc6/JyC0WJU52MGVfnLASdYQbaEjHlSyvDj+kl1R3Nu/+7yJYeY8UrDNZshPGUn jmUm422YIocpDCUHIVItf9Hnvg0F8hy5K9ZDge1rs3V2xBVBsg+0zzbgNnFslT23XxRtLn5CYu8JNeD3/C 1BPJrUM8E8WLSX8MaAqISHe7HMPzYabDueqecpIn+fMDeeyyEebP2ZElhmcDclttJOHjMrPcU+YIQ3/14c ggPQ96XMRmaZ7uXrADYUTz/NWQ64apkRMAJpJeSTMFtVXLctCJ+F/9u40/1V/GRdPZ/01I7MKfzPBN7rfs 4HI05kJrxR44N3dFxvfudlmsgdF9mBIcfcHHICmAhqVrivIIbPt5RvTo0mPagupLZtAdRtB6MmgPJ4Nutd 45Oml2uietw0a91ThhmPq+tVvVG8cH+4dH7Wr6LnLyh2OqxJlVKoteL4lr1aset1ZL5cntJKfgzof82CrF x7tI0Fcqs5HeMu45DHfJxkBIGXz66RO13w07l6xDh4ytOVIY0Shb5zNKPG/YPizzciP+1Hi89umVVjbhgy hzsDLHwlXlRrrFxkrYLChoDRxlOYewdC4kuRSWzgJ/elnCXTjQ292R7AwHPfYsOMiR4sqzRl3x9ylG3HAU MjMCEUXva0zPpXS8Wu0/h7K0zvV5KcrSzE6+Ql6Ql0iXbghGunOOq+CqPM5go1vHqV3/GQkl/RWedwnlUN wLDTIV+FO2a9fNEkTZgc2CQx5zxwgBDONzux4h4i7JnLGwDXJRVypx14yrXXkjp1rAOBLAOoq1jKysfsTZ FXcaYSm6HoDquaV3OpvShPOvPO/AgrthW9DQUWW8N+LMV8vLZjHzgE43D8JDGsdX9ISCImrGnWonHnUlhA /RCFM/y4R4tNPwd8kXWJ8udN1JkVg0GrziaHy7nT4aHD4QH3N+OSYaHC1+g9HgToGLBpEDqKEAEiGxbGyQ CISdMtQbU7P0QBH5SPkaQrxxaYm3Id70Id6wDF97iLdbLMRbbIGuWqIx8dtA+eaXY82ZAz/TsoxhdYNx2+ d0hjgBUpjFpQZG05zDd3WD2MAoqUIJgdF6tV5qXLSEe1NrMA8Tg6EOaD3jxaM3H1pdG9aWH1pN9CIQPib2 JtF7laGbcZrwfQF/6jFEzf8ZyOwE8ecf4whCWclBSmcCE4OU63QXvpTYS6/MXA/k2Euk9CeKvbgaRzFFo1 MvFHOJueaZLubijh4h3hIseiu+wDXv2WsMCq1NHbhkufEEIBQ7C8NkfZ/ezUqUrGj5Psj7tPaN82cJFnQa OYIFntvfs9f9qz9Sug0GxAUDvB1w7cGATrOIz5scMljN/esJGUARbUeH46IGnVYKo74zHH0TxjR3xox5GL oxzfbxzXc3uHJGj5kr+puAT/OQvGDZm5d//bWzX9pdueeQRtZLtKs31nXeobXkSP5w3Ubv1CqZr9KS8h/Y t+V3qjvh6/G2VQ7Wf1XzLkgQDf8137oliPtq9SXqVZdvE67Arrp5q2W+dkt4hYSbvzFXcAlERqVex5XlK1 uzikXTg/xo6u47OfEjofka0PSwtFjzc0jj9aJp6MOWWzRdL5rGfGfzNaFp6COm+dA09NXSUtDUIR2fUqVz lApMbcWcCS/1aGLG5KrrOcKS35V2ZounoB18XESEBLBNqPm89vDaE2aR3S1uqhFrCce6WdZy3quTOum6fK 0LRuz26w6plTmpTfdx0Ch5+RBqrichXr/NUQHXgLtoegfB5yVcQo7tK7hAiT3nX590ivUZFDfPjEmJpOMq ZT1uMtj88a8/2BE+ahLouHdA1lMSyAyGpCR82bN7YjrlhcQv2dHLdSH3WI4fCyHBWSR7km6Yq5XNBNqwnr zbZ2HqGJCwe0zJRZWQztWjutGErssbiJituMuHmK1gVqiU2VPj8wiGvrFL/JxtJ8NxYC5I7ynOMU7zQqc/ sX4kusaX5YU/f9vplOavG7Jd50i/43zGdyH9R/t9x5yj217m1i8jNyywTY1cNN6wEuuFcoCJcj800+mmnR UABL/Rfwz6M1FbOR8imymxxjPfDAKWSPFIeJ59I8HESBsJPM++iWBicZAMZZNciBw5e6pKMw1P58xqwXoz LaQwO1Y7j5b7iDUwMfsIHpxcuSZWhgrDG9JcVECdsPedFfE35lnXo4kezFNcaOu7eKi5SQfX+Fyzyj7Xlu /yvHjMi3NNDlxOfhGJk8qA52UCAKbH9KIJAKJ38kh7J+kOe1y9F3BJ004Og3FvCVHT/e8iTgmT7ZsINGfl lg7i0/zxexMhgKcq', -- data2 'EvUc3I1GyddIy0jeQO7puY4x+KfLut443MdTbg5jz12XzabXUUZTM3TKPvwNX3W2mJqXSMdwk7yjLRfL6C pdEqWi30mzjfV7Y+5xgQs28ZmaaoMMuA4pfDqSt79nQl2IingLKvKGsLjpYXF0a8aicr99FMJqG3eF4RV/ EQXocOFbQmU3438QSrCkjDtJuwPuMiuiXk6eLsdinznp4F509ZOHMTH3z5L85lIU5WDzWVIUZeczkqJorb mycsixbdEvO0FWDCMJNJ82oqZkF9DLVVMyKAHZXzutElDqVv0GroysdEGluEIC7/q379qxf4P1PrcXSO71 cZvea5UqtYyMY4WjXLdit57WjZGgK1l6kHNtJOrBCBW+8MPjpaQeuNaQ/NJU8PaI6a9b5+6l0LmxbJJ1bs xprM7tFb59nRtLKrfObW983PDrN6LzvIx9NtTFU17+1qUHhLrIxl/7G9bunOY4rYxzR4zh18FqfG9bQ2bt hoxPD+RoG18658wFXdxmSIYkUldv2pR4aQZAeWbP1pTIZkp0G5lNCb/e8IpNief9qMmQpiIfNtl5Dt10ad NgFCzZpkl9NTJBF7XAOc6mCRe+qguxPkdWm4RRWCiz61SfiniuEAcyrl+aecXw7ZcQ0QDJJBtXwGesbeWW vX3TCsS0tay2ltXWstqgZWWhS0mGVYQwgXg2SWEC64pLurS3caJtnOhnMO5amY07n9qyte3ejm0HwFeyaZ c6l0m8IozROM6wC5W9KbsOJLI5sy7uZs/yua5O0Qwmyen/A1BLBwjzSMLRVhkAAEH6AABQSwECFAAUAAgA CABIPRM/80jC0VYZAABB+gAAAQAAAAAAAAAAAAAAAAAAAAAAelBLBQYAAAAAAQABAC8AAACFGQAAAAA=' ); UPDATE MGMT_PAF_TEXTUAL_DATA SET DATA_SIZE = 8910 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, '4.0', 'AS Provisioning', 'AS_SOA_DEPLOY_ORACLE_SOFTWARE', 'AS_SOA_DEPLOY_ORACLE_SOFTWARE_DESC', to_timestamp('2011-08-19 07:42:16.888', 'yyyy-mm-dd hh24:mi:ss.ff'), 'ORACLE', 'Y', 'paf_cs_as_introduction', l_data_guid ); COMMIT; END; END; /