OE_Order_PUB.Process_Order
问题:数据库中因为有OU屏蔽,所以更新、导入失败
解决方法:
--设置OU,显示OU屏蔽的数据
通过mo_global.set_policy_context('S',81); 设置单OU,推荐使用这种方式(没有任何前提,直接将当前环境初始化为ORG_ID=81的环境)。
通过 mo_global.init('ONT'); 将OM应用能访问的组织都初始化访问列表中(前提是使用的应用已经注册了多组织访问)
l_header_rec oe_order_pub.header_rec_type;
l_line_tbl oe_order_pub.line_tbl_type;
l_line_tb2 oe_order_pub.line_tbl_type;
l_action_request_tbl oe_order_pub.request_tbl_type;
l_return_status varchar2(1000);
l_msg_count number;
l_msg_data varchar2(1000);
v_line_number varchar2(1000);
l_index varchar2(1000);
x_header_val_rec oe_order_pub.header_val_rec_type;
x_header_adj_tbl oe_order_pub.header_adj_tbl_type;
x_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
x_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
x_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
x_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
x_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
x_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
x_line_val_tbl oe_order_pub.line_val_tbl_type;
x_line_adj_tbl oe_order_pub.line_adj_tbl_type;
x_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
x_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
x_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type; <