该博客展示了如何使用Oracle E-Business Suite (EBS) 的API更新销售订单行信息。通过初始化参数，设置订单头和行信息，然后调用`oe_order_pub.process_order`过程来执行更新操作。示例代码包括了必要的变量声明、初始化、错误处理和提交/回滚事务。
更新销售订单行信息
DECLARE
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;<
扫一扫
436
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
