Oracle EBS:使用接口表抛数所生成OM订单
作者:admin 日期:2012-10-26
一开始是用接口抛数据到interface的表,再通过后台跑请求,抛入ERP的,不过在测试过程中发现速度有点慢,等待的时间有点长,所以到最后才换成直接使用API生在订单.
这里记录并分享一下主要的procedure ,欢迎指教!谢谢.
--抛数据到接口表
/*插入至接口表中*/
procedure InsertOOMINTERFACE(P_SOE_ORDERNO varchar2,
v_retval out varchar2,
v_retmessage out varchar2) is
cursor cur_om_header is
select *
from edu_om_temp_header oth
where oth.soe_order_no = P_SOE_ORDERNO
and rownum = 1
这里记录并分享一下主要的procedure ,欢迎指教!谢谢.
--抛数据到接口表
复制内容到剪贴板
程序代码
程序代码/*插入至接口表中*/
procedure InsertOOMINTERFACE(P_SOE_ORDERNO varchar2,
v_retval out varchar2,
v_retmessage out varchar2) is
cursor cur_om_header is
select *
from edu_om_temp_header oth
where oth.soe_order_no = P_SOE_ORDERNO
and rownum = 1
Oracle EBS: order Management API代码示例
作者:admin 日期:2012-09-19
创建一个一行物料的订单:
set serveroutput on
DECLARE
l_header_rec OE_ORDER_PUB.Header_Rec_Type;
l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type;
l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
l_request_rec OE_ORDER_PUB.Request_Rec_Type ;
l_return_status VARCHAR2(1000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(1000);
复制内容到剪贴板 程序代码
程序代码set serveroutput on
DECLARE
l_header_rec OE_ORDER_PUB.Header_Rec_Type;
l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type;
l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
l_request_rec OE_ORDER_PUB.Request_Rec_Type ;
l_return_status VARCHAR2(1000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(1000);
