{"id":1484,"date":"2019-04-25T17:40:08","date_gmt":"2019-04-25T09:40:08","guid":{"rendered":"http:\/\/www.llku.com\/?p=1484"},"modified":"2019-04-25T17:40:46","modified_gmt":"2019-04-25T09:40:46","slug":"ebs%e8%b5%84%e4%ba%a7%e8%b0%83%e6%95%b4-api%e4%be%8b%e5%ad%90","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1484","title":{"rendered":"Oracle ebs\u8d44\u4ea7\u8c03\u6574 api\u4f8b\u5b50"},"content":{"rendered":"<p>\n\tdeclare<br \/>\n\t&nbsp; l_trans_rec &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.trans_rec_type;<br \/>\n\t&nbsp; l_asset_hdr_rec &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.asset_hdr_rec_type;<br \/>\n\t&nbsp; l_asset_fin_rec_adj &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.asset_fin_rec_type;<br \/>\n\t&nbsp; l_asset_fin_rec_new &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.asset_fin_rec_type;<br \/>\n\t&nbsp; l_asset_fin_mrc_tbl_new &nbsp; &nbsp; FA_API_TYPES.asset_fin_tbl_type;<br \/>\n\t&nbsp; l_inv_trans_rec &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.inv_trans_rec_type;<br \/>\n\t&nbsp; l_inv_tbl &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.inv_tbl_type;<br \/>\n\t&nbsp; l_inv_rate_tbl &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FA_API_TYPES.inv_rate_tbl_type;<br \/>\n\t&nbsp; l_asset_deprn_rec_adj &nbsp; &nbsp; &nbsp; FA_API_TYPES.asset_deprn_rec_type;<br \/>\n\t&nbsp; l_asset_deprn_rec_new &nbsp; &nbsp; &nbsp; FA_API_TYPES.asset_deprn_rec_type;<br \/>\n\t&nbsp; l_asset_deprn_mrc_tbl_new &nbsp; FA_API_TYPES.asset_deprn_tbl_type;<br \/>\n\t&nbsp; l_inv_rec &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FA_API_TYPES.inv_rec_type;<br \/>\n\t&nbsp; l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;<br \/>\n\t&nbsp; l_return_status &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VARCHAR2(1);<br \/>\n\t&nbsp; l_mesg_count &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;number := 0;<br \/>\n\t&nbsp; l_mesg_len &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;number;<br \/>\n\t&nbsp; l_mesg &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar2(4000);<br \/>\n\tbegin<br \/>\n\t&nbsp; fnd_profile.put(&#39;PRINT_DEBUG&#39;, &#39;Y&#39;);<br \/>\n\t&nbsp; dbms_output.enable(1000000);<br \/>\n\t&nbsp; FA_SRVR_MSG.Init_Server_Message;<br \/>\n\t&nbsp; FA_DEBUG_PKG.Initialize;<br \/>\n\t&nbsp; &#8212; asset header info<br \/>\n\t&nbsp; l_asset_hdr_rec.asset_id &nbsp; &nbsp; &nbsp; := 100000206;<br \/>\n\t&nbsp; l_asset_hdr_rec.book_type_code := &#39;FIN_FA_BOOK&#39;;<br \/>\n\t&nbsp; &#8212; fin info<br \/>\n\t&nbsp; l_asset_fin_rec_adj.cost := 1002;\n<\/p>\n<p>\n\t&nbsp; &#8211;\u9700\u6ce8\u610f\u8fd9\u4e2a\u91d1\u989d\u662f\u5728\u539f\u57fa\u7840\u4e0a\u7684\u589e\u51cf\u503c\u3002<br \/>\n\t&nbsp; FA_ADJUSTMENT_PUB.do_adjustment(p_api_version &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; 1.0,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_init_msg_list &nbsp; &nbsp; &nbsp; &nbsp; =&gt; FND_API.G_FALSE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_commit &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; FND_API.G_FALSE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_validation_level &nbsp; &nbsp; &nbsp;=&gt; FND_API.G_VALID_LEVEL_FULL,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_calling_fn &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; &#39;ADJ_TEST_SCRIPT&#39;,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x_return_status &nbsp; &nbsp; &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; x_msg_count &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; l_mesg_count,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x_msg_data &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; l_mesg,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; px_trans_rec &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; l_trans_rec,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; px_asset_hdr_rec &nbsp; &nbsp; &nbsp; &nbsp;=&gt; l_asset_hdr_rec,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_asset_fin_rec_adj &nbsp; &nbsp; =&gt; l_asset_fin_rec_adj,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x_asset_fin_rec_new &nbsp; &nbsp; =&gt; l_asset_fin_rec_new,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x_asset_fin_mrc_tbl_new =&gt; l_asset_fin_mrc_tbl_new,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; px_inv_trans_rec &nbsp; &nbsp; &nbsp; &nbsp;=&gt; l_inv_trans_rec,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; px_inv_tbl &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; l_inv_tbl,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#8211;px_inv_rate_tbl &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; l_inv_rate_tbl,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_asset_deprn_rec_adj &nbsp; &nbsp; &nbsp; =&gt; l_asset_deprn_rec_adj,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x_asset_deprn_rec_new &nbsp; &nbsp; &nbsp; =&gt; l_asset_deprn_rec_new,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x_asset_deprn_mrc_tbl_new &nbsp; =&gt; l_asset_deprn_mrc_tbl_new,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p_group_reclass_options_rec =&gt; l_group_reclass_options_rec);<br \/>\n\t&nbsp; dbms_output.put_line(l_return_status);<br \/>\n\t&nbsp; if (l_return_status &lt;&gt; FND_API.G_RET_STS_SUCCESS) then<br \/>\n\t&nbsp; &nbsp; fa_debug_pkg.dump_debug_messages(max_mesgs =&gt; 0);<br \/>\n\t&nbsp; &nbsp; l_mesg_count := fnd_msg_pub.count_msg;<br \/>\n\t&nbsp; &nbsp; if l_mesg_count &gt; 0 then<br \/>\n\t&nbsp; &nbsp; &nbsp; l_mesg := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;512);<br \/>\n\t&nbsp; &nbsp; &nbsp; dbms_output.put_line(substr(l_mesg, 1, 255));<br \/>\n\t&nbsp; &nbsp; &nbsp; for i in 1 .. l_mesg_count &#8211; 1 loop<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; l_mesg := substr(fnd_msg_pub.get(fnd_msg_pub.G_NEXT,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;fnd_api.G_FALSE),<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;512);<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; dbms_output.put_line(substr(l_mesg, 1, 255));<br \/>\n\t&nbsp; &nbsp; &nbsp; end loop;<br \/>\n\t&nbsp; &nbsp; &nbsp; fnd_msg_pub.delete_msg();<br \/>\n\t&nbsp; &nbsp; end if;<br \/>\n\t&nbsp; else<br \/>\n\t&nbsp; &nbsp; dbms_output.put_line(&#39;SUCCESS&#39;);<br \/>\n\t&nbsp; &nbsp; dbms_output.put_line(&#39;THID&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to_char(l_trans_rec.transaction_header_id));<br \/>\n\t&nbsp; end if;<br \/>\n\tend;<br \/>\n\t\/<br \/>\n\t\u53c2\u8003\u6587\u4ef6\uff1aOracle Assets Adjustments API Documentation Supplement (\u6587\u6863 ID 206474.1)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>declare &nbsp; l_trans_rec &nbsp; &nbsp; &nbsp; &nbsp;  &hellip; <a href=\"https:\/\/www.llku.com\/?p=1484\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle ebs\u8d44\u4ea7\u8c03\u6574 api\u4f8b\u5b50<\/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":[53,1],"tags":[238,221],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1484"}],"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=1484"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1484\/revisions"}],"predecessor-version":[{"id":1487,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1484\/revisions\/1487"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}