{"id":22092,"date":"2025-01-08T16:33:54","date_gmt":"2025-01-08T19:33:54","guid":{"rendered":"https:\/\/orabr.virttus.com\/?p=22092"},"modified":"2025-01-08T17:06:43","modified_gmt":"2025-01-08T20:06:43","slug":"copiar-responsabilidade-de-outro-usuario","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=22092","title":{"rendered":"Copiar responsabilidade de outro usu\u00e1rio"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>BEGIN\n  FOR c1 IN (WITH payload_tbv AS\n                (SELECT 'xxxx' from_user\n                       ,'yyyy' to_user\n                  FROM dual)\n               SELECT substr(regexp_substr(payload, '&#91;^,]+', 1, LEVEL), 1, 10) emp\n                 FROM (SELECT payload\n                         FROM payload_tbv) t\n                WHERE regexp_substr(payload, '&#91;^,]+', 1, LEVEL) IS NOT NULL\n               CONNECT BY LEVEL &lt;= (SELECT length(REPLACE(payload, ',', NULL))\n                                      FROM (SELECT payload\n                                              FROM payload_tbv) t))\n  LOOP\n    FOR c2 IN (SELECT DISTINCT fr.responsibility_key\n                              ,fa.application_short_name\n                 FROM apps.fnd_user_resp_groups_direct furg\n                     ,applsys.fnd_user                 fu\n                     ,applsys.fnd_responsibility_tl    frt\n                     ,applsys.fnd_responsibility       fr\n                     ,applsys.fnd_application_tl       fat\n                     ,applsys.fnd_application          fa\n                WHERE furg.user_id = fu.user_id\n                  AND furg.responsibility_id = frt.responsibility_id\n                  AND fr.responsibility_id = frt.responsibility_id\n                  AND fa.application_id = fat.application_id\n                  AND fr.application_id = fat.application_id\n                  AND frt.language = 'US'\n                  AND fu.usser_name = c1.from_user\n                  )\n    LOOP\n      BEGIN\n        fnd_user_pkg.addresp(username => c1.to_user,\n                             resp_app => c2.application_short_name,\n                             resp_key => c2.responsibility_key,\n                             security_group => 'STANDARD',\n                             description => NULL, start_date => SYSDATE,\n                             end_date => NULL);\n        COMMIT;\n      EXCEPTION\n        WHEN OTHERS THEN\n          ROLLBACK;\n          dbms_output.put_line(SQLERRM);\n      END;\n    END LOOP;\n  END LOOP;\nEND;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-22092","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/22092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22092"}],"version-history":[{"count":2,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/22092\/revisions"}],"predecessor-version":[{"id":22094,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/22092\/revisions\/22094"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}