{"id":213,"date":"2015-01-14T11:12:25","date_gmt":"2015-01-14T03:12:25","guid":{"rendered":"http:\/\/www.llku.com\/?p=213"},"modified":"2015-01-14T11:15:02","modified_gmt":"2015-01-14T03:15:02","slug":"%e5%90%8e%e5%8f%b0%e6%9c%80%e7%bb%88%e5%85%b3%e9%97%adpo%e5%8d%95%e5%8f%b7%e7%a8%8b%e5%ba%8f%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=213","title":{"rendered":"\u540e\u53f0\u6700\u7ec8\u5173\u95edPO\u5355\u53f7\u7a0b\u5e8f\u4ee3\u7801"},"content":{"rendered":"<p>\n\t&nbsp; &nbsp; \u7531\u4e8e\u5ba2\u6237\u7684PO\u5355\u662f\u5916\u90e8\u7cfb\u7edf\u5bfc\u5165\u5230EBS PO\u6a21\u5757\uff0c\u56e0\u6b64\u4f1a\u6d89\u53ca\u5230\u5173\u95edPO\u5355\u7684\u64cd\u4f5c\uff0c\u53ef\u4ee5\u901a\u8fc7\u63a5\u53e3\u5173\u95edPO\u5355\u3002\u4ee5\u4e0b\u662f\u6838\u5fc3\u4ee3\u7801\uff1a\n<\/p>\n<p>\n\tdeclare<br \/>\n\t&nbsp; l_action &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; varchar2(100) := &#39;FINALLY CLOSE&#39;;<br \/>\n\t&nbsp; v_po_header_id &nbsp; &nbsp; number := 1292;<br \/>\n\t&nbsp; l_return_status &nbsp; &nbsp;varchar2(100);<br \/>\n\t&nbsp; l_return_code &nbsp; &nbsp; &nbsp;varchar2(100);<br \/>\n\t&nbsp; l_exc_msg &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar2(100);<br \/>\n\t&nbsp; l_online_report_id varchar2(100);<br \/>\n\t&nbsp; p_reasons &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar2(100) := &#39;\u5c0f\u6f58\u6d4b\u8bd5\u6700\u7ec8\u5173\u95edPO\u5355&#39;;\n<\/p>\n<p>\n\tbegin\n<\/p>\n<p>\n\t&nbsp; &#8211;\u521d\u59cb\u5316<br \/>\n\t&nbsp; fnd_global.apps_initialize(user_id &nbsp; &nbsp; &nbsp;=&gt; 1110, &#8211;\u7528\u6237\u540d<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;resp_id &nbsp; &nbsp; &nbsp;=&gt; 50737, &#8211;PO\u804c\u8d23<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;resp_appl_id =&gt; 201); &#8211;PO\u4ea7\u54c1\n<\/p>\n<p>\n\t&nbsp; &#8211;\u8c03\u7528\u7cfb\u7edf\u81ea\u5e26\u529f\u80fd\u91ca\u653e\u4fdd\u7559\u6b3e&nbsp;<br \/>\n\t&nbsp; PO_DOCUMENT_ACTION_PVT.do_manual_close(p_action &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; l_action,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_document_id &nbsp; &nbsp; &nbsp;=&gt; v_po_header_id,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_document_type &nbsp; &nbsp;=&gt; &#39;PO&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_document_subtype =&gt; &#39;STANDARD&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_line_id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; &#39;&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_shipment_id &nbsp; &nbsp; &nbsp;=&gt; &#39;&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_reason &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; p_reasons,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_action_date &nbsp; &nbsp; &nbsp;=&gt; to_date(to_char(sysdate,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&#39;DD-MON-YYYY&#39;),<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&#39;DD-MON-YYYY&#39;),<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_calling_mode &nbsp; &nbsp; =&gt; &#39;PO&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_origin_doc_id &nbsp; &nbsp;=&gt; NULL,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_called_from_conc =&gt; FALSE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p_use_gl_date &nbsp; &nbsp; &nbsp;=&gt; &#39;N&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x_return_status &nbsp; &nbsp;=&gt; l_return_status,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x_return_code &nbsp; &nbsp; &nbsp;=&gt; l_return_code,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x_exception_msg &nbsp; &nbsp;=&gt; l_exc_msg,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x_online_report_id =&gt; l_online_report_id);\n<\/p>\n<p>\n\t&nbsp; DBMS_OUTPUT.put_line(&#39;\u6210\u529f\u4e0e\u5426\u6807\u8bb0\uff1a&#39; || l_return_status);<br \/>\n\t&nbsp; DBMS_OUTPUT.put_line(&#39;\u8fd4\u56de\u4ee3\u7801\uff1a&#39; || l_return_code);<br \/>\n\t&nbsp; DBMS_OUTPUT.put_line(&#39;\u9519\u8bef\u6d88\u606f\uff1a&#39; || l_exc_msg);<br \/>\n\tend;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; \u7531\u4e8e\u5ba2\u6237\u7684PO\u5355\u662f\u5916\u90e8\u7cfb\u7edf\u5bfc\u5165\u5230EBS PO\u6a21\u5757\uff0c\u56e0\u6b64\u4f1a\u6d89\u53ca\u5230\u5173\u95edPO\u5355\u7684\u64cd\u4f5c\uff0c\u53ef &hellip; <a href=\"https:\/\/www.llku.com\/?p=213\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u540e\u53f0\u6700\u7ec8\u5173\u95edPO\u5355\u53f7\u7a0b\u5e8f\u4ee3\u7801<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[27,48],"tags":[51,50],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/213"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=213"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/213\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/213\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}