{"id":1906,"date":"2014-05-06T07:48:43","date_gmt":"2014-05-06T10:48:43","guid":{"rendered":"http:\/\/www.juniovitor.com\/?p=1906"},"modified":"2024-10-30T16:58:10","modified_gmt":"2024-10-30T19:58:10","slug":"submetendo-relatorio-xml-publisher-via-pl-sql","status":"publish","type":"post","link":"https:\/\/www.juniovitor.com\/?p=1906","title":{"rendered":"Submetendo relat\u00f3rio XML Publisher (Via PL\/SQL)"},"content":{"rendered":"<p>Bom dia!<\/p>\n<p>Voc\u00ea que precisa submeter um Relat\u00f3rio XML Pusblisher via PL\/SQL e est\u00e1 sem saber como utilizar o template, aqui vai a dica! Basicamente voc\u00ea ir\u00e1 utilizar o\u00a0ADD_LAYOUT antes do SUBMIT_REQUEST.<\/p>\n<p>Veja o exemplo:<\/p>\n<pre class=\"brush:sql\">\r\nDECLARE\r\n--\r\nl_responsibility_id  NUMBER;\r\nl_application_id     NUMBER;\r\nl_user_id            NUMBER;\r\nl_request_id         NUMBER;\r\nl_layout             NUMBER;\r\n--\r\nBEGIN\r\n  --\r\n  -- Preisamos SETAR User\/Responsabilidade para fazer isto via PL\/SQL. Portanto vamos pegar os IDs e setar o APPS INITIALIZE\r\n  -- Informacoes Responsabilidade\r\n  SELECT DISTINCT \r\n         fr.responsibility_id,\r\n         frx.application_id\r\n    INTO l_responsibility_id,\r\n         l_application_id\r\n    FROM fnd_responsibility frx,\r\n         fnd_responsibility_tl fr\r\n   WHERE fr.responsibility_id = frx.responsibility_id\r\n     AND fr.responsibility_name LIKE ('INFORME SUA RESPONSABILIDADE');\r\n     \r\n  -- Informacoes Usuario\r\n   SELECT user_id \r\n     INTO l_user_id \r\n     FROM fnd_user \r\n    WHERE user_name = 'INFORME SEU USUARIO';\r\n    \r\n  --\r\n  -- Setando contexto\r\n  --\r\n  fnd_global.apps_initialize (l_user_id\r\n                             ,l_responsibility_id\r\n                             ,l_application_id);\r\n  \r\n  --\r\n  -- Submetendo Layout\r\n  --\r\n  l_layout := fnd_request.add_layout(template_appl_name => 'XXBRA',\r\n                                     template_code      => 'XXCONCCODE',\r\n                                     template_language  => 'ptb',\r\n                                     template_territory => 'BR',\r\n                                     output_format      => 'EXCEL');\r\n  --\r\n  -- Submetendo Concurrent\r\n  --\r\n  l_request_id := fnd_request.submit_request (application   => 'XXBRA', \r\n                                              program       => 'XXCONCCODE', \r\n                                              description   => 'XX Relatorio Teste', \r\n                                              start_time    => SYSDATE, \r\n                                              sub_request   => FALSE,\r\n                                              argument1     => 'Parametro do seu concurrent');\r\n  \r\n  -------\r\n  COMMIT;\r\n  -------\r\n  \r\n  IF l_request_id = 0\r\n  \r\n  THEN\r\n     dbms.output.put_line ('Concurrent n\u00e3o foi submetido - ' || SQLERRM);\r\n  ELSE\r\n     dbms_output.put_line('');\r\n  END IF;\r\n  \r\nEXCEPTION\r\n   WHEN OTHERS THEN\r\n      dbms_output.put_line('Erro ao submeter o programa concorrente: '||TO_CHAR(SQLCODE)||'-'||SQLERRM);\r\nEND;\r\n<\/pre>\n<p>Apoio: http:\/\/prasanthapps.blogspot.com.br\/<\/p>\n<p>Abs,<br \/>\nJunio Vitor<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bom dia! Voc\u00ea que precisa submeter um Relat\u00f3rio XML Pusblisher via PL\/SQL e est\u00e1 sem saber como utilizar o template, aqui vai [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[622,722,720,162,721,98,155],"class_list":["post-1906","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-plsql-example","tag-reports","tag-sql","tag-submit-request-plsql","tag-xml","tag-xml-publisher"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1906"}],"collection":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1906"}],"version-history":[{"count":5,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1906\/revisions"}],"predecessor-version":[{"id":1911,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1906\/revisions\/1911"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}