CREATE OR REPLACE PACKAGE BODY WB_RT_TF_MAP_OPERATIONS wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 5d 2 :e: 1PACKAGE: 1BODY: 1WB_RT_TF_MAP_OPERATIONS: 1FUNCTION: 1START_MAP: 1APPLY_NAME1: 1VARCHAR2: 1MAP_NAME: 1RETURN: 1NUMBER: 1PLSQL_BLOCK: 160: 1ERROR_COUNT_TIME: 1TIMESTAMP: 1CURRENT_ERROR_TIME: 1INIT_ERROR_COUNT: 1CURRENT_ERROR_COUNT: 1ERROR_COUNT: 10: 1MAX_ERROR_LIMIT: 150: 1WITHIN_ERROR_LIMITS: 1BOOLEAN: 1TRUE: 1CURRENT_STATUS: 120: 1AUDIT_ID: 1ERROR_TIME_LIMIT: 110: 1APPLY_NAME2: 138: 1": 1||: 1COUNT: 1DBA_APPLY_ERROR: 1APPLY_NAME: 1SELECT count(*) into INIT_ERROR_COUNT from dba_apply_error :nwhere apply_name+ 1 = apply_name1: 1OWBSYS: 1GET_AUDIT_ID: 1DBMS_LOB: 1SUBSTR: 1WB_RT_TASK_VARIABLE: 1GET_VALUE: 1max_no_of_errors: 1WB_RT_CONSTANTS: 1PARAM_KIND_SYSTEM: 1PARAM_SCOPE_PARAM: 14000: 11: 1default_error_time_limit: 1BEGIN DBMS_APPLY_ADM.START_APPLY(::x); END;: 1EXECUTE: 1IMMEDIATE: 1USING: 1GET_STATUS: 1WHILE: 1!=: 1STOPPED: 1LOOP: 1DBMS_LOCK: 1SLEEP: 1=: 1ABORTED: 1SELECT count(*) into CURRENT_ERROR_COUNT from dba_apply_error :n where+ 1 apply_name = apply_name1: 1>: 1SYSDATE: 1+: 1-: 1IS NOT NULL: 1NUMTODSINTERVAL: 1<=: 1HOUR: 1>=: 1FALSE: 1TRUNC: 1HH: 1SELECT count(*) into INIT_ERROR_COUNT from dba_apply_error :n + 1where apply_name = apply_name1: 1STOP_MAP: 1BEGIN DBMS_APPLY_ADM.STOP_APPLY(::x); END;: 1RET: 1100: 1STATUS: 1ALL_APPLY: 1SELECT STATUS into ret FROM ALL_APPLY WHERE APPLY_NAME = apply_name1: 1DISABLED: 1ELSIF: 1EXECUTING: 1EXECUTION_AUDIT_ID: 1ALL_RT_AUDIT_EXECUTIONS: 1OBJECT_NAME: 1CREATED_ON: 1ROWNUM: 1SELECT execution_audit_id into audit_id from (select execution_audit_id from + 1all_rt_audit_executions where object_name = MAP_NAME order by created_on desc+ 1) where rownum < 2: 0 0 0 1f4 2 0 :2 a0 97 a0 8d 8f a0 b0 3d 8f a0 b0 3d b4 :2 a0 2c 6a a3 a0 51 a5 1c 81 b0 a3 a0 1c 4d 81 b0 a3 a0 1c 81 b0 a3 a0 1c 81 b0 a3 a0 1c 81 b0 a3 a0 1c 51 81 b0 a3 a0 1c 51 81 b0 a3 a0 1c a0 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a0 6e 7e a0 b4 2e 7e 6e b4 2e d :5 a0 12a :3 a0 6b a0 6b a0 a5 b d :3 a0 6b :2 a0 6b a0 6b a0 6e :2 a0 6b :2 a0 6b a5 b :2 51 a5 b d :3 a0 6b :2 a0 6b a0 6b a0 6e :2 a0 6b :2 a0 6b a5 b :2 51 a5 b d a0 6e d :5 a0 112 11e 11a 11d :3 a0 a5 b d :3 a0 7e 6e b4 2e 5a a 10 a0 5a 82 :2 a0 6b 51 a5 57 :3 a0 a5 b d a0 7e 6e b4 2e 5a :5 a0 12a :2 a0 7e b4 2e 5a :2 a0 d :2 a0 7e a0 b4 2e 7e a0 b4 2e d a0 7e b4 2e 5a a0 7e a0 b4 2e a0 7e 51 6e a5 b b4 2e 5a a 10 5a :2 a0 7e b4 2e 5a :2 a0 d b7 19 3c b7 :3 a0 6e a5 b d :2 a0 7e a0 b4 2e d b7 :2 19 3c a0 5a :5 a0 12a :5 a0 112 11e 11a 11d b7 19 3c b7 19 3c b7 19 3c b7 a0 47 a0 51 65 b7 a4 a0 b1 11 68 4f a0 8d 8f a0 b0 3d b4 :2 a0 2c 6a a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a0 6e 7e a0 b4 2e 7e 6e b4 2e d a0 6e d :5 a0 112 11e 11a 11d a0 51 65 b7 a4 a0 b1 11 68 4f a0 8d 8f a0 b0 3d b4 :2 a0 2c 6a a3 a0 51 a5 1c 81 b0 :5 a0 12a a0 7e 6e b4 2e 5a a0 6e d a0 b7 a0 7e 6e b4 2e 5a a0 6e d b7 19 a0 6e d b7 :2 19 3c :2 a0 65 b7 a4 a0 b1 11 68 4f a0 8d 8f a0 b0 3d b4 :2 a0 2c 6a a3 a0 1c 81 b0 :8 a0 12a :2 a0 65 b7 a4 a0 b1 11 68 4f b1 b7 a4 11 a0 b1 56 4f 1d 17 b5 1f4 2 0 3 7 b 15 19 35 31 30 3d 4a 46 2d 52 45 57 5b 5f 63 7d 6b 42 6f 70 78 6a 99 88 8c 67 94 87 b5 a4 a8 b0 84 cd bc c0 c8 a3 e9 d8 dc e4 a0 104 f0 f4 fc ff d7 120 10f 113 d4 11b 10e 140 12b 12f 137 13b 10b 15c 147 14b 14e 14f 157 12a 178 167 16b 173 127 194 17f 183 186 187 18f 166 1b1 19f 163 1a3 1a4 1ac 19e 1b8 1bc 19b 1c1 1c5 1c6 1cb 1ce 1d3 1d4 1d9 1dd 1e1 1e5 1e9 1ed 1f1 1fd 201 205 209 20c 210 213 217 218 21a 21e 222 226 22a 22d 231 235 238 23c 23f 243 248 24c 250 253 257 25b 25e 25f 261 264 267 268 26a 26e 272 276 27a 27d 281 285 288 28c 28f 293 298 29c 2a0 2a3 2a7 2ab 2ae 2af 2b1 2b4 2b7 2b8 2ba 2be 2c2 2c7 2cb 2cf 2d3 2d7 2db 2df 2e0 2e5 2e6 2ea 2ee 2f2 2f6 2f7 2f9 2fd 301 305 309 30c 311 312 317 1 31a 31f 323 326 328 32c 330 333 336 337 33c 340 344 348 349 34b 34f 353 356 35b 35c 361 364 368 36c 370 374 378 384 388 38c 38f 390 395 398 39c 3a0 3a4 3a8 3ac 3af 3b3 3b4 3b9 3bc 3c0 3c1 3c6 3ca 3ce 3d1 3d2 3d7 3da 3de 3e1 3e5 3e6 3eb 3ef 3f2 3f5 3fa 3fb 3fd 3fe 403 1 406 40b 40e 412 416 419 41a 41f 422 426 42a 42e 430 434 437 439 43d 441 445 44a 44b 44d 451 455 459 45c 460 461 466 46a 46c 470 474 477 47b 47e 482 486 48a 48e 492 49e 4a2 4a6 4aa 4ae 4b2 4b3 4b8 4b9 4bd 4bf 4c3 4c6 4c8 4cc 4cf 4d1 4d5 4d8 4da 4de 4e5 4e9 4ec 4f0 4f2 4f6 4fa 4fc 508 50c 50e 512 52e 52a 529 536 526 53b 53f 543 547 564 54f 553 556 557 55f 54e 581 56f 54b 573 574 57c 56e 588 58c 56b 591 595 596 59b 59e 5a3 5a4 5a9 5ad 5b1 5b6 5ba 5be 5c2 5c6 5ca 5ce 5cf 5d4 5d5 5d9 5dd 5e0 5e4 5e6 5ea 5ee 5f0 5fc 600 602 606 622 61e 61d 62a 61a 62f 633 637 63b 658 643 647 64a 64b 653 642 65f 663 667 66b 66f 673 67f 63f 683 688 689 68e 691 695 69a 69e 6a2 6a4 6a8 6ab 6b0 6b1 6b6 6b9 6bd 6c2 6c6 6c8 6cc 6d0 6d5 6d9 6db 6df 6e3 6e6 6ea 6ee 6f2 6f4 6f8 6fc 6fe 70a 70e 710 714 730 72c 72b 738 728 73d 741 745 749 762 751 755 75d 750 769 76d 771 775 779 77d 781 785 789 795 799 79d 74d 7a1 7a5 7a9 7ab 7b7 7bb 7bd 7bf 7c1 7c5 7d1 7d5 7d7 7da 7dc 7dd 7e6 1f4 2 0 1 9 e 1 a 15 21 :2 15 2b 34 :2 2b 14 15 1c :3 1 17 20 1f :2 17 :2 1 :2 17 24 17 :2 1 :3 17 :2 1 :3 17 :2 1 :3 17 :2 1 :2 17 21 17 :2 1 :2 17 21 17 :2 1 :2 17 22 17 :2 1 17 20 1f :2 17 :2 1 :3 17 :2 1 17 20 1f :2 17 :2 1 17 20 1f :2 17 :2 1 10 14 17 :2 10 23 26 :2 10 1 8 16 2c 7 14 :2 1 d :2 14 :2 2c 39 :2 d :2 1 14 :2 1d 24 :2 2b :2 3f 49 53 67 :2 77 8a :2 9a :2 24 ae b4 :2 14 :2 1 15 :2 1e 25 :2 2c :2 40 4a 54 70 :2 80 93 :2 a3 :2 25 b7 bd :2 15 :2 1 10 :2 1 9 13 1f 25 1f :4 1 13 1e :2 13 :2 1 8 21 30 33 :2 30 20 :2 8 3f 7 1 5 :2 f 15 :3 5 17 22 :2 17 5 9 18 1a :2 18 8 10 1e 37 f 1c 9 d 23 :3 21 c d 23 :2 d 1c 28 29 :2 1c 3d 3f :2 1c d :4 12 11 12 25 27 :2 12 15 38 25 28 :2 15 :2 38 :3 11 10 15 24 :3 21 14 15 2c 15 35 :2 11 12 11 25 2b 3f :2 25 :2 11 20 34 36 :2 20 11 :4 d 11 10 18 26 3c 17 24 :2 11 19 23 2f 35 2f :3 11 26 :2 d 35 :2 9 25 :2 5 3f 5 :2 1 8 :3 1 5 :5 1 a 13 1e :2 13 12 28 2f :3 1 d 16 15 :2 d :2 1 d 16 15 :2 d :2 1 10 14 17 :2 10 22 25 :2 10 :2 1 10 :2 1 9 13 1f 25 1f :4 1 8 :3 1 5 :5 1 a 16 22 :2 16 15 2d 34 :3 1 5 e d :2 5 1 8 14 1d 2d 3a 1 5 9 b :2 9 4 1 8 :2 1 17 8 c e :2 c 7 1 8 1 19 17 1 8 :6 1 8 :3 1 5 :5 1 a 17 23 :2 17 16 2d 34 :2 1 5 :3 e 5 c 24 3a 52 70 7e 90 a7 :2 5 c 5 :2 1 5 :8 1 5 :6 1 1f4 4 0 :3 1 :b 3 :2 4 :2 3 :7 5 :6 6 :5 7 :5 8 :5 9 :6 a :6 b :6 c :7 d :5 e :7 f :7 10 :b 15 :3 17 :2 18 17 :a 1a :18 1c :18 1e :3 21 :9 22 :6 24 :d 26 :6 28 :6 2a :6 2b :3 2d :2 2e 2d :6 30 :3 31 :b 32 :5 34 :5 35 36 35 :4 36 :3 35 :3 34 :6 38 :3 39 :3 38 37 :7 3c :7 3d 3b :3 34 :2 40 :3 41 :2 42 41 :9 44 :3 40 :3 30 :3 2b 26 48 26 :3 4a :2 12 4b :4 3 :b 4e :7 4f :7 50 :b 53 :3 54 :9 55 :3 56 :2 51 57 :4 4e :b 5a :7 5b :6 5d :6 5e :3 5f 60 5e :6 60 :3 61 60 5e :3 63 62 :3 5e :3 65 :2 5c 66 :4 5a :b 69 :5 6a :9 6c :3 6e :2 6b 6f :4 69 :4 3 72 :6 1 7e8 4 :3 0 1 :3 0 2 :3 0 3 :6 0 1 :2 0 4 :3 0 5 :a 0 14b 2 :7 0 5 42 0 3 7 :3 0 6 :7 0 8 7 :3 0 c :2 0 :2 7 :3 0 8 :7 0 c b :3 0 9 :3 0 a :3 0 e 10 0 14b 5 11 :5 0 c 7 :3 0 a 14 16 :6 0 19 17 0 149 0 b :6 0 10 a0 0 :2 e :3 0 1b :7 0 1f 1c 1d 149 0 d :6 0 14 d4 0 12 e :3 0 21 :7 0 24 22 0 149 0 f :6 0 a :3 0 26 :7 0 29 27 0 149 0 10 :6 0 15 :2 0 16 a :3 0 2b :7 0 2e 2c 0 149 0 11 :6 0 a :3 0 30 :7 0 13 :2 0 34 31 32 149 0 12 :6 0 1a 127 0 18 a :3 0 36 :7 0 3a 37 38 149 0 14 :6 0 20 163 0 1e 17 :3 0 3c :7 0 18 :3 0 40 3d 3e 149 0 16 :6 0 7 :3 0 1a :2 0 1c 42 44 :6 0 47 45 0 149 0 19 :6 0 1f :2 0 24 a :3 0 49 :7 0 4c 4a 0 149 0 1b :6 0 7 :3 0 1d :2 0 22 4e 50 :6 0 53 51 0 149 0 1c :6 0 21 :2 0 28 7 :3 0 26 55 57 :6 0 5a 58 0 149 0 1e :6 0 1e :3 0 20 :4 0 6 :3 0 2a 5d 5f :3 0 21 :2 0 20 :4 0 2d 61 63 :3 0 5b 64 0 146 22 :3 0 10 :3 0 23 :3 0 24 :3 0 6 :4 0 25 1 :8 0 146 1b :3 0 26 :3 0 3 :3 0 6d 6e 0 27 :3 0 6f 70 0 8 :3 0 30 71 73 6c 74 0 146 14 :3 0 28 :3 0 29 :3 0 77 78 0 26 :3 0 2a :3 0 7a 7b 0 2b :3 0 7c 7d 0 1b :3 0 2c :4 0 2d :3 0 2e :3 0 81 82 0 2d :3 0 2f :3 0 84 85 0 32 7e 87 30 :2 0 31 :2 0 37 79 8b 76 8c 0 146 1c :3 0 28 :3 0 29 :3 0 8f 90 0 26 :3 0 2a :3 0 92 93 0 2b :3 0 94 95 0 1b :3 0 32 :4 0 2d :3 0 2e :3 0 99 9a 0 2d :3 0 2f :3 0 9c 9d 0 3b 96 9f 30 :2 0 31 :2 0 40 91 a3 8e a4 0 146 b :3 0 33 :4 0 a6 a7 0 146 34 :3 0 35 :3 0 b :3 0 36 :3 0 1e :3 0 ad ab 0 b0 :2 0 44 af :2 0 146 19 :3 0 37 :3 0 6 :3 0 46 b3 b5 b2 b6 0 146 38 :3 0 16 :3 0 19 :3 0 39 :2 0 3a :4 0 4a bb bd :3 0 be :2 0 b9 c0 bf :2 0 3b :3 0 c1 :2 0 c3 142 3c :3 0 3d :3 0 c5 c6 0 1d :2 0 4d c7 c9 :2 0 140 19 :3 0 37 :3 0 6 :3 0 4f cc ce cb cf 0 140 19 :3 0 3e :2 0 3f :4 0 53 d2 d4 :3 0 d5 :2 0 22 :3 0 11 :3 0 23 :3 0 24 :3 0 6 :4 0 40 1 :8 0 13d 11 :3 0 10 :3 0 41 :2 0 58 df e0 :3 0 e1 :2 0 f :3 0 42 :3 0 e3 e4 0 13a 12 :3 0 12 :3 0 43 :2 0 11 :3 0 5b e8 ea :3 0 44 :2 0 10 :3 0 5e ec ee :3 0 e6 ef 0 13a d :3 0 45 :2 0 61 f2 f3 :3 0 f4 :2 0 f :3 0 44 :2 0 d :3 0 63 f7 f9 :3 0 46 :3 0 47 :2 0 31 :2 0 48 :4 0 66 fb ff 6b fc 101 :3 0 102 :2 0 f5 104 103 :2 0 105 :2 0 12 :3 0 14 :3 0 49 :2 0 70 109 10a :3 0 10b :2 0 16 :3 0 4a :3 0 10d 10e 0 110 73 111 10c 110 0 112 75 0 113 77 123 d :3 0 4b :3 0 f :3 0 4c :4 0 79 115 118 114 119 0 122 12 :3 0 11 :3 0 44 :2 0 10 :3 0 7c 11d 11f :3 0 11b 120 0 122 7f 124 106 113 0 125 0 122 0 125 82 0 13a 16 :3 0 126 :2 0 22 :3 0 10 :3 0 23 :3 0 24 :3 0 6 :4 0 4d 1 :8 0 137 34 :3 0 35 :3 0 b :3 0 36 :3 0 6 :3 0 132 130 0 135 :2 0 85 134 :2 0 137 87 138 127 137 0 139 8a 0 13a 8c 13b e2 13a 0 13c 91 0 13d 93 13e d6 13d 0 13f 96 0 140 98 142 3b :3 0 c4 140 :4 0 146 9 :3 0 31 :2 0 144 :2 0 146 9c 14a :3 0 14a 5 :3 0 a7 14a 149 146 147 :6 0 14b 1 0 5 11 14a 1ee :2 0 4 :3 0 4e :a 0 185 4 :7 0 b6 :2 0 b4 7 :3 0 24 :7 0 151 150 :3 0 9 :3 0 a :3 0 153 155 0 185 14e 156 :2 0 1f :2 0 ba 7 :3 0 c :2 0 b8 159 15b :6 0 15e 15c 0 183 0 b :6 0 21 :2 0 be 7 :3 0 bc 160 162 :6 0 165 163 0 183 0 1e :6 0 1e :3 0 20 :4 0 24 :3 0 c0 168 16a :3 0 21 :2 0 20 :4 0 c3 16c 16e :3 0 166 16f 0 180 b :3 0 4f :4 0 171 172 0 180 34 :3 0 35 :3 0 b :3 0 36 :3 0 1e :3 0 178 176 0 17b :2 0 c6 17a :2 0 180 9 :3 0 31 :2 0 17e :2 0 180 c8 184 :3 0 184 4e :3 0 cd 184 183 180 181 :6 0 185 1 0 14e 156 184 1ee :2 0 4 :3 0 37 :a 0 1c4 5 :7 0 d2 :2 0 d0 7 :3 0 6 :7 0 18b 18a :3 0 9 :3 0 7 :3 0 18d 18f 0 1c4 188 190 :2 0 3e :2 0 d6 7 :3 0 51 :2 0 d4 193 195 :6 0 198 196 0 1c2 0 50 :6 0 52 :3 0 50 :3 0 53 :3 0 24 :3 0 6 :4 0 54 1 :8 0 1bf 50 :3 0 55 :4 0 da 1a0 1a2 :3 0 1a3 :2 0 50 :3 0 3a :4 0 1a5 1a6 0 1a9 56 :3 0 dd 1b9 50 :3 0 3e :2 0 3f :4 0 e1 1ab 1ad :3 0 1ae :2 0 50 :3 0 3f :4 0 1b0 1b1 0 1b3 e4 1b4 1af 1b3 0 1bb 50 :3 0 57 :4 0 1b5 1b6 0 1b8 e6 1ba 1a4 1a9 0 1bb 0 1b8 0 1bb e8 0 1bf 9 :3 0 50 :3 0 1bd :2 0 1bf ec 1c3 :3 0 1c3 37 :3 0 f0 1c3 1c2 1bf 1c0 :6 0 1c4 1 0 188 190 1c3 1ee :2 0 4 :3 0 27 :a 0 1e7 6 :7 0 f4 :2 0 f2 7 :3 0 8 :7 0 1ca 1c9 :3 0 9 :3 0 a :3 0 1cc 1ce 0 1e7 1c7 1cf :2 0 f8 1e6 0 f6 a :3 0 1d2 :7 0 1d5 1d3 0 1e5 0 1b :6 0 58 :3 0 1b :3 0 58 :3 0 59 :3 0 5a :3 0 8 :3 0 5b :3 0 5c :4 0 5d 1 :8 0 1e2 9 :3 0 1b :3 0 1e0 :2 0 1e2 :3 0 1e6 27 :3 0 fb 1e6 1e5 1e2 1e3 :6 0 1e7 1 0 1c7 1cf 1e6 1ee :3 0 1ec 0 1ec :3 0 1ec 1ee 1ea 1eb :6 0 1ef :2 0 3 :3 0 fd 0 3 1ec 1f2 :3 0 1f1 1ef 1f3 :8 0 102 4 :3 0 1 6 1 a 2 9 d 1 15 1 13 1 1a 1 20 1 25 1 2a 1 2f 1 35 1 3b 1 43 1 41 1 48 1 4f 1 4d 1 56 1 54 2 5c 5e 2 60 62 1 72 4 7f 80 83 86 3 88 89 8a 4 97 98 9b 9e 3 a0 a1 a2 1 ae 1 b4 1 bc 2 ba bc 1 c8 1 cd 1 d3 2 d1 d3 1 de 2 dd de 2 e7 e9 2 eb ed 1 f1 2 f6 f8 2 fd fe 1 100 2 fa 100 1 108 2 107 108 1 10f 1 111 1 112 2 116 117 2 11c 11e 2 11a 121 2 123 124 1 133 2 12d 136 1 138 4 e5 f0 125 139 1 13b 2 dc 13c 1 13e 3 ca d0 13f a 65 6b 75 8d a5 a8 b1 b7 142 145 c 18 1e 23 28 2d 33 39 3f 46 4b 52 59 1 14f 1 152 1 15a 1 158 1 161 1 15f 2 167 169 2 16b 16d 1 179 4 170 173 17c 17f 2 15d 164 1 189 1 18c 1 194 1 192 1 1a1 2 19f 1a1 1 1a7 1 1ac 2 1aa 1ac 1 1b2 1 1b7 3 1b9 1b4 1ba 3 19e 1bb 1be 1 197 1 1c8 1 1cb 1 1d1 2 1de 1e1 1 1d4 4 14b 185 1c4 1e7 1 4 0 1f2 0 1 14 6 1a 0 1 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1c8 6 0 a 2 0 5 1 2 2a 2 0 2f 2 0 1a 2 0 35 2 0 189 5 0 6 2 0 15f 4 0 54 2 0 3 0 1 14f 4 0 158 4 0 13 2 0 192 5 0 3b 2 0 188 1 5 1c7 1 6 41 2 0 1d1 6 0 4d 2 0 48 2 0 25 2 0 14e 1 4 20 2 0 0 /